void ganDL(SinhVien_Obh svObj)
{
svObj.Mathe = txtMaThe.Text.Trim();
svObj.TenSV = txtTen.Text.Trim();
svObj.Ngaysinh = txtNgaysinh.Text.Trim();
svObj.DiaChi = txtDiaChi.Text.Trim();
svObj.Lop = txtLop.Text.Trim();
svObj.Khoa = txtKhoa.Text.Trim();
svObj.NgayCapThe = dateTimePicker1.Text.Trim();
svObj.NgayHetHan = dateTimePicker2.Text.Trim();
svObj.Gioitinh = txtGioiTinh.Text.Trim();
}
public bool UpdateData(SinhVien_Obh svObj)
{
cmd.CommandText = "Update sinhvien set MaThe ='" + svObj.Mathe + "', TenSV = N'" + svObj.TenSV + "', Ngaysinh = CONVERT(DATE, '" + svObj.Ngaysinh + "',103),DiaChi=N'" + svObj.DiaChi + "', Lop=N'" + svObj.Lop + "',Khoa=N'" + svObj.Khoa + "',NgayCapThe = CONVERT(DATE, '" + svObj.NgayCapThe + "',103), NgayHetHan = CONVERT(DATE, '" + svObj.NgayHetHan + "',103),gioitinh= '" + svObj.Gioitinh + "' where sophieu= '" + svObj.Mathe + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenCon();
cmd.ExecuteNonQuery();
con.CloseCon();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();//xoa bo phien lam viec
con.CloseCon();
}
return(false);
}
//them data
public bool AddData(SinhVien_Obh svObj)
{
cmd.CommandText = "insert into sinhvien values ('" + svObj.Mathe + "',N'" + svObj.TenSV + "',CONVERT(DATE, '" + svObj.Ngaysinh + "',103),N'" + svObj.DiaChi + "',N'" + svObj.Lop + "','" + svObj.Khoa + "',CONVERT(DATE, '" + svObj.NgayCapThe + "',103)CONVERT(DATE, '" + svObj.NgayHetHan + "',103),'" + svObj.Gioitinh + "' )";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenCon();
cmd.ExecuteNonQuery();
con.CloseCon();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();//xoa bo phien lam viec
con.CloseCon();
}
return(false);
}
public bool upDate(SinhVien_Obh svObj)
{
return(svMo.UpdateData(svObj));
}
public bool addData(SinhVien_Obh svObj)
{
return(svMo.AddData(svObj));
}
