private void BtnDPHeaderMarkDelivered_Click(object sender, RoutedEventArgs e) { //Deliver a picksheet bool reOpen = false; var selectedPickSheet = (PickSheet)dgDeliverPickSheet.SelectedItem; if (selectedPickSheet.PickDeliveredBy > 0) { var mbr = MessageBox.Show("Pick Sheet " + selectedPickSheet.PickSheetID + " Is Already Delivered \n\rDo you want To Reopen it?", " ReOpen PickSheet ", MessageBoxButton.YesNo); if (mbr == MessageBoxResult.No) { return; } else { reOpen = true; } } if (selectedPickSheet.PickDeliveredBy == 0) { var mbr = MessageBox.Show("Pick Sheet " + selectedPickSheet.PickSheetID + " Will Be Delivered \n\rIs this what you want to do?", " ReOpen PickSheet ", MessageBoxButton.YesNo); if (mbr == MessageBoxResult.No) { return; } else { reOpen = false; } } var newPickSheet = new PickSheet(); newPickSheet = CopyPickSheet(selectedPickSheet); if (reOpen) { newPickSheet.PickDeliveryDate = new DateTime(0001, 1, 1); newPickSheet.PickDeliveredBy = 0; } else { newPickSheet.PickDeliveryDate = DateTime.Now; newPickSheet.PickDeliveredBy = _employeeID; } try { int result = _pickManager.UpdatePickSheet(newPickSheet, selectedPickSheet); _picksheetDetails = null; dgProcessPickDetail.ItemsSource = _picksheetDetails; LoadCreatePickGrid(false); LoadPickSheetDeliveryGrid((DateTime)dtpDeliveryStartDate.SelectedDate); LoadPickSheetHeaderGrid((DateTime)dtpProcessPickStartDate.SelectedDate); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void chkPickItem_Checked(object sender, RoutedEventArgs e) { //create a picked object for setting up picking the item var ackorder = (PickOrder)dgPickCreate.SelectedItem; if (ackorder.OrderStatusView.Equals("ORDER ACKNOWLEDGED")) { MessageBox.Show("Item Has Already Been Picked"); return; } //ackorder.PickSheetID = _picksheetID; PickSheet picked = new PickSheet(); picked.TempPickSheetID = _pickSheetID; picked.PickSheetInternalOrderID = ackorder.InternalOrderID; picked.PickSheetCreatedBy = _employeeID; ackorder.PickSheetID = _pickSheetID; //Insert to tmpPickTable if (1 == InsertRecordToTempPickTable(ackorder)) { txtPickInfo.Text = "OrderID: " + ackorder.InternalOrderID + "\nPartNum: " + ackorder.ItemID + " Description: " + ackorder.ItemDescription + " Qty: " + ackorder.OrderQty + "\nAdded to PickSheet " + picked.TempPickSheetID; } else { return; } }
private static PickSheet CopyPickSheet(PickSheet pickSheet) { PickSheet _newPickSheet = new PickSheet() { PickSheetID = pickSheet.PickSheetID, CreateDate = pickSheet.CreateDate, PickCompletedBy = pickSheet.PickCompletedBy, PickCompletedDate = pickSheet.PickCompletedDate, PickDeliveredByName = pickSheet.PickDeliveredByName, PickDeliveryDate = pickSheet.PickDeliveryDate, PickDeliveredBy = pickSheet.PickDeliveredBy, PickCompletedByName = pickSheet.PickCompletedByName, PickCompletedDateView = pickSheet.PickCompletedDateView, PickDeliveryDateView = pickSheet.PickDeliveryDateView, PickSheetCreatedBy = pickSheet.PickSheetCreatedBy, PickSheetCreatedByName = pickSheet.PickSheetCreatedByName, PickSheetIDView = pickSheet.PickSheetIDView, PickSheetInternalOrderID = pickSheet.PickSheetInternalOrderID, PickSheetStatus = pickSheet.PickSheetStatus, TempPickSheetID = pickSheet.TempPickSheetID, NumberOfOrders = pickSheet.NumberOfOrders }; return(_newPickSheet); }
} //end constructor public int Delete_TmpPickSheet(string picksheetID) { int result = 0; _tmpPickSheet = null; if (null == _tmpPickSheet) { result = 1; } return(result); }
public int UpdatePickSheet(PickSheet picksheet, PickSheet oldPickSheet) { var index = _pickSheets.FindIndex(x => x.PickSheetID == picksheet.PickSheetID); _pickSheets[index] = picksheet; if (index > 0) { return(1); } else { return(0); } }
/// Eric Bostwick /// 4/10/2019 public void UpdatePickSheet() { PickSheet pickSheet; pickSheet = _pickManager.Select_All_PickSheets().Find(p => p.PickSheetID == "10000022222"); PickSheet newPickSheet = new PickSheet(); newPickSheet = CopyPickSheet(pickSheet); newPickSheet.NumberOfOrders = 500; int result; //Act result = _pickManager.UpdatePickSheet(newPickSheet, pickSheet); //Assert Assert.AreNotEqual(pickSheet, newPickSheet); }
public void TestSetup() { _pickAccessorMock = new PickAccessorMock(); _pickManager = new PickManager(_pickAccessorMock); _pickOrders = new List <PickOrder>(); _pickSheets = new List <PickSheet>(); _tmpPickOrders = new List <PickOrder>(); _tmpPickSheet = new PickSheet(); _tmpPickOrder = new PickOrder(); _dt = new DateTime(); _dt = DateTime.Now.AddDays(-60); //there two items that will be returned here for later testing _pickSheets = _pickAccessorMock.Select_All_PickSheets(); _pickOrders = _pickAccessorMock.Select_Orders_For_Acknowledgement(_dt, false); _tmpPickOrders = _pickAccessorMock.Select_All_Temp_PickOrders(); //_pickOrders = _pickAccessorMock. }
public int UpdatePickSheet(PickSheet pickSheet, PickSheet oldPickSheet) { int result; try { if (!pickSheet.IsValid() || (!oldPickSheet.IsValid())) { throw new ArgumentException("Data for this itemsupplier record is invalid"); } result = _pickAccessor.UpdatePickSheet(pickSheet, oldPickSheet); } catch (Exception ex) { ExceptionLogManager.getInstance().LogException(ex); throw ex; } return(result); }
public int Insert_TmpPickSheet_To_PickSheet(string picksheetID) { try { using (TransactionScope scope = new TransactionScope()) { foreach (PickOrder pickOrder in _tmpPickOrders) { if (pickOrder.PickSheetID == picksheetID) { pickOrder.OrderReceivedDate = DateTime.Now; pickOrder.OrderStatus = 2; } } int orderNumber = _tmpPickOrders.FindAll(o => o.PickSheetID == picksheetID).Count; int pickedBy = _tmpPickSheet.PickCompletedBy; PickSheet pickSheet = new PickSheet(); pickSheet.PickSheetID = picksheetID; pickSheet.PickSheetCreatedBy = pickedBy; pickSheet.NumberOfOrders = orderNumber; _pickSheets.Add(pickSheet); scope.Complete(); return(1); } } catch (TransactionAbortedException ex) { return(0); throw ex; } }
private void chkPickItem_Unchecked(object sender, RoutedEventArgs e) { var mbr = MessageBox.Show("Do You Really Want to Delete this Item From the PickSheet?", "Delete Item From Pick Sheet", MessageBoxButton.YesNo); if (mbr == MessageBoxResult.No) { return; } //Will have to back out the item var ackorder = (PickOrder)dgPickCreate.SelectedItem; ackorder.PickSheetID = _pickSheetID; PickSheet picked = new PickSheet(); picked.TempPickSheetID = _pickSheetID; picked.PickSheetInternalOrderID = ackorder.InternalOrderID; picked.PickSheetCreatedBy = _employeeID; //Delete From tmpPickTable try { _pickManager.Delete_TmpPickSheet_Item(ackorder); _numPickedItems -= 1; //LoadCreatePickGrid(false); } catch (Exception ex) { MessageBox.Show(ex.Message); } txtPickInfo.Text = "OrderID: " + ackorder.InternalOrderID + "\nPartNum: " + ackorder.ItemID + " Description: " + ackorder.ItemDescription + " Qty: " + ackorder.OrderQty + "\nRemoved From PickSheet " + picked.TempPickSheetID; }
public PickAccessorMock() { _pickOrders = new List <PickOrder>(); _pickSheets = new List <PickSheet>(); _tmpPickOrders = new List <PickOrder>(); _tmpPickSheet = new PickSheet(); //Set up some orders to pick _pickOrders.Add(new PickOrder() { ItemID = 100000, ItemOrderID = 100000, OrderQty = 500, QtyReceived = 0, PickSheetID = "1000011111", OrderReceivedDate = new DateTime(0001, 1, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 1 }); _pickOrders.Add(new PickOrder() { ItemID = 100001, ItemOrderID = 100000, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000011111", OrderReceivedDate = new DateTime(0001, 1, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 1 }); _pickOrders.Add(new PickOrder() { ItemID = 100002, ItemOrderID = 100000, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000011111", OrderReceivedDate = new DateTime(0001, 1, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 1 }); _pickOrders.Add(new PickOrder() { ItemID = 100003, ItemOrderID = 100001, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000022222", OrderReceivedDate = new DateTime(0001, 1, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 1 }); _pickOrders.Add(new PickOrder() { ItemID = 100004, ItemOrderID = 100001, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000022222", OrderReceivedDate = new DateTime(0001, 1, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 1 }); _pickOrders.Add(new PickOrder() { ItemID = 100005, ItemOrderID = 100001, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000011111", OrderReceivedDate = new DateTime(0001, 1, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 1 }); _pickOrders.Add(new PickOrder() { ItemID = 100006, ItemOrderID = 100002, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000011111", OrderReceivedDate = new DateTime(0001, 1, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 1 }); _pickOrders.Add(new PickOrder() { ItemID = 100007, ItemOrderID = 100002, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000011111", OrderReceivedDate = new DateTime(2019, 4, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 2 }); _pickOrders.Add(new PickOrder() { ItemID = 100008, ItemOrderID = 100002, OrderQty = 500, QtyReceived = 0, PickSheetID = "10000011111", OrderReceivedDate = new DateTime(2019, 4, 1), PickCompleteDate = new DateTime(0001, 1, 1), DeliveryDate = new DateTime(0001, 1, 1), OrderStatus = 2 }); _pickSheets.Add(new PickSheet() { CreateDate = DateTime.Now, PickSheetID = "10000022222", PickSheetCreatedBy = 0, PickSheetCreatedByName = "Name", PickCompletedBy = 0, PickCompletedByName = "", PickCompletedDate = new DateTime(0001, 1, 1), PickSheetStatus = 0, PickDeliveredBy = 0, PickDeliveredByName = "", PickDeliveryDate = new DateTime(0001, 1, 1), PickSheetStatusView = "", NumberOfOrders = 0, TempPickSheetID = "" }); _pickSheets.Add(new PickSheet() { CreateDate = DateTime.Now.AddDays(-10), PickSheetID = "10000033333", PickSheetCreatedBy = 0, PickSheetCreatedByName = "Name", PickCompletedBy = 0, PickCompletedByName = "", PickCompletedDate = new DateTime(0001, 1, 1), PickSheetStatus = 0, PickDeliveredBy = 0, PickDeliveredByName = "", PickDeliveryDate = new DateTime(0001, 1, 1), PickSheetStatusView = "", NumberOfOrders = 0, TempPickSheetID = "" }); _tmpPickSheet = new PickSheet { PickSheetID = "100000" + "12345", PickCompletedBy = 100001 }; _tmpPickOrders.Add(new PickOrder() { PickSheetID = "100000" + "12345", InternalOrderID = 100000, ItemID = 100000, EmployeeID = 100001, PickCompleteDate = DateTime.Now.AddDays(-1) }); _tmpPickOrders.Add(new PickOrder() { PickSheetID = "100000" + "12345", InternalOrderID = 10000, ItemID = 100001, EmployeeID = 100001, PickCompleteDate = DateTime.Now.AddDays(-1) }); _tmpPickOrders.Add(new PickOrder() { PickSheetID = "100000" + "12345", InternalOrderID = 10000, ItemID = 100002, EmployeeID = 100001, PickCompleteDate = DateTime.Now.AddDays(-1) }); } //end constructor
public int UpdatePickSheet(PickSheet pickSheet, PickSheet oldPickSheet) { //List<PickSheet> pickSheet = new List<PickSheet>(); int result; string cmdtext; var conn = DBConnection.GetDbConnection(); var cmdText = @"sp_update_picksheet"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmdtext = cmd.CommandText; cmd.Parameters.AddWithValue("@PickSheetID", pickSheet.PickSheetID); cmd.Parameters.AddWithValue("@PickCompletedBy", pickSheet.PickCompletedBy); if (pickSheet.PickCompletedDate.Year < DateTime.Now.Year) { cmd.Parameters.AddWithValue("@PickCompletedDate", Convert.DBNull); } else { cmd.Parameters.AddWithValue("@PickCompletedDate", pickSheet.PickCompletedDate); } if (pickSheet.PickDeliveryDate.Year < DateTime.Now.Year) { cmd.Parameters.AddWithValue("@PickDeliveryDate", Convert.DBNull); } else { cmd.Parameters.AddWithValue("@PickDeliveryDate", pickSheet.PickDeliveryDate); } cmd.Parameters.AddWithValue("@PickDeliveredBy", pickSheet.PickDeliveredBy); cmd.Parameters.AddWithValue("@NumberofOrders", pickSheet.NumberOfOrders); cmd.Parameters.AddWithValue("@OldPickCompletedBy", oldPickSheet.PickCompletedBy); if (oldPickSheet.PickCompletedDate.Year < DateTime.Now.Year) { cmd.Parameters.AddWithValue("@OldPickCompletedDate", Convert.DBNull); } else { cmd.Parameters.AddWithValue("@OldPickCompletedDate", oldPickSheet.PickCompletedDate); } cmd.Parameters.AddWithValue("@OldPickDeliveredBy", oldPickSheet.PickDeliveredBy); if (oldPickSheet.PickDeliveryDate.Year < DateTime.Now.Year) { cmd.Parameters.AddWithValue("@OldPickDeliveryDate", Convert.DBNull); } else { cmd.Parameters.AddWithValue("@OldPickDeliveryDate", oldPickSheet.PickDeliveryDate); } cmd.Parameters.AddWithValue("@OldNumberofOrders", oldPickSheet.NumberOfOrders); var x = cmd.Parameters.Count; try { conn.Open(); result = cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(result); }