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";
}
}
}
