public List <Lop_DTO> loadDSLop2(string MaKhoa)
{
List <Lop_DTO> lsLop = new List <Lop_DTO>();
SqlConnection connect = DataProvider.TaoKetNoi();
string strTruyVan = "SELECT MaLop, TenLop, LichHoc, GioBatDau, MaNV FROM Lop WHERE MaKhoaHoc = @MaKhoaHoc GROUP BY MaLop, TenLop, MaKhoaHoc, LichHoc, GioBatDau, MaNV";
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@MaKhoaHoc", MaKhoa);
SqlDataReader reader = DataProvider.TruyVanDuLieu(strTruyVan, parameter, connect);
while (reader.Read())
{
Lop_DTO loai = new Lop_DTO()
{
MaLop = reader["MaLop"].ToString(),
TenLop = reader["TenLop"].ToString(),
MaNV = reader["MaNV"].ToString(),
LichHoc = reader["LichHoc"].ToString(),
GioBatDau = reader["GioBatDau"].ToString()
};
lsLop.Add(loai);
}
reader.Close();
connect.Close();
return(lsLop);
}
public List <Lop_DTO> LoadDSLop()
{
List <Lop_DTO> lsLop = new List <Lop_DTO>();
SqlConnection connect = DataProvider.TaoKetNoi();
string strTruyVan = "SELECT * FROM Lop WHERE TrangThai = 1";
SqlDataReader reader = DataProvider.TruyVanDuLieu(strTruyVan, connect);
while (reader.Read())
{
Lop_DTO loai = new Lop_DTO()
{
MaLop = reader["MaLop"].ToString(),
TenLop = reader["TenLop"].ToString(),
MaNV = reader["MaNV"].ToString(),
MaPhg = reader["MaPhg"].ToString(),
MaKhoaHoc = reader["MaKhoaHoc"].ToString(),
LichHoc = reader["LichHoc"].ToString(),
GioBatDau = reader["GioBatDau"].ToString(),
GioKetThuc = reader["GioKetThuc"].ToString(),
//SoHV = int.Parse(reader["SoHV"].ToString()),
TrangThai = int.Parse(reader["TrangThai"].ToString())
};
lsLop.Add(loai);
}
reader.Close();
connect.Close();
return(lsLop);
}
private void dgcontrol_lopHoc_Click(object sender, EventArgs e)
{
if (dgview_lopHoc.SelectedRowsCount > 0)
{
int[] selectedRows = dgview_lopHoc.GetSelectedRows();
foreach (int rowHandle in selectedRows)
{
if (rowHandle >= 0)
{
lopDTO.MaLop = dgview_lopHoc.GetRowCellValue(rowHandle, cl_malop).ToString().Trim();
lopDTO.MaKhoaHoc = dgview_lopHoc.GetRowCellValue(rowHandle, cl_makhoahoc).ToString().Trim();
lopDTO.TenLop = dgview_lopHoc.GetRowCellValue(rowHandle, cl_tenlop).ToString().Trim();
lopDTO.MaNV = dgview_lopHoc.GetRowCellValue(rowHandle, cl_manv).ToString().Trim();
lopDTO.MaPhg = dgview_lopHoc.GetRowCellValue(rowHandle, cl_maphg).ToString().Trim();
lopDTO.LichHoc = dgview_lopHoc.GetRowCellValue(rowHandle, cl_lichhoc).ToString().Trim();
lopDTO.GioBatDau = dgview_lopHoc.GetRowCellValue(rowHandle, cl_giobatdau).ToString().Trim();
lopDTO.GioKetThuc = dgview_lopHoc.GetRowCellValue(rowHandle, cl_gioketthuc).ToString().Trim();
}
}
}
else
{
lopDTO = null;
}
BindingChiTiet();
}
public List <Lop_DTO> LayTatCaLop()
{
List <Lop_DTO> dsLop = new List <Lop_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("select Lop.*,TenKhoi,TenGiaoVien,MaGiaoVien from Lop left join Khoi on Khoi.MaKhoi = Lop.MaKhoi left join GVCN on Lop.MaLop = GVCN.MaLop left join GiaoVien on GiaoVien.MaGiaoVien = GVCN.MaGaioVien");
foreach (DataRow row in data.Rows)
{
Lop_DTO lop = new Lop_DTO(row);
dsLop.Add(lop);
}
return(dsLop);
}
public List <Lop_DTO> TimKiemLop(string param)
{
List <Lop_DTO> dsLop = new List <Lop_DTO>();
string query = string.Format("select Lop.*,TenKhoi,TenGiaoVien,MaGiaoVien from Lop left join Khoi on Khoi.MaKhoi = Lop.MaKhoi left join GVCN on Lop.MaLop = GVCN.MaLop left join GiaoVien on GiaoVien.MaGiaoVien = GVCN.MaGaioVien where TenLop like N'%{0}%'", param);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow row in data.Rows)
{
Lop_DTO lop = new Lop_DTO(row);
dsLop.Add(lop);
}
return(dsLop);
}
private void LoadDSLop()
{
Lop_BUS lopBUS = new Lop_BUS();
Lop_DTO lopDAO = new Lop_DTO();
lsLop = lopBUS.DanhSachLop();
lke_lopHoc.Properties.DataSource = lsLop;
lke_lopHoc.Properties.DisplayMember = "MaLop";
lke_lopHoc.Properties.ValueMember = "MaLop";
lke_lopHoc.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaLop", "Mã Lớp Học", 10));
lke_lopHoc.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenLop", "Tên Lớp Học", 20));
}
private void GetDetail()
{
if (lopDTO != null)
{
lopDTO = new Lop_DTO();
}
lopDTO.MaLop = txt_maLop.Text.Trim();
lopDTO.MaKhoaHoc = lke_makh.Text.Trim();
lopDTO.TenLop = txt_tenLop.Text.Trim();
lopDTO.MaNV = lke_maNhanVien.Text.Trim();
lopDTO.MaPhg = cbo_maPhong.Text.Trim();
lopDTO.LichHoc = cbo_lichHoc.Text.Trim();
lopDTO.GioBatDau = txt_gioBatDau.Text.Trim();
lopDTO.GioKetThuc = txt_gioKetThuc.Text.Trim();
}
private void LoadDSLop()
{
Lop_BUS lopBUS = new Lop_BUS();
Lop_DTO lopDAO = new Lop_DTO();
lsLop = lopBUS.DanhSachLop();
//cbo_maLop.DataSource = lsLop;
//cbo_maLop.DisplayMember = "MaLop";
//cbo_maLop.ValueMember = "MaLop";
//cbo_searchLop.DataSource = lsLop;
//cbo_searchLop.DisplayMember = "MaLop";
//cbo_searchLop.ValueMember = "MaLop";
}
public int UpdateLopHoc(Lop_DTO lopDTO)
{
string update = "UPDATE Lop SET MaLop = @MaLop, TenLop = @TenLop, MaNV = @MaNV, MaPhg = @MaPhg, MaKhoaHoc = @MaKhoaHoc, LichHoc = @LichHoc, GioBatDau = @GioBatDau, GioKetThuc = @GioKetThuc WHERE MaLop = @MaLop";
SqlParameter[] parameter = new SqlParameter[8];
parameter[0] = new SqlParameter("@MaLop", lopDTO.MaLop);
parameter[1] = new SqlParameter("@TenLop", lopDTO.TenLop);
parameter[2] = new SqlParameter("@MaNV", lopDTO.MaNV);
parameter[3] = new SqlParameter("@MaPhg", lopDTO.MaPhg);
parameter[4] = new SqlParameter("@MaKhoaHoc", lopDTO.MaKhoaHoc);
parameter[5] = new SqlParameter("@LichHoc", lopDTO.LichHoc);
parameter[6] = new SqlParameter("@GioBatDau", lopDTO.GioBatDau);
parameter[7] = new SqlParameter("@GioKetThuc", lopDTO.GioKetThuc);
SqlConnection connect = DataProvider.TaoKetNoi();
int ketQua = DataProvider.ExecuteUpdateQuery(update, parameter, connect);
connect.Close();
return(ketQua);
}
public int AddLopHoc(Lop_DTO lopDTO)
{
string insert = "INSERT INTO Lop (MaLop, TenLop, MaNV, MaPhg, MaKhoaHoc, LichHoc, GioBatDau, GioKetThuc, SoHV, TrangThai) VALUES (@MaLop, @TenLop, @MaNV, @MaPhg, @MaKhoaHoc, @LichHoc, @GioBatDau, @GioKetThuc, NULL, 1)";
SqlParameter[] parameter = new SqlParameter[8];
parameter[0] = new SqlParameter("@MaLop", lopDTO.MaLop);
parameter[1] = new SqlParameter("@TenLop", lopDTO.TenLop);
parameter[2] = new SqlParameter("@MaNV", lopDTO.MaNV);
parameter[3] = new SqlParameter("@MaPhg", lopDTO.MaPhg);
parameter[4] = new SqlParameter("@MaKhoaHoc", lopDTO.MaKhoaHoc);
parameter[5] = new SqlParameter("@LichHoc", lopDTO.LichHoc);
parameter[6] = new SqlParameter("@GioBatDau", lopDTO.GioBatDau);
parameter[7] = new SqlParameter("@GioKetThuc", lopDTO.GioKetThuc);
SqlConnection connect = DataProvider.TaoKetNoi();
int ketQua = DataProvider.ExecuteInsertQuery(insert, parameter, connect);
connect.Close();
return(ketQua);
}
public int AddLop(Lop_DTO lopDTO)
{
Lop_DAO lopDAO = new Lop_DAO();
return(lopDAO.AddLopHoc(lopDTO));
}
public int UpdateLop(Lop_DTO lopDTO)
{
Lop_DAO lopDAO = new Lop_DAO();
return(lopDAO.UpdateLopHoc(lopDTO));
}
