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);
}
}
public bool InsertGiaoVien(GiaoVienVO gv)
{
try
{
string query = string.Format("insert into GiaoVien(MaGV,TenGV,DiaChi,SoDienThoai) Values(@MaGV,@TenGV,@DiaChi,@SoDienThoai)");
SqlParameter[] sqlParameters = new SqlParameter[4];
sqlParameters[0] = new SqlParameter("@MaGV", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(gv.MaGV);
sqlParameters[1] = new SqlParameter("@TenGV", SqlDbType.NVarChar);
sqlParameters[1].Value = Convert.ToString(gv.TenGV);
sqlParameters[2] = new SqlParameter("@DiaChi", SqlDbType.NVarChar);
sqlParameters[2].Value = Convert.ToString(gv.DiaChi);
sqlParameters[3] = new SqlParameter("@SoDienThoai", SqlDbType.VarChar);
sqlParameters[3].Value = Convert.ToString(gv.SoDienThoai);
return(conn.executeInsertQuery(query, sqlParameters));
}
catch
{
return(false);
}
}
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);
}
}
public bool InsertPhong(PhongVO P)
{
try
{
string query = string.Format("insert into Phong(MaPhong,TenPhong,SoMay) Values(@MaPhong,@TenPhong,@SoMay)");
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@MaPhong", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(P.MaPhong);
sqlParameters[1] = new SqlParameter("@TenPhong", SqlDbType.NVarChar);
sqlParameters[1].Value = Convert.ToString(P.TenPhong);
sqlParameters[2] = new SqlParameter("@SoMay", SqlDbType.Int);
sqlParameters[2].Value = Convert.ToString(P.SoMay);
return(conn.executeInsertQuery(query, sqlParameters));
}
catch
{
return(false);
}
}
public bool insertLapLich(LichDayVO ld)
{
try
{
string query = string.Format("insert into LichDayLyThuyet(MaGV,MaMH,MaLop,MaPhong,Tuan,Thu,Tiet) Values(@MaGV,@MaMH,@MaLop,@MaPhong,@Tuan,@Thu,@Tiet)");
SqlParameter[] sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@MaGV", SqlDbType.VarChar);
sqlParameters[0].Value = Convert.ToString(ld.MaGV);
sqlParameters[1] = new SqlParameter("@MaMH", SqlDbType.NVarChar);
sqlParameters[1].Value = Convert.ToString(ld.MaMH);
sqlParameters[2] = new SqlParameter("@MaLop", SqlDbType.NVarChar);
sqlParameters[2].Value = Convert.ToString(ld.MaLop);
sqlParameters[3] = new SqlParameter("@MaPhong", SqlDbType.VarChar);
sqlParameters[3].Value = Convert.ToString(ld.MaPhong);
sqlParameters[4] = new SqlParameter("@Tuan", SqlDbType.VarChar);
sqlParameters[4].Value = Convert.ToString(ld.Tuan);
sqlParameters[5] = new SqlParameter("@Thu", SqlDbType.VarChar);
sqlParameters[5].Value = Convert.ToString(ld.Thu);
sqlParameters[6] = new SqlParameter("@Tiet", SqlDbType.VarChar);
sqlParameters[6].Value = Convert.ToString(ld.Tiet);
return(conn.executeInsertQuery(query, sqlParameters));
}
catch
{
return(false);
}
}
