//Saves to sourcing contact person table public static void SaveChanges(SOURCING_CONTACTPERSON model) { try { using (var context = new Entities()) { context.SOURCING_CONTACTPERSON.Add(model); context.SaveChanges(); } } catch (Exception ex) { Logger.Log("Unable to save to ContactPerson Table. Error: " + ex.Message + "------------------------------------------------" + ex.StackTrace, "error"); } }
internal static string ProcessRFPIndex(ViewModels.RFIRFPComboViewModel model) { SOURCING_RFP_RFI_REQ _Request = new SOURCING_RFP_RFI_REQ(); SOURCING_CONTACTPERSON _Commercial = new SOURCING_CONTACTPERSON(); SOURCING_CONTACTPERSON _Technical = new SOURCING_CONTACTPERSON(); decimal ItemId = ProcessRequest.GetSequence(); try { using (var context = new Entities()) { _Request.TEMP_ID = ItemId; _Request.PRJECT_TITLE = model.Request.PRJECT_TITLE; _Request.INITIATOR_NAME = model.Request.INITIATOR_NAME; _Request.INITIATOR = model.Request.INITIATOR; _Request.INITIATION_DATE = model.Request.INITIATION_DATE; _Request.PROJECT_OBJECTIVE = model.Request.PROJECT_OBJECTIVE; _Request.WORK_SCOPE = model.Request.WORK_SCOPE; _Request.UBN_OVERVIEW = model.Request.UBN_OVERVIEW; _Request.TECHNICAL_PROPOSAL = model.Request.TECHNICAL_PROPOSAL; _Request.ISSUE_DATE = model.Request.ISSUE_DATE; _Request.DUE_DATE = model.Request.DUE_DATE; _Request.DUE_TIME = model.Request.DUE_TIME; _Request.LST_QRY_RECEIPT_DATE = model.Request.LST_QRY_RECEIPT_DATE; _Request.MAPPING = model.Request.MAPPING; _Request.BANK_QRY_RES_DATE = model.Request.BANK_QRY_RES_DATE; _Request.LST_RPF_RECPT_DATE = model.Request.LST_RPF_RECPT_DATE; _Request.STATUS = "Awaiting Vendor Response"; context.SOURCING_RFP_RFI_REQ.Add(_Request); context.SaveChanges(); _Commercial.TEMP_NO = ItemId; _Commercial.NAME = model.Commercial.NAME; _Commercial.DEPARTMENT = model.Commercial.DEPARTMENT; _Commercial.DESIGNATION = model.Commercial.DESIGNATION; _Commercial.TELEPHONE = model.Commercial.TELEPHONE; _Commercial.EMAIL = model.Commercial.EMAIL; _Commercial.CONTACT_TYPE = "Commercial"; _Technical.TEMP_NO = ItemId; _Technical.NAME = model.Technical.NAME; _Technical.DEPARTMENT = model.Technical.DEPARTMENT; _Technical.DESIGNATION = model.Technical.DESIGNATION; _Technical.TELEPHONE = model.Technical.TELEPHONE; _Technical.EMAIL = model.Technical.EMAIL; _Technical.CONTACT_TYPE = "Technical"; Common.SaveChanges(_Commercial); Common.SaveChanges(_Technical); if (model.Request.MAPPING != null) { Common.UpdateSourcingRequestTableWithMappingInfo((decimal)model.Request.MAPPING, ItemId); } string _tempId = Convert.ToString(ItemId); return(_tempId); } } catch (Exception ex) { Logger.Log("Unable to Insert into SOURCING_RFP_RFI_REQ table. Error: " + ex.Message + "------------------------------------------------" + ex.StackTrace, "error"); return(null); } }