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())); }