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