protected void Page_Load(object sender, System.EventArgs e)
{
const string defaultHeading = "Master Files";
string stHeading = defaultHeading;
const string defaultTitle = "Product Variation Combinations";
SiteTitle.Title = defaultTitle;
const SearchCategoryID defaultSearchIndex = SearchCategoryID.ProductVariationsMatrix;
SearchCategoryID SearchIndex = defaultSearchIndex;
HorizontalNavBar.PageNavigatorid = HorizontalNavID.MasterFiles;
if (Request.QueryString["task"]!=null)
{
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
long prodid = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"].ToString(), Session.SessionID));
clsDetails = clsProduct.Details(prodid);
clsProduct.CommitAndDispose();
string productCode = " for : " + clsDetails.ProductCode;
string task = Common.Decrypt(Request.QueryString["task"].ToString(),Session.SessionID);
switch(task)
{
case "add":
stHeading = "Create New Product Variation Combination";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlInsert.Visible = true;
break;
case "edit":
stHeading = "Modify Product Variation Combination";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlUpdate.Visible = true;
break;
case "det":
stHeading = "Product Variation Details";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlDetails.Visible = true;
break;
case "list":
stHeading = "Product Variation Combinations List ";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlList.Visible = true;
break;
default:
break;
}
LargeHeading.Text = stHeading + productCode;
RightBodySectionSearch.SearchIDSelectedItem = SearchIndex;
}
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
Products clsProduct = new Products();
int intProductBaseUnitID = 0;
decimal decCommision = 0;
try {
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(cboProductCode.SelectedValue));
intProductBaseUnitID = clsDetails.BaseUnitID; decCommision = clsDetails.PercentageCommision;
}
catch { }
txtProductCode.ToolTip = intProductBaseUnitID.ToString();
lblProductID.ToolTip = decCommision.ToString();
clsProduct.CommitAndDispose();
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboProductCode.SelectedItem.Value != Constants.ZERO_STRING)
{
Products clsProduct = new Products();
ProductDetails clsProductDetails = clsProduct.Details(long.Parse(cboProductCode.SelectedItem.Value));
clsProduct.CommitAndDispose();
txtRedeemRewardPoints.Text = clsProductDetails.RewardPoints.ToString("#,##0.#0");
txtNewRewardPoints.Text = Convert.ToInt32(Convert.ToDecimal(txtCurrentRewardPoints.Text) - Convert.ToDecimal(txtRedeemRewardPoints.Text)).ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
private bool CopyPOSToActual()
{
bool boRetValue = false;
Products clsProduct = new Products();
boRetValue = clsProduct.CopyPOSToActualByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value));
clsProduct.CommitAndDispose();
boRetValue = true;
return boRetValue;
}
private string CloseInventory()
{
string strRetValue = "";
try
{
DateTime DeliveryDate = Convert.ToDateTime(txtClosingDate.Text);
ERPConfig clsERPConfig = new ERPConfig();
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
if (clsERPConfigDetails.PostingDateFrom <= DeliveryDate && clsERPConfigDetails.PostingDateTo >= DeliveryDate)
{
string strReferenceNo = Constants.CLOSE_INVENTORY_CODE + CompanyDetails.BECompanyCode + DateTime.Now.Year.ToString() + clsERPConfig.get_LastClosingNo();
AccessUserDetails clsAccessUserDetails = (AccessUserDetails)Session["AccessUserDetails"];
ProductInventories clsProductInventories = new ProductInventories(clsERPConfig.Connection, clsERPConfig.Transaction);
clsProductInventories.CloseInventoryByProductGroup(int.Parse(cboBranch.SelectedItem.Value), clsAccessUserDetails.UID, DateTime.Parse(txtClosingDate.Text), strReferenceNo, long.Parse(cboProductGroup.SelectedItem.Value), cboProductGroup.SelectedItem.Text);
Products clsProducts = new Products(clsERPConfig.Connection, clsERPConfig.Transaction);
clsProducts.LockUnlockForSellingByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value), false);
clsERPConfig.CommitAndDispose();
strRetValue = strReferenceNo;
}
else
{
clsERPConfig.CommitAndDispose();
string stScript = "<Script>";
stScript += "window.alert('Sorry you cannot close using the closing date: " + txtClosingDate.Text + ". Please enter an allowable posting date.')";
stScript += "</Script>";
Response.Write(stScript);
}
}
catch (Exception ex)
{
string stScript = "<Script>";
stScript += "window.alert('An error has occured while closing the inventory. Details:' " + ex.Message + ")";
stScript += "</Script>";
Response.Write(stScript);
}
return strRetValue;
}
protected void cboProductSubGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
DataClass clsDataClass = new DataClass();
Products clsProduct = new Products();
cboProducts.DataTextField = "ProductCode";
cboProducts.DataValueField = "ProductID";
cboProducts.DataSource = clsProduct.ProductIDandCodeDataTable(ProductListFilterType.ShowActiveAndInactive, txtProductCode.Text.Trim(), 0, Convert.ToInt64(cboProductGroup.SelectedItem.Value), string.Empty, Convert.ToInt64(cboSubGroup.SelectedItem.Value));
cboProducts.DataBind();
cboProducts.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
if (cboProducts.Items.Count > 1 && txtProductCode.Text.Trim() != string.Empty) cboProducts.SelectedIndex = 1; else cboProducts.SelectedIndex = 0;
clsProduct.CommitAndDispose();
cboProducts_SelectedIndexChanged(null, System.EventArgs.Empty);
}
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");
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
return;
if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING)
return;
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{ cboVariation.Items.Add(new ListItem("No Variation", "0")); }
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID, MatrixID: Int64.Parse(cboVariation.SelectedItem.Value));
clsProductVariationsMatrix.CommitAndDispose();
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrevPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0");
txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0");
if (clsDetails.VAT >0)
chkIsTaxable.Checked = true;
else
chkIsTaxable.Checked = false;
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
}
private void SaveRecord()
{
long lngProductGroupID = long.Parse(cboProductGroup.SelectedItem.Value);
long lngProductSubGroupID = long.Parse(cboProductSubGroup.SelectedItem.Value);
long lngProductID = long.Parse(cboProductCode.SelectedItem.Value);
decimal decRewardPoints = 0;
string javaScript;
try
{ decRewardPoints = decimal.Parse(txtRewardPoints.Text); }
catch
{
javaScript = "window.alert('Please enter a valid Reward Points.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
Products clsProduct = new Products();
clsProduct.UpdateRewardPoints(lngProductGroupID, lngProductSubGroupID, lngProductID, decRewardPoints);
clsProduct.CommitAndDispose();
javaScript = "window.alert('Reward Points has been updated.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
}
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)
{
// Aug 1, 2011 : Lemu
// Remove the entire code and replaced with the code below to cater InventoryAdjustment and ProductMovement
// See _Product/_variationsMatrix/_List.cs.Delete
//
// ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
// clsProductVariationsMatrix.Delete(stIDs.Substring(0,stIDs.Length-1));
// clsProductVariationsMatrix.SynchronizeQuantity(Convert.ToInt64(lblProductID.Text));
// clsProductVariationsMatrix.CommitAndDispose();
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
clsProductVariationsMatrix.GetConnection();
Products clsProducts = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
long ProductID = Int64.Parse(lblProductID.Text);
string[] strIDs = stIDs.Substring(0, stIDs.Length - 1).Split(',');
foreach (string ID in strIDs)
{
long MatrixID = long.Parse(ID);
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
InvAdjustmentDetails clsInvAdjustmentDetails = new InvAdjustmentDetails();
clsInvAdjustmentDetails.UID = clsAccessUserDetails.UID;
clsInvAdjustmentDetails.InvAdjustmentDate = DateTime.Now;
clsInvAdjustmentDetails.ProductID = clsDetails.ProductID;
clsInvAdjustmentDetails.ProductCode = clsDetails.ProductCode;
clsInvAdjustmentDetails.Description = clsDetails.ProductDesc;
clsInvAdjustmentDetails.VariationMatrixID = clsDetails.MatrixID;
clsInvAdjustmentDetails.MatrixDescription = clsDetails.MatrixDescription;
clsInvAdjustmentDetails.UnitID = clsDetails.BaseUnitID;
clsInvAdjustmentDetails.UnitCode = clsDetails.BaseUnitCode;
clsInvAdjustmentDetails.QuantityBefore = clsDetails.Quantity;
clsInvAdjustmentDetails.QuantityNow = 0;
clsInvAdjustmentDetails.MinThresholdBefore = clsDetails.MinThreshold;
clsInvAdjustmentDetails.MinThresholdNow = 0;
clsInvAdjustmentDetails.MaxThresholdBefore = clsDetails.MaxThreshold;
clsInvAdjustmentDetails.MaxThresholdNow = 0;
clsInvAdjustmentDetails.Remarks = "deleted item.";
InvAdjustment clsInvAdjustment = new InvAdjustment(clsProducts.Connection, clsProducts.Transaction);
clsInvAdjustment.Insert(clsInvAdjustmentDetails);
clsProducts.SubtractQuantity(Constants.BRANCH_ID_MAIN, clsDetails.ProductID, clsDetails.MatrixID, clsDetails.Quantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_PRODUCT_VARIATION_DELETE) + " : " + clsDetails.MatrixDescription, clsInvAdjustmentDetails.InvAdjustmentDate, "SYS-VARDEL" + clsInvAdjustmentDetails.InvAdjustmentDate.ToString("yyyyMMddHHmmss"), clsAccessUserDetails.Name);
clsProductVariationsMatrix.Delete(long.Parse(ID));
}
clsProductVariationsMatrix.CommitAndDispose();
}
return boRetValue;
}
private ProductPurchasePriceHistoryDetails SetDetails(System.Data.DataTable dt, Int32 BranchID = 0)
{
try
{
ProductPurchasePriceHistoryDetails Details = new ProductPurchasePriceHistoryDetails();
Details.ProductPurchasePriceHistoryID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.ProductPurchasePriceHistoryID = Int64.Parse(dr["ProductPurchasePriceHistoryID"].ToString());
Details.MatrixID = Int64.Parse(dr["MatrixID"].ToString());
Details.SupplierID = Int64.Parse(dr["SupplierID"].ToString());
Details.PurchasePrice = Decimal.Parse(dr["PurchasePrice"].ToString());
Details.PurchaseDate = DateTime.Parse(dr["PurchaseDate"].ToString());
Details.Remarks = "" + dr["Remarks"].ToString();
Products clsProduct = new Products(base.Connection, base.Transaction);
Details.ProductDetails = clsProduct.Details1(BranchID, Details.ProductID);
Contacts clsContact = new Contacts(base.Connection, base.Transaction);
Details.SupplierDetails = clsContact.Details(Details.SupplierID);
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
long lngProductGroupID = long.Parse(cboProductGroup.SelectedItem.Value);
long lngProductSubGroupID = long.Parse(cboProductSubGroup.SelectedItem.Value);
long lngProductID = long.Parse(cboProductCode.SelectedItem.Value);
decimal decVAT = 0; decimal decEVAT = 0; decimal decLocalTax = 0;
string javaScript;
try
{ decVAT = decimal.Parse(txtVAT.Text); }
catch
{
javaScript = "window.alert('Please enter a valid VAT.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
try
{ decEVAT = decimal.Parse(txtEVAT.Text); }
catch
{
javaScript = "window.alert('Please enter a valid EVAT.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
try
{ decLocalTax = decimal.Parse(txtLocalTax.Text); }
catch
{
javaScript = "window.alert('Please enter a valid LocalTax.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
Products clsProduct = new Products();
clsProduct.ChangeTax(lngProductGroupID, lngProductSubGroupID, lngProductID, decVAT, decEVAT, decLocalTax, Convert.ToString(Session["Name"]));
clsProduct.CommitAndDispose();
txtVAT.Text = decVAT.ToString("#,##0.#0");
txtEVAT.Text = decEVAT.ToString("#,##0.#0");
txtLocalTax.Text = decLocalTax.ToString("#,##0.#0");
javaScript = "window.alert('Taxes has been updated.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboProductCode.SelectedItem.Value != Constants.ZERO_STRING)
{
Products clsProduct = new Products();
ProductDetails clsProductDetails = clsProduct.Details(long.Parse(cboProductCode.SelectedItem.Value));
clsProduct.CommitAndDispose();
txtVAT.Text = clsProductDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsProductDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsProductDetails.LocalTax.ToString("#,##0.#0");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadOptions()
{
Int64 prodid = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"].ToString(),Session.SessionID));
lblProductID.Text = Convert.ToString(prodid);
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(prodid);
if (clsUnitDetails.BottomUnitName == null)
{
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
clsDetails = clsProduct.Details(prodid);
clsProduct.CommitAndDispose();
txtBaseUnit.Text = clsDetails.BaseUnitName;
lblBaseUnitID.Text = Convert.ToString(clsDetails.BaseUnitID);
}
else
{
txtBaseUnit.Text = clsUnitDetails.BottomUnitName;
lblBaseUnitID.Text = Convert.ToString(clsUnitDetails.BottomUnitID);
}
cboBottomUnit.DataTextField = "UnitName";
cboBottomUnit.DataValueField = "UnitID";
cboBottomUnit.DataSource = clsUnitMatrix.AvailableUnitsForProduct(prodid).DefaultView;
cboBottomUnit.DataBind();
if (cboBottomUnit.Items.Contains( new ListItem(txtBaseUnit.Text, lblBaseUnitID.Text)))
{
cboBottomUnit.Items.RemoveAt( cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text)));
}
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1;
clsUnitMatrix.CommitAndDispose();
}
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;
}
private void SaveRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
int iChartOfAccountIDPurchase = Convert.ToInt32(cboChartOfAccountPurchase.SelectedItem.Value);
int iChartOfAccountIDSold = Convert.ToInt32(cboChartOfAccountSold.SelectedItem.Value);
int iChartOfAccountIDInventory = Convert.ToInt32(cboChartOfAccountInventory.SelectedItem.Value);
int iChartOfAccountIDTaxPurchase = Convert.ToInt32(cboChartOfAccountIDTaxPurchase.SelectedItem.Value);
int iChartOfAccountIDTaxSold = Convert.ToInt32(cboChartOfAccountIDTaxSold.SelectedItem.Value);
Products clsProduct = new Products();
clsProduct.UpdateFinancialInformation(iID, iChartOfAccountIDPurchase, iChartOfAccountIDSold, iChartOfAccountIDInventory, iChartOfAccountIDTaxPurchase, iChartOfAccountIDTaxSold);
clsProduct.CommitAndDispose();
}
private void LoadOptions()
{
lblMatrixID.Text = Common.Decrypt((string)Request.QueryString["matrixid"],Session.SessionID);
lblProductID.Text = Common.Decrypt((string)Request.QueryString["prodid"],Session.SessionID);
ProductUnitsMatrix clsUnit = new ProductUnitsMatrix();
cboUnit.DataTextField = "BottomUnitName";
cboUnit.DataValueField = "BottomUnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(Convert.ToInt64(lblProductID.Text)).DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
cboUnit.Items.Add(new ListItem(clsDetails.BaseUnitName, clsDetails.BaseUnitID.ToString()));
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsDetails.Price.ToString("#,##0.#0");
txtPurchasePrice.Text = clsDetails.PurchasePrice.ToString("#,##0.#0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
clsProduct.CommitAndDispose();
}
protected void lstItem_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
Common Common = new Common();
HtmlInputCheckBox chkList = (HtmlInputCheckBox) e.Item.FindControl("chkList");
HyperLink lnkProductCode = (HyperLink)e.Item.FindControl("lnkProductCode");
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value,Session.SessionID);
switch(e.CommandName)
{
case "imgProductTag":
{
ImageButton imgProductTag = (ImageButton) e.Item.FindControl("imgProductTag");
Products clsProduct = new Products();
if (imgProductTag.ToolTip == "Tag this product as INACTIVE.")
clsProduct.TagInactive(long.Parse(chkList.Value));
else
clsProduct.TagActive(long.Parse(chkList.Value));
clsProduct.CommitAndDispose();
LoadList();
}
break;
case "cmdSaveVariationClick":
{
DropDownList cboVariationType = (DropDownList)e.Item.FindControl("cboVariationType");
SaveVariation(long.Parse(chkList.Value), int.Parse(cboVariationType.SelectedItem.Value), cboVariationType.SelectedItem.Text);
ProductVariations clsVariation = new ProductVariations();
cboVariationType.DataTextField = "VariationType";
cboVariationType.DataValueField = "VariationID";
cboVariationType.DataSource = clsVariation.AvailableVariationsDataTable(long.Parse(chkList.Value), "VariationType", SortOption.Ascending).DefaultView;
cboVariationType.DataBind();
cboVariationType.SelectedIndex = cboVariationType.Items.Count - 1;
clsVariation.CommitAndDispose();
}
break;
case "imgSaveVariationClick":
{
DropDownList cboVariationType = (DropDownList)e.Item.FindControl("cboVariationType");
SaveVariation(long.Parse(chkList.Value), int.Parse(cboVariationType.SelectedItem.Value), cboVariationType.SelectedItem.Text);
ProductVariations clsVariation = new ProductVariations();
cboVariationType.DataTextField = "VariationType";
cboVariationType.DataValueField = "VariationID";
cboVariationType.DataSource = clsVariation.AvailableVariationsDataTable(long.Parse(chkList.Value), "VariationType", SortOption.Ascending).DefaultView;
cboVariationType.DataBind();
cboVariationType.SelectedIndex = cboVariationType.Items.Count - 1;
clsVariation.CommitAndDispose();
}
break;
case "imgVariationsClick":
stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam);
break;
case "imgVariationsMatrixClick":
stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam);
break;
case "imgUnitsMatrixClick":
stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_UnitsMatrix/Default.aspx" + stParam);
break;
case "imgVariationsAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Variations/Default.aspx" + stParam);
break;
case "imgVariationsMatrixAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam);
break;
case "imgUnitsMatrixAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_UnitsMatrix/Default.aspx" + stParam);
break;
case "imgPackageMatrixAddClick":
stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Package/Default.aspx" + stParam);
break;
case "imgInventoryAdjustmentClick":
stParam = "?task=" + Common.Encrypt("invadjustment", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/Inventory/Default.aspx" + stParam);
break;
case "imgProductHistoryClick":
stParam = "?task=" + Common.Encrypt("producthistory", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/Reports/Default.aspx" + stParam);
break;
case "imgProductPriceHistoryClick":
stParam = "?task=" + Common.Encrypt("pricehistory", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/Reports/Default.aspx" + stParam);
break;
case "imgChangePriceClick":
stParam = "?task=" + Common.Encrypt("changeprice", Session.SessionID) +
"&productcode=" + Common.Encrypt(Server.UrlEncode(lnkProductCode.Text), Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
break;
case "imgFinanceClick":
stParam = "?task=" + Common.Encrypt("finance", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect(Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/Default.aspx" + stParam);
break;
case "imgEditNowClick":
stParam = "?task=" + Common.Encrypt("edit", Session.SessionID) + "&id=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
break;
}
}
protected void cboVariation_SelectedIndexChanged(object sender, System.EventArgs e)
{
long MatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (MatrixID != 0)
{
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
Products clsProducts = new Products();
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
clsProducts.CommitAndDispose();
txtPrevPrice.Text = clsDetails.PurchasePrice.ToString("####0.#0");
txtPrice.Text = clsDetails.PurchasePrice.ToString("####0.#0");
if (clsDetails.VAT > 0)
chkIsTaxable.Checked = true;
else
chkIsTaxable.Checked = false;
ComputeItemAmount();
}
}
private void LoadList()
{
string SortField = "ProductDesc";
if (Request.QueryString["sortfield"]!=null)
{ SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); }
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"]!=null)
{ sortoption = (SortOption) Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }
ProductListFilterType clsProductListFilterType = ProductListFilterType.ShowActiveOnly;
if (rdoShowInactiveOnly.Checked == true) clsProductListFilterType = ProductListFilterType.ShowInactiveOnly;
if (rdoShowActiveOnly.Checked == true) clsProductListFilterType = ProductListFilterType.ShowActiveOnly;
if (rdoShowAll.Checked == true) clsProductListFilterType = ProductListFilterType.ShowActiveAndInactive;
int intLimit = 0;
try { intLimit = int.Parse(txtLimit.Text); }
catch { }
string SearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{ SearchKey = Server.UrlDecode(Common.Decrypt((string)Request.QueryString["search"], Session.SessionID)); }
else if (Session["Search"] != null)
{ SearchKey = Server.UrlDecode(Common.Decrypt(Session["Search"].ToString(), Session.SessionID)); }
try { Session.Remove("Search"); } catch { }
if (SearchKey == null) { SearchKey = string.Empty; }
else if (SearchKey != string.Empty) { Session.Add("Search", Common.Encrypt(SearchKey, Session.SessionID)); }
Data.ProductDetails clsSearchKeys = new Data.ProductDetails();
clsSearchKeys.BarCode = SearchKey;
clsSearchKeys.BarCode2 = SearchKey;
clsSearchKeys.BarCode3 = SearchKey;
clsSearchKeys.ProductCode = SearchKey;
ProductAddOnFilters clsProductAddOnFilters = new ProductAddOnFilters();
clsProductAddOnFilters.BarcodeFrom = txtBarcodeFrom.Text;
clsProductAddOnFilters.BarcodeTo = txtBarcodeTo.Text;
clsProductAddOnFilters.ProductCodeFrom = txtProductCodeFrom.Text;
clsProductAddOnFilters.ProductCodeTo = txtProductCodeTo.Text;
clsProductAddOnFilters.ProductSubGroupNameFrom = txtProductSubGroupNameFrom.Text;
clsProductAddOnFilters.ProductSubGroupNameTo = txtProductSubGroupNameTo.Text;
clsProductAddOnFilters.ProductGroupNameFrom = txtProductGroupnameFrom.Text;
clsProductAddOnFilters.ProductGroupNameTo = txtProductGroupNameTo.Text;
clsProductAddOnFilters.SupplierNameFrom = txtSupplierNameFrom.Text;
clsProductAddOnFilters.SupplierNameTo = txtSupplierNameTo.Text;
Products clsProduct = new Products();
System.Data.DataTable dt = clsProduct.ListAsDataTable(clsSearchKeys: clsSearchKeys, ProductAddOnFilters: clsProductAddOnFilters, clsProductListFilterType: clsProductListFilterType, limit: 100, SortField: SortField, SortOrder: SortOption.Ascending);
clsProduct.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;
}
private void SaveRecord()
{
DebitMemoItemDetails clsDetails = new DebitMemoItemDetails();
Products clsProducts = new Products();
ProductDetails clsProductDetails = clsProducts.Details1(Constants.BRANCH_ID_MAIN, Convert.ToInt64(cboProductCode.SelectedItem.Value));
Terminal clsTerminal = new Terminal(clsProducts.Connection, clsProducts.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProducts.CommitAndDispose();
clsDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.ProductCode = clsProductDetails.ProductCode;
clsDetails.BarCode = clsProductDetails.BarCode;
clsDetails.Description = clsProductDetails.ProductDesc;
clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.ProductUnitCode = cboProductUnit.SelectedItem.Text;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.PrevUnitCost = Convert.ToDecimal(txtPrevPrice.Text);
clsDetails.UnitCost = Convert.ToDecimal(txtPrice.Text);
clsDetails.Discount = getItemTotalDiscount();
clsDetails.DiscountApplied = Convert.ToDecimal(txtDiscount.Text);
if (clsDetails.DiscountApplied == 0)
{
if (chkInPercent.Checked == true)
clsDetails.DiscountType = DiscountTypes.Percentage;
else
clsDetails.DiscountType = DiscountTypes.FixedValue;
}
else
{
clsDetails.DiscountType = DiscountTypes.NotApplicable;
}
clsDetails.IsVatable = chkIsTaxable.Checked;
clsDetails.Amount = ComputeItemAmount();
if (clsDetails.IsVatable)
{
clsDetails.VatableAmount = clsDetails.Amount;
clsDetails.EVatableAmount = clsDetails.Amount;
clsDetails.LocalTax = clsDetails.Amount;
if (clsTerminalDetails.IsVATInclusive == false)
{
if (clsDetails.VatableAmount < clsDetails.Discount) clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount < clsDetails.Discount) clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax < clsDetails.Discount) clsDetails.LocalTax = 0;
}
else
{
if (clsDetails.VatableAmount >= clsDetails.Discount) clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount >= clsDetails.Discount) clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax >= clsDetails.Discount) clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); else clsDetails.LocalTax = 0;
}
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
}
clsDetails.isVATInclusive = clsTerminalDetails.IsVATInclusive;
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (clsDetails.VariationMatrixID != 0)
clsDetails.MatrixDescription = cboVariation.SelectedItem.Text;
clsDetails.ProductGroup = clsProductDetails.ProductGroupCode;
clsDetails.ProductSubGroup = clsProductDetails.ProductSubGroupCode;
clsDetails.Remarks = txtRemarks.Text;
DebitMemoItems clsDebitMemoItems = new DebitMemoItems();
if (lblDebitMemoItemID.Text != "0")
{
clsDetails.DebitMemoItemID = Convert.ToInt64(lblDebitMemoItemID.Text);
clsDebitMemoItems.Update(clsDetails);
}
else
clsDebitMemoItems.Insert(clsDetails);
DebitMemoDetails clsDebitMemoDetails = new DebitMemoDetails();
clsDebitMemoDetails.DebitMemoID = clsDetails.DebitMemoID;
clsDebitMemoDetails.DiscountApplied = Convert.ToDecimal(txtPODebitMemoDiscountApplied.Text);
clsDebitMemoDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscountType.SelectedItem.Value);
clsDebitMemoDetails.Discount2Applied = Convert.ToDecimal(txtPODebitMemoDiscount2Applied.Text);
clsDebitMemoDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount2Type.SelectedItem.Value);
clsDebitMemoDetails.Discount3Applied = Convert.ToDecimal(txtPODebitMemoDiscount3Applied.Text);
clsDebitMemoDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount3Type.SelectedItem.Value);
DebitMemos clsDebitMemos = new DebitMemos(clsDebitMemoItems.Connection, clsDebitMemoItems.Transaction);
clsDebitMemos.UpdateDiscount(clsDetails.DebitMemoID, clsDebitMemoDetails.DiscountApplied, clsDebitMemoDetails.DiscountType, clsDebitMemoDetails.Discount2Applied, clsDebitMemoDetails.Discount2Type, clsDebitMemoDetails.Discount3Applied, clsDebitMemoDetails.Discount3Type);
clsDebitMemoDetails = clsDebitMemos.Details(clsDetails.DebitMemoID);
clsDebitMemoItems.CommitAndDispose();
UpdateFooter(clsDebitMemoDetails);
}
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)
{
Products clsProduct = new Products();
clsProduct.Delete( stIDs.Substring(0,stIDs.Length-1), Convert.ToString(Session["Name"]));
clsProduct.CommitAndDispose();
Security.AuditTrailDetails clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = Convert.ToString(Session["Name"]);
clsAuditDetails.IPAddress = Request.UserHostAddress;
clsAuditDetails.Activity = "Products";
clsAuditDetails.Remarks = "Delete Product(s). IDs:'" + stIDs + "'";
Security.AuditTrail clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
clsAuditTrail.CommitAndDispose();
}
return boRetValue;
}
protected void lstItem_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList");
HtmlInputCheckBox chkMatrixID = (HtmlInputCheckBox)e.Item.FindControl("chkMatrixID");
string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) +
"&prodid=" + Common.Encrypt(chkList.Value, Session.SessionID);
switch(e.CommandName)
{
case "imgProductTag":
{
ImageButton imgProductTag = (ImageButton)e.Item.FindControl("imgProductTag");
Products clsProduct = new Products();
if (imgProductTag.ToolTip == "Tag this product as INACTIVE.")
{
clsProduct.TagInactive(long.Parse(chkList.Value));
imgProductTag.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/prodtaginact.gif";
imgProductTag.ToolTip = "Tag this product as ACTIVE.";
}
else
{
clsProduct.TagActive(long.Parse(chkList.Value));
imgProductTag.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/prodtagact.gif";
imgProductTag.ToolTip = "Tag this product as INACTIVE.";
}
clsProduct.CommitAndDispose();
}
break;
case "imgSaveActualQuantity":
{
TextBox txtActualQuantity = (TextBox)e.Item.FindControl("txtActualQuantity");
try { decimal.Parse(txtActualQuantity.Text); }
catch
{
string stScript = "<Script>";
stScript += "window.alert('Please enter a VALID actual quantity.')";
stScript += "</Script>";
Response.Write(stScript);
break;
}
ProductInventories clsProductInventories = new ProductInventories();
clsProductInventories.UpdateActualQuantity(int.Parse(cboBranch.SelectedItem.Value), long.Parse(chkList.Value), long.Parse(chkMatrixID.Value), decimal.Parse(txtActualQuantity.Text));
clsProductInventories.CommitAndDispose();
}
break;
}
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
return;
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{ cboVariation.Items.Add(new ListItem("No Variation", "0"));}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID);
clsProductVariationsMatrix.CommitAndDispose();
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrice.Text = clsDetails.WSPrice.ToString("#####0.#0");
txtSellingPrice.Text = clsDetails.Price.ToString("#####0.#0");
decimal decMargin = clsDetails.Price - clsDetails.WSPrice;
try { decMargin = decMargin / clsDetails.WSPrice; }
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");
if (clsDetails.VAT > 0)
chkIsTaxable.Checked = true;
else
chkIsTaxable.Checked = false;
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
//if (ProductID != 0)
//{
// lnkVariationAdd.Visible = true;
// string stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
// "&prodid=" + Common.Encrypt(ProductID.ToString(), Session.SessionID);
// lnkVariationAdd.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam;
//}
//else { lnkVariationAdd.Visible = false; }
}
private bool ZeroOutActualQuantity()
{
bool boRetValue = false;
Products clsProduct = new Products();
boRetValue = clsProduct.ZeroOutActualQuantityByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value));
clsProduct.CommitAndDispose();
boRetValue = true;
return boRetValue;
}
protected void cboVariation_SelectedIndexChanged(object sender, System.EventArgs e)
{
long MatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (MatrixID != 0)
{
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
Products clsProducts = new Products();
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
clsProducts.CommitAndDispose();
txtPrice.Text = clsDetails.WSPrice.ToString("####0.#0");
txtSellingPrice.Text = clsDetails.Price.ToString("#####0.#0");
decimal decMargin = clsDetails.Price - clsDetails.WSPrice;
try { decMargin = decMargin / clsDetails.WSPrice; }
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");
if (clsDetails.VAT > 0)
chkIsTaxable.Checked = true;
else
chkIsTaxable.Checked = false;
ComputeItemAmount();
}
}
private void LockUnlockForSelling(string UnLock = "")
{
bool isLock = false;
if (UnLock == "Unlock")
{
isLock = false;
}
else if (cmdLockUnlockProduct.ToolTip == "unlock")
{
isLock = true;
}
Products clsProducts = new Products();
clsProducts.LockUnlockForSellingByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value), isLock);
clsProducts.CommitAndDispose();
if (!isLock)
{
cmdLockUnlockProduct.Text = "Lock Product Group [<label class='ms-error'>Note:</label>Products under this group are <u>CURRENTLY ALLOWED</u> for Selling]";
cmdLockUnlockProduct.ToolTip = "unlock";
}
else
{
cmdLockUnlockProduct.Text = "UnLock Product Group [<label class='ms-error'>Note:</label>Products under this group are <u>CURRENTLY NOT ALLOWED</u> for Selling]";
cmdLockUnlockProduct.ToolTip = "lock";
}
}
private void SaveRecord()
{
SOItemDetails clsDetails = new SOItemDetails();
Products clsProducts = new Products();
ProductDetails clsProductDetails = clsProducts.Details1(Constants.BRANCH_ID_MAIN, Convert.ToInt64(cboProductCode.SelectedItem.Value));
Terminal clsTerminal = new Terminal(clsProducts.Connection, clsProducts.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProducts.CommitAndDispose();
clsDetails.SOID = Convert.ToInt64(lblSOID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.ProductCode = clsProductDetails.ProductCode;
clsDetails.BarCode = clsProductDetails.BarCode;
clsDetails.Description = clsProductDetails.ProductDesc;
clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.ProductUnitCode = cboProductUnit.SelectedItem.Text;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.UnitCost = Convert.ToDecimal(txtPrice.Text);
clsDetails.Discount = getItemTotalDiscount();
clsDetails.DiscountApplied = Convert.ToDecimal(txtDiscount.Text);
if (clsDetails.DiscountApplied == 0)
{
if (chkInPercent.Checked == true)
clsDetails.DiscountType = DiscountTypes.Percentage;
else
clsDetails.DiscountType = DiscountTypes.FixedValue;
}
else
{
clsDetails.DiscountType = DiscountTypes.NotApplicable;
}
clsDetails.IsVatable = chkIsTaxable.Checked;
clsDetails.Amount = ComputeItemAmount();
if (clsDetails.IsVatable)
{
clsDetails.VatableAmount = clsDetails.Amount;
clsDetails.EVatableAmount = clsDetails.Amount;
clsDetails.LocalTax = clsDetails.Amount;
if (clsTerminalDetails.IsVATInclusive == false)
{
if (clsDetails.VatableAmount < clsDetails.Discount) clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount < clsDetails.Discount) clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax < clsDetails.Discount) clsDetails.LocalTax = 0;
}
else
{
if (clsDetails.VatableAmount >= clsDetails.Discount) clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount >= clsDetails.Discount) clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax >= clsDetails.Discount) clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); else clsDetails.LocalTax = 0;
}
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
//if (!clsTerminalDetails.IsVATInclusive) clsDetails.Amount += (clsDetails.VAT + clsDetails.LocalTax);
//if (!clsTerminalDetails.EnableEVAT) clsDetails.Amount += clsDetails.EVAT;
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
}
clsDetails.isVATInclusive = clsTerminalDetails.IsVATInclusive;
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (clsDetails.VariationMatrixID != 0)
clsDetails.MatrixDescription = cboVariation.SelectedItem.Text;
clsDetails.ProductGroup = clsProductDetails.ProductGroupCode;
clsDetails.ProductSubGroup = clsProductDetails.ProductSubGroupCode;
clsDetails.Remarks = txtRemarks.Text;
// Added Jul 1, 2010 4:20PM : for suggested selling information
clsDetails.SellingPrice = decimal.Parse(txtSellingPrice.Text);
clsDetails.SellingVAT = decimal.Parse(txtVAT.Text);
clsDetails.SellingEVAT = decimal.Parse(txtEVAT.Text);
clsDetails.SellingLocalTax = decimal.Parse(txtLocalTax.Text);
SOItem clsSOItem = new SOItem();
if (lblSOItemID.Text != "0")
{
clsDetails.SOItemID = Convert.ToInt64(lblSOItemID.Text);
clsSOItem.Update(clsDetails);
}
else
clsSOItem.Insert(clsDetails);
SODetails clsSODetails = new SODetails();
clsSODetails.SOID = clsDetails.SOID;
clsSODetails.DiscountApplied = Convert.ToDecimal(txtSODiscountApplied.Text);
clsSODetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboSODiscountType.SelectedItem.Value);
SO clsSO = new SO(clsSOItem.Connection, clsSOItem.Transaction);
clsSO.UpdateDiscount(clsDetails.SOID, clsSODetails.DiscountApplied, clsSODetails.DiscountType);
clsSODetails = clsSO.Details(clsDetails.SOID);
clsSOItem.CommitAndDispose();
UpdateFooter(clsSODetails);
}
private void LoadItemData()
{
try
{
string strGroupCode = string.Empty;
ListView.SelectedListViewItemCollection items = this.lstGroup.SelectedItems;
foreach (ListViewItem item in items)
{ strGroupCode = item.SubItems[0].Name; break; }
if (strGroupCode != string.Empty)
{
Products clsProduct = new Products();
System.Data.DataTable dt;
if (mboShowInActiveProducts == false)
{ dt = clsProduct.SearchSaleableDataTableByGroup(strGroupCode, string.Empty, "ProductCode", SortOption.Ascending, 0, mboShowItemMoreThanZeroQty); }
else
{ dt = clsProduct.SearchDataTableActiveInactive(ProductListFilterType.ShowInactiveOnly, strGroupCode, "ProductCode", SortOption.Ascending, 0, mboShowItemMoreThanZeroQty); }
clsProduct.CommitAndDispose();
lstItems.Items.Clear(); int iImgCtr = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (mboIsPriceInq)
lstItems.Items.Add(dr["Barcode"].ToString(), "[" + dr["Price"].ToString() + "]" + Environment.NewLine + dr["ProductCode"].ToString(), iImgCtr);
else
lstItems.Items.Add(dr["Barcode"].ToString(), dr["ProductCode"].ToString(), iImgCtr);
if (iImgCtr == 7) iImgCtr = 0; else iImgCtr++;
}
try { lstItems.Items[0].Selected = true; }
catch { }
}
}
catch (IndexOutOfRangeException){}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
private void LoadRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"],Session.SessionID));
Products clsProduct = new Products();
ProductDetails clsDetails = clsProduct.Details(iID);
Contacts clsContact = new Contacts(clsProduct.Connection, clsProduct.Transaction);
ContactDetails clsContactDetails = clsContact.Details(clsDetails.SupplierID);
clsProduct.CommitAndDispose();
lblProductID.Text = clsDetails.ProductID.ToString();
lblQuantity.Text = clsDetails.Quantity.ToString("#,##0.#0");
lblUnitCode.Text = clsDetails.BaseUnitCode;
lblProductCode.Text = clsDetails.ProductCode;
lblBarcode.Text = clsDetails.BarCode;
lblProductDesc.Text = clsDetails.ProductDesc;
lblProductGroup.Text = clsDetails.ProductGroupCode + "/" + clsDetails.ProductGroupName;
lblProductSubGroup.Text = clsDetails.ProductSubGroupCode + "/" + clsDetails.ProductSubGroupName;
lblSupplierCode.Text = clsContactDetails.ContactCode.ToString();
string stParam = "?task=" + Common.Encrypt("details",Session.SessionID) + "&id=" + Common.Encrypt(clsDetails.SupplierID.ToString(),Session.SessionID);
lblSupplierCode.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Contact/Default.aspx" + stParam;
lblSupplierContact.Text = clsContactDetails.BusinessName;
lblSupplierTelephoneNo.Text = clsContactDetails.TelephoneNo;
cboChartOfAccountPurchase.SelectedIndex = cboChartOfAccountPurchase.Items.IndexOf(cboChartOfAccountPurchase.Items.FindByValue(clsDetails.ChartOfAccountIDPurchase.ToString()));
cboChartOfAccountSold.SelectedIndex = cboChartOfAccountSold.Items.IndexOf(cboChartOfAccountSold.Items.FindByValue(clsDetails.ChartOfAccountIDSold.ToString()));
cboChartOfAccountInventory.SelectedIndex = cboChartOfAccountInventory.Items.IndexOf(cboChartOfAccountInventory.Items.FindByValue(clsDetails.ChartOfAccountIDInventory.ToString()));
cboChartOfAccountIDTaxPurchase.SelectedIndex = cboChartOfAccountIDTaxPurchase.Items.IndexOf(cboChartOfAccountIDTaxPurchase.Items.FindByValue(clsDetails.ChartOfAccountIDTaxPurchase.ToString()));
cboChartOfAccountIDTaxSold.SelectedIndex = cboChartOfAccountIDTaxSold.Items.IndexOf(cboChartOfAccountIDTaxSold.Items.FindByValue(clsDetails.ChartOfAccountIDTaxSold.ToString()));
}