protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CaSiBH csab = (CaSiBH)Session["csbh"];
txtid.Text = csab.id.ToString();
txtcasi.Text = csab.macasi.ToString();
txtbaihat.Text = csab.mabaihat.ToString();
}
}
protected void sua_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "sua")
{
int m = Convert.ToInt16(e.CommandArgument);
CaSiBH csbh = data.layra1CSBH(m);
Session["csbh"] = csbh;
Response.Redirect("SuaCaSiBH.aspx");
}
}
// thêm ca sĩ bh
public void ThemCaSiBH(CaSiBH csbh)
{
con.Open();
string sql = "insert into casi_baihat values(@macs,@mabh)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("macs", csbh.macasi);
cmd.Parameters.AddWithValue("mabh", csbh.mabaihat);
cmd.ExecuteNonQuery();
con.Close();
}
// cập nhật
public void capNhatCSBH(CaSiBH csbh)
{
con.Open();
string sql = "update casi_baihat set macasi=@macs,mabaihat=@mabh where id=@id";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("macs", csbh.macasi);
cmd.Parameters.AddWithValue("mabh", csbh.mabaihat);
cmd.Parameters.AddWithValue("id", csbh.id);
cmd.ExecuteNonQuery();
con.Close();
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
CaSiBH csbh = new CaSiBH();
csbh.macasi = int.Parse(txtcasi.Text);
csbh.mabaihat = int.Parse(txtbaihat.Text);
data.ThemCaSiBH(csbh);
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
{
CaSiBH s = new CaSiBH();
s.id = int.Parse(txtid.Text);
s.macasi = int.Parse(txtcasi.Text);
s.mabaihat = int.Parse(txtbaihat.Text);
data.capNhatCSBH(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 <CaSiBH> dsCaSiBH()
{
List <CaSiBH> ds = new List <CaSiBH>();
string sql = "select * from casi_baihat";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
CaSiBH csbh = new CaSiBH();
csbh.id = (int)rd["id"];
csbh.macasi = (int)rd["macasi"];
csbh.mabaihat = (int)rd["mabaihat"];
ds.Add(csbh);
}
con.Close();
return(ds);
}
// lấy ra 1 ca sĩ bh
public CaSiBH layra1CSBH(int id)
{
string sql = "select *from casi_baihat where id=@id";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("id", id);
SqlDataReader rd = cmd.ExecuteReader();
CaSiBH csbh = null;
if (rd.Read())
{
csbh = new CaSiBH();
csbh.id = (int)rd["id"];
csbh.macasi = (int)rd["macasi"];
csbh.mabaihat = (int)rd["mabaihat"];
}
con.Close();
return(csbh);
}