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