private Collection <SalesItemViewModel> GetDummyRecords(SalesOrderViewModel order) { var items = new Collection <SalesItemViewModel>(); int n = _Model.MaxPreview == 0 ? 5 : _Model.MaxPreview; for (int i = 0; i < n; i++) { Thread.Sleep(10); var item = new SalesItemViewModel( order, 60932, string.Format("AS100{0:000}", i + 1), 67661, "Y", 5, (i + 1), "Ea", "USD", 100003628 ); item.SerialNumber = "EM1234567"; items.Add(item); } order._LoadedAll = true; order.RefreshStatus(); return(items); }
internal Collection <SalesItemViewModel> LoadParent(SalesOrderViewModel orderVM) { Collection <SalesItemViewModel> items = new Collection <SalesItemViewModel>(); Order order = Order.GetOrderDetails(orderVM.HeaderId, _Model.RntIncidentId, _Model.RntContactId); foreach (var item in order.Items) { var itemVM = new SalesItemViewModel( orderVM, _Model.EbsSrId, "", (decimal)item.INVENTORY_ITEM_ID, "Y", 5, (decimal)item.ORDERED_QUANTITY, "Ea", "USD", _Model.EbsOwnerId ); itemVM.UnitSellingPrice = item.UNIT_SELLING_PRICE; itemVM.ItemName = item.INVENTORY_ITEM; itemVM.LineID = (int)item.LINE_ID; itemVM.SerialNumber = "EM1234567"; items.Add(itemVM); } orderVM._LoadedAll = true; orderVM.RefreshStatus(); return(items); }
internal Collection <SalesItemViewModel> GetAvailableItems(int limit = 0, SalesOrderViewModel parent = null) { var items = new Collection <SalesItemViewModel>(); String query = @"SELECT sp.PartNumber, sp.Name , sp.Schedules.SalesProductScheduleList.Price.Value FROM SalesProduct sp WHERE sp.Folder.Name = 'EBS Products' AND sp.Schedules.SalesProductScheduleList.Price.Currency.Name = 'USD' AND sp.Schedules.SalesProductScheduleList.Price.Value > 0 LIMIT 1000"; String[] rows = null; string row = null; try { rows = workspaceAddIn._rnSrv.queryData(query); } catch (Exception e) { string logMessage = "Error in getting products from CWSS. Error query: " + query; ErrorLog(logMessage, e.Message); } try { foreach (string r in rows) { row = r; string[] s = r.Split(','); int id = Convert.ToInt32(s[0]); string name = s[1]; decimal usp = Math.Round(Convert.ToDecimal(s[2]), 2); var item = new SalesItemViewModel( parent, _Model.EbsSrId, name, id, "Y", 0, 1, "Ea", "USD", _Model.EbsOwnerId ); item.UnitSellingPrice = usp; item.SerialNumber = "EM1234567"; items.Add(item); } } catch (Exception e) { string logMessage = "Bad data returned by products query. Data: " + row; NoticeLog(logMessage, e.Message); } return(items); }
private void add_Click(object sender, RoutedEventArgs e) { var selected = _Model.CurrentParent.SelectedItem; if (null == selected) return; var item = new SalesItemViewModel(selected); if (IsValid()) { _Model.CurrentParent.Items.Add(item); selected.Quantity = 1; } }
public SalesItemViewModel(SalesItemViewModel selected) { _File = selected._File; _serviceRequestId = selected._serviceRequestId; ItemName = selected.ItemName; InventoryItemId = selected.InventoryItemId; ApprovalRequiredFlag = selected.ApprovalRequiredFlag; _UnitSellingPrice = selected._UnitSellingPrice; _Quantity = selected._Quantity; UnitOfMeasure = selected.UnitOfMeasure; Currency = selected.Currency; ResourceId = selected.ResourceId; _Status = selected._Status; }
private void add_Click(object sender, RoutedEventArgs e) { var selected = _Model.CurrentParent.SelectedItem; if (null == selected) { return; } var item = new SalesItemViewModel(selected); if (IsValid()) { _Model.CurrentParent.Items.Add(item); selected.Quantity = 1; } }
internal bool Import(SalesItemViewModel repairOrder) { return(true); }
internal Collection<SalesItemViewModel> GetAvailableItems(int limit = 0, SalesOrderViewModel parent = null) { var items = new Collection<SalesItemViewModel>(); String query = @"SELECT sp.PartNumber, sp.Name , sp.Schedules.SalesProductScheduleList.Price.Value FROM SalesProduct sp WHERE sp.Folder.Name = 'EBS Products' AND sp.Schedules.SalesProductScheduleList.Price.Currency.Name = 'USD' AND sp.Schedules.SalesProductScheduleList.Price.Value > 0 LIMIT 1000"; String[] rows = null; string row = null; try { rows = workspaceAddIn._rnSrv.queryData(query); } catch (Exception e) { string logMessage = "Error in getting products from CWSS. Error query: " + query; ErrorLog(logMessage, e.Message); } try { foreach (string r in rows) { row = r; string[] s = r.Split(','); int id = Convert.ToInt32(s[0]); string name = s[1]; decimal usp = Math.Round(Convert.ToDecimal(s[2]), 2); var item = new SalesItemViewModel( parent, _Model.EbsSrId, name, id, "Y", 0, 1, "Ea", "USD", _Model.EbsOwnerId ); item.UnitSellingPrice = usp; item.SerialNumber = "EM1234567"; items.Add(item); } } catch (Exception e) { string logMessage = "Bad data returned by products query. Data: " + row; NoticeLog(logMessage, e.Message); } return items; }
private Collection<SalesItemViewModel> GetDummyRecords(SalesOrderViewModel order) { var items = new Collection<SalesItemViewModel>(); int n = _Model.MaxPreview == 0 ? 5 : _Model.MaxPreview; for (int i = 0; i < n; i++) { Thread.Sleep(10); var item = new SalesItemViewModel( order, 60932, string.Format("AS100{0:000}", i + 1), 67661, "Y", 5, (i + 1), "Ea", "USD", 100003628 ); item.SerialNumber = "EM1234567"; items.Add(item); } order._LoadedAll = true; order.RefreshStatus(); return items; }
internal bool Import(SalesItemViewModel repairOrder) { return true; }
internal Collection<SalesItemViewModel> LoadParent(SalesOrderViewModel orderVM) { Collection<SalesItemViewModel> items = new Collection<SalesItemViewModel>(); Order order = Order.GetOrderDetails(orderVM.HeaderId, _Model.RntIncidentId, _Model.RntContactId); foreach (var item in order.Items) { var itemVM = new SalesItemViewModel( orderVM, _Model.EbsSrId, "", (decimal) item.INVENTORY_ITEM_ID, "Y", 5, (decimal) item.ORDERED_QUANTITY, "Ea", "USD", _Model.EbsOwnerId ); itemVM.UnitSellingPrice = item.UNIT_SELLING_PRICE; itemVM.ItemName = item.INVENTORY_ITEM; itemVM.LineID = (int) item.LINE_ID; itemVM.SerialNumber = "EM1234567"; items.Add(itemVM); } orderVM._LoadedAll = true; orderVM.RefreshStatus(); return items; }