public static void UpdateJobID(PrcRequisition prcRequisition) { using (var context = new EServicesDBContext()) { PrcRequisition request = context.PrcRequisition.Where(x => x.Id == prcRequisition.Id).FirstOrDefault(); request.JobId = prcRequisition.JobId; context.SaveChanges(); } }
public static int AddNewRequest(PrcRequisition prcRequisition) { using (var context = new EServicesDBContext()) { if (prcRequisition.RequisitionNatureId == 18) { PrcRequisitionNature newNature = new PrcRequisitionNature(); newNature.RequisitionNatureAr = prcRequisition.RequisitionNature.RequisitionNatureAr; newNature.RequisitionNatureEn = prcRequisition.RequisitionNature.RequisitionNatureEn; newNature.Default = false; context.PrcRequisitionNature.Add(newNature); context.SaveChanges(); prcRequisition.RequisitionNatureId = newNature.Id; } context.PrcRequisition.Add(prcRequisition); context.SaveChanges(); } return(prcRequisition.Id); }
public static void addNewHistoricalRecord(string approverId, string jobId, short nodeId, string activityName, string decisionId, string decisionomment) { using (EServicesDBContext a = new EServicesDBContext()) { CoreApprovals newEntry = new CoreApprovals(); newEntry.JobId = jobId; newEntry.NodeId = nodeId; newEntry.Name = approverId; newEntry.Role = activityName; newEntry.Comment = decisionId; newEntry.Notes = decisionomment; newEntry.Date = DateTime.Now; a.CoreApprovals.Add(newEntry); a.SaveChanges(); } }
public static void UpdateRequest(PrcRequisition prcRequisition, List <JsonFieldsDTO> fields) { using (var context = new EServicesDBContext()) { //Context.Entry<PrcRequisition>(prcRequisition).Property(x => prop.Name).IsModified = false; context.PrcRequisition.Update(prcRequisition); if (fields != null && fields.Count > 0) { foreach (var prop in typeof(PrcRequisition).GetProperties()) { var match = fields.FirstOrDefault(x => x.FieldName == prop.Name); if (!match.Editable) { context.Entry <PrcRequisition>(prcRequisition).Property(x => prop.Name).IsModified = false; } } } context.SaveChanges(); } }