//update rfq request
public decimal UpdateRFQRequest()
{
SOURCING_RFQ_REQ _request = new SOURCING_RFQ_REQ();
try
{
using (var context = new Entities())
{
var query = context.SOURCING_RFQ_REQ.Where(m => m.TEMP_NO == this.model.TEMP_NO).FirstOrDefault();
if (query != null)
{
query.DELIVERY_ADDRESS = this.model.DELIVERY_ADDRESS;
query.RFQ_START_DATE = this.model.RFQ_START_DATE;
query.RFQ_CLOSE_DATE = this.model.RFQ_CLOSE_DATE;
context.SaveChanges();
return(this.model.TEMP_NO);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
Logger.Log("Error: " + ex.Message + "-" + ex.StackTrace, "error");
return(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);
}
}
