using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data;
using MySql.Data.MySqlClient;
using MySql.Data.Types;


public partial class addartistfav : System.Web.UI.Page
{
    private string strUserID;
    int UserId;

    protected void Page_Load(object sender, EventArgs e)
    {
        UserControl_CheckSessionCookie a = new UserControl_CheckSessionCookie();
        a.CheckCookieStatus();

        try
        {
            strUserID = Session["UserId"].ToString();
        }
        catch (Exception)
        {
            Response.Redirect("~/login.aspx");
        }
        try
        {
            UserId = Convert.ToInt32(Request.QueryString["UserId"].ToString());
            lblUserName.Text = getArtistName(UserId);
            lblState.Text = getStateName(UserId);
            Image1.ImageUrl = getArtistImage(UserId);
            ArtistFan1.UserId = Convert.ToString(UserId);
            lblGenre.Text = getGenreName(UserId);
            lblStatus.Text = showStatus(UserId);
            showRating(UserId);
        }
        catch (Exception)
        {
            Response.Redirect("/login.aspx");

        }
    }

    public string getArtistName(int UserId)
    {
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select loginname from usermaster where userid=" + UserId;
        cmd.Connection = conn;
        cmd.Connection.Open();
        string ArtistName = Convert.ToString(cmd.ExecuteScalar());
        cmd.Connection.Close();
        return ArtistName;
    }

    public string getStateName(int UserId)
    {
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select s.statename from statemaster s join usermaster u on s.stateid=u.stateid where u.userid=" + UserId;
        cmd.Connection = conn;
        cmd.Connection.Open();
        string State = Convert.ToString(cmd.ExecuteScalar());
        cmd.Connection.Close();
        return State;

    }


    public string getGenreName(int UserId)
    {
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select g.genrename from genre g join usermaster u on g.genreid=u.genreid where u.userid=" + UserId;
        cmd.Connection = conn;
        cmd.Connection.Open();
        string GenreName = Convert.ToString(cmd.ExecuteScalar());
        cmd.Connection.Close();
        return GenreName;
    }

    public string getInstruments(int UserId)
    {
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select  i.instrumentname from instrument i join performerexpertise p on i.instrumentid=p.instrumentid where performerid=" + UserId;
        cmd.Connection = conn;
        cmd.Connection.Open();
        //MySqlDataReader rdr = cmd.ExecuteReader();
        string Instrument = Convert.ToString(cmd.ExecuteScalar());

        /*string instruments = Convert.ToString(cmd.ExecuteReader());
        /*while (rdr1.HasRows)
        {
            rdr.Read();
            lblInstruments.Text += rdr["instrumentname"].ToString() + ",";

        }

        rdr.Close();*/
        cmd.Connection.Close();
        return Instrument;
    }

    public string getArtistImage(int UserId)
    {
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select ifnull(concat('../UploadPhoto/Images/', u.photoid, '.jpg'),'../UploadPhoto/Images/notAvail.jpg') from usermaster u";
        cmd.CommandText += " where u.userid=" + UserId;
        cmd.Connection = conn;
        cmd.Connection.Open();
        string Image = Convert.ToString(cmd.ExecuteScalar());
        cmd.Connection.Close();
        return Image;
    }

    public string getArtistProfile(int UserId)
    {
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select motto,bio as profile from usermaster where userid= " + UserId;
        cmd.Connection = conn;
        cmd.Connection.Open();
        string ArtistProfile = Convert.ToString(cmd.ExecuteScalar());
        cmd.Connection.Close();
        return ArtistProfile;
    }

    public string showStatus(int UserId)
    {
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select lastlogintime from userstatus where userid= " + UserId;
        cmd.Connection = conn;
        cmd.Connection.Open();
        string Status = Convert.ToString(cmd.ExecuteScalar());
        cmd.Connection.Close();
        return Status;
    }

    protected string getImageUrl(string userrate)
    {
        string retValue = string.Empty;

        if (userrate == "1") retValue = "~/Images/1s.gif";
        if (userrate == "2") retValue = "~/Images/2s.gif";
        if (userrate == "3") retValue = "~/Images/3s.gif";
        if (userrate == "4") retValue = "~/Images/4s.gif";
        if (userrate == "5") retValue = "~/Images/5s.gif";
        if (userrate == "") retValue = "~/Images/3s.gif";

        return retValue;
    }

    public void showRating(int UserId)
    {
        String rating;
        int totalRated = 0;
        MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "select userrate from userrating where userid=" + UserId;
        cmd.Connection = conn;
        conn.Open();
        try
        {
            rating = Convert.ToString(cmd.ExecuteScalar());
            Rating1.Rating = rating;
        }
        catch (Exception ee) { }
        cmd.CommandText = "select TotalUsersRated from userrating where userid=" + UserId;
        try
        {
            totalRated = Convert.ToInt32(cmd.ExecuteScalar());
            lblTotalRated.Text = Convert.ToString(totalRated);
        }
        catch (Exception ee) { }
        cmd.Connection.Close();
    }

    protected void btnYes_Click(object sender, EventArgs e)
    {
        try
        {
            String strUserId = string.Empty;
            try
            {
                strUserId = Session["UserId"].ToString();
            }
            catch (Exception)
            { Response.Redirect("/login.aspx"); }

            //Check whether the user is adding himself in his fav.

           

            if (strUserId.Trim().Equals(Convert.ToString(UserId).Trim()))
            {
                lblMessage.Text = "Sorry You can't add yourself as favourite";
                lblMessage.Visible = true;
                btnYes.Enabled = false;
                return;
            }


            MySqlConnection conn = new MySqlConnection(MySqlHelper.GetAHOConnectionString);
            MySqlCommand cmd = new MySqlCommand();
            cmd.Connection = conn;
            cmd.Connection.Open();

            //Check whether this user has already added him in his fav.
            int checkStatus = 0;
            try
            {
                cmd.CommandText = "select count(*) from userfav where userid=?userid and useridoffriend=?useridoffriend";
                cmd.Parameters.Add("?userid", MySqlDbType.Int32).Value = UserId;
                cmd.Parameters.Add("?useridoffriend", MySqlDbType.Int32).Value = Convert.ToInt32(strUserId);
                checkStatus = Convert.ToInt32(cmd.ExecuteScalar());

            }
            catch (Exception) { }

            if (checkStatus == 0)
            {
                try
                {
                    cmd.CommandText = "insert into userfav (userid,useridoffriend,joineddate)values(?userid,?useridofriend,curdate())";

                    cmd.Parameters.Add("?userid", MySqlDbType.Int32).Value = UserId;
                    cmd.Parameters.Add("?useridofriend", MySqlDbType.Int32).Value = Convert.ToInt32(strUserId);
                    cmd.ExecuteNonQuery();
                }
                catch (Exception) { }
            }

            cmd.Connection.Close();
            Response.Redirect("/MembersProfile.aspx?UserId=" + Convert.ToString(UserId));
        }
        catch (Exception ee) { }
    }


}