public bool AddVendorOrder(VendorOrder order) { if (order == null) throw new ApplicationException("Order cannot be null"); if (order.DateOrdered == null) order.DateOrdered = DateTime.Now; var result = VendorOrderDAL.Add(order, _connection); if (result) { var newVendorOrder = VendorOrderDAL.GetVendorOrderByVendorAndDate(order.VendorID,_connection); if (order.LineItems != null) { foreach (var item in order.LineItems) { item.VendorOrderId = newVendorOrder.Id; if (item.Note == null || item.Note == "") { item.Note = "no note"; } if (VendorOrderLineItemDAL.Add(item, _connection)) { prodMan.AddToOnOrder(item.QtyOrdered, item.ProductID); } } } } return result; }
public static VendorOrderLineItem Get(VendorOrder vendorOrder, Product product, SqlConnection myConnection) { VendorOrderLineItem vendorOrderLineItem = null; myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetVendorOrderLineItem", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@VendorOrderID", vendorOrder.Id); mySqlCommand.Parameters.AddWithValue("@ProductID", product.Id); myConnection.Open(); var mySqlReader = mySqlCommand.ExecuteReader(); if (mySqlReader.HasRows) { while (mySqlReader.Read()) { vendorOrderLineItem = new VendorOrderLineItem(mySqlReader.GetInt32(0), mySqlReader.GetInt32(1)) { QtyOrdered = mySqlReader.GetInt32(2), QtyReceived = mySqlReader.GetInt32(3), QtyDamaged = mySqlReader.GetInt32(4) }; } } mySqlReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return vendorOrderLineItem; }
public static List<VendorOrder> GetAll(SqlConnection connection) { List<VendorOrder> allOrders = new List<VendorOrder>(); connection = connection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetAllVendorOrders", connection) { CommandType = CommandType.StoredProcedure }; connection.Open(); var myReader = mySqlCommand.ExecuteReader(); if (myReader.HasRows) { while (myReader.Read()) { var newVendorOrder = new VendorOrder(myReader.GetInt32(0), myReader.GetInt32(1)) { DateOrdered = (DateTime)myReader.GetSqlDateTime(2), NumberOfShipments = myReader.GetInt32(3), Finalized = myReader.GetBoolean(4), Active = myReader.GetBoolean(5) }; allOrders.Add(newVendorOrder); }; } myReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { connection.Close(); } return allOrders; }
public bool AddLineItem(VendorOrder order, Product product, int qty) { if (order == null) throw new ApplicationException("Vendor Order is null"); if (product == null) throw new ApplicationException("Product cannot be null"); if (qty == null) qty = 0; VendorOrderLineItem lineItem = new VendorOrderLineItem(order.Id, product.Id); lineItem.QtyOrdered = qty; var result = VendorOrderLineItemDAL.Add(lineItem, _connection); if (result) { order.AddLineItem(lineItem); } return result; }
public bool AddNewLineItemToVendorOrder(VendorOrder vendorOrder,Product productToAdd, int qtyReceived, string note, int qtyDamaged) { if (productToAdd == null) throw new ApplicationException("Product can't be null"); if (vendorOrder == null) throw new ApplicationException("VendorOrder can't be null"); if (qtyReceived <= 0) throw new ApplicationException("Quantity recieved has to be greater than 0"); var newVendorOrderLineItem = new VendorOrderLineItem(vendorOrder.Id, productToAdd.Id) { QtyOrdered = 0, QtyReceived = qtyReceived, QtyDamaged = qtyDamaged, Note = note }; return VendorOrderLineItemDAL.Add(newVendorOrderLineItem, _connection); }
public FrmAddLineItemToVendorOrder(VendorOrder vendorOrder, AccessToken acctkn) { InitializeComponent(); _myAccessToken = acctkn; var RoleAccess = new RoleAccess(acctkn, this); this.vendorOrder = vendorOrder; txtVendorOrderID.Text = vendorOrder.Id.ToString(); VendorManager _vendorManager = new VendorManager(); var vendor = vendorOrder.VendorID; txtVendorName.Text = _vendorManager.GetVendor(vendorOrder.VendorID).Name; txtVendorID.Text = vendorOrder.VendorID.ToString(); txtVendorName.ReadOnly = true; txtVendorID.ReadOnly = true; fillProductDropDown(vendorOrder.VendorID); }
private void btnUpdatedNote_Click(object sender, EventArgs e) { var note = txtNotes.Text; _receivingManager = new ReceivingManager(); VendorOrderManager _vendorOrderManager = new VendorOrderManager(); vendorOrder = new VendorOrder(Int32.Parse(txtVendorOrderID.Text.ToString()),Int32.Parse(txtVendorID.Text.ToString())); VendorOrderLineItem vendorOrderLineItem = new VendorOrderLineItem(Int32.Parse(txtVendorOrderID.Text), Int32.Parse(txtProductID.Text)); vendorOrderLineItem.Note = note; _receivingManager.UpdateLineItemNote(vendorOrderLineItem, note); MessageBox.Show("Note added to Order"); this.Close(); }
public frmReceiving(VendorOrder vendorOrder, AccessToken acctkn) { InitializeComponent(); _myAccessToken = acctkn; VendorManager _vendorManager = new VendorManager(); this.vendorOrder = vendorOrder; txtVendorOrderID.Text = vendorOrder.Id.ToString(); txtVendorName.Text = _vendorManager.GetVendor(vendorOrder.VendorID).Name.ToString(); txtVendorID.Text = _vendorManager.GetVendor(vendorOrder.VendorID).Id.ToString(); txtNumberofShipments.Text = _vendorOrderManager.getVendorOrder(vendorOrder.Id).NumberOfShipments.ToString(); txtDateOrdered.Text = _vendorOrderManager.getVendorOrder(vendorOrder.Id).DateOrdered.ToString(); vendorOrder = new VendorOrder(Int32.Parse(txtVendorOrderID.Text.ToString()), Int32.Parse(txtVendorID.Text.ToString())); populateListView(); //try //{ // lvReceiving.Clear(); // vendorOrderLineItemList = _receivingManager.GetAllLineItemsByVendorOrder(vendorOrder); // foreach (var vendorOrderLineItem in vendorOrderLineItemList) // { // var item = new ListViewItem(); // item.Text = vendorOrderLineItem.ProductID.ToString(); // item.SubItems.Add(_productManager.GetProduct(vendorOrderLineItem.ProductID).Name.ToString()); // item.SubItems.Add(vendorOrderLineItem.QtyOrdered.ToString()); // item.SubItems.Add(vendorOrderLineItem.QtyReceived.ToString()); // item.SubItems.Add(vendorOrderLineItem.QtyDamaged.ToString()); // item.SubItems.Add(vendorOrderLineItem.Note); // lvReceiving.Items.Add(item); // } // lvReceiving.Columns.Add("ProductID"); // lvReceiving.Columns.Add("Product Name"); // lvReceiving.Columns.Add("Quantity Ordered"); // lvReceiving.Columns.Add("Quantity Received"); // lvReceiving.Columns.Add("Quantity Damaged"); // lvReceiving.Columns.Add("Note"); // lvReceiving.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); //} //catch (Exception ex) //{ // MessageBox.Show("An error occured while loading the vendor listView. " + ex.ToString()); //} }
public static bool Add(VendorOrder order, SqlConnection connection) { connection = connection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_InsertVendorOrder", connection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@VendorID", order.VendorID); //mySqlCommand.Parameters.AddWithValue("@DateOrdered", order.DateOrdered.ToString("yyyy-MM-dd HH:mm:ss")); mySqlCommand.Parameters.AddWithValue("@NumberOfShipments", order.NumberOfShipments); connection.Open(); if (mySqlCommand.ExecuteNonQuery() == 1) { return true; } } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { connection.Close(); } return false; }
private void btnAddLineItem_Click(object sender, EventArgs e) { ReceivingManager _receivingManager = new ReceivingManager(); VendorOrderManager _vendorOrderManager = new VendorOrderManager(); VendorOrder vendorOrder; Product product; Int32 qtyReceived; Int32 qtyDamaged; Int32 vendorID = Int32.Parse(txtVendorID.Text); vendorOrder = new VendorOrder(Int32.Parse(txtVendorOrderID.Text), vendorID); int index = cbProductName.SelectedItem.ToString().IndexOf(" "); var productID = Int32.Parse(cbProductName.SelectedItem.ToString().Substring(0, index)); product = new Product(productID); qtyReceived = Int32.Parse(upQuantityReceived.Value.ToString()); qtyDamaged = Int32.Parse(upQtyDamaged.Value.ToString()); string note = txtNotes.Text; _receivingManager.AddNewLineItemToVendorOrder(vendorOrder, product, qtyReceived, note, qtyDamaged); MessageBox.Show("Line Item Added"); this.Close(); }
private void button1_Click(object sender, EventArgs e) { VendorOrder thisOrder = new VendorOrder(vendorOrder.Id); thisOrder.LineItems = vendorOrderLineItemList; _vendorOrderManager.FinalizeVendorOrder(vendorOrder); }
public static bool Update(VendorOrder oldVendorOrder, VendorOrder newVendorOrder, SqlConnection connection) { connection = connection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_UpdateVendorOrder", connection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@VendorOrderID", newVendorOrder.Id); mySqlCommand.Parameters.AddWithValue("@VendorID", newVendorOrder.VendorID); mySqlCommand.Parameters.AddWithValue("@AmountOfShipments", newVendorOrder.NumberOfShipments); mySqlCommand.Parameters.AddWithValue("@Finalized", newVendorOrder.Finalized); mySqlCommand.Parameters.AddWithValue("@orig_AmountOfShipments", oldVendorOrder.NumberOfShipments); mySqlCommand.Parameters.AddWithValue("@orig_Finalized", oldVendorOrder.Finalized); connection.Open(); if (mySqlCommand.ExecuteNonQuery() == 1) { return true; } } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { connection.Close(); } return false; }
public static VendorOrder GetVendorOrderByVendorAndDate(int vendorId, SqlConnection connection) { VendorOrder newVendorOrder; connection = connection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetVendorOrderByVendorAndDate", connection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@VendorId", vendorId); connection.Open(); var myReader = mySqlCommand.ExecuteReader(); if (myReader.HasRows) { while (myReader.Read()) { newVendorOrder = new VendorOrder(myReader.GetInt32(0), myReader.GetInt32(1)) { DateOrdered = (DateTime)myReader.GetSqlDateTime(2), NumberOfShipments = myReader.GetInt32(3), Finalized = myReader.GetBoolean(4), Active = myReader.GetBoolean(5) }; return newVendorOrder; }; } myReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { connection.Close(); } throw new ApplicationException("Vendor Order from vendor: " + vendorId + "not found"); }
public Boolean FinalizeVendorOrder(VendorOrder order) { if (order == null) throw new ApplicationException("VendorOrder cannot be null"); if (order.LineItems == null) throw new ApplicationException("VendorOrder cannot have zero line items"); var oldOrder = new VendorOrder(order.Id, order.VendorID); oldOrder.Finalized = order.Finalized; oldOrder.NumberOfShipments = order.NumberOfShipments; order.Finalized = true; foreach (VendorOrderLineItem item in order.LineItems) { prodMan.AddToAvailable(item.QtyReceived, item.ProductID); prodMan.AddToOnHand(item.QtyDamaged + item.QtyReceived, item.ProductID); prodMan.RemoveFromOnOrder(item.QtyReceived + item.QtyDamaged, item.ProductID); } var result = VendorOrderDAL.Update(oldOrder, order, _connection); return result; }
public static List<VendorOrderLineItem> GetExceptionItems(VendorOrder vendorOrder, SqlConnection myConnection) { var exceptionItemsList = new List<VendorOrderLineItem>(); myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetExceptionItems", myConnection) { CommandType = CommandType.StoredProcedure }; myConnection.Open(); var mySqlReader = mySqlCommand.ExecuteReader(); if (mySqlReader.HasRows) { while (mySqlReader.Read()) { var vendorOrderLineItem = new VendorOrderLineItem(mySqlReader.GetInt32(0), mySqlReader.GetInt32(1)) { QtyOrdered = mySqlReader.GetInt32(2), QtyReceived = mySqlReader.GetInt32(3), QtyDamaged = mySqlReader.GetInt32(4) }; exceptionItemsList.Add(vendorOrderLineItem); } } mySqlReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return exceptionItemsList; }
public static bool Add(VendorOrder order) { return true; }
private void btSaveOrder_Click(object sender, EventArgs e) { try { List<VendorOrderLineItem> lineItemList = new List<VendorOrderLineItem>(); int index = comboVendor.SelectedItem.ToString().IndexOf(" "); int id = Convert.ToInt32(comboVendor.SelectedItem.ToString().Substring(0, index)); _myVendorManager = new VendorManager(); var vendorName = _myVendorManager.GetVendor(id).Name; //VendorOrder myVendorOrder = new VendorOrder(int.Parse(id)); VendorOrder myVendorOrder = new VendorOrder(id); myVendorOrder.NumberOfShipments = Convert.ToInt32(comboShipments.SelectedItem.ToString()); myVendorOrder.DateOrdered = Convert.ToDateTime(tbOrderDate.Text); myVendorOrder.Name = vendorName; for (int i = 0; i < lvOrderItems.Items.Count;i++) { Int32 productId = Int32.Parse(lvOrderItems.Items[i].SubItems[0].Text); VendorOrderLineItem item = new VendorOrderLineItem(id, productId); item.Name = lvOrderItems.Items[i].SubItems[1].Text; item.QtyOrdered = Int32.Parse(lvOrderItems.Items[i].SubItems[3].Text); lineItemList.Add(item); } myVendorOrder.LineItems = lineItemList; Boolean success = _myVendorOrderManager.AddVendorOrder(myVendorOrder); if (success == true) { MessageBox.Show("Order Added."); populateListView(); comboProduct.Items.Clear(); } else { MessageBox.Show("A field is not filled in. Please verify all fields are correct."); } } catch(Exception ex) { MessageBox.Show("A Generic error as occured. You should fix this message " + ex.ToString()); } }
public bool UpdateShipmentsReceived(VendorOrder order, int qtyReceived) { if(order == null) throw new ApplicationException("VendorOrder cannot be null"); if(qtyReceived + order.NumberOfShipments < 0) throw new ApplicationException("Total quantity of shipments received cannot be negative"); var oldOrder = order; order.NumberOfShipments += qtyReceived; var result = VendorOrderDAL.Update(oldOrder, order, _connection); return result; }
public static bool Update(VendorOrder oldVendorOrder, VendorOrder newVendorOrder, SqlConnection connection) { return true; }
public Boolean OrderReorders() { VendorOrder order = new VendorOrder(_reorders[0].VendorSourceItem.VendorID); foreach (var reorder in _reorders) { if (reorder.ShouldReorder == true && reorder.CasesToOrder > 0) { order.AddLineItem(new VendorOrderLineItem(reorder.Product.Id, (reorder.CasesToOrder * reorder.VendorSourceItem.ItemsPerCase), 0, 0)); } } return _voMangaer.AddVendorOrder(order); }
public List<VendorOrderLineItem> GetExceptionItemsByVendorOrder(VendorOrder vendorOrder) { if (vendorOrder == null) throw new ApplicationException("No such VendorOrder"); var exceptionLineItems = VendorOrderLineItemDAL.GetExceptionItemsByVendorOrder(vendorOrder, _connection); return exceptionLineItems ?? new List<VendorOrderLineItem>(); }
private void btnAddLineItemtoCurrentListView_Click(object sender, EventArgs e) { vendorOrder = new VendorOrder(Int32.Parse(txtVendorOrderID.Text), Int32.Parse(txtVendorID.Text)); FrmAddLineItemToVendorOrder _FrmAddLineItemToVendorOrder = new FrmAddLineItemToVendorOrder(vendorOrder, _myAccessToken); _FrmAddLineItemToVendorOrder.ShowDialog(); populateListView(); }