private void LoadList()
{
string SortField = "PackageID";
if (Request.QueryString["sortfield"]!=null)
{ SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); }
SortOption SortOrder = SortOption.Ascending;
if (Request.QueryString["sortoption"]!=null)
{ SortOrder = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }
ProductPackage clsProductPackage = new ProductPackage();
System.Data.DataTable dt = clsProductPackage.ListAsDataTable(Convert.ToInt64(lblProductID.Text), SortField: SortField, SortOrder: SortOrder);
clsProductPackage.CommitAndDispose();
PageData.DataSource = dt.DefaultView;
int iPageSize = Convert.ToInt16(Session["PageSize"]) ;
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i=0; i < PageData.PageCount;i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{ cboCurrentPage.Items[i].Selected = true;}
else
{ cboCurrentPage.Items[i].Selected = false;}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
int intProductBaseUnitID = 0;
decimal decCommision = 0;
lblProductSubGroupID.Text = "0";
if (cboProductCode.SelectedItem.Value != Constants.ZERO_STRING)
{
Products clsProduct = new Products();
try
{
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(cboProductCode.SelectedValue));
intProductBaseUnitID = clsDetails.BaseUnitID; decCommision = clsDetails.PercentageCommision;
lblProductSubGroupID.Text = clsDetails.ProductSubGroupID.ToString();
}
catch { }
txtProductCode.ToolTip = intProductBaseUnitID.ToString();
lblProductID.ToolTip = decCommision.ToString();
long ProductID = Convert.ToInt64(cboProductCode.SelectedValue);
ProductPackage clsProductPackage = new ProductPackage(clsProduct.Connection, clsProduct.Transaction);
lstProductPackages.DataSource = clsProductPackage.ListAsDataTable(Convert.ToInt64(cboProductCode.SelectedValue)).DefaultView;
lstProductPackages.DataBind();
ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(clsProduct.Connection, clsProduct.Transaction);
System.Data.DataTable dtProductPurchasePriceHistory = clsProductPurchasePriceHistory.ListAsDataTable(Convert.ToInt64(cboProductCode.SelectedValue), DateTime.Now.AddMonths(-6), "PurchasePrice", SortOption.Ascending);
clsProduct.CommitAndDispose();
string strPurchasePriceHistory = string.Empty;
foreach (System.Data.DataRow dr in dtProductPurchasePriceHistory.Rows)
{
DateTime dtePurchaseDate = DateTime.Parse(dr["PurchaseDate"].ToString());
decimal decPurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString());
string strSupplierName = "" + dr["PurchaserName"].ToString();
string strPurchaserName = "" + dr["SupplierName"].ToString();
strPurchasePriceHistory += dtePurchaseDate.ToString("ddMMMyyyy HH:mm") + ": " + strPurchaserName.PadRight(50) + " - " + decPurchasePrice.ToString("#,##0.#0").PadLeft(10) + " " + strSupplierName + "\r\n<br />" + Environment.NewLine;
}
lblPurchasePriceHistory.Text = "<br /><b>PURCHASE PRICE HISTORY: </b><br /><br />" + strPurchasePriceHistory;
lblProductPackage.Visible = true;
lnkProductPackageAdd.Visible = true;
lstProductPackages.Visible = true;
imgProductHistory.Visible = true;
imgProductPriceHistory.Visible = true;
imgInventoryAdjustment.Visible = true;
imgEditNow.Visible = true;
lnkPackage.Visible = true;
imgVariationsMatrix.Visible = true;
imgUnitsMatrix.Visible = true;
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(cboProductCode.SelectedValue, Session.SessionID);
lnkPackage.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Package/Default.aspx" + stParam;
lnkProductPackageAdd.ToolTip = "Add new package for " + cboProductCode.SelectedItem.Text;
lnkProductPackageAdd.NavigateUrl = "_Package/Default.aspx?task=" + Common.Encrypt("add", Session.SessionID) + "&prodid=" + Common.Encrypt(cboProductCode.SelectedValue, Session.SessionID) + "&productcode=" + Common.Encrypt(cboProductCode.SelectedItem.Text, Session.SessionID);
txtProductCode.Text = cboProductCode.SelectedItem.Text;
lblPurchasePriceHistory.Visible = true;
}
else if (cboProductCode.SelectedItem.Text == Constants.ZERO_STRING)
{
lblProductPackage.Visible = false;
lnkProductPackageAdd.Visible = false;
lstProductPackages.Visible = false;
imgProductHistory.Visible = false;
imgProductPriceHistory.Visible = false;
imgInventoryAdjustment.Visible = false;
imgEditNow.Visible = false;
lnkPackage.Visible = false;
imgVariationsMatrix.Visible = false;
imgUnitsMatrix.Visible = false;
lblPurchasePriceHistory.Visible = false;
txtProductCode.ToolTip = intProductBaseUnitID.ToString();
lblProductID.ToolTip = decCommision.ToString();
}
}
protected void cboProductUnit_SelectedIndexChanged(object sender, EventArgs e)
{
ProductPackage clsProductPackage = new ProductPackage();
ProductPackageDetails clsDetails = clsProductPackage.DetailsByProductIDAndUnitID(long.Parse(cboProductCode.SelectedValue), long.Parse(cboProductUnit.SelectedValue));
if (clsDetails.PackageID == 0)
{
ProductUnit clsProductUnit = new ProductUnit(clsProductPackage.Connection, clsProductPackage.Transaction);
Products clsProduct = new Products(clsProductPackage.Connection, clsProductPackage.Transaction);
ProductDetails clsProductDetails = clsProduct.Details(long.Parse(cboProductCode.SelectedItem.Value));
decimal decBaseUnitValue = clsProductUnit.GetBaseUnitValue(long.Parse(cboProductCode.SelectedItem.Value), int.Parse(cboProductUnit.SelectedItem.Value), 1);
clsDetails.Price = decBaseUnitValue * clsProductDetails.Price;
clsDetails.PurchasePrice = decBaseUnitValue * clsProductDetails.PurchasePrice;
}
clsProductPackage.CommitAndDispose();
txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.##0");
}
private void LoadItemData()
{
try
{
DataClass clsData = new DataClass();
ProductPackage clsProductPackage = new ProductPackage();
System.Data.DataTable dt = clsData.DataReaderToDataTable(clsProductPackage.List(mDetails.ProductID, "ProductDesc", SortOption.Ascending));
clsProductPackage.CommitAndDispose();
lstItems.Items.Clear(); int iImgCtr = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (mboIsPriceInq)
lstItems.Items.Add(dr["PackageID"].ToString(), "[" + dr["Price"].ToString() + "]" + Environment.NewLine + dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["ProductDesc"].ToString(), iImgCtr);
else
lstItems.Items.Add(dr["PackageID"].ToString(), dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["ProductDesc"].ToString(), iImgCtr);
if (iImgCtr == 7) iImgCtr = 0; else iImgCtr++;
}
try { lstItems.Items[0].Selected = true; }
catch { }
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
private void SubtractItemToInventory(long SOID)
{
SODetails clsSODetails = Details(SOID);
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
SOItem clsSOItem = new SOItem(base.Connection, base.Transaction);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
Products clsProduct = new Products(base.Connection, base.Transaction);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
Inventory clsInventory = new Inventory(base.Connection, base.Transaction);
InventoryDetails clsInventoryDetails;
//MatrixPackagePriceHistoryDetails clsMatrixPackagePriceHistoryDetails;
//ProductPackagePriceHistoryDetails clsProductPackagePriceHistoryDetails;
System.Data.DataTable dt = clsSOItem.ListAsDataTable(SOID, "SOItemID", 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 = clsProductUnit.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 decVAT = decimal.Parse(dr["VAT"].ToString());
///*******************************************
// * Add in the Sales Price History
// * ****************************************/
//if (lngVariationMatrixID != 0)
//{
// // Update MatrixPackagePriceHistory first to get the history
// clsMatrixPackagePriceHistoryDetails = new MatrixPackagePriceHistoryDetails();
// clsMatrixPackagePriceHistoryDetails.UID = clsSODetails.SellerID;
// clsMatrixPackagePriceHistoryDetails.PackageID = clsMatrixPackage.GetPackageID(lngVariationMatrixID, intProductUnitID);
// clsMatrixPackagePriceHistoryDetails.ChangeDate = DateTime.Now;
// clsMatrixPackagePriceHistoryDetails.Price = decUnitCost;
// clsMatrixPackagePriceHistoryDetails.PurchasePrice = -1; //-1 = nochange
// clsMatrixPackagePriceHistoryDetails.VAT = -1; //-1 = nochange
// clsMatrixPackagePriceHistoryDetails.EVAT = -1; //-1 = nochange
// clsMatrixPackagePriceHistoryDetails.LocalTax = -1; //-1 = nochange
// clsMatrixPackagePriceHistoryDetails.Remarks = "Based on SO #: " + clsSODetails.SONo;
// MatrixPackagePriceHistory clsMatrixPackagePriceHistory = new MatrixPackagePriceHistory(base.Connection, base.Transaction);
// clsMatrixPackagePriceHistory.Insert(clsMatrixPackagePriceHistoryDetails);
//}
//else
//{
// // Update ProductPackagePriceHistory first to get the history
// clsProductPackagePriceHistoryDetails = new ProductPackagePriceHistoryDetails();
// clsProductPackagePriceHistoryDetails.UID = clsSODetails.SellerID;
// clsProductPackagePriceHistoryDetails.PackageID = clsProductPackage.GetPackageID(lngProductID, intProductUnitID);
// clsProductPackagePriceHistoryDetails.ChangeDate = DateTime.Now;
// clsProductPackagePriceHistoryDetails.Price = decUnitCost;
// clsProductPackagePriceHistoryDetails.PurchasePrice = -1; //-1 = nochange
// clsProductPackagePriceHistoryDetails.VAT = -1; //-1 = nochange
// clsProductPackagePriceHistoryDetails.EVAT = -1; //-1 = nochange
// clsProductPackagePriceHistoryDetails.LocalTax = -1; //-1 = nochange
// clsProductPackagePriceHistoryDetails.Remarks = "Based on SO #: " + clsSODetails.SONo;
// ProductPackagePriceHistory clsProductPackagePriceHistory = new ProductPackagePriceHistory(base.Connection, base.Transaction);
// clsProductPackagePriceHistory.Insert(clsProductPackagePriceHistoryDetails);
//}
/*******************************************
* Subtract to Inventory
* ****************************************/
// clsProduct.SubtractQuantity(lngProductID, decQuantity);
// if (lngVariationMatrixID != 0) { clsProductVariationsMatrix.SubtractQuantity(lngVariationMatrixID, decQuantity); }
// July 28, 2011: change the above codes to the following
clsProduct.SubtractQuantity(clsSODetails.BranchID, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_SOLD_WHOLESALE), DateTime.Now, clsSODetails.SONo, clsSODetails.SellerName);
/*******************************************
* Update Selling Information
* ****************************************/
int iBaseUnitID = clsProduct.get_BaseUnitID(lngProductID);
if (iBaseUnitID != intProductUnitID)
{
clsProduct.UpdateSellingPrice(lngProductID, lngVariationMatrixID, clsSODetails.CustomerID, intProductUnitID, (decItemQuantity * decUnitCost) / decQuantity, -1, -1, -1,- 1, -1); // Price should be the sugegsted selling price
}
clsProduct.UpdateSellingWSPrice(lngProductID, lngVariationMatrixID, clsSODetails.CustomerID, intProductUnitID, decUnitCost); // WS Price should be the unit cost
/*******************************************
* Add to Inventory Analysis
* ****************************************/
clsInventoryDetails = new InventoryDetails();
clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom;
clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo;
clsInventoryDetails.PostingDate = clsSODetails.DeliveryDate;
clsInventoryDetails.ReferenceNo = clsSODetails.SONo;
clsInventoryDetails.ContactID = clsSODetails.CustomerID;
clsInventoryDetails.ContactCode = clsSODetails.CustomerCode;
clsInventoryDetails.ProductID = lngProductID;
clsInventoryDetails.ProductCode = strProductCode;
clsInventoryDetails.VariationMatrixID = lngVariationMatrixID;
clsInventoryDetails.MatrixDescription = strMatrixDescription;
clsInventoryDetails.SoldQuantity = decQuantity;
clsInventoryDetails.SoldCost = decItemCost - decVAT;
clsInventoryDetails.SoldVAT = decItemCost; // Sales Cost with VAT
clsInventory.Insert(clsInventoryDetails);
}
}
private void AddItemToInventory(long pvtDebitMemoID)
{
DebitMemoDetails clsDebitMemoDetails = Details(pvtDebitMemoID);
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
DebitMemoItems clsDebitMemoItems = new DebitMemoItems(base.Connection, base.Transaction);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
ProductDetails clsProductDetails = new ProductDetails();
Products clsProduct = new Products(base.Connection, base.Transaction);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
Inventory clsInventory = new Inventory(base.Connection, base.Transaction);
ProductPackagePriceHistoryDetails clsProductPackagePriceHistoryDetails;
ProductPackagePriceHistory clsProductPackagePriceHistory = new ProductPackagePriceHistory(base.Connection, base.Transaction);
System.Data.DataTable dt = clsDebitMemoItems.ListAsDataTable(pvtDebitMemoID, SortField: "DebitMemoItemID", SortOrder: SortOption.Ascending);
foreach (System.Data.DataRow dr in dt.Rows)
{
long lngProductID = Convert.ToInt64(dr["ProductID"]);
int intProductUnitID = Convert.ToInt16(dr["ProductUnitID"]);
decimal decItemQuantity = Convert.ToDecimal(dr["Quantity"]);
decimal decQuantity = clsProductUnit.GetBaseUnitValue(lngProductID, intProductUnitID, decItemQuantity);
long lngVariationMatrixID = Convert.ToInt64(dr["VariationMatrixID"]);
string strMatrixDescription = dr["MatrixDescription"].ToString();
string strProductCode = dr["ProductCode"].ToString();
string strProductUnitCode = dr["ProductUnitCode"].ToString();
decimal decNewUnitCost = Convert.ToDecimal(dr["UnitCost"]);
decimal decAmount = Convert.ToDecimal(dr["Amount"]);
//decimal decSellingPrice = Convert.ToDecimal(dr["SellingPrice"]);
decimal decVAT = Convert.ToDecimal(dr["VAT"]);
//decimal decEVAT = Convert.ToDecimal(dr["EVAT"]);
//decimal decLocalTax = Convert.ToDecimal(dr["LocalTax"]);
clsProductDetails = clsProduct.Details1(clsDebitMemoDetails.BranchID, lngProductID);
/*******************************************
* Add in the Purchase Price History based on Debit Memo
* ****************************************/
// Update ProductPackagePriceHistory first to get the history
clsProductPackagePriceHistoryDetails = new ProductPackagePriceHistoryDetails();
clsProductPackagePriceHistoryDetails.UID = clsDebitMemoDetails.PurchaserID;
clsProductPackagePriceHistoryDetails.PackageID = clsProductPackage.GetPackageID(lngProductID, intProductUnitID);
clsProductPackagePriceHistoryDetails.ChangeDate = DateTime.Now;
clsProductPackagePriceHistoryDetails.PurchasePrice = decNewUnitCost * (decItemQuantity / decQuantity);
clsProductPackagePriceHistoryDetails.Price = -1;
clsProductPackagePriceHistoryDetails.VAT = -1;
clsProductPackagePriceHistoryDetails.EVAT = -1;
clsProductPackagePriceHistoryDetails.LocalTax = -1;
clsProductPackagePriceHistoryDetails.Remarks = "Based on DebitMemo #: " + clsDebitMemoDetails.MemoNo;
clsProductPackagePriceHistory.Insert(clsProductPackagePriceHistoryDetails);
/*******************************************
* Subtract from Inventory : Remove this since this is a Debit Memo
* ****************************************/
//clsProduct.SubtractQuantity(lngProductID, decQuantity);
//if (lngVariationMatrixID != 0)
//{
// clsProductVariationsMatrix.SubtractQuantity(lngVariationMatrixID, decQuantity);
//}
/*******************************************
* Update Purchasing Information
* ****************************************/
int iBaseUnitID = clsProduct.get_BaseUnitID(lngProductID);
if (iBaseUnitID != intProductUnitID)
{
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsDebitMemoDetails.SupplierID, iBaseUnitID, (decItemQuantity * decNewUnitCost) / decQuantity);
}
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsDebitMemoDetails.SupplierID, intProductUnitID, decNewUnitCost);
/*******************************************
* Add to Inventory Analysis
* ****************************************/
InventoryDetails clsInventoryDetails = new InventoryDetails();
clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom;
clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo;
clsInventoryDetails.PostingDate = clsDebitMemoDetails.PostingDate;
clsInventoryDetails.ReferenceNo = clsDebitMemoDetails.MemoNo;
clsInventoryDetails.ContactID = clsDebitMemoDetails.SupplierID;
clsInventoryDetails.ContactCode = clsDebitMemoDetails.SupplierCode;
clsInventoryDetails.ProductID = lngProductID;
clsInventoryDetails.ProductCode = strProductCode;
clsInventoryDetails.VariationMatrixID = lngVariationMatrixID;
clsInventoryDetails.MatrixDescription = strMatrixDescription;
clsInventoryDetails.PDebitQuantity = decQuantity;
clsInventoryDetails.PDebitCost = decAmount - decVAT;
clsInventoryDetails.PDebitVAT = decAmount;
clsInventory.Insert(clsInventoryDetails);
}
}
public void UpdateSellingPrice(long ProductID, long MatrixID, long SupplierID, int BaseUnitID, decimal SellingPrice, decimal Price1, decimal Price2, decimal Price3, decimal Price4, decimal Price5)
{
try
{
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.UpdateSelling(ProductID, MatrixID, BaseUnitID, 1, SellingPrice, Price1, Price2, Price3, Price4, Price5);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void AddItemToInventory(long POID)
{
PODetails clsPODetails = Details(POID);
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
POItem clsPOItem = new POItem(base.Connection, base.Transaction);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
Products clsProduct = new Products(base.Connection, base.Transaction);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
Inventory clsInventory = new Inventory(base.Connection, base.Transaction);
InventoryDetails clsInventoryDetails;
ProductPackagePriceHistoryDetails clsProductPackagePriceHistoryDetails;
//MySqlDataReader myReader = clsPOItem.List(POID, "POItemID", SortOption.Ascending);
System.Data.DataTable dt = clsPOItem.ListAsDataTable(POID, "POItemID", SortOption.Ascending);
//while (myReader.Read())
foreach (System.Data.DataRow dr in dt.Rows)
{
long lngProductID = Convert.ToInt64(dr["ProductID"]);
int intProductUnitID = Convert.ToInt16(dr["ProductUnitID"]);
decimal decItemQuantity = Convert.ToDecimal(dr["Quantity"]);
decimal decQuantity = clsProductUnit.GetBaseUnitValue(lngProductID, intProductUnitID, decItemQuantity);
long lngVariationMatrixID = Convert.ToInt64(dr["VariationMatrixID"]);
string strMatrixDescription = dr["MatrixDescription"].ToString();
string strProductCode = dr["ProductCode"].ToString();
string strProductUnitCode = dr["ProductUnitCode"].ToString();
decimal decUnitCost = Convert.ToDecimal(dr["UnitCost"]);
decimal decItemCost = Convert.ToDecimal(dr["Amount"]);
decimal decSellingPrice = Convert.ToDecimal(dr["SellingPrice"]);
decimal decVAT = Convert.ToDecimal(dr["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 = clsPODetails.PurchaserID;
clsProductPackagePriceHistoryDetails.PackageID = clsProductPackage.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 PO #: " + clsPODetails.PONo;
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(clsPODetails.BranchID, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_PURCHASE) + " @ " + decUnitCost.ToString("#,##0.#0") + "/" + strProductUnitCode, DateTime.Now, clsPODetails.PONo, clsPODetails.PurchaserName);
/*******************************************
* Update Purchasing Information
*
* 30May2013 Include variation in the package.
* ****************************************/
int iBaseUnitID = clsProduct.get_BaseUnitID(lngProductID);
if (iBaseUnitID != intProductUnitID)
{
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsPODetails.SupplierID, iBaseUnitID, (decItemQuantity * decUnitCost) / decQuantity);
}
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsPODetails.SupplierID, intProductUnitID, decUnitCost);
/*******************************************
* Add to Inventory Analysis
* ****************************************/
clsInventoryDetails = new InventoryDetails();
clsInventoryDetails.BranchID = clsPODetails.BranchID;
clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom;
clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo;
clsInventoryDetails.PostingDate = clsPODetails.DeliveryDate;
clsInventoryDetails.ReferenceNo = clsPODetails.PONo;
clsInventoryDetails.ContactID = clsPODetails.SupplierID;
clsInventoryDetails.ContactCode = clsPODetails.SupplierCode;
clsInventoryDetails.ProductID = lngProductID;
clsInventoryDetails.ProductCode = strProductCode;
clsInventoryDetails.VariationMatrixID = lngVariationMatrixID;
clsInventoryDetails.MatrixDescription = strMatrixDescription;
clsInventoryDetails.PurchaseQuantity = decQuantity;
clsInventoryDetails.PurchaseCost = decItemCost - decVAT;
clsInventoryDetails.PurchaseVAT = decItemCost; // Purchase Cost with VAT
clsInventory.Insert(clsInventoryDetails);
/*******************************************
* Added Jan 1, 2010 4:20PM
* Update Selling Information when PO is posted
* ****************************************/
clsProduct.UpdateSellingPrice(lngProductID, lngVariationMatrixID, clsPODetails.SupplierID, intProductUnitID, Convert.ToDecimal(dr["SellingPrice"]), -1, -1, -1, -1, -1);
/*******************************************
* Added Mar 8, 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 = clsPODetails.SupplierID;
clsProductPurchasePriceHistoryDetails.PurchasePrice = decUnitCost;
clsProductPurchasePriceHistoryDetails.PurchaseDate = clsPODetails.PODate;
clsProductPurchasePriceHistoryDetails.Remarks = clsPODetails.PONo;
clsProductPurchasePriceHistoryDetails.PurchaserName = clsPODetails.PurchaserName;
ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(base.Connection, base.Transaction);
clsProductPurchasePriceHistory.AddToList(clsProductPurchasePriceHistoryDetails);
}
//myReader.Close();
}
public void Update(ProductDetails Details)
{
try
{
if (IsExist(Details.ProductID, Details.BarCode, Details.BarCode2, Details.BarCode3))
{
throw new Exception("This product already exist, please check the barcode.");
}
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblProducts SET " +
"ProductCode = @ProductCode, " +
"ProductDesc = @ProductDesc, " +
"ProductSubGroupID = @ProductSubGroupID, " +
"BaseUnitID = @BaseUnitID, " +
"PercentageCommision = @PercentageCommision, " +
"IncludeInSubtotalDiscount = @IncludeInSubtotalDiscount, " +
"MinThreshold = @MinThreshold, " +
"MaxThreshold = @MaxThreshold, " +
"SupplierID = @SupplierID, " +
"IsItemSold = @IsItemSold, " +
"WillPrintProductComposition = @WillPrintProductComposition, " +
"RID = @RID, " +
"SequenceNo = @SequenceNo " +
"WHERE ProductID = @ProductID;";
cmd.Parameters.AddWithValue("ProductCode", Details.ProductCode);
cmd.Parameters.AddWithValue("ProductDesc", Details.ProductDesc);
cmd.Parameters.AddWithValue("ProductSubGroupID", Details.ProductSubGroupID);
cmd.Parameters.AddWithValue("BaseUnitID", Details.BaseUnitID);
cmd.Parameters.AddWithValue("PercentageCommision", Details.PercentageCommision);
cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount);
cmd.Parameters.AddWithValue("MinThreshold", Details.MinThreshold);
cmd.Parameters.AddWithValue("MaxThreshold", Details.MaxThreshold);
cmd.Parameters.AddWithValue("SupplierID", Details.SupplierID);
cmd.Parameters.AddWithValue("IsItemSold", Details.IsItemSold);
cmd.Parameters.AddWithValue("WillPrintProductComposition", Details.WillPrintProductComposition);
cmd.Parameters.AddWithValue("RID", Details.RID);
cmd.Parameters.AddWithValue("SequenceNo", Details.SequenceNo);
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
if (Details.Quantity > 0)
{
SQL = "UPDATE tblProducts SET Active = 1 WHERE ProductID = @ProductID AND Active = 0;";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
ProductPackageDetails clsDetails = new ProductPackageDetails();
clsDetails.ProductID = Details.ProductID;
clsDetails.Quantity = 1;
clsDetails.Price = Details.Price;
clsDetails.Price1 = Details.Price1;
clsDetails.Price2 = Details.Price2;
clsDetails.Price3 = Details.Price3;
clsDetails.Price4 = Details.Price4;
clsDetails.Price5 = Details.Price5;
clsDetails.WSPrice = Details.WSPrice;
clsDetails.PurchasePrice = Details.PurchasePrice;
clsDetails.VAT = Details.VAT;
clsDetails.EVAT = Details.EVAT;
clsDetails.LocalTax = Details.LocalTax;
clsDetails.UnitID = Details.BaseUnitID;
clsDetails.UnitCode = Details.BaseUnitCode;
clsDetails.UnitName = Details.BaseUnitName;
clsDetails.BarCode1 = Details.BarCode;
clsDetails.BarCode2 = Details.BarCode2;
clsDetails.BarCode3 = Details.BarCode3;
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.UpdateByProductIDUnitIDAndQuantity(clsDetails, Details.UpdatedBy, Details.UpdatedOn, "Edit product module.");
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void UpdatePurchasing(long ProductID, long MatrxID, long SupplierID, int BaseUnitID, decimal UnitCost)
{
try
{
string SQL = "UPDATE tblProducts SET " +
"SupplierID = @SupplierID " +
"WHERE ProductID = @ProductID " +
"AND BaseUnitID = @BaseUnitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@SupplierID", SupplierID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@BaseUnitID", BaseUnitID);
base.ExecuteNonQuery(cmd);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.UpdatePurchasing(ProductID, MatrxID, BaseUnitID, 1, UnitCost);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(ProductDetails Details)
{
try
{
if (IsExist(Details.ProductID, Details.BarCode, Details.BarCode2, Details.BarCode3))
{
throw new EntryPointNotFoundException("This product already exist, please check the barcode.");
}
string SQL = "INSERT INTO tblProducts (" +
"ProductCode, " +
"ProductDesc, " +
"ProductSubGroupID, " +
"BaseUnitID, " +
"DateCreated, " +
"PercentageCommision, " +
"IncludeInSubtotalDiscount, " +
"MinThreshold, " +
"MaxThreshold, " +
"SupplierID, " +
"IsItemSold, " +
"WillPrintProductComposition"+
") VALUES (" +
"@ProductCode, " +
"@ProductDesc, " +
"@ProductSubGroupID, " +
"@BaseUnitID, " +
"@DateCreated," +
"@PercentageCommision, " +
"@IncludeInSubtotalDiscount, " +
"@MinThreshold, " +
"@MaxThreshold, " +
"@SupplierID, " +
"@IsItemSold, " +
"@WillPrintProductComposition);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductCode = new MySqlParameter("@ProductCode",MySqlDbType.String);
prmProductCode.Value = Details.ProductCode;
cmd.Parameters.Add(prmProductCode);
MySqlParameter prmProductDesc = new MySqlParameter("@ProductDesc",MySqlDbType.String);
prmProductDesc.Value = Details.ProductDesc;
cmd.Parameters.Add(prmProductDesc);
MySqlParameter prmProductSubGroupID = new MySqlParameter("@ProductSubGroupID",MySqlDbType.Int64);
prmProductSubGroupID.Value = Details.ProductSubGroupID;
cmd.Parameters.Add(prmProductSubGroupID);
MySqlParameter prmBaseUnitID = new MySqlParameter("@BaseUnitID",MySqlDbType.String);
prmBaseUnitID.Value = Details.BaseUnitID;
cmd.Parameters.Add(prmBaseUnitID);
MySqlParameter prmDateCreated = new MySqlParameter("@DateCreated",MySqlDbType.DateTime);
prmDateCreated.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmDateCreated);
MySqlParameter prmPercentageCommision = new MySqlParameter("@PercentageCommision",MySqlDbType.Decimal);
prmPercentageCommision.Value = Details.PercentageCommision;
cmd.Parameters.Add(prmPercentageCommision);
MySqlParameter prmIncludeInSubtotalDiscount = new MySqlParameter("@IncludeInSubtotalDiscount",MySqlDbType.Int16);
prmIncludeInSubtotalDiscount.Value = Details.IncludeInSubtotalDiscount;
cmd.Parameters.Add(prmIncludeInSubtotalDiscount);
MySqlParameter prmMinThreshold = new MySqlParameter("@MinThreshold",MySqlDbType.Decimal);
prmMinThreshold.Value = Details.MinThreshold;
cmd.Parameters.Add(prmMinThreshold);
MySqlParameter prmMaxThreshold = new MySqlParameter("@MaxThreshold",MySqlDbType.Decimal);
prmMaxThreshold.Value = Details.MaxThreshold;
cmd.Parameters.Add(prmMaxThreshold);
MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64);
prmSupplierID.Value = Details.SupplierID;
cmd.Parameters.Add(prmSupplierID);
MySqlParameter prmIsItemSold = new MySqlParameter("@IsItemSold",MySqlDbType.Int16);
prmIsItemSold.Value = Convert.ToInt16(Details.IsItemSold);
cmd.Parameters.Add(prmIsItemSold);
MySqlParameter prmWillPrintProductComposition = new MySqlParameter("@WillPrintProductComposition",MySqlDbType.Int16);
prmWillPrintProductComposition.Value = Convert.ToInt16(Details.WillPrintProductComposition);
cmd.Parameters.Add(prmWillPrintProductComposition);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails();
clsProductPackageDetails.ProductID = iID;
clsProductPackageDetails.BarCode1 = Details.BarCode;
clsProductPackageDetails.BarCode2 = Details.BarCode2;
clsProductPackageDetails.BarCode3 = Details.BarCode3;
clsProductPackageDetails.UnitID = Details.BaseUnitID;
clsProductPackageDetails.Price = Details.Price;
clsProductPackageDetails.Price1 = Details.Price1;
clsProductPackageDetails.Price2 = Details.Price2;
clsProductPackageDetails.Price3 = Details.Price3;
clsProductPackageDetails.Price4 = Details.Price4;
clsProductPackageDetails.Price5 = Details.Price5;
clsProductPackageDetails.WSPrice = Details.WSPrice;
clsProductPackageDetails.PurchasePrice = Details.PurchasePrice;
clsProductPackageDetails.Quantity = 1;
clsProductPackageDetails.VAT = Details.VAT;
clsProductPackageDetails.EVAT = Details.EVAT;
clsProductPackageDetails.LocalTax = Details.LocalTax;
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.Insert(clsProductPackageDetails);
// Oct 28, 2011 : Lemu
// Added to cater branch inventory
//BranchInventory clsBranchInventory = new BranchInventory(base.Connection, base.Transaction);
//clsBranchInventory.CreateToAllBranches(iID);
//base.ExecuteNonQuery(cmd);
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
// Dec 10, 2011 : Obsolete, change to ChangeTax
//public void ChangeVAT(decimal OldVAT, decimal NewVAT)
//{
// try
// {
// string SQL = "UPDATE tblProducts SET " +
// "VAT = @NewVAT " +
// "WHERE VAT = @OldVAT;";
//
// MySqlCommand cmd = new MySqlCommand();
//
//
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmNewVAT = new MySqlParameter("@NewVAT",MySqlDbType.Decimal);
// prmNewVAT.Value = NewVAT;
// cmd.Parameters.Add(prmNewVAT);
// MySqlParameter prmOldVAT = new MySqlParameter("@OldVAT",MySqlDbType.Decimal);
// prmOldVAT.Value = OldVAT;
// cmd.Parameters.Add(prmOldVAT);
// base.ExecuteNonQuery(cmd);
// MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
// clsMatrixPackage.ChangeVAT(OldVAT, NewVAT);
// ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
// clsProductVariationsMatrix.ChangeVAT(OldVAT, NewVAT);
// ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
// clsProductPackage.ChangeVAT(OldVAT, NewVAT);
// }
// catch (Exception ex)
// {
//
//
// {
//
//
//
//
// }
// throw base.ThrowException(ex);
// }
//}
//// Dec 10, 2011 : Obsolete, change to ChangeTax
//public void ChangeEVAT(decimal OldEVAT, decimal NewEVAT)
//{
// try
// {
// string SQL = "UPDATE tblProducts SET " +
// "EVAT = @NewEVAT " +
// "WHERE EVAT = @OldEVAT;";
//
// MySqlCommand cmd = new MySqlCommand();
//
//
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmNewEVAT = new MySqlParameter("@NewEVAT",MySqlDbType.Decimal);
// prmNewEVAT.Value = NewEVAT;
// cmd.Parameters.Add(prmNewEVAT);
// MySqlParameter prmOldEVAT = new MySqlParameter("@OldEVAT",MySqlDbType.Decimal);
// prmOldEVAT.Value = OldEVAT;
// cmd.Parameters.Add(prmOldEVAT);
// base.ExecuteNonQuery(cmd);
// MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
// clsMatrixPackage.ChangeEVAT(OldEVAT, NewEVAT);
// ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
// clsProductVariationsMatrix.ChangeEVAT(OldEVAT, NewEVAT);
// ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
// clsProductPackage.ChangeEVAT(OldEVAT, NewEVAT);
// }
// catch (Exception ex)
// {
//
//
// {
//
//
//
//
// }
// throw base.ThrowException(ex);
// }
//}
//// Dec 10, 2011 : Obsolete, change to ChangeTax
//public void ChangeLocalTax(decimal OldLocalTax, decimal NewLocalTax)
//{
// try
// {
// string SQL = "UPDATE tblProducts SET " +
// "LocalTax = @NewLocalTax " +
// "WHERE LocalTax = @OldLocalTax;";
//
// MySqlCommand cmd = new MySqlCommand();
//
//
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmNewLocalTax = new MySqlParameter("@NewLocalTax",MySqlDbType.Decimal);
// prmNewLocalTax.Value = NewLocalTax;
// cmd.Parameters.Add(prmNewLocalTax);
// MySqlParameter prmOldLocalTax = new MySqlParameter("@OldLocalTax",MySqlDbType.Decimal);
// prmOldLocalTax.Value = OldLocalTax;
// cmd.Parameters.Add(prmOldLocalTax);
// base.ExecuteNonQuery(cmd);
// MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
// clsMatrixPackage.ChangeLocalTax(OldLocalTax, NewLocalTax);
// ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
// clsProductVariationsMatrix.ChangeLocalTax(OldLocalTax, NewLocalTax);
// ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
// clsProductPackage.ChangeLocalTax(OldLocalTax, NewLocalTax);
// }
// catch (Exception ex)
// {
//
//
// {
//
//
//
//
// }
// throw base.ThrowException(ex);
// }
//}
/// <summary>
/// Update Products VAT, EVAT and LocalTax
/// This will also update ProductPackage, ProductVariationsMatrix and MatrixPackage
/// </summary>
/// <param name="ProductGroupID"></param>
/// <param name="ProductSubGroupID"></param>
/// <param name="ProductID"></param>
/// <param name="NewVAT"></param>
/// <param name="NewEVAT"></param>
/// <param name="NewLocalTax"></param>
public void ChangeTax(long ProductGroupID, long ProductSubGroupID, long ProductID, decimal NewVAT, decimal NewEVAT, decimal NewLocalTax, string CreatedBy)
{
try
{
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.ChangeTax(ProductGroupID, ProductSubGroupID, ProductID, NewVAT, NewEVAT, NewLocalTax, CreatedBy);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach(DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList");
if (chkList!=null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
ProductPackage clsProductPackage = new ProductPackage();
clsProductPackage.Delete(stIDs.Substring(0,stIDs.Length-1));
clsProductPackage.CommitAndDispose();
Security.AuditTrailDetails clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = Convert.ToString(Session["Name"]);
clsAuditDetails.IPAddress = Request.UserHostAddress;
clsAuditDetails.Activity = "Product Package";
clsAuditDetails.Remarks = "Delete Product Package(s). ProductID:'" + lblProductID.Text + "' IDs:'" + stIDs + "'";
Security.AuditTrail clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
clsAuditTrail.CommitAndDispose();
}
return boRetValue;
}
private void LoadRecord()
{
ProductPackage clsProductPackage = new ProductPackage();
ProductPackageDetails clsDetails = clsProductPackage.Details(Convert.ToInt64(lblPackageID.Text));
Products clsProduct = new Products(clsProductPackage.Connection, clsProductPackage.Transaction);
ProductDetails clsProductDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
ProductBaseVariationsMatrixDetails clsProductBaseVariationsMatrixDetails = new ProductBaseVariationsMatrix(clsProductPackage.Connection, clsProductPackage.Transaction).BaseDetails(clsDetails.MatrixID, clsDetails.ProductID);
clsProductPackage.CommitAndDispose();
lblProductSubGroupID.Text = clsProductDetails.ProductSubGroupID.ToString();
lblMatrixID.Text = clsDetails.MatrixID.ToString();
lblMatrixDescription.Text = clsDetails.MatrixID == 0 ? "" : "Base Matrix: " + clsProductBaseVariationsMatrixDetails.Description;
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsDetails.UnitID.ToString()));
txtProductPrice.Text = clsDetails.Price.ToString("#,##0.#0");
txtPrice1.Text = clsDetails.Price1.ToString("#,##0.#0");
txtPrice2.Text = clsDetails.Price2.ToString("#,##0.#0");
txtPrice3.Text = clsDetails.Price3.ToString("#,##0.#0");
txtPrice4.Text = clsDetails.Price4.ToString("#,##0.#0");
txtPrice5.Text = clsDetails.Price5.ToString("#,##0.#0");
txtWSPrice.Text = clsDetails.WSPrice.ToString("#,##0.#0");
txtPurchasePrice.Text = clsDetails.PurchasePrice.ToString("#,##0.#0");
decimal decMargin = clsDetails.Price - clsDetails.PurchasePrice;
try { decMargin = decMargin / clsDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
decMargin = clsDetails.WSPrice - clsDetails.PurchasePrice;
try { decMargin = decMargin / clsDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtWSPriceMarkUp.Text = decMargin.ToString("#,##0.##0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
txtQuantity.Text = clsDetails.Quantity.ToString("#,##0.#0");
txtBarCode1.Text = clsDetails.BarCode1;
txtBarCode2.Text = clsDetails.BarCode2;
txtBarCode3.Text = clsDetails.BarCode3;
if (clsDetails.Quantity == 1 && clsProductDetails.BaseUnitID == clsDetails.UnitID)
{
txtQuantity.Enabled = false; cboUnit.Enabled = false;
}
}
public void UpdateSellingWSPrice(long ProductID, long MatrixID, long SupplierID, int BaseUnitID, decimal WholesalePrice)
{
try
{
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.UpdateSellingWSPrice(ProductID, MatrixID, BaseUnitID, 1, WholesalePrice);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private bool SaveRecord()
{
long lngUID = long.Parse(Session["UID"].ToString());
DateTime dteChangeDate = DateTime.Now;
ProductPackage clsProductPackage = new ProductPackage();
ProductPackageDetails clsDetails = new ProductPackageDetails();
clsDetails.PackageID = Convert.ToInt64(lblPackageID.Text);
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.Price1 = Convert.ToDecimal(txtPrice1.Text);
clsDetails.Price2 = Convert.ToDecimal(txtPrice2.Text);
clsDetails.Price3 = Convert.ToDecimal(txtPrice3.Text);
clsDetails.Price4 = Convert.ToDecimal(txtPrice4.Text);
clsDetails.Price5 = Convert.ToDecimal(txtPrice5.Text);
clsDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.BarCode1 = txtBarCode1.Text;
clsDetails.BarCode2 = txtBarCode2.Text;
clsDetails.BarCode3 = txtBarCode3.Text;
clsProductPackage.Update(clsDetails, lngUID, dteChangeDate, "Product Package Update.");
clsProductPackage.CommitAndDispose();
return true;
}
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 bool SaveRecord()
{
ProductPackageDetails clsDetails = new ProductPackageDetails();
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.Price1 = Convert.ToDecimal(txtPrice1.Text);
clsDetails.Price2 = Convert.ToDecimal(txtPrice2.Text);
clsDetails.Price3 = Convert.ToDecimal(txtPrice3.Text);
clsDetails.Price4 = Convert.ToDecimal(txtPrice4.Text);
clsDetails.Price5 = Convert.ToDecimal(txtPrice5.Text);
clsDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.BarCode1 = txtBarCode1.Text;
clsDetails.BarCode2 = txtBarCode2.Text;
clsDetails.BarCode3 = txtBarCode3.Text;
ProductPackage clsProductPackage = new ProductPackage();
clsProductPackage.Insert(clsDetails);
clsProductPackage.CommitAndDispose();
return true;
}
public bool UpdateBaseVariation(ProductBaseVariationsMatrixDetails Details)
{
try
{
ProductBaseVariationsMatrix clsProductBaseVariationsMatrix = new ProductBaseVariationsMatrix(base.Connection, base.Transaction);
clsProductBaseVariationsMatrix.Update(Details);
ProductPackageDetails clsDetails = new ProductPackageDetails();
clsDetails.ProductID = Details.ProductID;
clsDetails.MatrixID = Details.MatrixID;
clsDetails.UnitID = Details.UnitID;
clsDetails.Price = Details.Price;
// 02Mar2015 : Added Price1...Price5
clsDetails.Price1 = Details.Price1;
clsDetails.Price2 = Details.Price2;
clsDetails.Price3 = Details.Price3;
clsDetails.Price4 = Details.Price4;
clsDetails.Price5 = Details.Price5;
clsDetails.WSPrice = Details.WSPrice;
clsDetails.PurchasePrice = Details.PurchasePrice;
clsDetails.Quantity = 1;
clsDetails.VAT = Details.VAT;
clsDetails.EVAT = Details.EVAT;
clsDetails.LocalTax = Details.LocalTax;
// 27May2014: Added barcode details
clsDetails.BarCode1 = Details.BarCode1;
clsDetails.BarCode2 = Details.BarCode2;
clsDetails.BarCode3 = Details.BarCode3;
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.Update(clsDetails, 0, DateTime.Now, "Update base variation");
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
protected void cboProductUnit_SelectedIndexChanged(object sender, EventArgs e)
{
ProductPackage clsProductPackage = new ProductPackage();
ProductPackageDetails clsDetails = clsProductPackage.DetailsByProductIDAndUnitID(long.Parse(cboProductCode.SelectedValue), long.Parse(cboProductUnit.SelectedValue));
if (clsDetails.PackageID == 0)
{
ProductUnit clsProductUnit = new ProductUnit(clsProductPackage.Connection, clsProductPackage.Transaction);
Products clsProduct = new Products(clsProductPackage.Connection, clsProductPackage.Transaction);
ProductDetails clsProductDetails = clsProduct.Details(long.Parse(cboProductCode.SelectedItem.Value));
decimal decBaseUnitValue = clsProductUnit.GetBaseUnitValue(long.Parse(cboProductCode.SelectedItem.Value), int.Parse(cboProductUnit.SelectedItem.Value), 1);
clsDetails.Price = decBaseUnitValue * clsProductDetails.Price;
clsDetails.PurchasePrice = decBaseUnitValue * clsProductDetails.PurchasePrice;
}
clsProductPackage.CommitAndDispose();
txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.##0");
txtSellingPrice.Text = clsDetails.Price.ToString("#####0.##0");
txtOldSellingPrice.Text = clsDetails.Price.ToString("#####0.##0");
decimal decMargin = clsDetails.Price - clsDetails.PurchasePrice;
try { decMargin = decMargin / clsDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.##0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.##0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.##0");
ComputeItemAmount();
lstItemFixCssClass();
}
/// <summary>
/// Aug 1, 2011 : Lemu
/// Include clsProduct.AddQuantity
/// </summary>
/// <param name="Details"></param>
/// <returns></returns>
public Int64 InsertBaseVariation(ProductBaseVariationsMatrixDetails Details)
{
try
{
ProductBaseVariationsMatrix clsProductBaseVariationsMatrix = new ProductBaseVariationsMatrix(base.Connection, base.Transaction);
clsProductBaseVariationsMatrix.Insert(Details);
string SQL = "SELECT LAST_INSERT_ID();";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = Int64.Parse(dt.Rows[0][0].ToString());
// 23May2013 Add n the product package
ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails();
clsProductPackageDetails.ProductID = Details.ProductID;
clsProductPackageDetails.MatrixID = iID;
clsProductPackageDetails.BarCode1 = Details.BarCode1;
clsProductPackageDetails.BarCode2 = Details.BarCode2;
clsProductPackageDetails.BarCode3 = Details.BarCode3;
clsProductPackageDetails.UnitID = Details.UnitID;
clsProductPackageDetails.Price = Details.Price;
clsProductPackageDetails.WSPrice = Details.WSPrice;
clsProductPackageDetails.PurchasePrice = Details.PurchasePrice;
clsProductPackageDetails.Quantity = 1;
clsProductPackageDetails.VAT = Details.VAT;
clsProductPackageDetails.EVAT = Details.EVAT;
clsProductPackageDetails.LocalTax = Details.LocalTax;
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.Insert(clsProductPackageDetails);
/************************
* 23May2013 Remove handling of inventory here
* Inventory should be added in the addquantity / subtractquantity
*
MatrixPackageDetails clsMatrixPackageDetails = new MatrixPackageDetails();
clsMatrixPackageDetails.MatrixID = iID;
clsMatrixPackageDetails.UnitID = Details.UnitID;
clsMatrixPackageDetails.Price = Details.Price;
clsMatrixPackageDetails.WSPrice = Details.WSPrice;
clsMatrixPackageDetails.PurchasePrice = Details.PurchasePrice;
clsMatrixPackageDetails.Quantity = 1;
clsMatrixPackageDetails.VAT = Details.VAT;
clsMatrixPackageDetails.EVAT = Details.EVAT;
clsMatrixPackageDetails.LocalTax = Details.LocalTax;
MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
clsMatrixPackage.Insert(clsMatrixPackageDetails);
// Oct 28, 2011 : Lemu
// Added to cater branch inventory
SQL = "CALL procProductBranchInventoryInsert(@lngProductID);";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@lngProductID", Details.ProductID);
base.ExecuteNonQuery(cmd);
// Oct 28, 2011 : change to procSyncProductVariationFromQuantityPerItem(lngProductID, intBranchID);
// ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
// decimal Quantity = clsProductUnit.GetBaseUnitValue(Details.ProductID, Details.UnitID, Details.Quantity);
// Product clsProduct = new Product(base.Connection, base.Transaction);
// clsProduct.AddQuantity(Constants.BRANCH_ID_MAIN, Details.ProductID, iID, Details.Quantity, Product.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_PRODUCT_VARIATION_CREATION), DateTime.Now, "SYS-ADDVAR" + DateTime.Now.ToString("yyyyMMddHHmmss"), Details.CreatedBy);
SQL = "CALL procSyncProductVariationFromQuantityPerItemAllBranch(@lngProductID);";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@lngProductID", Details.ProductID);
base.ExecuteNonQuery(cmd);
// Added August 2, 2009 to monitor if product still has/have variations
Products clsProduct = new Products(base.Connection, base.Transaction);
clsProduct.UpdateVariationCount(Details.ProductID);
*************************/
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private Int32 SaveRecord()
{
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsDetails = new ProductUnitsMatrixDetails();
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.BaseUnitID = Convert.ToInt32(lblBaseUnitID.Text);
clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text);
clsDetails.BottomUnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value);
clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text);
int id = clsUnitMatrix.Insert(clsDetails);
ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails();
ProductPackage clsProductPackage = new ProductPackage(clsUnitMatrix.Connection, clsUnitMatrix.Transaction);
clsProductPackageDetails = clsProductPackage.DetailsByProductIDAndUnitID(Convert.ToInt64(lblProductID.Text), Convert.ToInt32(cboBottomUnit.SelectedItem.Value));
if (clsProductPackageDetails.PackageID == 0)
{
Products clsProduct = new Products(clsUnitMatrix.Connection, clsUnitMatrix.Transaction);
ProductDetails clsProductDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
Terminal clsTerminal = new Terminal(clsUnitMatrix.Connection, clsUnitMatrix.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProductPackageDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsProductPackageDetails.UnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value);
clsProductPackageDetails.Price = clsProductDetails.Price * Convert.ToDecimal(txtBaseUnitValue.Text);
clsProductPackageDetails.WSPrice = clsProductDetails.WSPrice * Convert.ToDecimal(txtBaseUnitValue.Text);
clsProductPackageDetails.PurchasePrice = clsProductDetails.PurchasePrice * Convert.ToDecimal(txtBaseUnitValue.Text);
clsProductPackageDetails.Quantity = 1;
clsProductPackageDetails.VAT = clsTerminalDetails.VAT;
clsProductPackageDetails.EVAT = clsTerminalDetails.EVAT;
clsProductPackageDetails.LocalTax = clsTerminalDetails.LocalTax;
if (!string.IsNullOrEmpty(clsProductDetails.BarCode1)) clsProductPackageDetails.BarCode1 = clsProductDetails.BarCode1 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString();
if (!string.IsNullOrEmpty(clsProductDetails.BarCode2)) clsProductPackageDetails.BarCode2 = clsProductDetails.BarCode2 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString();
if (!string.IsNullOrEmpty(clsProductDetails.BarCode3)) clsProductPackageDetails.BarCode3 = clsProductDetails.BarCode3 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString();
clsProductPackage.Insert(clsProductPackageDetails);
}
clsUnitMatrix.CommitAndDispose();
return id;
}
protected void lstProductPackages_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
TextBox txtSellingPrice = (TextBox)e.Item.FindControl("txtSellingPrice");
TextBox txtBarCode1 = (TextBox)e.Item.FindControl("txtBarCode1");
TextBox txtBarCode2 = (TextBox)e.Item.FindControl("txtBarCode2");
TextBox txtBarCode3 = (TextBox)e.Item.FindControl("txtBarCode3");
switch (e.CommandName)
{
case "cmdDelProductPackage":
Label lblProductPackageID = (Label)e.Item.FindControl("lblProductPackageID");
ProductPackage clsProductPackage = new ProductPackage();
clsProductPackage.Delete(lblProductPackageID.Text);
clsProductPackage.CommitAndDispose();
cboProductCode_SelectedIndexChanged(null, null);
break;
case "cmdPrintShelvesBarCode1":
AceSoft.ThermalBarCodePrinter clsThermalBarCodePrinter1 = new ThermalBarCodePrinter();
clsThermalBarCodePrinter1.PrintShelvesTag(cboProductCode.SelectedItem.Text, txtBarCode1.Text, Convert.ToDecimal(txtSellingPrice.Text).ToString("#,##0.#0"));
break;
case "cmdPrintShelvesBarCode2":
AceSoft.ThermalBarCodePrinter clsThermalBarCodePrinter2 = new ThermalBarCodePrinter();
clsThermalBarCodePrinter2.PrintShelvesTag(cboProductCode.SelectedItem.Text, txtBarCode2.Text, Convert.ToDecimal(txtSellingPrice.Text).ToString("#,##0.#0"));
break;
case "cmdPrintShelvesBarCode3":
AceSoft.ThermalBarCodePrinter clsThermalBarCodePrinter3 = new ThermalBarCodePrinter();
clsThermalBarCodePrinter3.PrintShelvesTag(cboProductCode.SelectedItem.Text, txtBarCode3.Text, Convert.ToDecimal(txtSellingPrice.Text).ToString("#,##0.#0"));
break;
case "cmdPrintTagPriceBarCode1":
AceSoft.ThermalBarCodePrinter clsThermalBarCodeTagPrice1 = new ThermalBarCodePrinter();
clsThermalBarCodeTagPrice1.PrintTagPrice(cboProductCode.SelectedItem.Text, txtBarCode1.Text, Convert.ToDecimal(txtSellingPrice.Text).ToString("#,##0.#0"));
break;
case "cmdPrintTagPriceBarCode2":
AceSoft.ThermalBarCodePrinter clsThermalBarCodeTagPrice2 = new ThermalBarCodePrinter();
clsThermalBarCodeTagPrice2.PrintTagPrice(cboProductCode.SelectedItem.Text, txtBarCode2.Text, Convert.ToDecimal(txtSellingPrice.Text).ToString("#,##0.#0"));
break;
case "cmdPrintTagPriceBarCode3":
AceSoft.ThermalBarCodePrinter clsThermalBarCodeTagPrice3 = new ThermalBarCodePrinter();
clsThermalBarCodeTagPrice3.PrintTagPrice(cboProductCode.SelectedItem.Text, txtBarCode3.Text, Convert.ToDecimal(txtSellingPrice.Text).ToString("#,##0.#0"));
break;
// 02Mar2015 : Added to automatically generate Barcode
case "imgCreateBarCode1_Click":
txtBarCode1.Text = CreateBarCode();
break;
case "imgCreateBarCode2_Click":
txtBarCode2.Text = CreateBarCode();
break;
case "imgCreateBarCode3_Click":
txtBarCode3.Text = CreateBarCode();
break;
}
}
private void LoadItemData()
{
ProductPackage clsProductPackage = new ProductPackage();
try
{
DataClass clsData = new DataClass();
System.Data.DataTable dt = clsData.DataReaderToDataTable(clsProductPackage.List(mDetails.ProductID,"ProductDesc",SortOption.Ascending));
clsProductPackage.CommitAndDispose();
//dt.TableName = "tblProductPackage";
this.dgStyle.MappingName = dt.TableName;
dgItems.DataSource = dt;
dgItems.Select(0);
dgItems.CurrentRowIndex=0;
}
catch (Exception ex)
{
clsProductPackage.CommitAndDispose();
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
private void SaveRecord()
{
long lngUID = long.Parse(Session["UID"].ToString());
DateTime dteChangeDate = DateTime.Now;
ProductPackage clsProductPackage = new ProductPackage();
clsProductPackage.GetConnection();
bool boIsFirstRecord = true;
ProductPackageDetails clsProductPackageDetails;
foreach (DataListItem e in lstProductPackages.Items)
{
if (boIsFirstRecord == true)
{
TextBox txtCommision = (TextBox)e.FindControl("txtCommision");
Products clsProduct = new Products(clsProductPackage.Connection, clsProductPackage.Transaction);
clsProduct.UpdateCommision(long.Parse(cboProductCode.SelectedValue), Convert.ToDecimal(txtCommision.Text));
boIsFirstRecord = false;
}
HtmlInputCheckBox chkProductPackageID = (HtmlInputCheckBox)e.FindControl("chkProductPackageID");
TextBox txtBarCode1 = (TextBox)e.FindControl("txtBarCode1");
TextBox txtBarCode2 = (TextBox)e.FindControl("txtBarCode2");
TextBox txtBarCode3 = (TextBox)e.FindControl("txtBarCode3");
Label lblUnitName = (Label)e.FindControl("lblUnitName");
TextBox txtQuantity = (TextBox)e.FindControl("txtQuantity");
TextBox txtPurchasePrice = (TextBox)e.FindControl("txtPurchasePrice");
TextBox txtSellingPrice = (TextBox)e.FindControl("txtSellingPrice");
TextBox txtPrice1 = (TextBox)e.FindControl("txtPrice1");
TextBox txtPrice2 = (TextBox)e.FindControl("txtPrice2");
TextBox txtPrice3 = (TextBox)e.FindControl("txtPrice3");
TextBox txtPrice4 = (TextBox)e.FindControl("txtPrice4");
TextBox txtPrice5 = (TextBox)e.FindControl("txtPrice5");
TextBox txtWSPrice = (TextBox)e.FindControl("txtWSPrice");
Label lblVAT = (Label)e.FindControl("lblVAT");
Label lblEVAT = (Label)e.FindControl("lblEVAT");
Label lblLocalTax = (Label)e.FindControl("lblLocalTax");
clsProductPackageDetails = new ProductPackageDetails();
clsProductPackageDetails.PackageID = Convert.ToInt64(chkProductPackageID.Value);
clsProductPackageDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedValue);
clsProductPackageDetails.UnitID = Convert.ToInt32(lblUnitName.ToolTip);
clsProductPackageDetails.Price = Convert.ToDecimal(txtSellingPrice.Text);
clsProductPackageDetails.Price1 = Convert.ToDecimal(txtPrice1.Text);
clsProductPackageDetails.Price2 = Convert.ToDecimal(txtPrice2.Text);
clsProductPackageDetails.Price3 = Convert.ToDecimal(txtPrice3.Text);
clsProductPackageDetails.Price4 = Convert.ToDecimal(txtPrice4.Text);
clsProductPackageDetails.Price5 = Convert.ToDecimal(txtPrice5.Text);
clsProductPackageDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsProductPackageDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsProductPackageDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsProductPackageDetails.VAT = Convert.ToDecimal(lblVAT.Text);
clsProductPackageDetails.EVAT = Convert.ToDecimal(lblEVAT.Text);
clsProductPackageDetails.LocalTax = Convert.ToDecimal(lblLocalTax.Text);
clsProductPackageDetails.BarCode1 = txtBarCode1.Text;
clsProductPackageDetails.BarCode2 = txtBarCode2.Text;
clsProductPackageDetails.BarCode3 = txtBarCode3.Text;
clsProductPackage.Update(clsProductPackageDetails, lngUID, dteChangeDate, "Change price adjustment.");
}
clsProductPackage.CommitAndDispose();
}
private void SelectItem()
{
ListView.SelectedListViewItemCollection items = this.lstItems.SelectedItems;
foreach (ListViewItem item in items)
{ mDetails.ProductPackageID = Convert.ToInt64(item.SubItems[0].Name); break; }
ProductPackage clsProductPackage = new ProductPackage();
ProductPackageDetails clsDetails = clsProductPackage.Details(mDetails.ProductPackageID);
clsProductPackage.CommitAndDispose();
if (mDetails.ProductPackageID != 0)
{
mDetails.ProductUnitID = clsDetails.UnitID;
mDetails.ProductUnitCode = clsDetails.UnitCode;
mDetails.Price = clsDetails.Price;
mDetails.PackageQuantity = clsDetails.Quantity;
mDetails.VAT = clsDetails.VAT;
mDetails.LocalTax = clsDetails.LocalTax;
mDetails.Amount = (mDetails.Quantity * mDetails.Price) - (mDetails.Quantity * mDetails.Discount);
mDetails.PurchasePrice = clsDetails.PurchasePrice;
mDetails.Amount = mDetails.Quantity * mDetails.PurchasePrice;
}
dialog = DialogResult.OK;
this.Hide();
}
private void SubtractItemFromInventory(long TransferOutID)
{
TransferOutDetails clsTransferOutDetails = Details(TransferOutID);
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
TransferOutItem clsTransferOutItem = new TransferOutItem(base.Connection, base.Transaction);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
Products clsProduct = new Products(base.Connection, base.Transaction);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
Inventory clsInventory = new Inventory(base.Connection, base.Transaction);
InventoryDetails clsInventoryDetails;
//MatrixPackagePriceHistoryDetails clsMatrixPackagePriceHistoryDetails;
//ProductPackagePriceHistoryDetails clsProductPackagePriceHistoryDetails;
System.Data.DataTable dt = clsTransferOutItem.ListAsDataTable(TransferOutID, "TransferOutItemID", 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 = clsProductUnit.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 decVAT = decimal.Parse(dr["VAT"].ToString());
///*******************************************
// * Add in the Purchase Price History
// * ****************************************/
//if (lngVariationMatrixID != 0)
//{
// // Update MatrixPackagePriceHistory first to get the history
// clsMatrixPackagePriceHistoryDetails = new MatrixPackagePriceHistoryDetails();
// clsMatrixPackagePriceHistoryDetails.UID = clsTransferOutDetails.TransferrerID;
// clsMatrixPackagePriceHistoryDetails.PackageID = clsMatrixPackage.GetPackageID(lngVariationMatrixID, intProductUnitID);
// clsMatrixPackagePriceHistoryDetails.ChangeDate = DateTime.Now;
// clsMatrixPackagePriceHistoryDetails.PurchasePrice = (decItemQuantity * decUnitCost) / decQuantity;
// clsMatrixPackagePriceHistoryDetails.Price = -1;
// clsMatrixPackagePriceHistoryDetails.VAT = -1;
// clsMatrixPackagePriceHistoryDetails.EVAT = -1;
// clsMatrixPackagePriceHistoryDetails.LocalTax = -1;
// clsMatrixPackagePriceHistoryDetails.Remarks = "Based on TransferOut #: " + clsTransferOutDetails.TransferOutNo;
// MatrixPackagePriceHistory clsMatrixPackagePriceHistory = new MatrixPackagePriceHistory(base.Connection, base.Transaction);
// clsMatrixPackagePriceHistory.Insert(clsMatrixPackagePriceHistoryDetails);
//}
//else
//{
// // Update ProductPackagePriceHistory first to get the history
// clsProductPackagePriceHistoryDetails = new ProductPackagePriceHistoryDetails();
// clsProductPackagePriceHistoryDetails.UID = clsTransferOutDetails.TransferrerID;
// clsProductPackagePriceHistoryDetails.PackageID = clsProductPackage.GetPackageID(lngProductID, intProductUnitID);
// clsProductPackagePriceHistoryDetails.ChangeDate = DateTime.Now;
// clsProductPackagePriceHistoryDetails.PurchasePrice = (decItemQuantity * decUnitCost) / decQuantity;
// clsProductPackagePriceHistoryDetails.Price = -1;
// clsProductPackagePriceHistoryDetails.VAT = -1;
// clsProductPackagePriceHistoryDetails.EVAT = -1;
// clsProductPackagePriceHistoryDetails.LocalTax = -1;
// clsProductPackagePriceHistoryDetails.Remarks = "Based on TransferOut #: " + clsTransferOutDetails.TransferOutNo;
// 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.SubtractQuantity(clsTransferOutDetails.BranchID, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_TRANSFER_OUT), DateTime.Now, clsTransferOutDetails.TransferOutNo, clsTransferOutDetails.TransferrerName);
///*******************************************
// * Update Purchasing Information
// * ****************************************/
//clsProduct.UpdatePurchasing(lngProductID, clsTransferOutDetails.SupplierID, intProductUnitID, (decItemQuantity * decUnitCost) / decQuantity);
//if (lngVariationMatrixID != 0)
//{
// clsProductVariationsMatrix.UpdatePurchasing(lngVariationMatrixID, clsTransferOutDetails.SupplierID, intProductUnitID, (decItemQuantity * decUnitCost) / decQuantity);
//}
/*******************************************
* Add to Inventory Analysis
* ****************************************/
clsInventoryDetails = new InventoryDetails();
clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom;
clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo;
clsInventoryDetails.PostingDate = clsTransferOutDetails.DeliveryDate;
clsInventoryDetails.ReferenceNo = clsTransferOutDetails.TransferOutNo;
clsInventoryDetails.ContactID = clsTransferOutDetails.SupplierID;
clsInventoryDetails.ContactCode = clsTransferOutDetails.SupplierCode;
clsInventoryDetails.ProductID = lngProductID;
clsInventoryDetails.ProductCode = strProductCode;
clsInventoryDetails.VariationMatrixID = lngVariationMatrixID;
clsInventoryDetails.MatrixDescription = strMatrixDescription;
clsInventoryDetails.TransferOutQuantity = decQuantity;
clsInventoryDetails.TransferOutCost = decItemCost - decVAT;
clsInventoryDetails.TransferOutVAT = decItemCost; // TransferOut Cost with VAT
clsInventory.Insert(clsInventoryDetails);
/*******************************************
* Added April 28, 2010 4:20PM
* Update Selling Information when TransferOut is posted
* ****************************************/
//clsProduct.UpdateSellingIncludingAllMatrixWithSameQuantityAndUnit(lngProductID, clsTransferOutDetails.SupplierID, intProductUnitID, decimal.Parse(myReader["SellingPrice");
//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 = clsTransferOutDetails.SupplierID;
//clsProductPurchasePriceHistoryDetails.PurchasePrice = decUnitCost;
//clsProductPurchasePriceHistoryDetails.PurchaseDate = clsTransferOutDetails.TransferOutDate;
//clsProductPurchasePriceHistoryDetails.Remarks = clsTransferOutDetails.TransferOutNo;
//ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(base.Connection, base.Transaction);
//clsProductPurchasePriceHistory.AddToList(clsProductPurchasePriceHistoryDetails);
}
}