private void dgcontrol_bienLai_Click(object sender, EventArgs e)
{
if (dgview_bienLai.SelectedRowsCount > 0)
{
int[] selectedRows = dgview_bienLai.GetSelectedRows();
foreach (int rowHandle in selectedRows)
{
if (rowHandle >= 0)
{
blDTO.MaBL = dgview_bienLai.GetRowCellValue(rowHandle, cl_maBL).ToString().Trim();
blDTO.MSHV = dgview_bienLai.GetRowCellValue(rowHandle, cl_mahv).ToString().Trim();
blDTO.HoTen = dgview_bienLai.GetRowCellValue(rowHandle, cl_hoten).ToString().Trim();
blDTO.GioiTinh = dgview_bienLai.GetRowCellValue(rowHandle, cl_gioiTinh).ToString().Trim();
blDTO.SDT = dgview_bienLai.GetRowCellValue(rowHandle, cl_sdt).ToString().Trim();
blDTO.NgaySinh = DateTime.Parse(dgview_bienLai.GetRowCellValue(rowHandle, cl_ngaySinh).ToString().Trim());
blDTO.Email = dgview_bienLai.GetRowCellValue(rowHandle, cl_email).ToString().Trim();
blDTO.MaKH = dgview_bienLai.GetRowCellValue(rowHandle, cl_maKH).ToString().Trim();
blDTO.TenKH = dgview_bienLai.GetRowCellValue(rowHandle, cl_tenkh).ToString().Trim();
blDTO.MaLop = dgview_bienLai.GetRowCellValue(rowHandle, cl_maLop).ToString().Trim();
blDTO.LichHoc = dgview_bienLai.GetRowCellValue(rowHandle, cl_lichHoc).ToString().Trim();
blDTO.NgayBatDau = DateTime.Parse(dgview_bienLai.GetRowCellValue(rowHandle, cl_ngayBatDau).ToString().Trim());
blDTO.GioBatDau = dgview_bienLai.GetRowCellValue(rowHandle, cl_gioBatDau).ToString().Trim();
blDTO.HocPhi = int.Parse(dgview_bienLai.GetRowCellValue(rowHandle, cl_hocPhi).ToString().Trim());
blDTO.NgayLapBienLai = DateTime.Parse(dgview_bienLai.GetRowCellValue(rowHandle, cl_ngayLapBL).ToString().Trim());
blDTO.MaNV = dgview_bienLai.GetRowCellValue(rowHandle, cl_manv).ToString().Trim();
blDTO.HoTenNV = dgview_bienLai.GetRowCellValue(rowHandle, cl_nguoiLapBL).ToString().Trim();
}
}
}
else
{
blDTO = null;
}
BindingChiTiet();
}
private void GetDetail()
{
if (blDTO != null)
{
blDTO = new BienLai_DTO();
}
blDTO.MaBL = lb_maBL.Text.Trim();
blDTO.MaNV = lb_manv.Text.Trim();
blDTO.MSHV = lb_mahv.Text.Trim();
blDTO.MaKH = lb_khoahoc.Text.Trim();
blDTO.MaLop = lb_maLop.Text.Trim();
blDTO.HocPhi = int.Parse(lb_hocPhi.Text.Trim());
blDTO.NgayLapBienLai = DateTime.Parse(lb_ngayLapBL.Text.Trim());
}
public List <BienLai_DTO> LoadDSBienLai()
{
SqlConnection connect = DataProvider.TaoKetNoi();
List <BienLai_DTO> bienLai = new List <BienLai_DTO>();
string truyVan = "SELECT BienLai.MaBL, BienLai.MaNV, BienLai.MSHV, BienLai.MaKH, BienLai.Malop, BienLai.HocPhi, BienLai.NgayLapBienLai, BienLai.TrangThai,"
+ "HocVien.Ho + ' ' + HocVien.Ten as HoTen, HocVien.GioiTinh, HocVien.DiaChi, HocVien.SDT, HocVien.NgaySinh, HocVien.Email, "
+ "KhoaHoc.TenKH, KhoaHoc.NgayBatDau, "
+ "Lop.LichHoc, Lop.MaNV, Lop.GioBatDau, "
+ "NhanVien.HoNV + ' ' + NhanVien.TenNV as HoTenNV "
+ "FROM BienLai, HocVien, KhoaHoc, Lop, NhanVien "
+ "WHERE BienLai.MSHV = HocVien.MSHV AND BienLai.MaKH = HocVien.MaKH AND BienLai.MaNV = NhanVien.MaNV AND "
+ "BienLai.MaKH = KhoaHoc.MaKH AND BienLai.MaLop = Lop.MaLop AND BienLai.TrangThai = 1";
SqlDataReader reader = DataProvider.TruyVanDuLieu(truyVan, connect);
while (reader.Read())
{
BienLai_DTO bl = new BienLai_DTO()
{
MaBL = reader["MaBL"].ToString(),
MaNV = reader["MaNV"].ToString(),
HoTenNV = reader["HoTenNV"].ToString(),
MSHV = reader["MSHV"].ToString(),
HoTen = reader["HoTen"].ToString(),
GioiTinh = reader["GioiTinh"].ToString(),
DiaChi = reader["DiaChi"].ToString(),
SDT = reader["SDT"].ToString(),
NgaySinh = DateTime.Parse(reader["NgaySinh"].ToString()),
Email = reader["Email"].ToString(),
MaKH = reader["MaKH"].ToString(),
TenKH = reader["TenKH"].ToString(),
MaLop = reader["MaLop"].ToString(),
LichHoc = reader["LichHoc"].ToString(),
NgayBatDau = DateTime.Parse(reader["NgayBatDau"].ToString()),
GioBatDau = reader["GioBatDau"].ToString(),
HocPhi = int.Parse(reader["HocPhi"].ToString()),
//NguoiLap = reader["HoTenNV"].ToString(),
NgayLapBienLai = DateTime.Parse(reader["NgayLapBienLai"].ToString()),
TrangThai = int.Parse(reader["TrangThai"].ToString())
};
bienLai.Add(bl);
}
reader.Close();
connect.Close();
return(bienLai);
}
public int SaveBienLai(BienLai_DTO blDTO)
{
string insert = "INSERT INTO BienLai(MaBL, MaNV, MSHV, MaKH, MaLop, HocPhi, NgayLapBienLai, TrangThai) VALUES(@MaBL, @MaNV, @MSHV, @MaKH, @MaLop, @HocPhi, @NgayLapBienLai, 1)";
SqlParameter[] parameter = new SqlParameter[7];
parameter[0] = new SqlParameter("@MaBL", blDTO.MaBL);
parameter[1] = new SqlParameter("@MaNV", blDTO.MaNV);
parameter[2] = new SqlParameter("@MSHV", blDTO.MSHV);
parameter[3] = new SqlParameter("@MaKH", blDTO.MaKH);
parameter[4] = new SqlParameter("@MaLop", blDTO.MaLop);
parameter[5] = new SqlParameter("@HocPhi", blDTO.HocPhi);
parameter[6] = new SqlParameter("@NgayLapBienLai", blDTO.NgayLapBienLai);
SqlConnection connect = DataProvider.TaoKetNoi();
int ketQua = DataProvider.ExecuteInsertQuery(insert, parameter, connect);
connect.Close();
return(ketQua);
}
public int SaveBL(BienLai_DTO blDTO)
{
BienLai_DAO blDAO = new BienLai_DAO();
return(blDAO.SaveBienLai(blDTO));
}
