public DiemDanhInfo DataToInfo(DataGridViewRow r, DateTime ngay, bool cophep)
{
DiemDanhInfo dd = new DiemDanhInfo();
dd.CoPhep = cophep;
dd.NgayVang = ngay;
PhongInfo p = new PhongInfo();
p.MaPhong = r.Cells["MAPHG"].Value.ToString();
dd.Phong = p;
SinhVienInfo sv = new SinhVienInfo();
sv.MaKTX = r.Cells["MAKTX"].Value.ToString();
sv.HoTen = r.Cells["HOTEN"].Value.ToString();
dd.SinhVien = sv;
return(dd);
}
public DataTable Them(DiemDanhInfo dd)
{
DataService ser = new DataService();
SqlCommand command = new SqlCommand("INSERT INTO DIEMDANH(MAKTX,MAPHG,COPHEP,NGAYVANG) values(@maktx,@maphg,@cophep,@ngayvang)");
command.Parameters.Add("@maktx", SqlDbType.VarChar, 7).Value = dd.SinhVien.MaKTX;
command.Parameters.Add("@maphg", SqlDbType.VarChar, 4).Value = dd.Phong.MaPhong;
command.Parameters.Add("@cophep", SqlDbType.Bit).Value = dd.CoPhep;
command.Parameters.Add("@ngayvang", SqlDbType.DateTime).Value = dd.NgayVang;
try
{
ser.Load(command);
}
catch (Exception e)
{
MessageBox.Show("Hôm nay sinh viên " + dd.SinhVien.HoTen + " Điểm danh rồi");
}
return(ser);
}
public void Them(DiemDanhInfo info)
{
DiemDanhData data = new DiemDanhData();
data.Them(info);
}
