public bool InsertMonHoc(MonHocVO MH) { try { string query = string.Format("insert into MonHoc(MaMH,TenMonHoc,SoChi,SoTiet,Khoa) Values(@MaMH,@TenMonHoc,@SoChi,@SoTiet,@Khoa)"); SqlParameter[] sqlParameters = new SqlParameter[5]; sqlParameters[0] = new SqlParameter("@MaMH", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(MH.MaMH); sqlParameters[1] = new SqlParameter("@TenMonHoc", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(MH.TenMonHoc); sqlParameters[2] = new SqlParameter("@SoChi", SqlDbType.Int); sqlParameters[2].Value = Convert.ToString(MH.SoChi); sqlParameters[3] = new SqlParameter("@SoTiet", SqlDbType.Int); sqlParameters[3].Value = Convert.ToString(MH.SoTiet); sqlParameters[4] = new SqlParameter("@Khoa", SqlDbType.NVarChar); sqlParameters[4].Value = Convert.ToString(MH.Khoa); return(conn.executeInsertQuery(query, sqlParameters)); } catch { return(false); } }
// add data to each Sheet. private void addDataToExcel(Worksheet workSheet, List <LichDayVO> listLichDay) { for (int i = 0; i < listLichDay.Count; i++) { MonHocVO subject = monHocBUS.getObjectMonHocByMa(listLichDay[i].MaMH); String tenGV = giaoVienBUS.getNameGiaoVienByMa(listLichDay[i].MaGV); String tenLop = lopHocBUS.getTenLopHocByMa(listLichDay[i].MaLop); // content format : TenGiaoVien-TenMonHoc-TenLop(tietBatDau-tietKetThuc). String content = tenGV + "-" + subject.TenMonHoc + "-" + tenLop + "(" + listLichDay[i].Tiet + ")"; // Lay Thu String number = listLichDay[i].Thu; for (int k = 0; k < numberPhong; k++) { if ((listLichDay[i].MaPhong).Equals(listPhong[k].MaPhong)) { String tiet = listLichDay[i].Tiet; int TietEnd = Int32.Parse(tiet.Split('-')[1]); if (TietEnd < 7) { workSheet.Cells[5 + k, 2 + Int32.Parse(number)] = content; } else { workSheet.Cells[5 + k + numberPhong + 1, 2 + Int32.Parse(number)] = content; } } } } }
public bool DeleteMonHoc(MonHocVO MH) { try { string query = string.Format("DELETE MonHoc Where MaMH = @MaMH and TenMonHoc=@TenMonHoc and SoChi=@SoChi and SoTiet=@SoTiet and Khoa=@Khoa"); SqlParameter[] sqlParameters = new SqlParameter[4]; sqlParameters[0] = new SqlParameter("@MaMH", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(MH.MaMH); sqlParameters[1] = new SqlParameter("@TenMonHoc", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(MH.TenMonHoc); sqlParameters[2] = new SqlParameter("@SoChi", SqlDbType.Int); sqlParameters[2].Value = Convert.ToString(MH.SoChi); sqlParameters[3] = new SqlParameter("@SoTiet", SqlDbType.Int); sqlParameters[3].Value = Convert.ToString(MH.SoTiet); sqlParameters[4] = new SqlParameter("@Khoa", SqlDbType.NVarChar); sqlParameters[4].Value = Convert.ToString(MH.Khoa); return(conn.executeInsertQuery(query, sqlParameters)); } catch { return(false); } }
public bool themMonHoc(MonHocVO MH) { bool a = _MonHocDAO.InsertMonHoc(MH); if (a == true) { return(true); } return(false); }
public DataTable getMonHocByName(MonHocVO MH) { string query = string.Format("select * from MonHoc where TenMonHoc = @TenMonHoc"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@TenMonHoc", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(MH.TenMonHoc); return(conn.executeSelectQuery(query, sqlParameters)); }
public int themMonHocTheoTen(MonHocVO MH) { for (int i = 1; i < 1000; i++) { string monHoc = "MH"; if (i < 10) { monHoc = monHoc + "00"; } else { if (i < 100) { monHoc = monHoc + "0"; } } monHoc = monHoc + i; DataTable dt = new DataTable(); DataTable dt2 = new DataTable(); MH.MaMH = monHoc; dt = _MonHocDAO.searchMaMonHoc(MH); dt2 = _MonHocDAO.searchTenMonHoc(MH); string maMH = "", tenMH = ""; if (dt2 != null) { foreach (DataRow dr in dt2.Rows) { tenMH = dr[1].ToString(); } } if (tenMH != "") { return(2); } if (dt != null) { foreach (DataRow dr in dt.Rows) { maMH = dr[0].ToString(); } } if (maMH == "") { MH.MaMH = monHoc; if (_MonHocDAO.InsertMonHocTheoTen(MH)) { return(1); } } } return(0); }
public MonHocVO getObjectMonHocByMa(String maMH) { MonHocVO monHocVO = new MonHocVO(); DataTable dataTable = new DataTable(); dataTable = _MonHocDAO.getMonHocByMa(maMH); if (dataTable != null) { foreach (DataRow dr in dataTable.Rows) { monHocVO.MaMH = dr[0].ToString(); monHocVO.TenMonHoc = dr[1].ToString(); } } return(monHocVO); }
public DataTable searchTenMonHoc(MonHocVO mH) { string query = string.Format("select * from MonHoc where TenMonHoc=N'" + mH.TenMonHoc + "'"); return(conn.executeSelectQueryNoParam(query)); }
public bool XoaMonHoc(MonHocVO MH) { return(_MonHocDAO.DeleteMonHoc(MH)); }
public bool CapNhatMonHoc(MonHocVO MH) { return(_MonHocDAO.UpdateMonHoc(MH)); }