public ProductAdjustmentHistoryCollection GetAllProductAdjustmentHistoryDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); ProductAdjustmentHistoryCollection cols = new ProductAdjustmentHistoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectUsersDynamic"); while (reader.Read()) { ProductAdjustmentHistory PAH = new ProductAdjustmentHistory(); PAH.ProductID = Int32.Parse(reader["ProductID"].ToString()); PAH.AdjustedQuantity = Int32.Parse(reader["ProductID"].ToString()); PAH.Reason = reader["Reason"].ToString(); PAH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(PAH); } } catch (Exception ex) { log.Write(ex.Message, "GetAllProductAdjustmentHistoryDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public ProductAdjustmentHistoryCollection GetAllProductAdjustmentHistoryCollection(int purchaseAdjustedQuantity) { IDBManager dbm = new DBManager(); ProductAdjustmentHistoryCollection cols = new ProductAdjustmentHistoryCollection(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@ProductID", purchaseAdjustedQuantity); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductAdjustmentHistoryByAdjustedQuantity"); while (reader.Read()) { ProductAdjustmentHistory PAH = new ProductAdjustmentHistory(); PAH.ProductID = Int32.Parse(reader["ProductID"].ToString()); PAH.AdjustedQuantity = Int32.Parse(reader["AdjustedQuantity"].ToString()); PAH.Reason = reader["Reason"].ToString(); PAH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(PAH); } } catch (Exception ex) { log.Write(ex.Message, "ProductAdjustmentHistoryCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public int AddProductAdjustmentHistory(ProductAdjustmentHistory PAH) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(5); dbm.AddParameters(0, "@ProductID", PAH.ProductID); dbm.AddParameters(1, "@AdjustedQuantity", PAH.AdjustedQuantity); dbm.AddParameters(2, "@Reason", PAH.Reason); dbm.AddParameters(3, "@ModifiedDate", PAH.ModifiedDate); dbm.AddParameters(4, "@ID", PAH.ID); dbm.Parameters[4].Direction = ParameterDirection.Output; dbm.ExecuteNonQuery(CommandType.StoredProcedure, "InsertProductAdjustmentHistory"); PAH.ID = Int32.Parse(dbm.Parameters[4].Value.ToString()); } catch (Exception ex) { log.Write(ex.Message, "AddProductAdjustmentHistory"); throw (ex); } finally { dbm.Dispose(); } return(PAH.ID); }
private void AddProduct() { Product p = new Product(); Product product = new Product(); ProductInventory pi = new ProductInventory(); ProductAdjustmentHistory pah = new ProductAdjustmentHistory(); try { p = SetProduct(); //pi.ProductID = p.ProductID; string qty = txtQuantity.Text.Trim() == string.Empty?"0" : txtQuantity.Text.Trim(); pi.Quantity = Int32.Parse(qty); pi.ModifiedDate = DateTime.Now; pi.Shelf = "2"; pi.LocationID = 1; pi.Bin = 1; p.ProductInventory = pi; int productid = p.Exists(p.Name, p.Description); if (productid > 0) { DialogResult result = MessageBox.Show("The product " + p.Name + " already exists\nWould you like to update it?", "MICS", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { p.ProductID = productid; p.UpdateProduct(p); PopulateGrid(String.Empty, String.Empty, p.ProductID); MessageBox.Show("Record updated successfully", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Record is not saved", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Warning); } return; } p.ProductID = product.AddProduct(p); if (p.ProductID > 0) { MessageBox.Show("Product Added"); PopulateGrid(String.Empty, String.Empty, p.ProductID); } else { MessageBox.Show("Unable to add product"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { p = null; } // PopulateGrid(String.Empty, String.Empty,p.ProductID); }
private void btnSave_Click(object sender, EventArgs e) { if (ValidateFields() == false) { return; } if (dgInventory.Rows.Count < 1 || InventoryAdjustmentCount == 0) { return; } // int selectedRows = dgInventory.SelectedRows.Count; int selectedCount = 0; DialogResult result = MessageBox.Show("You are about to adjust the inventory for " + InventoryAdjustmentCount.ToString() + " item(s). Are you sure you want proceed.?", "MICS", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.No) { return; } int curIndex = 0; bool success = true; for (int row = 0; row < dgInventory.Rows.Count; row++) { if (dsProductInventory.Tables[0].Rows[row]["AdjustedQuantity"] == DBNull.Value) { continue; } if (selectedCount > InventoryAdjustmentCount) { break; } selectedCount++; //DataGridViewRow row = dgInventory.CurrentRow; //int curIndex = dgInventory.CurrentRow.Index; curIndex = row; //if (row == null) return; Cursor.Current = Cursors.WaitCursor; ProductInventory pi = new ProductInventory(); ProductAdjustmentHistory pah = new ProductAdjustmentHistory(); // int adjustedQuantity = Int32.Parse(txtAdjustedQuanity.Text.Trim()); // string reason = txtReason.Text.Trim(); try { int productid = Int32.Parse(dsProductInventory.Tables[0].Rows[row]["productid"].ToString()); //Int32.Parse(dgInventory.CurrentRow.Cells["productid"].Value.ToString()); int CurQuantity = 0; int NewQuantity = 0; if (dsProductInventory.Tables[0].Rows[row]["AdjustedQuantity"] != DBNull.Value) { NewQuantity = Int32.Parse(dsProductInventory.Tables[0].Rows[row]["AdjustedQuantity"].ToString()); } if (dsProductInventory.Tables[0].Rows[row]["Quantity"] != DBNull.Value) { CurQuantity = Int32.Parse(dsProductInventory.Tables[0].Rows[row]["Quantity"].ToString()); } pah.ProductID = productid; pah.AdjustedQuantity = NewQuantity - CurQuantity; if (dsProductInventory.Tables[0].Rows[row]["Reason"] != DBNull.Value) { pah.Reason = dsProductInventory.Tables[0].Rows[row]["Reason"].ToString(); } else { pah.Reason = ""; } // pah.AdjustedQuantity = adjustedQuantity; pah.ModifiedDate = DateTime.Now; pah.AddProductAdjustmentHistory(pah); pi.ProductID = productid; pi.Quantity = NewQuantity; pi.LocationID = 0; pi.ModifiedDate = DateTime.Now; pi.Shelf = ""; pi.Bin = 0; ProductInventory inv = new ProductInventory(); inv = inv.GetProductInventorys(productid); // pi.Quantity = (long) adjustedQuantity; //pi.ModifiedDate = DateTime.Now; if (inv.ProductID > 0) { pi.UpdateProductInventory(pi); } else { pi.AddProductInventory(pi); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Product Inventory", MessageBoxButtons.OK, MessageBoxIcon.Error); Cursor.Current = Cursors.Default; success = false; break; } finally { Cursor.Current = Cursors.Default; } } if (success) { MessageBox.Show("Inventory Adjusted successfully.", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Inventory Adjustment failed.", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Warning); } Search(curIndex); }