/// <summary>
/// Richard Carroll
/// Created: 2019/01/30
///
/// Secondary constructor for the window.
/// This is used when viewing orders.
/// </summary>
public InternalOrderDetail(VMInternalOrder order)
{
InitializeComponent();
this.order = order;
isEditable = false;
setupViewing();
}
/// <summary>
/// Richard Carroll
/// Created: 2019/01/30
///
/// This Method Requests Order data from the database
/// and returns it to the Logic Layer if Possible.
/// </summary>
public List <VMInternalOrder> SelectAllInternalOrders()
{
List <VMInternalOrder> orders = new List <VMInternalOrder>();
var cmdText = "sp_select_all_internal_orders";
var conn = DBConnection.GetDbConnection();
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
VMInternalOrder order = new VMInternalOrder();
order.InternalOrderID = reader.GetInt32(0);
order.EmployeeID = reader.GetInt32(1);
order.FirstName = reader.GetString(2);
order.LastName = reader.GetString(3);
order.DepartmentID = reader.GetString(4);
order.Description = reader.GetString(5);
order.OrderComplete = reader.GetBoolean(6);
order.DateOrdered = reader.GetDateTime(7);
orders.Add(order);
}
}
}
catch (Exception)
{
throw;
}
return(orders);
}
