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