public int addchuyennganh(Chuyennganh cn)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@MaCN", cn.MaNganh));
paras.Add(new SqlParameter("@TenCN", cn.TenNganh));
return(dp.ExcuteNonquery("addchuyennganh", CommandType.StoredProcedure, paras));
}
public int ThemGV_LH(GV_LH GH)
{
List<SqlParameter> list = new List<SqlParameter>();
list.Add(new SqlParameter("@magv", GH.MaGV));
list.Add(new SqlParameter("@malop", GH.MaLop));
try
{
return (dp.ExcuteNonquery("ThemGV_LH", System.Data.CommandType.StoredProcedure, list));
}
catch (Exception ex)
{
throw ex;
}
}
public int ThemSV_MH(SV_MH SH)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@masv", SH.MaSV));
list.Add(new SqlParameter("@mamh", SH.MaMH));
list.Add(new SqlParameter("@diem", SH.Diem));
try
{
return(dp.ExcuteNonquery("ThemSV_MH", System.Data.CommandType.StoredProcedure, list));
}
catch (SqlException ex)
{
throw ex;
}
}
public int ThemSV_LH(SV_LH SLH)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@masv", SLH.MaSV));
list.Add(new SqlParameter("@malop", SLH.MaLop));
list.Add(new SqlParameter("@diemgk", SLH.DiemGK));
list.Add(new SqlParameter("@diemck", SLH.DiemCK));
try
{
return(dp.ExcuteNonquery("ThemSV_LH", System.Data.CommandType.StoredProcedure, list));
}
catch (SqlException ex)
{
throw ex;
}
}
public int ThemMH(MonHoc MH)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@mamh", MH.MaMH));
list.Add(new SqlParameter("@tenmh", MH.TenMH));
list.Add(new SqlParameter("@sotinchi", MH.SoTinChi));
list.Add(new SqlParameter("@sotiet", MH.SoTiet));
list.Add(new SqlParameter("@manganh", MH.MaNganh));
try
{
return(dp.ExcuteNonquery("ThemMH", System.Data.CommandType.StoredProcedure, list));
}
catch (SqlException ex)
{
throw ex;
}
}
public int ThemLH(LopHoc LH)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@malop", LH.MaLH));
list.Add(new SqlParameter("@mamh1", LH.MaMH));
list.Add(new SqlParameter("@mahk", LH.MaHK));
list.Add(new SqlParameter("@tgbatdau", LH.ThoiGianBatDau));
list.Add(new SqlParameter("@tgketthuc", LH.ThoiGianKetThuc));
list.Add(new SqlParameter("@tinhtrang", LH.TinhTrang));
try
{
return(dp.ExcuteNonquery("ThemLH", System.Data.CommandType.StoredProcedure, list));
}
catch (Exception ex)
{
throw ex;
}
}
public int ThemSV(SinhVien SV)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@masv", SV.MaSV));
list.Add(new SqlParameter("@ho", SV.Ho));
list.Add(new SqlParameter("@ten", SV.Ten));
list.Add(new SqlParameter("@sdt", SV.SDT));
list.Add(new SqlParameter("@diachi", SV.DiaChi));
list.Add(new SqlParameter("@gioitinh", SV.GioiTinh));
list.Add(new SqlParameter("@email", SV.Email));
list.Add(new SqlParameter("@manganh", SV.MaNganh));
list.Add(new SqlParameter("@hinh", SV.HinhSV));
try
{
return(dp.ExcuteNonquery("Them", System.Data.CommandType.StoredProcedure, list));
}
catch (SqlException ex)
{
throw ex;
}
}
