using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Runtime.InteropServices;
using System.Diagnostics;
using System.EnterpriseServices;
using System.Xml;

public partial class Admin : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void InsertCDButton_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CDIncorporatedConnectionString"].ConnectionString);
            con.Open();
            string insertcd = "INSERT INTO CDInfo (CD Name, CD Artist, CD Genre) values(@CD Name, @CD Artist, @CD Genre)";
            SqlCommand cmd = new SqlCommand(insertcd, con);
            cmd.Parameters.AddWithValue("@CD Name", InsertCDNameBox.Text);
            cmd.Parameters.AddWithValue("@CD Artist", InsertCDArtistBox.Text);
            cmd.Parameters.AddWithValue("@CD Genre", InsertCDGenreBox.Text);
            cmd.ExecuteNonQuery();
            GridViewAdminCDView.DataBind();
            con.Close();
            Response.Redirect("admin.aspx");
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }
    protected void UpdateCDButton_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CDIncorporatedConnectionString"].ConnectionString);
            con.Open();
            string updatecd = "UPDATE CDInfo set CD Name = @CD Name, CD Artist = @CD Artist, CD Genre = @CD Genre WHERE CDID = @CDID ";
            SqlCommand cmd = new SqlCommand(updatecd, con);
            cmd.Parameters.AddWithValue("@CDID", UpdateCDIDBox.Text);
            cmd.Parameters.AddWithValue("@CD Name", UpdateCDNameBox.Text);
            cmd.Parameters.AddWithValue("@CD Artist", UpdateCDArtistBox.Text);
            cmd.Parameters.AddWithValue("@CD Genre", UpdateCDGenreBox.Text);
            cmd.ExecuteNonQuery();
            GridViewAdminCDView.DataBind();
            con.Close();
            Response.Redirect("admin.aspx");
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }

    protected void DeleteCDButton_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CDIncorporatedConnectionString"].ConnectionString);
            con.Open();
            string deletecd = "DELETE FROM CDInfo WHERE CDID = @CDID";
            SqlCommand cmd = new SqlCommand(deletecd, con);
            cmd.Parameters.AddWithValue("@CDID", DeleteCDIDBox.Text);
            cmd.ExecuteNonQuery();
            GridViewAdminCDView.DataBind();
            con.Close();
            Response.Redirect("adminPages.aspx");
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }
        protected void SearchCDButton_Click(object sender, EventArgs e)
        {

        }

        protected void InsertUserButton_Click(object sender, EventArgs e)
        {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CDIncorporatedConnectionString"].ConnectionString);
            con.Open();
            string insertcd = "INSERT INTO UserInfo (Username, Email, Password) values(@Username, @Email, @Password)";
            SqlCommand cmd = new SqlCommand(insertcd, con);
            cmd.Parameters.AddWithValue("@Username", InsertUsernameBox.Text);
            cmd.Parameters.AddWithValue("@Email", InsertUserEmailBox.Text);
            cmd.Parameters.AddWithValue("@Password", InsertUserPasswordBox.Text);
            cmd.ExecuteNonQuery();
            GridViewAdminUserView.DataBind();
            con.Close();
            Response.Redirect("admin.aspx");
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }

        protected void UpdateUserButton_Click(object sender, EventArgs e)
        {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CDIncorporatedConnectionString"].ConnectionString);
            con.Open();
            string updatecd = "UPDATE UserInfo set Username = @Username, Email = @Email, Password = @Password WHERE UserID = @UserID ";
            SqlCommand cmd = new SqlCommand(updatecd, con);
            cmd.Parameters.AddWithValue("@UserID", UpdateUserIDBox.Text);
            cmd.Parameters.AddWithValue("@Username", UpdateUsernameBox.Text);
            cmd.Parameters.AddWithValue("@Email", UpdateUserEmailBox.Text);
            cmd.Parameters.AddWithValue("@Password", UpdateUserPasswordBox.Text);
            cmd.ExecuteNonQuery();
            GridViewAdminUserView.DataBind();
            con.Close();
            Response.Redirect("admin.aspx");
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }

        protected void DeleteUserButton_Click(object sender, EventArgs e)
        {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CDIncorporatedConnectionString"].ConnectionString);
            con.Open();
            string deleteuser = "DELETE FROM UserInfo WHERE UserID = @UserID";
            SqlCommand cmd = new SqlCommand(deleteuser, con);
            cmd.Parameters.AddWithValue("@UserID", DeleteUserIDBox.Text);
            cmd.ExecuteNonQuery();
            GridViewAdminUserView.DataBind();
            con.Close();
            Response.Redirect("adminPages.aspx");
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }

        protected void SearchUserButton_Click(object sender, EventArgs e)
        {

        }
    }