//cap nhat tác giả
public bool capNhapTacGia(ET_TacGia tg)
{
try
{
_cn.Open();
SqlCommand cmd = new SqlCommand("sp_capnhapTacGia", _cn);
cmd.CommandText = "sp_capnhapTacGia";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p_ma = new SqlParameter("@MaTG", tg.MaTG);
cmd.Parameters.Add(p_ma);
SqlParameter p_ten = new SqlParameter("@TenTG", tg.TenTG);
cmd.Parameters.Add(p_ten);
SqlParameter p_namSinh = new SqlParameter("@NamSinh", tg.NamSinh);
cmd.Parameters.Add(p_namSinh);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
finally
{
_cn.Close();
}
}
private void btnSua_Click(object sender, EventArgs e)
{
ET_TacGia TG = new ET_TacGia(txtMaTG.Text, txtTenTG.Text, int.Parse(txtNamSinh.Text));
if (tg.SuaTG(TG) == true)
{
MessageBox.Show("Sửa thành công ");
}
else
{
MessageBox.Show("Sua khong thanh cong ");
}
load();
}
private void btnThem_Click(object sender, EventArgs e)
{
ET_TacGia TG = new ET_TacGia(txtMaTG.Text, txtTenTG.Text, int.Parse(txtNamSinh.Text));
if (tg.ThemTG(TG) == true)
{
MessageBox.Show("Them thanh cong ");
txtMaTG.Text = "";
txtTenTG.Text = "";
txtNamSinh.Text = "";
txtMaTG.Focus();
}
else
{
MessageBox.Show("Them khong thanh cong ");
}
load();
}
public bool SuaTG(ET_TacGia tg)
{
return(TG.capNhapTacGia(tg));
}
public bool ThemTG(ET_TacGia tg)
{
return(TG.themTG(tg));
}
