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); }