private void AddItemToInventory(long TransferInID)
{
try
{
TransferInDetails clsTransferInDetails = Details(TransferInID);
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
TransferInItem clsTransferInItem = new TransferInItem(base.Connection, base.Transaction);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
Products clsProduct = new Products(base.Connection, base.Transaction);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
Inventory clsInventory = new Inventory(base.Connection, base.Transaction);
InventoryDetails clsInventoryDetails;
ProductPackagePriceHistoryDetails clsProductPackagePriceHistoryDetails;
System.Data.DataTable dt = clsTransferInItem.ListAsDataTable(TransferInID, "TransferInItemID", SortOption.Ascending);
foreach(System.Data.DataRow dr in dt.Rows)
{
long lngProductID = long.Parse(dr["ProductID"].ToString());
int intProductUnitID = int.Parse(dr["ProductUnitID"].ToString());
decimal decItemQuantity = decimal.Parse(dr["Quantity"].ToString());
decimal decQuantity = new ProductUnit().GetBaseUnitValue(lngProductID, intProductUnitID, decItemQuantity);
long lngVariationMatrixID = long.Parse(dr["VariationMatrixID"].ToString());
string strMatrixDescription = "" + dr["MatrixDescription"].ToString();
string strProductCode = "" + dr["ProductCode"].ToString();
decimal decUnitCost = decimal.Parse(dr["UnitCost"].ToString());
decimal decItemCost = decimal.Parse(dr["Amount"].ToString());
decimal decSellingPrice = Convert.ToDecimal(dr["SellingPrice"]);
decimal decVAT = Convert.ToDecimal(dr["VAT"]); // myReader.GetDecimal("VAT");
decimal decEVAT = Convert.ToDecimal(dr["EVAT"]);
decimal decLocalTax = Convert.ToDecimal(dr["LocalTax"]);
/*******************************************
* Add in the Price History
* ****************************************/
// Update ProductPackagePriceHistory first to get the history
clsProductPackagePriceHistoryDetails = new ProductPackagePriceHistoryDetails();
clsProductPackagePriceHistoryDetails.UID = clsTransferInDetails.TransferrerID;
clsProductPackagePriceHistoryDetails.PackageID = new ProductPackage().GetPackageID(lngProductID, intProductUnitID);
clsProductPackagePriceHistoryDetails.ChangeDate = DateTime.Now;
clsProductPackagePriceHistoryDetails.PurchasePrice = (decItemQuantity * decUnitCost) / decQuantity;
clsProductPackagePriceHistoryDetails.Price = decSellingPrice;
clsProductPackagePriceHistoryDetails.VAT = decVAT;
clsProductPackagePriceHistoryDetails.EVAT = decEVAT;
clsProductPackagePriceHistoryDetails.LocalTax = decLocalTax;
clsProductPackagePriceHistoryDetails.Remarks = "Based on TransferIn #: " + clsTransferInDetails.TransferInNo;
ProductPackagePriceHistory clsProductPackagePriceHistory = new ProductPackagePriceHistory(base.Connection, base.Transaction);
clsProductPackagePriceHistory.Insert(clsProductPackagePriceHistoryDetails);
/*******************************************
* Add to Inventory
* ****************************************/
//clsProduct.AddQuantity(lngProductID, decQuantity);
//if (lngVariationMatrixID != 0)
//{
// clsProductVariationsMatrix.AddQuantity(lngVariationMatrixID, decQuantity);
//}
// July 26, 2011: change the above codes to the following
clsProduct.AddQuantity(clsTransferInDetails.BranchID, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_TRANSFER_IN), DateTime.Now, clsTransferInDetails.TransferInNo, clsTransferInDetails.TransferrerName);
/*******************************************
* Update Purchasing Information
* ****************************************/
int iBaseUnitID = clsProduct.get_BaseUnitID(lngProductID);
if (iBaseUnitID != intProductUnitID)
{
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsTransferInDetails.SupplierID, iBaseUnitID, (decItemQuantity * decUnitCost) / decQuantity);
}
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsTransferInDetails.SupplierID, intProductUnitID, decUnitCost);
/*******************************************
* Add to Inventory Analysis
* ****************************************/
clsInventoryDetails = new InventoryDetails();
clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom;
clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo;
clsInventoryDetails.PostingDate = clsTransferInDetails.DeliveryDate;
clsInventoryDetails.ReferenceNo = clsTransferInDetails.TransferInNo;
clsInventoryDetails.ContactID = clsTransferInDetails.SupplierID;
clsInventoryDetails.ContactCode = clsTransferInDetails.SupplierCode;
clsInventoryDetails.ProductID = lngProductID;
clsInventoryDetails.ProductCode = strProductCode;
clsInventoryDetails.VariationMatrixID = lngVariationMatrixID;
clsInventoryDetails.MatrixDescription = strMatrixDescription;
clsInventoryDetails.TransferInQuantity = decQuantity;
clsInventoryDetails.TransferInCost = decItemCost - decVAT;
clsInventoryDetails.TransferInVAT = decItemCost; // TransferIn Cost with VAT
clsInventory.Insert(clsInventoryDetails);
/*******************************************
* Added April 28, 2010 4:20PM
* Update Selling Information when TransferIn is posted
* ****************************************/
clsProduct.UpdateSellingPrice(lngProductID, lngVariationMatrixID, clsTransferInDetails.SupplierID, intProductUnitID, decimal.Parse(dr["SellingPrice"].ToString()), -1, -1, -1, -1, -1);
//if (lngVariationMatrixID != 0)
//{
// clsProductVariationsMatrix.UpdateSellingWithSameQuantityAndUnit(lngVariationMatrixID, clsPODetails.SupplierID, intProductUnitID, decimal.Parse(myReader["SellingPrice");
//}
/*******************************************
* Added April 28, 2010 4:20PM
* Update the purchase price history to check who has the lowest price.
* ****************************************/
ProductPurchasePriceHistoryDetails clsProductPurchasePriceHistoryDetails = new ProductPurchasePriceHistoryDetails();
clsProductPurchasePriceHistoryDetails.ProductID = lngProductID;
clsProductPurchasePriceHistoryDetails.MatrixID = lngVariationMatrixID;
clsProductPurchasePriceHistoryDetails.SupplierID = clsTransferInDetails.SupplierID;
clsProductPurchasePriceHistoryDetails.PurchasePrice = decUnitCost;
clsProductPurchasePriceHistoryDetails.PurchaseDate = clsTransferInDetails.TransferInDate;
clsProductPurchasePriceHistoryDetails.Remarks = clsTransferInDetails.TransferInNo;
ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(base.Connection, base.Transaction);
clsProductPurchasePriceHistory.AddToList(clsProductPurchasePriceHistoryDetails);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void LoadItems()
{
DataClass clsDataClass = new DataClass();
TransferInItem clsTransferInItem = new TransferInItem();
lstItem.DataSource = clsTransferInItem.ListAsDataTable(Convert.ToInt64(lblTransferInID.Text)).DefaultView;
lstItem.DataBind();
clsTransferInItem.CommitAndDispose();
lstItemFixCssClass();
}
private void UpdateAccounts(long TransferInID)
{
try
{
TransferInDetails clsTransferInDetails = Details(TransferInID);
ChartOfAccounts clsChartOfAccount = new ChartOfAccounts(base.Connection, base.Transaction);
// update ChartOfAccountIDAPTracking as credit
clsChartOfAccount.UpdateCredit(clsTransferInDetails.ChartOfAccountIDAPTracking, clsTransferInDetails.SubTotal);
// update Deposit & APContra
clsChartOfAccount.UpdateCredit(clsTransferInDetails.ChartOfAccountIDAPContra, clsTransferInDetails.Discount);
// update Freight & APTracking
clsChartOfAccount.UpdateCredit(clsTransferInDetails.ChartOfAccountIDAPTracking, clsTransferInDetails.Freight);
clsChartOfAccount.UpdateDebit(clsTransferInDetails.ChartOfAccountIDAPFreight, clsTransferInDetails.Freight);
// update Deposit & APTracking
clsChartOfAccount.UpdateCredit(clsTransferInDetails.ChartOfAccountIDAPTracking, clsTransferInDetails.Deposit);
clsChartOfAccount.UpdateDebit(clsTransferInDetails.ChartOfAccountIDAPVDeposit, clsTransferInDetails.Deposit);
TransferInItem clsTransferInItem = new TransferInItem();
System.Data.DataTable dt = clsTransferInItem.ListAsDataTable(TransferInID, "TransferInItemID", SortOption.Ascending);
foreach (System.Data.DataRow dr in dt.Rows)
{
int iChartOfAccountIDTransferIn = Int16.Parse(dr["ChartOfAccountIDTransferIn"].ToString());
int iChartOfAccountIDTaxTransferIn = Int16.Parse(dr["ChartOfAccountIDTaxTransferIn"].ToString());
decimal decVAT = decimal.Parse(dr["VAT"].ToString());
decimal decVATABLEAmount = decimal.Parse(dr["Amount"].ToString()) - decVAT;
// update purchase as debit
clsChartOfAccount.UpdateDebit(iChartOfAccountIDTransferIn, decVATABLEAmount);
// update tax as debit
clsChartOfAccount.UpdateDebit(iChartOfAccountIDTaxTransferIn, decVAT);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}