private void btnAdd_Click(object sender, EventArgs e) { if(btnAdd.Text.Equals("Add Vendor")) { VendorSourceItem vendorSource = new VendorSourceItem() { ProductID = _currentProduct.Id, VendorID = ((KeyValuePair<int,string>)comboVendors.SelectedItem).Key, UnitCost = nudUnitPrice.Value, ItemsPerCase = (int)nudCase.Value, MinQtyToOrder = (int)nudMinnimum.Value, Active = true, }; try { if (_vendorSource.AddVendorSourceItem(vendorSource)) { this.DialogResult = DialogResult.OK; MessageBox.Show("The vendor details were added to this product."); } else { MessageBox.Show("The vendor was not attached to the product.\nThat Product/Vendor combination may already exist."); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else if(btnAdd.Text.Equals("Update Vendor")) { VendorSourceItem vendorSource = new VendorSourceItem() { ProductID = _currentProduct.Id, VendorID = ((KeyValuePair<int, string>)comboVendors.SelectedItem).Key, UnitCost = nudUnitPrice.Value, ItemsPerCase = (int)nudCase.Value, MinQtyToOrder = (int)nudMinnimum.Value, Active = true, }; try { if (_vendorSource.UpdateVendorSourceItem(vendorSource, _currentVendorSourceItem)) { this.DialogResult = DialogResult.OK; MessageBox.Show("The vendor details for this product were updated."); } else { MessageBox.Show("The vendor details were not updated. This information may have already been updated by another employee. Please try again."); } } catch (Exception ex) { MessageBox.Show("Error has Occured. Error Message: " + ex.Message); } } }
private void button1_Click(object sender, EventArgs e) { var vsiManager = new VendorSourceItemManager(); var vsrcItem = new VendorSourceItem { ProductID = (int) productCb.SelectedValue, VendorID = (int) vendorCb.SelectedValue, MinQtyToOrder = (int) minQty.Value, UnitCost = Convert.ToDecimal(unitCost.Text), Active = true }; vsiManager.AddVendorSourceItem(vsrcItem); }
public Boolean AddNewLineItem(Product product, VendorSourceItem vendorSrcItem, int caseAmt) { if (product == null) throw new ArgumentNullException("Product is null"); if (vendorSrcItem == null) throw new ArgumentNullException("VendorSourceItem is null"); Reorder addOrder = new Reorder(); addOrder.Product = product; addOrder.VendorSourceItem = vendorSrcItem; addOrder.ShouldReorder = true; addOrder.CasesToOrder = caseAmt; addOrder.ReorderTotal = GetReorderRowTotal(addOrder); return true; //throw new NotImplementedException(); }
public FrmAttachVendorSource(Product product, VendorSourceItem currentVendorSourceItem) { InitializeComponent(); _vendorSource = new VendorSourceItemManager(); _vendorManager = new VendorManager(); _currentVendorSourceItem = currentVendorSourceItem; _vendors = _vendorManager.GetVendors(); _currentProduct = product; nudCase.Value = _currentVendorSourceItem.ItemsPerCase; nudMinnimum.Value = _currentVendorSourceItem.MinQtyToOrder; nudUnitPrice.Value = _currentVendorSourceItem.UnitCost; btnAdd.Text = "Update Vendor"; comboVendors.Enabled = false; }
public static bool AddVendorSourceItem(VendorSourceItem vendorSrcItem, SqlConnection myConnection) { //Questional usage of ?? its incase myConnection comes in null it will grab a new connection. //Thoughts? myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_InsertIntoVendorSourceItems", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@productID", vendorSrcItem.ProductID); mySqlCommand.Parameters.AddWithValue("@vendorID", vendorSrcItem.VendorID); mySqlCommand.Parameters.AddWithValue("@unitCost", vendorSrcItem.UnitCost); mySqlCommand.Parameters.AddWithValue("@minQtyToOrder", vendorSrcItem.MinQtyToOrder); mySqlCommand.Parameters.AddWithValue("@itemsPerCase", vendorSrcItem.ItemsPerCase); mySqlCommand.Parameters.AddWithValue("@active", vendorSrcItem.Active ? 1 : 0); //Change to bit, Ternary Operator myConnection.Open(); if (mySqlCommand.ExecuteNonQuery() == 1) { return true; } } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { if (ex.Number == 2627) { throw new ApplicationException("This vendor is already attached to this product therefore it could not be added."); } else { 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 false; }
public static bool DeactivateVendorSourceItem(VendorSourceItem vendorSrcItem, SqlConnection myConnection) { myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_DeactivateVendorSourceItem", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@productID", vendorSrcItem.ProductID); mySqlCommand.Parameters.AddWithValue("@vendorID", vendorSrcItem.VendorID); myConnection.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 { myConnection.Close(); } return false; }
public static List<Reorder> GetReorderReportData(int vendorId, int reorderActive) { List<Reorder> reorders = new List<Reorder>(); SqlConnection conn = GetInventoryDbConnection(); try { conn.Open(); SqlCommand sqlCmd = new SqlCommand("proc_GenerateReorderReports", conn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@VendorID", vendorId); sqlCmd.Parameters.AddWithValue("@ReorderActive", reorderActive); SqlDataReader reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Reorder order = new Reorder(); var product = new Product(reader.GetInt32(0)) { Name = reader.GetString(reader.GetOrdinal("ShortDesc")), _reorderThreshold = reader.GetInt32(reader.GetOrdinal("ReorderThreshold")), _reorderAmount = reader.GetInt32(reader.GetOrdinal("ReorderAmount")), Active = true }; order.Product = product; var vendorSrcItem = new VendorSourceItem(reader.GetInt32(reader.GetOrdinal("ProductID")), reader.GetInt32(reader.GetOrdinal("VendorID"))) { UnitCost = (Decimal)reader.GetSqlMoney(reader.GetOrdinal("UnitCost")), MinQtyToOrder = reader.GetInt32(reader.GetOrdinal("MinQtyToOrder")), ItemsPerCase = reader.GetInt32(reader.GetOrdinal("ItemsPerCase")), Active = true }; order.CasesToOrder = (int)product._reorderAmount / vendorSrcItem.ItemsPerCase + (product._reorderAmount % vendorSrcItem.ItemsPerCase == 0 ? 0 : 1); order.ReorderTotal = (double)order.CasesToOrder * (double)vendorSrcItem.ItemsPerCase * (double)vendorSrcItem.UnitCost; order.ShouldReorder = true; order.VendorSourceItem = vendorSrcItem; reorders.Add(order); } } reader.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 { conn.Close(); } return reorders; }
public Boolean UpdateVendorSourceItem(VendorSourceItem vendorSrcItem, VendorSourceItem origVendorSrcItem) { return VendorSourceItemDAL.UpdateVendorSourceItem(vendorSrcItem, origVendorSrcItem, _connection); }
public Boolean ReactivateVendorSourceItem(VendorSourceItem vendorSrcItem) { return VendorSourceItemDAL.ReactivateVendorSourceItem(vendorSrcItem, _connection); }
public Boolean DeleteVendorSourceItem(VendorSourceItem vendorSrcItem) { return VendorSourceItemDAL.DeleteVendorSourceItem(vendorSrcItem, _connection); }
public Boolean AddVendorSourceItem(VendorSourceItem vendorSrcItem) { //Do error checking here return VendorSourceItemDAL.AddVendorSourceItem(vendorSrcItem, _connection); }
public static bool UpdateVendorSourceItem(VendorSourceItem vendorSrcItem, VendorSourceItem origVendorSrcItem, SqlConnection myConnection) { myConnection = myConnection ?? GetInventoryDbConnection(); try { //Talk about checking data first in sql, Passing the old data and verifiy its still the same. var mySqlCommand = new SqlCommand("proc_UpdateVendorSourceItem", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@productID", vendorSrcItem.ProductID); mySqlCommand.Parameters.AddWithValue("@vendorID", vendorSrcItem.VendorID); mySqlCommand.Parameters.AddWithValue("@unitCost", vendorSrcItem.UnitCost); mySqlCommand.Parameters.AddWithValue("@minQtyToOrder", vendorSrcItem.MinQtyToOrder); mySqlCommand.Parameters.AddWithValue("@itemsPerCase", vendorSrcItem.ItemsPerCase); mySqlCommand.Parameters.AddWithValue("@orig_productID", origVendorSrcItem.ProductID); mySqlCommand.Parameters.AddWithValue("@orig_vendorID", origVendorSrcItem.VendorID); mySqlCommand.Parameters.AddWithValue("@orig_unitCost", origVendorSrcItem.UnitCost); mySqlCommand.Parameters.AddWithValue("@orig_minQtyToOrder", origVendorSrcItem.MinQtyToOrder); mySqlCommand.Parameters.AddWithValue("@orig_itemsPerCase", origVendorSrcItem.ItemsPerCase); myConnection.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 { myConnection.Close(); } return false; }
public static List<VendorSourceItem> GetVendorSourceItemsByVendor(int vendorId, SqlConnection myConnection) { var vendorSourceItemList = new List<VendorSourceItem>(); myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetVendorSourceItemsByVendor", myConnection); mySqlCommand.Parameters.AddWithValue("@vendorID", vendorId); mySqlCommand.CommandType = CommandType.StoredProcedure; myConnection.Open(); var mySqlReader = mySqlCommand.ExecuteReader(); if (mySqlReader.HasRows) { while (mySqlReader.Read()) { var vendorSrcItem = new VendorSourceItem(mySqlReader.GetInt32(0), mySqlReader.GetInt32(1)) { UnitCost = (Decimal) mySqlReader.GetSqlMoney(2), MinQtyToOrder = mySqlReader.GetInt32(3), ItemsPerCase = mySqlReader.GetInt32(4), Active = true }; //Add item to list vendorSourceItemList.Add(vendorSrcItem); } } 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 vendorSourceItemList; }