Ejemplo n.º 1
0
        public static string ProcessRfqFormOne(RFQREQViewModel model)
        {
            SOURCING_RFQ_REQ _request = new SOURCING_RFQ_REQ();

            try
            {
                decimal ItemId = ProcessRequest.GetSequence();
                using (var context = new Entities())
                {
                    _request.MAPPING          = model.MAPPING;
                    _request.TEMP_NO          = ItemId;
                    _request.RFQ_START_DATE   = model.RFQ_START_DATE;
                    _request.RFQ_CLOSE_DATE   = model.RFQ_CLOSE_DATE;
                    _request.DELIVERY_ADDRESS = model.DELIVERY_ADDRESS;
                    _request.INITIATOR_ID     = model.INITIATOR_ID;
                    _request.INITIATOR_NAME   = model.INITIATOR_NAME;
                    _request.STATUS           = "Awaiting Vendor Response";
                    context.SOURCING_RFQ_REQ.Add(_request);
                    context.SaveChanges();
                }
                Common.UpdateSourcingRequestTableWithMappingInfo((decimal)model.MAPPING, ItemId);
                return(Convert.ToString(ItemId));
            }
            catch (Exception ex)
            {
                Logger.Log("Error insert into RFQ-REQ table. Error: " + ex.Message +
                           "------------------------------------------------" + ex.StackTrace,
                           "error");
                return(null);
            }
        }
Ejemplo n.º 2
0
        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);
            }
        }