public void UpdateStockSize(int id, int productId, int sizeId, int stock) { if (id < 1 || productId < 1 || sizeId < 1 || stock < 0) { throw new Exception("No es posible actualizar el Stock, los valores no son válidos"); } StockSizesDAO dao = new StockSizesDAO(); StockSize updateStockSize = dao.GetStockSize(id); if (updateStockSize != null) { updateStockSize.productId = productId; updateStockSize.sizeId = sizeId; updateStockSize.stock = stock; int result = dao.UpdateStockSize(updateStockSize); if (result < 1) { throw new Exception("No es posible actualizarel Stock"); } } else { throw new Exception("El id del Stock a actualizar no es válido"); } }
public static Image GetImage(string stock_id, StockSize size) { IntPtr raw = stock_get_image(stock_id, size); if(raw == IntPtr.Zero) throw new ArgumentException("Invalid stock ID", stock_id); return new Image(raw); }
public void InsertStockSize(int productId, int sizeId, int stock) { try { } catch (Exception) { throw new Exception("No es posible registrar el Stock"); } StockSizesDAO dao = new StockSizesDAO(); List <StockSize> brands = GetAllStockSizes(); StockSize newStockSize = new StockSize(); newStockSize.productId = productId; newStockSize.sizeId = sizeId; newStockSize.stock = stock; int result = dao.CreateStockSize(newStockSize); if (result < 1) { throw new Exception("No es posible registrar el Stock"); } }
private void AddParameters(StockSize stockSize, Database database, DbCommand command) { database.AddInParameter(command, "@pId", DbType.Int32, stockSize.id); database.AddInParameter(command, "@pProductId", DbType.Int32, stockSize.productId); database.AddInParameter(command, "@pSizeId", DbType.Int32, stockSize.sizeId); database.AddInParameter(command, "@pStock", DbType.Int32, stockSize.stock); database.AddParameter(command, "@pIdReturn", DbType.Int32, ParameterDirection.ReturnValue, null, DataRowVersion.Default, null); }
protected void Page_Load(object sender, EventArgs e) { int productId = -1; if (!IsPostBack) { try { productId = Convert.ToInt32(Request.QueryString["productId"]); CtrlProducts ctrlProducts = new CtrlProducts(); Product product = ctrlProducts.GetProduct(productId); if (product != null && product.id > 0) { lblNombreProducto.Text = product.name; lblDescripcion.Text = product.shortDescription; CtrlProductTypes ctrlProductTypes = new CtrlProductTypes(); ProductType productType = ctrlProductTypes.GetProductType(product.productTypeId); if (productType != null && productType.id > 0) { CtrlCategorySizes ctrlCategorySizes = new CtrlCategorySizes(); CategorySize categorySize = ctrlCategorySizes.GetCategorySize(productType.categorySizeId); CtrlSizes ctrlSizes = new CtrlSizes(); List <Size> listAllSizes = ctrlSizes.GetAllSizes(); listAllSizes = listAllSizes.FindAll(s => s.categorySizeId.Equals(categorySize.id)); CtrlStockSizes ctrlStockSizes = new CtrlStockSizes(); List <StockSize> listAllStockSizes = ctrlStockSizes.GetAllStockSizes(); listAllStockSizes = listAllStockSizes.FindAll(ss => ss.productId.Equals(product.id)); foreach (Size size in listAllSizes) { StockSize stockSize = listAllStockSizes.Find(ss => ss.sizeId.Equals(size.id)); if (stockSize == null) { StockSize newStockSize = new StockSize(); newStockSize.productId = product.id; newStockSize.sizeId = size.id; newStockSize.stock = 0; ctrlStockSizes.InsertStockSize(newStockSize.productId, newStockSize.sizeId, newStockSize.stock); } } } } } catch (Exception) { Response.Redirect("Products.aspx"); } } }
public void DeleteStockSize(int id) { StockSizesDAO dao = new StockSizesDAO(); StockSize deleteStockSize = dao.GetStockSize(id); if (deleteStockSize != null) { int result = dao.DeleteStockSize(deleteStockSize); if (result < 1) { throw new Exception("No es posible eliminar el Stock"); } } else { throw new Exception("El id del Stock a eliminar no es válido"); } }
public int DeleteStockSize(StockSize stockSize) { int result = -1; try { Database database = DatabaseFactory.CreateDatabase(); DbCommand command = database.GetStoredProcCommand(storedProcedureName); database.AddInParameter(command, "@pOperation", DbType.Int32, 5); AddParameters(stockSize, database, command); result = database.ExecuteNonQuery(command); } catch (Exception) { //Crear Exception } return(result); }
public StockSize GetStockSize(int id) { StockSize stockSize = null; try { Database database = DatabaseFactory.CreateDatabase(); DbCommand command = database.GetStoredProcCommand(storedProcedureName); database.AddInParameter(command, "@pOperation", DbType.Int32, 3); database.AddInParameter(command, "@pId", DbType.Int32, id); DataSet dsStockSize = database.ExecuteDataSet(command); if (dsStockSize != null && dsStockSize.Tables.Count > 0) { stockSize = DAOUtilities.FillEntities <StockSize>(dsStockSize.Tables[0]) .FirstOrDefault(); } } catch (Exception) { //Crear Exception } return(stockSize); }
//after Save For Grid Data public List <PRDChemProdReqItem> GetTransactionItemList(long _TransactionID, string _IssueFrom) { using (var context = new BLC_DEVEntities()) { var StockResult = (from p in context.INV_ChemStockSupplier where p.StoreID.ToString() == _IssueFrom group p by new { //p.StoreID, p.SupplierID, p.PackSize, p.ItemID, p.SizeUnit, p.UnitID } into g select new { TransectionID = g.Max(p => p.TransectionID), //StoreID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.StoreID).FirstOrDefault(), ItemID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.ItemID).FirstOrDefault(), SupplierID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.SupplierID).FirstOrDefault(), //UnitID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.UnitID).FirstOrDefault(), PackSize = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.PackSize).FirstOrDefault(), SizeUnit = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.SizeUnit).FirstOrDefault(), PackQty = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.PackClosingQty).FirstOrDefault(), ClosingQty = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.ClosingQty).FirstOrDefault(), StockUnit = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.UnitID).FirstOrDefault() }); var Data = (from i in context.INV_StoreTransItem where i.TransactionID == _TransactionID // Stock Size from s in StockResult.Where(x => x.ItemID == i.ItemID && x.PackSize == i.PackSize && x.SizeUnit == i.SizeUnit && x.SupplierID == i.SupplierID).DefaultIfEmpty() join si in context.Sys_Size on(s == null ? null : s.PackSize) equals si.SizeID into StockSize from si in StockSize.DefaultIfEmpty() join siu in context.Sys_Unit on(s == null ? null : s.SizeUnit) equals siu.UnitID into StockSizeUnit from siu in StockSizeUnit.DefaultIfEmpty() join su in context.Sys_Unit on(s == null ? null : s.StockUnit) equals su.UnitID into StockUnit from su in StockUnit.DefaultIfEmpty() // Stock Size join it in context.Sys_ChemicalItem on(i == null ? null : i.ItemID) equals it.ItemID into Chemicals from it in Chemicals.DefaultIfEmpty() join sup in context.Sys_Supplier on(i == null ? null : i.SupplierID) equals sup.SupplierID into Suppliers from sup in Suppliers.DefaultIfEmpty() join iu in context.Sys_Unit on(i == null ? null : i.TransactionUnit) equals iu.UnitID into IUnits from iu in IUnits.DefaultIfEmpty() join issuesize in context.Sys_Size on(i == null ? null : i.PackSize) equals issuesize.SizeID into IssueSizes from issuesize in IssueSizes.DefaultIfEmpty() join issuesizeunit in context.Sys_Unit on(i == null ? null : i.SizeUnit) equals issuesizeunit.UnitID into IssueSizeUnit from issuesizeunit in IssueSizeUnit.DefaultIfEmpty() orderby(it == null ? null : it.ItemName) select new PRDChemProdReqItem { TransItemID = i.TransItemID, ItemID = i.ItemID, ItemName = (it == null ? null : it.ItemName), SupplierID = i.SupplierID, SupplierName = (sup == null ? null : sup.SupplierName), PackSize = (s == null ? 0 : s.PackSize), PackSizeName = (si == null ? null : si.SizeName), SizeUnit = (s == null ? 0 : s.SizeUnit), SizeUnitName = (siu == null ? null : siu.UnitName), PackQty = (s == null ? 0 : (Int32)(s.PackQty)), StockQty = (s == null ? 0 : s.ClosingQty), StockUnit = (s == null ? 0 : s.StockUnit), StockUnitName = (su == null ? null : su.UnitName), IssuePackSize = i.PackSize, IssuePackSizeName = (issuesize == null ? null : issuesize.SizeName), IssueSizeUnit = i.SizeUnit, IssueSizeUnitName = (issuesizeunit == null ? null : issuesizeunit.UnitName), IssuePackQty = i.PackQty, IssueQty = i.TransactionQty, IssueUnitName = (iu == null ? null : iu.UnitName) }).ToList(); return(Data); } }
private static extern IntPtr stock_get_image(string stock_id, StockSize size);