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