public int luuDeChuan(DECHUAN de)
{
try
{
object[] valparams =
{
new SqlParameter("@tende", de.TenDeChuan),
new SqlParameter("@VARsubjectID", de.MaMon),
new SqlParameter("@macathi", de.MaCaThi),
new SqlParameter("@sodehoanvi", de.SoDeHoanVi),
new SqlParameter("@thoigianthi", de.ThoiGian),
};
int res = db.Database.ExecuteSqlCommand("setDECHUAN2 @tende, @VARsubjectID, @macathi, @sodehoanvi, @thoigianthi", valparams);
db.SaveChanges();
return(res);
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("- Entity of type \"{0}\", in state \"{1}\" has the following validation errors: ", eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
return(-1);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
return(-1);
}
}
public ActionResult SaveTest(DECHUAN de)
{
Guid idsub = new SubjectDAO().ShowAllSubIDSingle(de.MaDeChuan).SubjectID;
de.MaMon = idsub;
de.MaDeChuan = -1;
int id = new DeChuanDAO().luuDeChuan(de);
return(Json(id, JsonRequestBehavior.AllowGet));
}
public bool DeleteDECHUAN(int id)
{
try
{
DECHUAN u = db.DECHUANs.Single(p => p.MaDeChuan == id);
db.DECHUANs.Remove(u);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
return(false);
}
return(true);
}
public bool UpdateDECHUAN(DECHUAN DECHUANDAO)
{
try
{
DECHUAN u = db.DECHUANs.Where(p => p.MaDeChuan == DECHUANDAO.MaDeChuan).SingleOrDefault();
u.TenDeChuan = DECHUANDAO.TenDeChuan;
u.MaMon = DECHUANDAO.MaMon;
u.SoDeHoanVi = DECHUANDAO.SoDeHoanVi;
u.TrangThaiTron = DECHUANDAO.TrangThaiTron;
u.ThoiGian = DECHUANDAO.ThoiGian;
u.Lock = DECHUANDAO.Lock;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}