public PCMDiversionViewModel GetUpdateDiversion_M(int mId)
{
PCMDiversionViewModel vm = new PCMDiversionViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from m in db.PCM_Diversion_M
where (m.M_Id == mId)
select m.M_Id).FirstOrDefault();
PCM_Diversion_M mm = db.PCM_Diversion_M.Find(id);
if (mm != null)
{
vm.M_Id = db.PCM_Diversion_M.Find(mm.M_Id).M_Id;
vm.P_Id = mm.P_Id;
vm.Modules_Id = mm.Modules_Id;
vm.No_Module = mm.No_Module;
vm.Sessions = mm.Sessions;
vm.No_Sessions = mm.No_Sessions;
vm.Session_StartDate = mm.Session_StartDate;
vm.Session_EndDate = mm.Session_EndDate;
db.SaveChanges();
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(vm);
}
}
public void UpdateDiversion_M(PCMDiversionViewModel vm, int mId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Diversion_M mm = db.PCM_Diversion_M.Find(mId);
mm.P_Id = vm.P_Id;
mm.Modules_Id = vm.Modules_Id;
mm.No_Module = vm.No_Module;
mm.Sessions = vm.Sessions;
mm.No_Sessions = vm.No_Sessions;
mm.Session_StartDate = vm.Session_StartDate;
mm.Session_EndDate = vm.Session_EndDate;
db.SaveChanges();
}
catch
{
}
}
}
public void CreateDiversion_M(PCMDiversionViewModel vm)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Diversion_M m = new PCM_Diversion_M();
m.P_Id = vm.P_Id;
m.Modules_Id = vm.Modules_Id;
m.No_Module = vm.No_Module;
m.Sessions = vm.Sessions;
m.No_Sessions = vm.No_Sessions;
m.Session_StartDate = vm.Session_StartDate;
m.Session_EndDate = vm.Session_EndDate;
db.PCM_Diversion_M.Add(m);
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
