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); }