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();
}
public List <SV_MH> GetSV_MH(string sql)
{
try
{
SqlDataReader dr = dp.ExecReader(sql);
List <SV_MH> list = new List <SV_MH>();
int masv;
string mamh;
double diem;
while (dr.Read())
{
masv = dr.GetInt32(0);
mamh = dr.GetString(1);
diem = dr.GetDouble(2);
SV_MH smh = new SV_MH(masv, mamh, diem);
list.Add(smh);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dp.disCon();
}
}
public int SuaSV_MH(SV_MH SV_MH)
{
try
{
return(new SV_MHDAO().SuaSV_MH(SV_MH));
}
catch (Exception ex)
{
throw ex;
}
}
public int SuaSV_MH(SV_MH SV_MH)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@masv", SV_MH.MaSV));
list.Add(new SqlParameter("@mamh", SV_MH.MaMH));
list.Add(new SqlParameter("@diem", SV_MH.Diem));
try
{
return(dp.ExcuteNonquery("SuaSV_MH", System.Data.CommandType.StoredProcedure, list));
}
catch (Exception ex)
{
throw ex;
}
}
