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