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 VEPReferalsViewModel GetVEPReferrals(int Id)
{
var DataOnDB = (from a in dbContext.VEP_Referals
where a.CaseId == Id
select a).FirstOrDefault();
VEPReferalsViewModel Model = new VEPReferalsViewModel();
//Model.CreateDate = DataOnDB.CreateDate;
Model.CreateDate = DateTime.Now;
Model.Createdby = DataOnDB.Createdby;
//Model.CreatedByString = dbContext.Users.Find(DataOnDB.Createdby).User_Name;
Model.CreatedByString = "";
Model.FromDepartment = DataOnDB.FromDepartment.ToString();
Model.ToDepartment = DataOnDB.ToDepartment.ToString();
Model.Notes = DataOnDB.Notes;
return(Model);
}
