public void UpdateReferrals(VEPReferalsViewModel vmodel)
{
var OldObj = (from c in dbContext.VEP_Referals
where c.CaseId == (vmodel.Caseid)
select c).FirstOrDefault();
if (OldObj != null)
{
OldObj.CreateDate = vmodel.CreateDate;
OldObj.Createdby = (from r in dbContext.Users
where r.User_Name == vmodel.CreatedByString
select r.User_Id).FirstOrDefault();
OldObj.FromDepartment = Convert.ToInt32(vmodel.FromDepartment);
OldObj.ToDepartment = Convert.ToInt32(vmodel.ToDepartment);
OldObj.Notes = vmodel.Notes;
dbContext.SaveChanges();
}
else
{
var NewObj = new VEP_Referals();
NewObj.CreateDate = vmodel.CreateDate;
NewObj.Createdby = vmodel.Createdby;
NewObj.FromDepartment = Convert.ToInt32(vmodel.FromDepartment);
NewObj.ToDepartment = Convert.ToInt32(vmodel.ToDepartment);
NewObj.Notes = vmodel.Notes;
NewObj.CaseId = vmodel.Caseid;
//NewObj.CaseId = Convert.ToInt32(Session["CaseID"]);
dbContext.VEP_Referals.Add(NewObj);
dbContext.SaveChanges();
}
}
public VEP_Referals CreateReferrals(VEP_Referals model)
{
var dbContext = new SDIIS_DatabaseEntities();
try
{
VEP_Referals referalTable = new VEP_Referals();
referalTable.CaseId = model.CaseId;
referalTable.FromDepartment = 1;
referalTable.ToDepartment = Convert.ToInt32(model.ToDepartment);
referalTable.Notes = model.Notes;
referalTable.Createdby = model.Createdby;
referalTable.CreateDate = DateTime.Now;
dbContext.VEP_Referals.Add(referalTable);
dbContext.SaveChanges();
return(model);
}
catch (Exception ex)
{
var Test = ex.Message;
return(null);
}
}