/// <summary>
/// Creator: Dalton Reierson
/// Created: 2020/04/24
/// Approver:
/// Approver:
///
/// selects all receiving records
/// </summary>
///
/// <remarks>
/// Updated By:
/// Updated:
/// Update:
/// </remarks>
public ReceivingRecord RetrieveReceivingRecordByOrderID(int OrderID)
{
ReceivingRecord receivingRecord = new ReceivingRecord();
try
{
receivingRecord = _receivingRecordAccessor.SelectReceivingRecordbyOrderID(OrderID);
}
catch (Exception ex)
{
throw new ApplicationException("Receiving Records not found");
}
return(receivingRecord);
}
/// <summary>
/// Creator: Dalton Reierson
/// Created: 2020/04/24
/// Approver:
/// Approver:
///
/// Selects all receiving records
/// </summary>
///
/// <remarks>
/// Updated By:
/// Updated:
/// Update:
/// </remarks>
public List <ReceivingRecord> SelectAllReceivingRecords()
{
List <ReceivingRecord> receivingRecords = new List <ReceivingRecord>();
// Connection
var conn = DBConnection.GetConnection();
// Command Object
var cmd = new SqlCommand("sp_select_all_receivingrecords");
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
// Parameter
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var receivingRecord = new ReceivingRecord();
receivingRecord.ReceivingRecordID = reader.GetInt32(0);
receivingRecord.OrderID = reader.GetInt32(1);
receivingRecord.ShipperID = reader.GetString(2);
receivingRecord.ReceivingOrderDate = reader.GetDateTime(3);
receivingRecords.Add(receivingRecord);
}
}
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(receivingRecords);
}
public void SelectReceivingRecordByOrderID()
{
// Arrange
ReceivingRecord receivingRecord = new ReceivingRecord();
ReceivingRecord result = new ReceivingRecord();
receivingRecord.OrderID = 100000;
receivingRecord.ShipperID = "100000";
receivingRecord.ReceivingRecordID = 100000;
receivingRecord.ReceivingOrderDate = DateTime.Now;
// Act
result = _fakeReceivingRecordAccessor.SelectReceivingRecordbyOrderID(100000);
// Assert
Assert.AreEqual(receivingRecord, result);
}
/// <summary>
/// Creator: Dalton Reierson
/// Created: 2020/04/24
/// Approver:
/// Approver:
///
/// Selects receiving records by orderID
/// </summary>
///
/// <remarks>
/// Updated By:
/// Updated:
/// Update:
/// </remarks>
public ReceivingRecord SelectReceivingRecordbyOrderID(int OrderID)
{
ReceivingRecord receivingRecord = new ReceivingRecord();
// Connection
var conn = DBConnection.GetConnection();
// Command Object
var cmd = new SqlCommand("sp_select_receiving_record_by_orderID");
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
// Parameter
cmd.Parameters.AddWithValue("@OrderID", OrderID);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.Read())
{
receivingRecord.ReceivingRecordID = reader.GetInt32(0);
receivingRecord.OrderID = reader.GetInt32(1);
receivingRecord.ShipperID = reader.GetString(2);
receivingRecord.ReceivingOrderDate = reader.GetDateTime(3);
}
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(receivingRecord);
}
/// <summary>
/// Creator: Dalton Reierson
/// Created: 2020/04/23
/// Approver:
/// Approver:
///
/// Method for selecting all receivingRecords matching the given orderID
/// </summary>
///
/// <remarks>
/// Updated By:
/// Updated:
/// Update:
/// </remarks>
public ReceivingRecord SelectReceivingRecordbyOrderID(int OrderID)
{
ReceivingRecord receivingRecord = new ReceivingRecord();
List <ReceivingRecord> receivingRecordList = new List <ReceivingRecord>();
List <ReceivingRecord> filteredReceivingRecordList = new List <ReceivingRecord>();
// ReceivingRecords to filter out
for (int i = 0; i < 4; i++)
{
receivingRecord.OrderID = 100001;
receivingRecord.ShipperID = "100000";
receivingRecord.ReceivingRecordID = 100000;
receivingRecord.ReceivingOrderDate = DateTime.Now;
receivingRecordList.Add(receivingRecord);
}
// ReceivingRecord to select
receivingRecord.OrderID = 100000;
receivingRecord.ShipperID = "100000";
receivingRecord.ReceivingRecordID = 100000;
receivingRecord.ReceivingOrderDate = DateTime.Now;
receivingRecordList.Add(receivingRecord);
// Filter
var results = from ReceivingRecord in receivingRecordList
where receivingRecord.OrderID == 100000
select receivingRecord;
// Add matching ReceivingRecords to new list
foreach (ReceivingRecord i in results)
{
filteredReceivingRecordList.Add(i);
}
return(filteredReceivingRecordList[0]);
}
/// <summary>
/// Creator: Dalton Reierson
/// Created: 2020/04/24
/// Approver: Jesse Tomash
/// Approver:
///
/// Method to show data in datagrid
/// </summary>
///
/// <remarks>
/// Updated By:
/// Updated:
/// Update:
/// </remarks>
private void PopulateDataGrid(Order order)
{
_receivingRecord = _receivingRecordManager.RetrieveReceivingRecordByOrderID(_order.OrderID);
dgOrderLine.ItemsSource = _orderLineManager.RetrieveOrderLineByReceivingRecordID(_receivingRecord.ReceivingRecordID);
}
