/// <summary>
/// Chỉnh sửa lại cột STT khi có thao tác xóa trên ListView
/// </summary>
/// <param name="list">ListView Cần Chỉnh</param>
public void SuaMaSoThanNhan(ListView list)
{
for (int i = 0; i < list.Items.Count; i++)
{
list.Items[i].Text = Convert.ToString(i + 1);
ThanNhanInfo tn = (ThanNhanInfo)list.Items[i].Tag;
tn.MaThanNhan = Convert.ToInt32(list.Items[i].Text);
list.Items[i].Tag = tn;
}
}
public bool XoaRaKhoiCSDL(ThanNhanInfo tn)
{
String sql = "DELETE ThanNhan where MATHANNHAN=" + tn.MaThanNhan + " and MAKTX='" + tn.SinhVien.MaKTX + "'";
try
{
SqlCommand command = new SqlCommand(sql);
ser.Load(command);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
public bool ThemVaoCSDL(ThanNhanInfo tn)
{
String sql = "Insert into ThanNhan(MATHANNHAN,MAKTX,HOTEN,NGHENGHIEP,QUANHE) VALUES(" +
"@mathannha,@maktx,@hoten,@nghenghiep,@quanhe)";
SqlCommand command = new SqlCommand(sql);
command.Parameters.Add("@mathannha", SqlDbType.Int).Value = tn.MaThanNhan;
command.Parameters.Add("@maktx", SqlDbType.NVarChar, 7).Value = tn.SinhVien.MaKTX;
command.Parameters.Add("@hoten", SqlDbType.NVarChar, 30).Value = tn.HoTenThanNhan;
command.Parameters.Add("@nghenghiep", SqlDbType.Int).Value = tn.NgheNghiep.MaNgheNghiep;
command.Parameters.Add("@quanhe", SqlDbType.Int).Value = tn.QuanHe.MaQuanHe;
//try
{
ser.Load(command);
return(true);
}
//catch (Exception e)
{
// e.ToString();
return(false);
}
}