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