private void button4_Click(object sender, EventArgs e)
{
int masv;
string mamh;
double diem;
masv = int.Parse(txtmsv.Text.Trim());
mamh = txtmmh.Text.Trim();
diem = double.Parse(txtdiem.Text.Trim());
SV_MH sh = new SV_MH(masv, mamh, diem);
try
{
int i = new SV_MHBus().SuaSV_MH(sh);
if (i == -2)
{
throw new Exception();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dgvSV_MH.DataSource = GetSV_MH();
}
private List <SV_MH> list2()
{
string sql = @"Select * from SV_MH where MaSV='" + txttim.Text + "'";
SV_MHBus mh = new SV_MHBus();
List <SV_MH> list2 = mh.GetSV_MH(sql);
return(list2);
}
public List <SV_MH> GetSV_MH()
{
try
{
string sql = "Select * from SV_MH";
SV_MHBus SV_MH = new SV_MHBus();
return(SV_MH.GetSV_MH(sql));
}
catch (Exception ex)
{
throw ex;
}
}
private void button5_Click(object sender, EventArgs e)
{
int masv;
string mamh;
masv = int.Parse(txtmsv.Text.Trim());
mamh = txtmsv.Text.Trim();
try
{
int i = new SV_MHBus().XoaSV_MH(masv, mamh);
if (i == -2)
{
throw new Exception();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dgvSV_MH.DataSource = GetSV_MH();
}
