/// <summary>
/// Xoa 1 record dựa vào mã lop
/// </summary>
/// <param name="maLop"></param>
public void Delete(string maLop)
{
using (var context = new QuanLyDaoTaoEntities())
{
Lop lp = context.Lops.Find(maLop);
if (lp != null)
{
context.Lops.Remove(lp);
context.SaveChanges();
}
}
}
public int SuaLop(Lop lop)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@tenlop", lop.TenLop));
list.Add(new SqlParameter("@namhoc", lop.SiSo));
list.Add(new SqlParameter("@khoahoc", lop.NamHoc));
try
{
return(ExecProcedure("SuaLop", System.Data.CommandType.StoredProcedure, list));
}
catch (SqlException ex)
{
throw ex;
}
}
public List <Lop> getLop()
{
try
{
string sql = "select lop.MaLop,lop.TenLop,lop.SiSo, lop.NamHoc,Khoi.TenKhoi from dbo.Lop lop join Khoi on Lop.MaKhoi = Khoi.MaKhoi";
SqlDataReader dr = dp.myExecuteReader(sql);
List <Lop> list = new List <Lop>();
int malop, siso, namhoc;
string tenlop, tenkhoi;
while (dr.Read())
{
malop = dr.GetInt32(0);
tenlop = dr.GetString(1);
siso = dr.GetInt32(2);
<< << << < HEAD
namhoc = dr.GetInt32(3);
makhoi = dr.GetInt32(4);
Lop lop = new Lop(malop, tenlop, siso, namhoc, makhoi);
public int ThemLop(Lop lop)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@tenlop", lop.TenLop));
list.Add(new SqlParameter("@namhoc", lop.NamHoc));
list.Add(new SqlParameter("@makhoi", lop.MaKhoi));
try
{
dp.Connect();
return(ExecProcedure("ThemLop", System.Data.CommandType.StoredProcedure, list));
}
catch (SqlException ex)
{
dp.DisConnect();
throw ex;
}
}
public List <Lop> getLop()
{
try
{
string sql = "select lop.MaLop,lop.TenLop,lop.SiSo, lop.NamHoc,Khoi.TenKhoi from dbo.Lop lop join Khoi on Lop.MaKhoi = Khoi.MaKhoi";
SqlDataReader dr = dp.myExecuteReader(sql);
List <Lop> list = new List <Lop>();
int malop, siso, namhoc;
string tenlop, tenkhoi;
while (dr.Read())
{
malop = dr.GetInt32(0);
tenlop = dr.GetString(1);
siso = dr.GetInt32(2);
////<<<<<<< HEAD
// namhoc = dr.GetInt32(3);
// makhoi = dr.GetInt32(4);
// Lop lop = new Lop(malop, tenlop, siso, namhoc, makhoi);
//=======
namhoc = Convert.ToInt32(dr.GetString(3));
tenkhoi = dr.GetString(4);
Lop lop = new Lop(malop, tenlop, siso, namhoc, tenkhoi);
//>>>>>>> origin/dev
list.Add(lop);
}
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dp.DisConnect();
}
}
