public void GetSalesOrders(string destination, out string error) { error = ""; var tranDt = new ObjectParameter("TranDT", typeof(DateTime)); var result = new ObjectParameter("Result", typeof(Int32)); try { SalesOrdersList.Clear(); if (_context != null) { _context.Dispose(); _context = new MONITOREntities_OrderMaintenance(); } if (_context != null) { var queryResult = _context.usp_PlanningReleaseManualImport_GetOrders(destination, tranDt, result); foreach (var item in queryResult.ToList()) { _salesOrder = new SalesOrderDataModel() { OrderNo = Convert.ToInt32(item.OrderNo), BlanketPart = item.BlanketPart, CustomerPart = item.CustomerPart, ModelYear = item.ModelYear }; SalesOrdersList.Add(_salesOrder); } if (!SalesOrdersList.Any()) { error = string.Format("No active sales orders were found for destination {0}", destination); } } } catch (Exception ex) { error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message; } }
public void UpdateSalesOrder(int orderNo, string modelYear, out string error) { error = ""; var tranDt = new ObjectParameter("TranDT", typeof(DateTime)); var result = new ObjectParameter("Result", typeof(Int32)); try { if (_context != null) { _context.Dispose(); _context = new MONITOREntities_OrderMaintenance(); } if (_context != null) _context.usp_PlanningReleaseManualImport_UpdateModelYear(orderNo, modelYear, tranDt, result); } catch (Exception ex) { error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message; } }
public SalesOrderMaintenance() { _context = new MONITOREntities_OrderMaintenance(); }