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