public static string ProcessRfqFormTwo(RFQITEMViewModel[] model)
{
SOURCING_RFQ_ITEM _item = new SOURCING_RFQ_ITEM();
try
{
var TempId = HttpContext.Current.Session["TempId"].ToString();
decimal _tempId = Convert.ToDecimal(TempId);
foreach (var item in model)
{
using (var context = new Entities())
{
_item.TEMP_NO = _tempId;
_item.DESCRIPTION = item.DESCRIPTION;
_item.QUANTITY = item.QUANTITY;
_item.UNIT_OF_MEAS = item.UNIT_OF_MEAS;
context.SOURCING_RFQ_ITEM.Add(_item);
context.SaveChanges();
}
}
return(TempId);
}
catch (Exception ex)
{
Logger.Log("Error insert into RFQ-Item table. Error: " + ex.Message +
"------------------------------------------------" + ex.StackTrace,
"error");
return(null);
}
}
public decimal UpdateREQItems()
{
decimal ReturnVal;
SOURCING_RFQ_ITEM _item = new SOURCING_RFQ_ITEM();
var TempId = HttpContext.Current.Session["TempId"].ToString();
decimal _tempId = Convert.ToDecimal(TempId);
var context = new Entities();
try
{
foreach (var item in this.items)
{
if (item.ITEM_NO == 0)
{
_item.TEMP_NO = _tempId;
_item.DESCRIPTION = item.DESCRIPTION;
_item.QUANTITY = item.QUANTITY;
_item.UNIT_OF_MEAS = item.UNIT_OF_MEAS;
context.SOURCING_RFQ_ITEM.Add(_item);
context.SaveChanges();
}
var query = context.SOURCING_RFQ_ITEM.Where(m => m.ITEM_NO == item.ITEM_NO).FirstOrDefault();
if (query != null)
{
query.DESCRIPTION = item.DESCRIPTION;
query.QUANTITY = item.QUANTITY;
query.UNIT_OF_MEAS = item.UNIT_OF_MEAS;
context.SaveChanges();
}
}
ReturnVal = this.TempId;
}
catch (Exception ex)
{
Logger.Log("Error: " + ex.Message + "-" + ex.StackTrace, "error");
ReturnVal = 0;
}
finally
{
context.Dispose();
}
return(ReturnVal);
}
