protected void sua_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "sua")
{
int m = Convert.ToInt16(e.CommandArgument);
PlaylistBH plbh = data.layra1PLBH(m);
Session["plbh"] = plbh;
Response.Redirect("SuaPlaylistBH.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PlaylistBH csab = (PlaylistBH)Session["plbh"];
txtid.Text = csab.id.ToString();
txtplaylist.Text = csab.maplaylist.ToString();
txtbaihat.Text = csab.mabaihat.ToString();
}
}
// thêm ca sĩ bh
public void ThemPlaylistBH(PlaylistBH plbh)
{
con.Open();
string sql = "insert into playlist_baihat values(@mapl,@mabh)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("mapl", plbh.maplaylist);
cmd.Parameters.AddWithValue("mabh", plbh.mabaihat);
cmd.ExecuteNonQuery();
con.Close();
}
// cập nhật
public void capNhatPLBH(PlaylistBH plbh)
{
con.Open();
string sql = "update playlist_baihat set maplaylist=@mapl,mabaihat=@mabh where id=@id";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("mapl", plbh.maplaylist);
cmd.Parameters.AddWithValue("mabh", plbh.mabaihat);
cmd.Parameters.AddWithValue("id", plbh.id);
cmd.ExecuteNonQuery();
con.Close();
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
PlaylistBH plbh = new PlaylistBH();
plbh.maplaylist = int.Parse(txtplaylist.Text);
plbh.mabaihat = int.Parse(txtbaihat.Text);
data.ThemPlaylistBH(plbh);
msg.Text = "Thêm thành công";
}
catch (Exception e1)
{
msg.Text = "Có lỗi khi thêm" + e1.Message;
}
}
protected void btnSua_Click(object sender, EventArgs e)
{
try
{
PlaylistBH s = new PlaylistBH();
s.id = int.Parse(txtid.Text);
s.maplaylist = int.Parse(txtplaylist.Text);
s.mabaihat = int.Parse(txtbaihat.Text);
data.capNhatPLBH(s);
msg.Text = "Cập nhật thành công";
}
catch (Exception e2)
{
msg.Text = "Cập nhật thất bại" + e2.Message;
}
}
// code lay ra CaSiBH trong bang va dua vao List
public List <PlaylistBH> dsPlaylistBH()
{
List <PlaylistBH> ds = new List <PlaylistBH>();
string sql = "select * from playlist_baihat";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
PlaylistBH plbh = new PlaylistBH();
plbh.id = (int)rd["id"];
plbh.maplaylist = (int)rd["maplaylist"];
plbh.mabaihat = (int)rd["mabaihat"];
ds.Add(plbh);
}
con.Close();
return(ds);
}
// lấy ra 1 ca sĩ bh
public PlaylistBH layra1PLBH(int id)
{
string sql = "select *from playlist_baihat where id=@id";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("id", id);
SqlDataReader rd = cmd.ExecuteReader();
PlaylistBH plbh = null;
if (rd.Read())
{
plbh = new PlaylistBH();
plbh.id = (int)rd["id"];
plbh.maplaylist = (int)rd["maplaylist"];
plbh.mabaihat = (int)rd["mabaihat"];
}
con.Close();
return(plbh);
}
