private void SaveRecord() { StockItemDetails clsDetails = new StockItemDetails(); clsDetails.StockID = Convert.ToInt64(lblStockID.Text); clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value); clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value); clsDetails.StockTypeID = Convert.ToInt16(txtStockTypeCode.ToolTip); clsDetails.StockDate = DateTime.Now; clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text); clsDetails.Remarks = txtRemarks.Text; clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text); StockDirections StockDirection = (StockDirections)Enum.Parse(typeof(StockDirections), txtStockDirection.Text); Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"]; Stock clsStock = new Stock(); clsStock.AddItem(int.Parse(cboBranch.SelectedItem.Value), lblTransactionNo.Text, clsAccessUserDetails.Name, clsDetails, StockDirection); clsStock.CommitAndDispose(); }
/// <summary> /// Jul 28, 2011 : Lemu // - Remove the adding/subtracting and SynchronizeQuantity in clsProductVariationsMatrix, // already included in the new AddQuantity and SubtractQuantity. /// </summary> /// <param name="Details"></param> /// <param name="StockDirection"></param> /// <returns></returns> public Int64 AddItem(int BranchID, string TransactionNo, string CreatedBy, StockItemDetails Details, StockDirections StockDirection) { try { StockItem clsStockItem = new StockItem(base.Connection, base.Transaction); Int64 StockItemID = clsStockItem.Insert(Details); ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction); decimal Quantity = clsProductUnit.GetBaseUnitValue(Details.ProductID, Details.ProductUnitID, Details.Quantity); string strRemarks = string.Empty; Products clsProduct = new Products(base.Connection, base.Transaction); if (StockDirection == StockDirections.Decrement) { strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_STOCK_INVENTORY) + " " + Details.Remarks; clsProduct.SubtractQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy); } else { strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_STOCK_INVENTORY) + " " + Details.Remarks; clsProduct.AddQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy); } // Removed //ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); //if (Details.VariationMatrixID != 0) //{ // if (StockDirection == StockDirections.Decrement) // { clsProductVariationsMatrix.SubtractQuantity(Details.VariationMatrixID, Quantity); } // else // { clsProductVariationsMatrix.AddQuantity(Details.VariationMatrixID, Quantity); } // clsProductVariationsMatrix.SynchronizeQuantity(Details.ProductID); //} return StockItemID; } catch (Exception ex) { throw base.ThrowException(ex); } }
/// <summary> /// Jul 28, 2011 : Lemu // - Remove the adding/subtracting and SynchronizeQuantity in clsProductVariationsMatrix, // already included in the new AddQuantity and SubtractQuantity. /// </summary> /// <param name="Details"></param> /// <param name="StockDirection"></param> /// <returns></returns> public Int64 AddItem(int BranchID, string TransactionNo, string CreatedBy, StockItemDetails Details, StockDirections StockDirection) { try { StockItem clsStockItem = new StockItem(base.Connection, base.Transaction); Int64 StockItemID = clsStockItem.Insert(Details); ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction); decimal Quantity = clsProductUnit.GetBaseUnitValue(Details.ProductID, Details.ProductUnitID, Details.Quantity); string strRemarks = string.Empty; Products clsProduct = new Products(base.Connection, base.Transaction); if (StockDirection == StockDirections.Decrement) { strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_STOCK_INVENTORY) + " " + Details.Remarks; clsProduct.SubtractQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy); } else { strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_STOCK_INVENTORY) + " " + Details.Remarks; clsProduct.AddQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy); } // Removed //ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); //if (Details.VariationMatrixID != 0) //{ // if (StockDirection == StockDirections.Decrement) // { clsProductVariationsMatrix.SubtractQuantity(Details.VariationMatrixID, Quantity); } // else // { clsProductVariationsMatrix.AddQuantity(Details.VariationMatrixID, Quantity); } // clsProductVariationsMatrix.SynchronizeQuantity(Details.ProductID); //} return(StockItemID); } catch (Exception ex) { throw base.ThrowException(ex); } }
protected void lstItem_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Header) { LoadSortFieldOptions(e); } else if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView dr = (DataRowView)e.Item.DataItem; ImageButton imgItemDelete = (ImageButton)e.Item.FindControl("imgItemDelete"); ImageButton imgItemEdit = (ImageButton)e.Item.FindControl("imgItemEdit"); HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList"); chkList.Value = dr["StockID"].ToString(); imgItemDelete.Enabled = cmdDelete.Visible; if (!imgItemDelete.Enabled) { imgItemDelete.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; } imgItemEdit.Enabled = cmdEdit.Visible; if (!imgItemEdit.Enabled) { imgItemEdit.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; } if (imgItemDelete.Enabled) { imgItemDelete.Attributes.Add("onClick", "return confirm_item_delete();"); } ImageButton imgItemTransfer = (ImageButton)e.Item.FindControl("imgItemTransfer"); if (dr["StockTypeID"].ToString() != Constants.STOCK_TYPE_TRANSFER_TO_BRANCH_ID) { imgItemTransfer.Enabled = false; imgItemTransfer.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; imgItemTransfer.ToolTip = ""; } else { imgItemTransfer.Enabled = cmdTransfer.Visible; if (!imgItemTransfer.Enabled) { imgItemTransfer.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; imgItemTransfer.ToolTip = ""; } } HyperLink lnkTransactionNo = (HyperLink)e.Item.FindControl("lnkTransactionNo"); lnkTransactionNo.Text = dr["TransactionNo"].ToString(); string stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&stockid=" + Common.Encrypt(chkList.Value.ToString(), Session.SessionID); lnkTransactionNo.NavigateUrl = Constants.ROOT_DIRECTORY + "/Inventory/_Stock/Default.aspx" + stParam; Label lblStockTypeCode = (Label)e.Item.FindControl("lblStockTypeCode"); lblStockTypeCode.Text = dr["StockTypeDescription"].ToString(); Label lblStockTypeID = (Label)e.Item.FindControl("lblStockTypeID"); lblStockTypeID.Text = dr["StockTypeID"].ToString(); Label lblStockDirection = (Label)e.Item.FindControl("lblStockDirection"); StockDirections stockdirection = (StockDirections)Enum.Parse(typeof(StockDirections), Convert.ToInt16(dr["StockDirection"]).ToString()); lblStockDirection.Text = stockdirection.ToString("G"); Label lblStockDate = (Label)e.Item.FindControl("lblStockDate"); lblStockDate.Text = Convert.ToDateTime(dr["StockDate"].ToString()).ToString("MM/dd/yyyy HH:mm:ss"); Label lblRemarks = (Label)e.Item.FindControl("lblRemarks"); lblRemarks.Text = dr["Remarks"].ToString(); ImageButton imgTransactionTag = (ImageButton)e.Item.FindControl("imgTransactionTag"); if (Convert.ToBoolean(dr["Active"])) { imgTransactionTag.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/prodtagact.gif"; imgTransactionTag.ToolTip = "Close this transaction to prevent user for adding new items."; } else //if (clsProductListFilterType == ProductListFilterType.ShowInactiveOnly) { imgTransactionTag.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; imgTransactionTag.ToolTip = "Transaction is already close."; imgTransactionTag.Enabled = false; chkList.Attributes.Add("disabled", "false"); imgItemDelete.Enabled = false; imgItemDelete.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; imgItemEdit.Enabled = false; imgItemEdit.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif"; } } }