private void dgcontrol_diemHocVien_Click(object sender, EventArgs e) { if (dgview_diemHocVien.SelectedRowsCount > 0) { int[] selectedRows = dgview_diemHocVien.GetSelectedRows(); foreach (int rowHandle in selectedRows) { if (rowHandle >= 0) { diemDTO.MSHV = dgview_diemHocVien.GetRowCellValue(rowHandle, cl_mahv).ToString().Trim(); diemDTO.MaKH = dgview_diemHocVien.GetRowCellValue(rowHandle, cl_maKH).ToString().Trim(); diemDTO.MaLop = dgview_diemHocVien.GetRowCellValue(rowHandle, cl_maLop).ToString().Trim(); diemDTO.Nghe = (float)dgview_diemHocVien.GetRowCellValue(rowHandle, cl_diemNghe); diemDTO.Noi = (float)dgview_diemHocVien.GetRowCellValue(rowHandle, cl_diemNoi); diemDTO.Doc = float.Parse(dgview_diemHocVien.GetRowCellValue(rowHandle, cl_diemDoc).ToString()); diemDTO.Viet = float.Parse(dgview_diemHocVien.GetRowCellValue(rowHandle, cl_diemViet).ToString()); } } } else { khDTO = null; } BindingChiTiet(); }
public List <KhoaHoc_DTO> LoadDSKhoaHoc() { List <KhoaHoc_DTO> lsKhoaHoc = new List <KhoaHoc_DTO>(); SqlConnection conn = DataProvider.TaoKetNoi(); string strTruyVan = "SELECT * FROM KhoaHoc WHERE NgayBatDau > GETDATE() AND TrangThai = 1"; SqlDataReader reader = DataProvider.TruyVanDuLieu(strTruyVan, conn); while (reader.Read()) { KhoaHoc_DTO loai = new KhoaHoc_DTO() { MaKH = reader["MaKH"].ToString(), TenKH = reader["TenKH"].ToString(), NgayBatDau = DateTime.Parse(reader["NgayBatDau"].ToString()), NgayKetThuc = DateTime.Parse(reader["NgayKetThuc"].ToString()), HocPhi = int.Parse(reader["HocPhi"].ToString()), TrangThai = int.Parse(reader["TrangThai"].ToString()) }; lsKhoaHoc.Add(loai); } reader.Close(); conn.Close(); return(lsKhoaHoc); }
public List <KhoaHoc_DTO> LoadDSKhoaHocTheoTen(string tenkh) { SqlConnection connect = DataProvider.TaoKetNoi(); List <KhoaHoc_DTO> khoaHoc = new List <KhoaHoc_DTO>(); string truyVan = "SELECT * FROM KhoaHoc WHERE TenKH LIKE N'%{0}%' AND TrangThai = 1"; SqlDataReader reader = DataProvider.TruyVanDuLieu(string.Format(truyVan, tenkh), connect); while (reader.Read()) { KhoaHoc_DTO kh = new KhoaHoc_DTO() { MaKH = reader["MaKH"].ToString(), TenKH = reader["TenKH"].ToString(), NgayBatDau = DateTime.Parse(reader["NgayBatDau"].ToString()), NgayKetThuc = DateTime.Parse(reader["NgayKetThuc"].ToString()), HocPhi = int.Parse(reader["HocPhi"].ToString()), TrangThai = int.Parse(reader["TrangThai"].ToString()) }; khoaHoc.Add(kh); } reader.Close(); connect.Close(); return(khoaHoc); }
private void GetDetail() { if (khDTO != null) { khDTO = new KhoaHoc_DTO(); } khDTO.MaKH = txt_makh.Text; khDTO.TenKH = txt_tenkh.Text; khDTO.NgayBatDau = DateTime.Parse(dt_ngayBatDau.EditValue.ToString()); khDTO.NgayKetThuc = DateTime.Parse(dt_ngayKetThuc.EditValue.ToString()); khDTO.HocPhi = int.Parse(txt_hocPhi.Text); }
private void LoadDSKhoaHoc() { KhoaHoc_BUS khBUS = new KhoaHoc_BUS(); KhoaHoc_DTO khDTO = new KhoaHoc_DTO(); lsKhoaHoc = khBUS.DanhSachKH(); lke_khoaHoc.Properties.DataSource = lsKhoaHoc; lke_khoaHoc.Properties.DisplayMember = "MaKH"; lke_khoaHoc.Properties.ValueMember = "MaKH"; //lke_khoaHoc.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaKH", "Mã Khóa Học", 10)); //lke_khoaHoc.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenKH", "Tên Khóa Học", 20)); }
private void LoadDSKhoaHoc() { KhoaHoc_BUS khBUS = new KhoaHoc_BUS(); KhoaHoc_DTO khDTO = new KhoaHoc_DTO(); lsKhoaHoc = khBUS.DanhSachKH(); //cbo_khoaHoc.DataSource = lsKhoaHoc; //cbo_khoaHoc.DisplayMember = "TenKH"; //cbo_khoaHoc.ValueMember = "MaKH"; //cbo_searchKhoaHoc.DataSource = lsKhoaHoc; //cbo_searchKhoaHoc.DisplayMember = "TenKH"; //cbo_searchKhoaHoc.ValueMember = "MaKH"; }
public int UpdateKhoaHoc(KhoaHoc_DTO khDTO) { string update = "UPDATE KhoaHoc SET TenKH = @TenKH, NgayBatDau = @NgayBatDau, NgayKetThuc = @NgayKetThuc, HocPhi = @HocPhi WHERE MaKH = @MaKH"; SqlParameter[] parameter = new SqlParameter[5]; parameter[0] = new SqlParameter("@MaKH", khDTO.MaKH); parameter[1] = new SqlParameter("@TenKH", khDTO.TenKH); parameter[2] = new SqlParameter("@NgayBatDau", khDTO.NgayBatDau); parameter[3] = new SqlParameter("@NgayKetThuc", khDTO.NgayKetThuc); parameter[4] = new SqlParameter("@HocPhi", khDTO.HocPhi); SqlConnection connect = DataProvider.TaoKetNoi(); int ketQua = DataProvider.ExecuteUpdateQuery(update, parameter, connect); connect.Close(); return(ketQua); }
public int AddKhoaHoc(KhoaHoc_DTO khDTO) { string insert = "INSERT INTO KhoaHoc(MaKH, TenKH, NgayBatDau, NgayKetThuc, HocPhi, TrangThai) VALUES(@MaKH, @TenKH, @NgayBatDau, @NgayKetThuc, @HocPhi, 1)"; SqlParameter[] parameter = new SqlParameter[5]; parameter[0] = new SqlParameter("@MaKH", khDTO.MaKH); parameter[1] = new SqlParameter("@TenKH", khDTO.TenKH); parameter[2] = new SqlParameter("@NgayBatDau", khDTO.NgayBatDau); parameter[3] = new SqlParameter("@NgayKetThuc", khDTO.NgayKetThuc); parameter[4] = new SqlParameter("@HocPhi", khDTO.HocPhi); SqlConnection connect = DataProvider.TaoKetNoi(); int ketQua = DataProvider.ExecuteInsertQuery(insert, parameter, connect); connect.Close(); return(ketQua); }
private void dgcontrol_khoaHoc_Click(object sender, EventArgs e) { if (dgview_khoaHoc.SelectedRowsCount > 0) { int[] selectedRows = dgview_khoaHoc.GetSelectedRows(); foreach (int rowHandle in selectedRows) { if (rowHandle >= 0) { khDTO.MaKH = dgview_khoaHoc.GetRowCellValue(rowHandle, cl_makh).ToString().Trim(); khDTO.TenKH = dgview_khoaHoc.GetRowCellValue(rowHandle, cl_tenkh).ToString(); khDTO.NgayBatDau = DateTime.Parse(dgview_khoaHoc.GetRowCellValue(rowHandle, cl_ngayBatDau).ToString()); khDTO.NgayKetThuc = DateTime.Parse(dgview_khoaHoc.GetRowCellValue(rowHandle, cl_ngayKetThuc).ToString()); khDTO.HocPhi = int.Parse(dgview_khoaHoc.GetRowCellValue(rowHandle, cl_hocPhi).ToString()); } } } else { khDTO = null; } BindingChiTiet(); }
public int UpdateKH(KhoaHoc_DTO khDTO) { KhoaHoc_DAO khDAO = new KhoaHoc_DAO(); return(khDAO.UpdateKhoaHoc(khDTO)); }
public int AddKH(KhoaHoc_DTO khDTO) { KhoaHoc_DAO khDAO = new KhoaHoc_DAO(); return(khDAO.AddKhoaHoc(khDTO)); }