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