public bool DeleteLopHoc(LopVO LH)
{
try
{
string query = string.Format("DELETE from Lop Where MaLop = @MaLop and TenLop=@TenLop and SoLuongSV=@SoLuongSV");
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@MaLop", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(LH.MaLop);
sqlParameters[1] = new SqlParameter("@TenLop", SqlDbType.NVarChar);
sqlParameters[1].Value = Convert.ToString(LH.TenLop);
sqlParameters[2] = new SqlParameter("@SoLuongSV", SqlDbType.Int);
sqlParameters[2].Value = Convert.ToString(LH.SoLuongSV);
return(conn.executeInsertQuery(query, sqlParameters));
}
catch
{
return(false);
}
}
public bool themLopHoc(LopVO LH)
{
if (_LopHocDAO.InsertLopHoc(LH) == true)
{
return(true);
}
else
{
return(false);
}
}
public DataTable getLopByName(LopVO L)
{
string query = string.Format("select * from Lop where TenLop = @TenLop");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@TenLop", SqlDbType.NVarChar);
sqlParameters[0].Value = Convert.ToString(L.TenLop);
return(conn.executeSelectQuery(query, sqlParameters));
}
private PhongVO kiemPhongDuSoMay(LopVO lopHocVO, LichDayVO lichDayNho)
{
for (int k = 0; k < listPhongTam.Count; k++)
{
if (listPhongTam[k].SoMay >= lopHocVO.SoLuongSV)
{
return(listPhongTam[k]);
}
}
return(null);
}
private List <PhongVO> kiemThemPhongDuSoMay(LopVO lopHocVO, List <PhongVO> listPhongTam)
{
int soMayNhieuPhong = 0;
List <PhongVO> listCacPhongDanhCho1LTH = new List <PhongVO>();
int j = listPhongTam.Count - 1;
while (j >= 0 && soMayNhieuPhong <= lopHocVO.SoLuongSV)
{
soMayNhieuPhong = soMayNhieuPhong + listPhongTam[j].SoMay;
listCacPhongDanhCho1LTH.Add(listPhongTam[j]);
j--;
}
return(listCacPhongDanhCho1LTH);
}
// lay ra danh sach LopHoc tuong voi List Lich Day.
private List <LopVO> getListLopHoc(List <LichDayVO> listLichDay)
{
List <LopVO> listOutPut = new List <LopVO>();
foreach (LichDayVO lich in listLichDay)
{
LopVO lopVO = new LopVO();
String ma = lich.MaLop;
lopVO = lophocBus.getLopHocByMa(ma);
listOutPut.Add(lopVO);
}
// sap xep lop theo so luong sinh vien giam dan.
listOutPut.Sort(comparerLop);
return(listOutPut);
}
public LopVO getLopHocByName(LopVO lh)
{
LopVO lopHocVO = new LopVO();
DataTable dataTable = new DataTable();
dataTable = _LopHocDAO.getLopByName(lh);
if (dataTable != null)
{
foreach (DataRow dr in dataTable.Rows)
{
lopHocVO.MaLop = dr[0].ToString();
lopHocVO.TenLop = dr[1].ToString();
}
}
return(lopHocVO);
}
public LopVO getLopHocByMa(String ma)
{
LopVO lopHocVO = new LopVO();
DataTable dataTable = new DataTable();
dataTable = _LopHocDAO.getLopByMa(ma);
if (dataTable != null)
{
foreach (DataRow dr in dataTable.Rows)
{
lopHocVO.MaLop = dr[0].ToString();
lopHocVO.TenLop = dr[1].ToString();
lopHocVO.SoLuongSV = Int32.Parse(dr[2].ToString());
}
}
return(lopHocVO);
}
private List <LopVO> getListLopHoc()
{
List <LopVO> lLopHoc = new List <LopVO>();
DataTable dt = new DataTable();
dt = lopHocDAO.GetAllLopHoc();
if (dt != null)
{
foreach (DataRow r in dt.Rows)
{
LopVO lopHocVO = new LopVO();
lopHocVO.MaLop = r[0].ToString();
lopHocVO.TenLop = r[1].ToString();
lopHocVO.SoLuongSV = Convert.ToInt32(r[2]);
lLopHoc.Add(lopHocVO);
}
}
return(lLopHoc);
}
public bool InsertLopHoc(LopVO LH)
{
try
{
string query = string.Format("insert into Lop(MaLop,TenLop,SoLuongSV) Values(@MaLop,@TenLop,@SoLuongSV)");
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@MaLop", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(LH.MaLop);
sqlParameters[1] = new SqlParameter("@TenLop", SqlDbType.NVarChar);
sqlParameters[1].Value = Convert.ToString(LH.TenLop);
sqlParameters[2] = new SqlParameter("@SoLuongSV", SqlDbType.Int);
sqlParameters[2].Value = Convert.ToString(LH.SoLuongSV);
return(conn.executeInsertQuery(query, sqlParameters));
}
catch
{
return(false);
}
}
private void importExelToSQL(DataTable dt)
{
if (dt != null)
{
for (int i = 3; i < dt.Rows.Count; i++)
{
for (int j = 3; j < dt.Columns.Count; j++)
{
string str = dt.Rows[i].ItemArray[j].ToString();
if (str != "")
{
if (str != " " || str != "\n" || str != " " || str != " ")
{
String[] mang = str.Split('(');
String[] ten = mang[0].Split('-');
string tenGV = ten[0];
string tenMH = ten[1];
string tenLop = ten[2];
string tiet = mang[1].Split(')')[0];
GiaoVienVO GV = new GiaoVienVO();
MonHocVO MH = new MonHocVO();
LopVO LH = new LopVO();
//lay ma GV thong qua TenGV
GV.TenGV = tenGV;
//tao maGV dua vao ten
//GV.TenGV=tenGV.Split(' ')o
GiaoVienVO gv = giaoVienBUS.getGiaoVienByName(GV);
//lay maMH thong qua TenMH
MH.TenMonHoc = tenMH;
MonHocVO mh = monHocBUS.getMonHocByName(MH);
//Lay MaLop Thong Qua Ten
LH.TenLop = tenLop;
LopVO lh = lopHocBUS.getLopHocByName(LH);
LichDayVO LD = new LichDayVO();
LD.MaGV = gv.MaGV;
LD.MaMH = mh.MaMH;
LD.MaLop = lh.MaLop;
LD.Thu = j - 1 + "";
LD.Tiet = tiet;
//cat chuoi lay tuan
string chuoi = dt.Rows[2].ItemArray[0].ToString();
string layChuoiCoTuan = (chuoi.Split('\n')[0]).Trim();
string tuanDangString = (layChuoiCoTuan.Split(' ')[1]).Trim();
int tuan = Convert.ToInt32(tuanDangString);
LD.Tuan = tuan;
lapLichBUS.themLapLichBoPhong(LD);
//LD.MaPhong = "P001"; ->khoi truyen
//if (lapLichBUS.themLapLichBoPhong(LD))
// MessageBox.Show("Da Them Vao CSDL");
//else
// MessageBox.Show("ko them vao CSDL duoc");
}
}
}
}
}
}
public bool XoaLopHoc(LopVO LH)
{
return(_LopHocDAO.DeleteLopHoc(LH));
}
public bool CapNhatLopHoc(LopVO LH)
{
return(_LopHocDAO.UpdateLopHoc(LH));
}
