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)); }