private static List <HistoricalRecord> getHistoricalRecordsFromEServicesDB(string jobID) { List <HistoricalRecord> returned = new List <HistoricalRecord>(); using (EServicesDBContext a = new EServicesDBContext()) { var histrocialRecords = (from p in a.CoreApprovals where p.JobId.Equals(jobID) select new { p.JobId, p.NodeId, p.Name, p.Role, p.Comment, p.Notes, p.Date }).OrderBy(x => x.Date).ToArray(); foreach (var oneRecord in histrocialRecords) { HistoricalRecord historicalRecord = new HistoricalRecord(); historicalRecord.JobID = oneRecord.JobId; historicalRecord.NodeID = (short)oneRecord.NodeId; historicalRecord.Name = oneRecord.Name; historicalRecord.ActivityName = oneRecord.Role; historicalRecord.Action = (from p in a.view_DecisionChoices where p.Lookup_Item_ID.Equals(oneRecord.Comment) select new { p.TextAR, p.TextEN, p.Lookup_Item_ID, p.CommentsMandatory }).ToList().FirstOrDefault().TextEN; historicalRecord.Comment = oneRecord.Notes; historicalRecord.Date = oneRecord.Date; returned.Add(historicalRecord); } } return(returned); }
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 PrcRequisition LoadRequest(string jobID) { using (var context = new EServicesDBContext()) { PrcRequisition requisition = context.PrcRequisition .Where(p => p.JobId == jobID).Include(x => x.PrcRequisitionVendors) .Include(x => x.RequisitionNature) .FirstOrDefault(); return(requisition); } }
public static List <SelectListItem> GetProjectTypes() { using (var context = new EServicesDBContext()) { List <SelectListItem> returnedData = new List <SelectListItem>(); var RequisitionProjectTypes = context.PrcRequisitionProjectTypes.OrderBy(n => n.Id); foreach (PrcRequisitionProjectTypes type in RequisitionProjectTypes) { returnedData.Add(new SelectListItem { Text = type.ProjectType, Value = type.Id.ToString() }); } return(returnedData); } }
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 List <SelectListItem> GetRequisitionNatures(short NodeID) { using (var context = new EServicesDBContext()) { List <SelectListItem> returnedData = new List <SelectListItem>(); List <PrcRequisitionNature> RequisitionNatures = context.PrcRequisitionNature.ToList(); if (NodeID == 0) { RequisitionNatures = RequisitionNatures.Where(n => n.Default == true).ToList(); } foreach (PrcRequisitionNature nature in RequisitionNatures) { returnedData.Add(new SelectListItem { Text = nature.RequisitionNatureAr, Value = nature.Id.ToString() }); } return(returnedData); } }
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(); } }
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 List <DecisionItem> getDecisionList(string helpText) { string decisionGroup = retriveDecisionGroupFromActivityHelpText(helpText); List <DecisionItem> returned = new List <DecisionItem>(); using (EServicesDBContext a = new EServicesDBContext()) { var decisions = !string.IsNullOrEmpty(helpText)?(from p in a.view_DecisionChoices where p.LookupGroup.Equals(decisionGroup) select new { p.TextAR, p.TextEN, p.Lookup_Item_ID, p.CommentsMandatory }).ToArray() : (from p in a.view_DecisionChoices select new { p.TextAR, p.TextEN, p.Lookup_Item_ID, p.CommentsMandatory }).ToArray(); foreach (var oneRecord in decisions) { DecisionItem oneDecision = new DecisionItem(); oneDecision.Value = oneRecord.Lookup_Item_ID; oneDecision.TextAR = oneRecord.TextAR; oneDecision.TextEN = oneRecord.TextEN; oneDecision.CommentsAreMandatory = oneRecord.CommentsMandatory; returned.Add(oneDecision); } } return(returned); }