/// <summary> /// Carlos Arzu /// Created: 2019/01/30 /// /// Input from the user when creating a new order. /// </summary> public bool InputUser() { bool result = false; SpecialOrderID.IsEnabled = false; try { if (TestDataOrder()) { _completespecialOrder = new CompleteSpecialOrder() { //User input for new order form EmployeeID = Int32.Parse(InputEmployeeID.Text), Description = InputDescription.Text, DateOrdered = DateTime.Parse(InputDateOrdered.Text), Supplier = InputSupplierID.Text, //Authorized = InputAuthorized.Text }; result = true; } } catch (NullReferenceException ex) { MessageBox.Show("Processor Usage" + ex.Message); } return(result); }
/// <summary> /// Carlos Arzu /// Created: 2019/02/28 /// /// Creates the new Supplier order, with the data provided by user. /// </summary public int InsertSpecialOrder(CompleteSpecialOrder newSpecialOrder) { _order.Add(newSpecialOrder); return(1); }
/// <summary> /// Carlos Arzu /// Created: 2019/01/30 /// /// The Second Constructor. /// Set the the order selected in a new window, with read only /// data, with the option to edit. /// </summary> public AddSpecialOrder(CompleteSpecialOrder selected) { InitializeComponent(); _selected = selected; AddItemBtn.Content = "Add Items"; btnAddOrder.Content = "Edit"; setReadOnly(); setDetails(); }
/// <summary author="Carlos Arzu" created="2019/02/06"> /// Called for updating the new input from the user, to the order in the DB. /// </summary> public bool EditSpecialOrder(CompleteSpecialOrder Order, CompleteSpecialOrder Ordernew) { bool result = false; try { result = (1 == specialOrderAccessor.UpdateOrder(Order, Ordernew)); } catch (Exception ex) { ExceptionLogManager.getInstance().LogException(ex); throw ex; } return(result); }
/// <summary author="Carlos Arzu" created="2019/04/05"> /// Called for updating the new input from the user, to the special order line in the DB. /// </summary> public int retrieveSpecialOrderID(CompleteSpecialOrder selected) { int result = 0; try { result = specialOrderAccessor.retrieveSpecialOrderIDbyDetails(selected); } catch (Exception ex) { ExceptionLogManager.getInstance().LogException(ex); throw ex; } return(result); }
/// <summary> /// Author: Kevin Broskow /// Created : 3/25/2019 /// Real constructor for the window being opened on a special order being recieved /// /// </summary> public OrderRecieving(CompleteSpecialOrder specialOrder) { _specialOrder = specialOrder; try { specialOrderLines = _specialManager.RetrieveOrderLinesByID(_specialOrder.SpecialOrderID); originalSpecialOrderLine = _specialManager.RetrieveOrderLinesByID(_specialOrder.SpecialOrderID); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } InitializeComponent(); this.lblRecieving.Content += _specialOrder.SpecialOrderID.ToString(); this.btnSubmit.Content = "Complete"; dgOrderRecieving.ItemsSource = specialOrderLines; }
/// <summary author="Carlos Arzu" created="2019/02/06"> /// Has the information of a new Order, and will create it in our DB. /// </summary> public bool CreateSpecialOrder(CompleteSpecialOrder SpecialOrder) { bool result = false; try { if (!SpecialOrder.isValid()) { throw new ArgumentException("Data entered for this order is invalid\n " + SpecialOrder.ToString()); } result = (1 == specialOrderAccessor.InsertSpecialOrder(SpecialOrder)); } catch (Exception ex) { ExceptionLogManager.getInstance().LogException(ex); throw ex; } return(result); }
public void TestCreateSupplierOrderInvalidDescriptionNull() { CompleteSpecialOrder order = new CompleteSpecialOrder() { SpecialOrderID = 100008, EmployeeID = 100005, Description = null, DateOrdered = DateTime.Now, Supplier = "Leap" }; SpecialOrderLine orderline = new SpecialOrderLine() { NameID = "You get nothing", Description = null, OrderQty = 40, QtyReceived = 0 }; _supplierOrderManager.CreateSpecialOrder(order); }
public void TestDateValid() { CompleteSpecialOrder order = new CompleteSpecialOrder() { SpecialOrderID = 100008, EmployeeID = 100005, Description = "Mighty tests", DateOrdered = DateTime.Now.AddDays(-1), Supplier = "Too much" }; SpecialOrderLine orderline = new SpecialOrderLine() { NameID = "Paviment", Description = createStringLength(1001), OrderQty = 10, QtyReceived = -10 }; _supplierOrderManager.CreateSpecialOrder(order); _supplierOrderManager.CreateSpecialOrderLine(orderline); }
public void AddItemOrderLineTestInValidQtyReceived() { CompleteSpecialOrder order = new CompleteSpecialOrder() { SpecialOrderID = 100008, EmployeeID = 100005, Description = "Mighty tests", DateOrdered = DateTime.Now, Supplier = "SuperMax" }; SpecialOrderLine orderline = new SpecialOrderLine() { NameID = "Pole", Description = createStringLength(1001), OrderQty = 10, QtyReceived = -10 }; _supplierOrderManager.CreateSpecialOrder(order); _supplierOrderManager.CreateSpecialOrderLine(orderline); }
public void TestCreateSupplierOrderInvalidDescriptionLength() { CompleteSpecialOrder order = new CompleteSpecialOrder() { SpecialOrderID = 100008, EmployeeID = 100005, Description = createStringLength(1001), DateOrdered = DateTime.Now, Supplier = "Fish n Dip" }; SpecialOrderLine orderline = new SpecialOrderLine() { NameID = "Paint", Description = createStringLength(1001), OrderQty = 40, QtyReceived = 0 }; _supplierOrderManager.CreateSpecialOrder(order); _supplierOrderManager.CreateSpecialOrderLine(orderline); }
public void TestCreateSupplierOrderInvalidDescriptionBlank() { CompleteSpecialOrder order = new CompleteSpecialOrder() { SpecialOrderID = 100008, EmployeeID = 100005, Description = "", DateOrdered = DateTime.Now, Supplier = "ShopFever" }; SpecialOrderLine orderline = new SpecialOrderLine() { NameID = "Job", Description = "", OrderQty = 40, QtyReceived = 0 }; _supplierOrderManager.CreateSpecialOrder(order); _supplierOrderManager.CreateSpecialOrderLine(orderline); }
// <summary> /// Carlos Arzu /// Created: 2019/01/31 /// /// Retrieves the ItemId needed for every form. /// </summary public int retrieveSpecialOrderIDbyDetails(CompleteSpecialOrder selected) { List <int> ID = new List <int>(); int max = 0; try { var conn = DBConnection.GetDbConnection(); conn.Open(); var cmd = new SqlCommand("sp_retrieve_last_specialOrderID_created", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmployeeID", selected.EmployeeID); cmd.Parameters.AddWithValue("@Description", selected.Description); cmd.Parameters.AddWithValue("@DateOrdered", selected.DateOrdered); cmd.Parameters.AddWithValue("@Supplier", selected.Supplier); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ID.Add(reader.GetInt32(0)); } } conn.Close(); max = ID.Max(); } catch (Exception) { throw; } return(max); }
public void AddItemOrderLineTestInValidOrderQty() { CompleteSpecialOrder order = new CompleteSpecialOrder() { SpecialOrderID = 100008, EmployeeID = 100005, Description = createStringLength(1001), DateOrdered = DateTime.Now, Supplier = "Rigga meter" }; SpecialOrderLine orderline = new SpecialOrderLine() { NameID = "Paint", Description = createStringLength(1001), OrderQty = -1, QtyReceived = 0 }; _supplierOrderManager.CreateSpecialOrder(order); _supplierOrderManager.CreateSpecialOrderLine(orderline); }
public void TestCreateSupplierOrderWithAllValidInputs() { //arrange CompleteSpecialOrder order = new CompleteSpecialOrder() { SpecialOrderID = 100008, EmployeeID = 100005, Description = "Escape Pod for Groom", DateOrdered = DateTime.Now, Supplier = "Backscratcher" }; SpecialOrderLine orderline = new SpecialOrderLine() { NameID = "Short Relief", Description = "Darts to sleep the Bride", OrderQty = 40, QtyReceived = 0 }; //Act _supplierOrderManager.CreateSpecialOrder(order); //Assert _compsupplierOrder = _supplierOrderManager.retrieveAllOrders(); _supplierOrderLine = _supplierOrderManager.RetrieveOrderLinesByID(order.SpecialOrderID); Assert.IsNotNull(_compsupplierOrder.Find(o => o.SpecialOrderID == order.SpecialOrderID && o.EmployeeID == order.EmployeeID && o.Description == order.Description && o.DateOrdered == order.DateOrdered && o.Supplier == order.Supplier)); /*Assert.IsNotNull(_supplierOrderLine.Find(l => l.NameID == orderline.NameID * && l.Description == orderline.Description && l.OrderQty == orderline.OrderQty * && l.QtyReceived == orderline.QtyReceived));*/ }
/// <summary> /// Carlos Arzu /// Created: 2019/01/31 /// /// Creates the new Special order, with the data provided by user. /// </summary public int InsertSpecialOrder(CompleteSpecialOrder newSpecialOrder) { int row = 0; try { var conn = DBConnection.GetDbConnection(); conn.Open(); var cmd1 = new SqlCommand("sp_create_specialOrder", conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@EmployeeID", newSpecialOrder.EmployeeID); cmd1.Parameters.AddWithValue("@Description", newSpecialOrder.Description); cmd1.Parameters.AddWithValue("@DateOrdered", newSpecialOrder.DateOrdered); cmd1.Parameters.AddWithValue("@Supplier", newSpecialOrder.Supplier); row += cmd1.ExecuteNonQuery(); conn.Close(); } catch (Exception) { throw; } return(row); }
/// <summary> /// Carlos Arzu /// Created: 2019/01/31 /// /// With the input user provided for updating, the order will be updated. /// </summary public int UpdateOrder(CompleteSpecialOrder Order, CompleteSpecialOrder Ordernew) { int rows = 0; var conn = DBConnection.GetDbConnection(); var cmdText = "sp_update_SpecialOrder"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SpecialOrderID", Order.SpecialOrderID); cmd.Parameters.AddWithValue("@EmployeeID", Ordernew.EmployeeID); cmd.Parameters.AddWithValue("@Description", Ordernew.Description); cmd.Parameters.AddWithValue("@Supplier", Ordernew.Supplier); cmd.Parameters.AddWithValue("@OldEmployeeID", Order.EmployeeID); cmd.Parameters.AddWithValue("@OldDescription", Order.Description); cmd.Parameters.AddWithValue("@OldSupplier", Order.Supplier); try { conn.Open(); rows = cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); } return(rows); }
public bool isValid(CompleteSpecialOrder SpecialOrder) { return(true); }
// <summary> /// Carlos Arzu /// Created: 2019/01/31 /// /// Retrieves the ItemId needed for every form. /// </summary public int retrieveSpecialOrderIDbyDetails(CompleteSpecialOrder selected) { throw new NotImplementedException(); }
/// <summary> /// Carlos Arzu /// Created: 2019/02/28 /// /// Update the new Special order, with the data provided by user. /// </summary public int UpdateOrder(CompleteSpecialOrder Order, CompleteSpecialOrder Ordernew) { int iterator = 1; return(iterator); }