public VEPServicesViewModel GetVEPServices(int Id) { var DataOnDB = (from a in dbContext.VEP_Services where a.CaseId == Id select a).FirstOrDefault(); VEPServicesViewModel Model = new VEPServicesViewModel(); if (DataOnDB != null) { Model.Serviceid = DataOnDB.ServiceId; Model.ServiceTypeid = DataOnDB.ServiceTypeId; Model.ServiceNotes = DataOnDB.ServiceNotes; Model.DateCreated = DataOnDB.DateCreated; Model.Caseid = DataOnDB.CaseId; } return(Model); }
public void CreateService(VEPServicesViewModel model) { var dbContext = new SDIIS_DatabaseEntities(); try { VEP_Services servicesTable = new VEP_Services(); servicesTable.CaseId = model.Caseid; servicesTable.ServiceId = model.Serviceid; //servicesTable.PersonId = model.clientID; servicesTable.ServiceTypeId = model.ServiceTypeid; servicesTable.ServiceNotes = model.ServiceNotes.Trim(); servicesTable.DateCreated = DateTime.Now; //Value 1 means record is not active(Not deleted) servicesTable.isActive = 1; dbContext.VEP_Services.Add(servicesTable); dbContext.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; } }