public static void EditRequest(SourceRequestViewModel model, string branchcode)
{
try
{
var context = new Entities();
var query = context.SOURCING_REQUEST.Where(m => m.TEMP_ID == model.TEMP_ID).FirstOrDefault();
if (query != null)
{
query.ITEM_CATEGORY = model.ITEM_CATEGORY;
query.ITEM_DESCRIPTION = model.ITEM_DESCRIPTION;
query.PREFERED_VENDOR = model.PREFERED_VENDOR;
query.PREFERED_VENDOR_ID = model.PREFERED_VENDOR_ID;
query.EXPECTED_DELIVERY_DATE = model.EXPECTED_DELIVERY_DATE;
query.ITEM_CATEGORY_ID = model.ITEM_CATEGORY_ID;
context.SaveChanges();
DocumentUploadDownload.UploadDocument(model.Files, branchcode, model.TEMP_ID);
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Logger.Log("Entity of type " + eve.Entry.Entity.GetType().Name + " in state " + eve.Entry.State + " has the following validation errors:", "error");
foreach (var ve in eve.ValidationErrors)
{
Logger.Log("- Property: " + ve.PropertyName + ", Error: " + ve.ErrorMessage + " ", "error");
}
}
// Logger.Log("An error occured upon inserting new request into database. Error: " + ex.StackTrace, "error");
}
}
public static void ProcessNewRequest(SourceRequestViewModel model, string _EmpNum)
{
string Content = "A new sourcing request has been initiated by " + model.INITIATOR_NAME;
Content += " , log on to the Procurement application to approve/decline the request.";
try
{
SOURCING_REQUEST _NewRequest = new SOURCING_REQUEST();
decimal ItemId = GetSequence();
var InfoFromHRMS = GetInfoFromHRMS.GetSupervisorsDetails(_EmpNum);
using (Entities context = new Entities())
{
_NewRequest.TEMP_ID = ItemId;
_NewRequest.ITEM_CATEGORY = model.ITEM_CATEGORY;
_NewRequest.ITEM_DESCRIPTION = model.ITEM_DESCRIPTION;
_NewRequest.PREFERED_VENDOR = model.PREFERED_VENDOR;
_NewRequest.PREFERED_VENDOR_ID = model.PREFERED_VENDOR_ID;
_NewRequest.INITIATING_BRANCH = model.INITIATING_BRANCH;
_NewRequest.INITIATOR_NAME = model.INITIATOR_NAME;
_NewRequest.INITIATOR_NUMBER = model.INITIATOR_NUMBER;
_NewRequest.INITIATING_BRANCHCODE = model.INITIATING_BRANCHCODE;
_NewRequest.INITIATING_DEPT = model.INITIATING_DEPT;
_NewRequest.INITIATION_DATE = DateTime.Now;
_NewRequest.INITIATOR_EMAIL = model.INITIATOR_EMAIL;
_NewRequest.EXPECTED_DELIVERY_DATE = model.EXPECTED_DELIVERY_DATE;
_NewRequest.INITIATING_DEPTCODE = model.INITIATING_DEPTCODE;
_NewRequest.LINE_MANAGER_NAME = InfoFromHRMS.FullName;
_NewRequest.LINE_MANAGER_NUM = InfoFromHRMS.EmployeeNumber;
_NewRequest.LINE_MANAGER_APPR = "Pending";
_NewRequest.LINE_MANAGER_EMAIL = InfoFromHRMS.Email;
_NewRequest.ITEM_CATEGORY_ID = model.ITEM_CATEGORY_ID;
context.SOURCING_REQUEST.Add(_NewRequest);
context.SaveChanges();
}
DocumentUploadDownload.UploadDocument(model.Files, model.INITIATING_BRANCHCODE, ItemId);
bool MailResponse = SendMail.prepMail(Content, InfoFromHRMS.FullName, InfoFromHRMS.Email, emailTemplatePath);
if (MailResponse)
{
Logger.Log("Email Sent to " + InfoFromHRMS.Email, "Info");
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Logger.Log("Entity of type " + eve.Entry.Entity.GetType().Name + " in state " + eve.Entry.State + " has the following validation errors:", "error");
foreach (var ve in eve.ValidationErrors)
{
Logger.Log("- Property: " + ve.PropertyName + ", Error: " + ve.ErrorMessage + " ", "error");
}
}
// Logger.Log("An error occured upon inserting new request into database. Error: " + ex.StackTrace, "error");
}
}