public RegistrationType IsDemoExpired(out string SerialNumber) { SerialNumber = null; try { RegistrationType regIsDemoExpired = RegistrationType.DEMO_Unexpired; SerialNumber = GetHDSerialNo(); if (SerialNumber == "W50SJSHQ" || SerialNumber == "K834T9A2BJNB" || SerialNumber == "K10HT77258WN" || SerialNumber == "587OCI98T" || SerialNumber == "MRG3W9KKH9S45H" || SerialNumber == "9546305796063968058" || SerialNumber == "9VP7QL84") { // K10HT77258WN - Lemuel // 587OCI98T - Darius // MRG3W9KKH9S45H - Rico // 9546305796063968058 - Grace // 9VP7QL84 - Lemuel // WD-WXTY08TPJ153 return RegistrationType.Registered; } try { Data.Terminal clsTerminal = new Data.Terminal(); string cipherText = clsTerminal.getTerminalKey(SerialNumber); clsTerminal.CommitAndDispose(); if (cipherText != string.Empty) { string plainText = CompanyDetails.CompanyCode + SerialNumber.ToString().Trim(); // original plaintext //string cipherText = System.Configuration.ConfigurationManager.AppSettings["RegistrationKey"].ToString(); // encrypted text string passPhrase = CompanyDetails.TIN; // can be any string string initVector = "%@skmelaT3rsh1t!"; // must be 16 bytes // Before encrypting data, we will append plain text to a random // salt value, which will be between 4 and 8 bytes long (implicitly // used defaults). AceSoft.Cryptor clsCryptor = new AceSoft.Cryptor(passPhrase, initVector); if (plainText == clsCryptor.Decrypt(cipherText)) { return RegistrationType.Registered; } } } catch { } Data.TerminalReport clsTerminalReport = new Data.TerminalReport(); string EndingTransactionNo = clsTerminalReport.EndingTransactioNo(Constants.TerminalBranchID, CompanyDetails.TerminalNo); clsTerminalReport.CommitAndDispose(); if (Convert.ToInt64(EndingTransactionNo) > 1000) regIsDemoExpired = RegistrationType.DEMO_Expired; return regIsDemoExpired; } catch (Exception ex) { SerialNumber = ex.ToString(); return RegistrationType.Error; } }
protected void Page_Load(object sender, System.EventArgs e) { const string defaultHeading = "Login"; const string defaultTitle = "RetailPlus System"; const SearchCategoryID defaultAllSourcesIndex = SearchCategoryID.AllSources; LargeHeading.Text = defaultHeading; SiteTitle.Title = defaultTitle; HorizontalNavBar.PageNavigatorid = HorizontalNavID.Home; RightBodySectionSearch.SearchIDSelectedItem = defaultAllSourcesIndex; PageLevelError.Visible = false; // Data.TerminalReport clsTerminalReport = new Data.TerminalReport(); // Data.TerminalReportDetails details = clsTerminalReport.Details(CompanyDetails.TerminalNo); // clsTerminalReport.CommitAndDispose(); // // if (Convert.ToInt64(details.EndingTransactionNo) >= 50) // { // Session["ErrorCurrentExecutionFilePath"] = Request.CurrentExecutionFilePath; // Session["ErrMessage"] = Constants.DEMO_EXPIRED_MESSAGE; // Session["ErrorMessage"] = Constants.DEMO_EXPIRED_MESSAGE; // Session["ErrorSource"] = Constants.DEMO_EXPIRED_HEADER; // Session["ErrorExceptionType"] = null; // Session["ErrorStackTrace"] = null; // // Response.Redirect("/RetailPlus/GenericError.aspx"); // } // else // { //Check if a user is currently login if (Session["UID"] != null) { Login.AssignUserSession(Convert.ToInt16(Session["UID"])); Response.Redirect(Constants.ROOT_DIRECTORY + "/Home/Default.aspx"); } else { HorizontalNavBar.Visible = false; RightBodySectionSearch.Visible = false; Data.Terminal clsTerminal = new Data.Terminal(); clsTerminal.UpdateBEVersion("2.0.1.5"); clsTerminal.CommitAndDispose(); } // } }
private void LoadRecord() { Terminal clsTerminal = new Terminal(); RewardPointsDetails clsDetails = clsTerminal.RewardPointsDetails(); clsTerminal.CommitAndDispose(); chkEnableRewardPoints.Checked = clsDetails.EnableRewardPoints; chkRoundDownRewardPoints.Checked = clsDetails.RoundDownRewardPoints; txtRewardPointsMinimum.Text = clsDetails.RewardPointsMinimum.ToString("##0.#0"); txtRewardPointsEvery.Text = clsDetails.RewardPointsEvery.ToString("##0.#0"); txtRewardPoints.Text = clsDetails.RewardPoints.ToString("##0.#0"); chkEnableRewardPointsAsPayment.Checked = clsDetails.EnableRewardPointsAsPayment; txtRewardPointsMaxPercentageForPayment.Text = clsDetails.RewardPointsMaxPercentageForPayment.ToString("##0.#0"); txtRewardPointsPaymentValue.Text = clsDetails.RewardPointsPaymentValue.ToString("##0.#0"); txtRewardPointsPaymentCashEquivalent.Text = clsDetails.RewardPointsPaymentCashEquivalent.ToString("##0.#0"); }
private void LoadOptions() { Data.Unit clsUnit = new Data.Unit(); cboProductGroupUnit.DataTextField = "UnitName"; cboProductGroupUnit.DataValueField = "UnitID"; cboProductGroupUnit.DataSource = clsUnit.ListAsDataTable(SortField: "UnitName").DefaultView; cboProductGroupUnit.DataBind(); cboProductGroupUnit.SelectedIndex = cboProductGroupUnit.Items.Count - 1; Terminal clsTerminal = new Terminal(clsUnit.Connection, clsUnit.Transaction); TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString()); txtVAT.Text = clsTerminalDetails.VAT.ToString("###.#0"); txtEVAT.Text = clsTerminalDetails.EVAT.ToString("###.#0"); txtLocalTax.Text = clsTerminalDetails.LocalTax.ToString("###.#0"); clsUnit.CommitAndDispose(); }
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 void LoadOptions() { Int64 UID = Convert.ToInt64(Session["UID"]); Security.AccessRights clsAccessRights = new Security.AccessRights(); Security.AccessRightsDetails clsDetails = clsAccessRights.Details(UID,(int) AccessTypes.SummarizedDailySalesWithTFDetailed); clsAccessRights.CommitAndDispose(); cboReportType.Items.Clear(); cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION)); cboReportType.Items.Add(new ListItem(ReportTypes.SummarizeDailySales, ReportTypes.SummarizeDailySales)); if (clsDetails.Read) cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerDay, ReportTypes.SalesPerDay)); if (cboReportType.Items.Count == 2) cboReportType.Items.RemoveAt(cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.REPORT_SELECTION))); cboReportType.SelectedIndex = 0; cboConsignment.Items.Clear(); cboConsignment.Items.Add(new ListItem("Both", "-1")); cboConsignment.Items.Add(new ListItem("Yes", true.ToString())); cboConsignment.Items.Add(new ListItem("No", false.ToString())); cboTransactionStatus.Items.Clear(); foreach(string status in Enum.GetNames(typeof(TransactionStatus))) { cboTransactionStatus.Items.Add(new ListItem(status, status)); } cboTransactionStatus.SelectedIndex = cboTransactionStatus.Items.IndexOf( cboTransactionStatus.Items.FindByText(TransactionStatus.NotYetApplied.ToString())); cboPaymentType.Items.Clear(); foreach(string PaymentType in Enum.GetNames(typeof(PaymentTypes))) { cboPaymentType.Items.Add(new ListItem(PaymentType, PaymentType)); } cboPaymentType.SelectedIndex = cboPaymentType.Items.IndexOf( cboPaymentType.Items.FindByText(PaymentTypes.NotYetAssigned.ToString())); txtStartTransactionDate.Text = Common.ToShortDateString(DateTime.Now.AddDays(-1)); txtEndTransactionDate.Text = Common.ToShortDateString(DateTime.Now); Customer clsCustomer = new Customer(); cboContactName.DataTextField = "ContactName"; cboContactName.DataValueField = "ContactID"; cboContactName.DataSource = clsCustomer.CustomersDataTable(txtContactName.Text, 0, false, "ContactName", SortOption.Ascending); cboContactName.DataBind(); if (string.IsNullOrEmpty(txtContactName.Text)) cboContactName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); else cboContactName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtContactName.Text, Constants.ZERO_STRING)); cboContactName.SelectedIndex = 0; cboAgent.Items.Clear(); Contacts clsContact = new Contacts(clsCustomer.Connection, clsCustomer.Transaction); cboAgent.DataTextField = "ContactName"; cboAgent.DataValueField = "ContactID"; cboAgent.DataSource = clsContact.AgentsAsDataTable(txtAgent.Text, 0, "ContactName", SortOption.Ascending); cboAgent.DataBind(); if (string.IsNullOrEmpty(txtAgent.Text)) cboAgent.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); else cboAgent.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtAgent.Text, Constants.ZERO_STRING)); cboAgent.SelectedIndex = 0; Terminal clsTerminal = new Terminal(clsCustomer.Connection, clsCustomer.Transaction); cboTerminalNo.DataTextField = "TerminalNo"; cboTerminalNo.DataValueField = "TerminalNo"; cboTerminalNo.DataSource = clsTerminal.ListAsDataTable(); cboTerminalNo.DataBind(); cboTerminalNo.Items.Insert(0, new ListItem(Constants.ALL, Constants.ALL)); cboTerminalNo.SelectedIndex = 0; Branch clsBranch = new Branch(clsCustomer.Connection, clsCustomer.Transaction); cboBranch.DataTextField = "BranchCode"; cboBranch.DataValueField = "BranchID"; cboBranch.DataSource = clsBranch.ListAsDataTable(OnlyIncludeIneSales: true).DefaultView; cboBranch.DataBind(); cboBranch.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); cboBranch.SelectedIndex = 0; Security.AccessUser clsAccessUser = new Security.AccessUser(clsCustomer.Connection, clsCustomer.Transaction); cboCashierName.DataTextField = "Name"; cboCashierName.DataValueField = "UID"; cboCashierName.DataSource = clsAccessUser.Cashiers(txtCashierName.Text, 0); cboCashierName.DataBind(); if (string.IsNullOrEmpty(txtCashierName.Text)) cboCashierName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); else cboCashierName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtCashierName.Text, Constants.ZERO_STRING)); cboCashierName.SelectedIndex = 0; ProductGroup clsProductGroup = new ProductGroup(clsCustomer.Connection, clsCustomer.Transaction); cboProductGroup.DataTextField = "ProductGroupName"; cboProductGroup.DataValueField = "ProductGroupName"; cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName"); cboProductGroup.DataBind(); cboProductGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); cboProductGroup.SelectedIndex = 0; clsCustomer.CommitAndDispose(); #region Sales Per Day cboMonth.Items.Add(new ListItem("January", "1")); cboMonth.Items.Add(new ListItem("February", "2")); cboMonth.Items.Add(new ListItem("March", "3")); cboMonth.Items.Add(new ListItem("April", "4")); cboMonth.Items.Add(new ListItem("May", "5")); cboMonth.Items.Add(new ListItem("June", "6")); cboMonth.Items.Add(new ListItem("July", "7")); cboMonth.Items.Add(new ListItem("August", "8")); cboMonth.Items.Add(new ListItem("September", "9")); cboMonth.Items.Add(new ListItem("October", "10")); cboMonth.Items.Add(new ListItem("November", "11")); cboMonth.Items.Add(new ListItem("Decemeber", "12")); cboMonth.SelectedIndex = DateTime.Now.Month - 1; int x = 2007; while (x <= DateTime.Now.Year) { cboYear.Items.Add(new ListItem(x.ToString(), x.ToString())); x++; } cboYear.SelectedIndex = cboYear.Items.Count - 1; #endregion }
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 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; }
public void GenerateItemsForReorder(Int32 TerminalID, long SOID) { try { GetConnection(); Terminal clsTerminal = new Terminal(base.Connection, base.Transaction); TerminalDetails clsTerminalDetails = clsTerminal.Details(TerminalID); SODetails clsSODetails = Details(SOID); Products clsProduct = new Products(base.Connection, base.Transaction); System.Data.DataTable dt = clsProduct.ForReorder(clsSODetails.CustomerID); SOItem clsSOItem = new SOItem(base.Connection, base.Transaction); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); foreach (System.Data.DataRow dr in dt.Rows) { SOItemDetails clsDetails = new SOItemDetails(); clsDetails.SOID = SOID; clsDetails.ProductID = Convert.ToInt64(dr["ProductID"]); clsDetails.ProductCode = dr["ProductCode"].ToString(); clsDetails.BarCode = dr["BarCode"].ToString(); clsDetails.Description = dr["ProductDesc"].ToString(); clsDetails.ProductGroup = dr["ProductGroupCode"].ToString(); clsDetails.ProductSubGroup = dr["ProductSubGroupCode"].ToString(); clsDetails.ProductUnitID = Convert.ToInt32(dr["UnitID"]); clsDetails.ProductUnitCode = dr["UnitName"].ToString(); clsDetails.Quantity = Convert.ToDecimal(dr["ReorderQty"]); clsDetails.UnitCost = Convert.ToDecimal(dr["Price"]); clsDetails.Discount = 0; clsDetails.DiscountApplied = 0; clsDetails.DiscountType = DiscountTypes.Percentage; clsDetails.Remarks = "added using auto generation"; decimal amount = clsDetails.Quantity * clsDetails.UnitCost; if (Convert.ToDecimal(dr["VAT"]) > 0) { clsDetails.VatableAmount = amount; clsDetails.EVatableAmount = amount; clsDetails.LocalTax = amount; clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100); clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100); clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100); clsDetails.IsVatable = true; } else { clsDetails.VAT = 0; clsDetails.VatableAmount = 0; clsDetails.EVAT = 0; clsDetails.EVatableAmount = 0; clsDetails.LocalTax = 0; clsDetails.IsVatable = false; } clsDetails.Amount = amount + clsDetails.VAT; System.Data.DataTable dtmatrix = clsProductVariationsMatrix.ForReorder(clsDetails.ProductID, clsSODetails.CustomerID); if (dtmatrix.Rows.Count > 0) foreach (System.Data.DataRow drmatrix in dtmatrix.Rows) { amount = clsDetails.Quantity * clsDetails.UnitCost; clsDetails.ProductUnitID = Convert.ToInt32(drmatrix["UnitID"]); clsDetails.ProductUnitCode = drmatrix["UnitName"].ToString(); clsDetails.Quantity = Convert.ToDecimal(drmatrix["ReorderQty"]); clsDetails.UnitCost = Convert.ToDecimal(drmatrix["Price"]); if (Convert.ToDecimal(drmatrix["VAT"]) > 0) { clsDetails.VatableAmount = amount; clsDetails.EVatableAmount = amount; clsDetails.LocalTax = amount; clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100); clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100); clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100); clsDetails.IsVatable = true; } else { clsDetails.VAT = 0; clsDetails.VatableAmount = 0; clsDetails.EVAT = 0; clsDetails.EVatableAmount = 0; clsDetails.LocalTax = 0; clsDetails.IsVatable = false; } clsDetails.Amount = amount + clsDetails.VAT; clsDetails.VariationMatrixID = Convert.ToInt64(drmatrix["MatrixID"]); clsDetails.MatrixDescription = drmatrix["VariationDesc"].ToString(); clsSOItem.Insert(clsDetails); } else { clsDetails.VariationMatrixID = 0; clsDetails.MatrixDescription = string.Empty; clsSOItem.Insert(clsDetails); } } } catch (Exception ex) { throw base.ThrowException(ex); } }
private void LoadOptions() { DataClass clsDataClass = new DataClass(); Int32 iID = Convert.ToInt32(Common.Decrypt(Request.QueryString["id"],Session.SessionID)); ProductGroup clsProductGroup = new ProductGroup(); cboProductGroup.DataTextField = "ProductGroupName"; cboProductGroup.DataValueField = "ProductGroupID"; cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName").DefaultView; cboProductGroup.DataBind(); cboProductGroup.SelectedIndex = cboProductGroup.Items.Count - 1; Data.Unit clsUnit = new Data.Unit(clsProductGroup.Connection, clsProductGroup.Transaction); cboProductUnit.DataTextField = "UnitName"; cboProductUnit.DataValueField = "UnitID"; cboProductUnit.DataSource = clsUnit.ListAsDataTable(SortField:"UnitName").DefaultView; cboProductUnit.DataBind(); cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1; clsUnit.CommitAndDispose(); ContactColumns clsContactColumns = new ContactColumns(); clsContactColumns.ContactID = true; clsContactColumns.ContactName = true; ContactColumns clsContactSearchColumns = new ContactColumns(); Contacts clsContact = new Contacts(clsProductGroup.Connection, clsProductGroup.Transaction); cboSupplier.DataTextField = "ContactName"; cboSupplier.DataValueField = "ContactID"; cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsContactSearchColumns, string.Empty, 0, false, "ContactName", System.Data.SqlClient.SortOrder.Ascending).DefaultView; cboSupplier.DataBind(); cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1; ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductGroup.Connection, clsProductGroup.Transaction); ProductUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(iID); if (clsUnitDetails.BottomUnitName == null) { cboProductUnit.Enabled = true; } // Added July 9, 2010 Terminal clsTerminal = new Terminal(clsProductGroup.Connection, clsProductGroup.Transaction); TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString()); txtWSPriceMarkUp.Text = clsTerminalDetails.WSPriceMarkUp.ToString(); txtMargin.Text = clsTerminalDetails.RETPriceMarkUp.ToString(); clsProductGroup.CommitAndDispose(); }
private void SaveRecord() { TerminalDetails clsDetails = new TerminalDetails(); clsDetails.BranchID = Convert.ToInt32(lblBranchID.Text); clsDetails.TerminalID = Convert.ToInt32(lblTerminalID.Text); clsDetails.TerminalNo = txtTerminalNo.Text; clsDetails.TerminalCode = txtTerminalCode.Text; clsDetails.TerminalName = txtTerminalName.Text; clsDetails.Status = 0; clsDetails.DateCreated = Convert.ToDateTime(txtDateCreated.Text); clsDetails.MachineSerialNo = txtMachineSerialNo.Text; clsDetails.AccreditationNo = txtAccreditationNo.Text; clsDetails.IsPrinterAutoCutter = Convert.ToBoolean(chkIsPrinterAutoCutter.Checked); clsDetails.AutoPrint = (PrintingPreference) Enum.Parse(typeof(PrintingPreference), cboAutoPrint.SelectedItem.Value); clsDetails.IsVATInclusive = Convert.ToBoolean(chkIsVATInclusive.Checked); clsDetails.PrinterName = txtPrinterName.Text; clsDetails.TurretName = txtTurretName.Text; clsDetails.CashDrawerName = txtCashDrawerName.Text; clsDetails.ItemVoidConfirmation = Convert.ToBoolean(chkItemVoidConfirmation.Checked); clsDetails.EnableEVAT = Convert.ToBoolean(chkEnableEVAT.Checked); clsDetails.MaxReceiptWidth = Convert.ToInt16(txtMaxReceiptWidth.Text); clsDetails.FORM_Behavior = cboFormBehaviour.SelectedItem.Value; clsDetails.MarqueeMessage = txtMarqueeMessage.Text; // Added May 6, 2009. clsDetails.VAT = Convert.ToDecimal(txtVAT.Text); clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text); clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text); clsDetails.ShowItemMoreThanZeroQty = chkShowItemMoreThanZeroQty.Checked; clsDetails.ShowOnlyPackedTransactions = chkShowOnlyPackedTransactions.Checked; clsDetails.ShowOneTerminalSuspendedTransactions = chkShowOneTerminalSuspendedTransactions.Checked; clsDetails.ReceiptType = (TerminalReceiptType)Enum.Parse(typeof(TerminalReceiptType), cboReceiptType.SelectedItem.Value); clsDetails.SalesInvoicePrinterName = txtSalesInvoicePrinterName.Text; clsDetails.CashCountBeforeReport = chkCashCountBeforeReport.Checked; clsDetails.PreviewTerminalReport = chkPreviewTerminalReport.Checked; // Added May 6, 2009. clsDetails.IsPrinterDotMatrix = chkIsPrinterDotmatrix.Checked; clsDetails.IsChargeEditable = chkIsChargeEditable.Checked; clsDetails.IsDiscountEditable = chkIsDiscountEditable.Checked; clsDetails.CheckCutOffTime = chkCheckCutOffTime.Checked; clsDetails.StartCutOffTime = txtStartCutOffTime.Text; clsDetails.EndCutOffTime = txtEndCutOffTime.Text; clsDetails.WithRestaurantFeatures = chkWithRestaurantFeatures.Checked; clsDetails.SeniorCitizenDiscountCode = cboDiscountCode.SelectedItem.Value; clsDetails.PWDDiscountCode = cboPWDDiscountCode.SelectedItem.Value; // Added May 21, 2009 clsDetails.IsTouchScreen = chkIsTouchScreen.Checked; // Added June 1, 2010 clsDetails.WillContinueSelectionVariation = chkWillContinueSelectionVariation.Checked; // Added June 15, 2010 clsDetails.WillContinueSelectionProduct = chkWillContinueSelectionProduct.Checked; // Added Sep 21, 2010 clsDetails.WillPrintGrandTotal = chkWillPrintGrandTotal.Checked; // Added Apr 12, 2011 clsDetails.ReservedAndCommit = chkReservedAndCommit.Checked; // Added Oct 17, 2011 clsDetails.ShowCustomerSelection = chkShowCustomerSelection.Checked; clsDetails.GroupChargeType = new ChargeTypeDetails() { ChargeTypeID = int.Parse(cboGroupChargeType.SelectedItem.Value), ChargeTypeCode = cboGroupChargeType.SelectedItem.Text }; clsDetails.PersonalChargeType = new ChargeTypeDetails() { ChargeTypeID = int.Parse(cboPersonalChargeType.SelectedItem.Value), ChargeTypeCode = cboPersonalChargeType.SelectedItem.Text }; // Added Sep 24, 2014 clsDetails.DefaultTransactionChargeCode = cboDefaultTransactionChargeCode.SelectedItem.Value; clsDetails.DineInChargeCode = cboDineInChargeCode.SelectedItem.Value; clsDetails.TakeOutChargeCode = cboTakeOutChargeCode.SelectedItem.Value; clsDetails.DeliveryChargeCode = cboDeliveryChargeCode.SelectedItem.Value; Terminal clsTerminal = new Terminal(); clsTerminal.Update(clsDetails); clsTerminal.CommitAndDispose(); }
private void LoadRecord() { Int32 TerminalID = Convert.ToInt32(Common.Decrypt(Request.QueryString["id"],Session.SessionID)); Terminal clsTerminal = new Terminal(); TerminalDetails clsDetails = clsTerminal.Details(TerminalID); clsTerminal.CommitAndDispose(); lblBranchID.Text = clsDetails.BranchID.ToString(); lblTerminalID.Text = clsDetails.TerminalID.ToString(); txtTerminalNo.Text = clsDetails.TerminalNo; txtTerminalCode.Text = clsDetails.TerminalCode; txtTerminalName.Text = clsDetails.TerminalName; txtStatus.Text = clsDetails.Status.ToString("G"); txtDateCreated.Text = clsDetails.DateCreated.ToString("yyyy-MM-dd HH:mm"); txtMachineSerialNo.Text = clsDetails.MachineSerialNo; txtAccreditationNo.Text = clsDetails.AccreditationNo; chkIsPrinterAutoCutter.Checked = clsDetails.IsPrinterAutoCutter; cboAutoPrint.SelectedIndex = cboAutoPrint.Items.IndexOf(cboAutoPrint.Items.FindByValue(clsDetails.AutoPrint.ToString("d"))); chkIsVATInclusive.Checked = clsDetails.IsVATInclusive; txtPrinterName.Text = clsDetails.PrinterName; txtTurretName.Text = clsDetails.TurretName; txtCashDrawerName.Text = clsDetails.CashDrawerName; chkItemVoidConfirmation.Checked = clsDetails.ItemVoidConfirmation; chkEnableEVAT.Checked = clsDetails.EnableEVAT; txtMaxReceiptWidth.Text = clsDetails.MaxReceiptWidth.ToString(); cboFormBehaviour.SelectedIndex = cboFormBehaviour.Items.IndexOf(cboFormBehaviour.Items.FindByValue(clsDetails.FORM_Behavior)); txtMarqueeMessage.Text = clsDetails.MarqueeMessage; if (Session["UserName"].ToString().ToLower() == "admin") { txtMachineSerialNo.ReadOnly = false; txtAccreditationNo.ReadOnly = false; } // Added May 6, 2009. txtVAT.Text = clsDetails.VAT.ToString("##.#0"); txtEVAT.Text = clsDetails.EVAT.ToString("##.#0"); txtLocalTax.Text = clsDetails.LocalTax.ToString("##.#0"); chkShowItemMoreThanZeroQty.Checked = clsDetails.ShowItemMoreThanZeroQty; chkShowOnlyPackedTransactions.Checked = clsDetails.ShowOnlyPackedTransactions; chkShowOneTerminalSuspendedTransactions.Checked = clsDetails.ShowOneTerminalSuspendedTransactions; cboReceiptType.SelectedIndex = cboReceiptType.Items.IndexOf(cboReceiptType.Items.FindByValue(clsDetails.ReceiptType.ToString("d"))); txtSalesInvoicePrinterName.Text = clsDetails.SalesInvoicePrinterName; chkCashCountBeforeReport.Checked = clsDetails.CashCountBeforeReport; chkPreviewTerminalReport.Checked = clsDetails.PreviewTerminalReport; // Added May 6, 2009. chkIsPrinterDotmatrix.Checked = clsDetails.IsPrinterDotMatrix; chkIsChargeEditable.Checked = clsDetails.IsChargeEditable; chkIsDiscountEditable.Checked = clsDetails.IsDiscountEditable; chkCheckCutOffTime.Checked = clsDetails.CheckCutOffTime; txtStartCutOffTime.Text = clsDetails.StartCutOffTime; txtEndCutOffTime.Text = clsDetails.EndCutOffTime; chkWithRestaurantFeatures.Checked = clsDetails.WithRestaurantFeatures; cboDiscountCode.SelectedIndex = cboDiscountCode.Items.IndexOf(cboDiscountCode.Items.FindByValue(clsDetails.SeniorCitizenDiscountCode)); cboPWDDiscountCode.SelectedIndex = cboPWDDiscountCode.Items.IndexOf(cboPWDDiscountCode.Items.FindByValue(clsDetails.PWDDiscountCode)); chkIsTouchScreen.Checked = clsDetails.IsTouchScreen; chkWillContinueSelectionVariation.Checked = clsDetails.WillContinueSelectionVariation; chkWillContinueSelectionProduct.Checked = clsDetails.WillContinueSelectionProduct; chkWillPrintGrandTotal.Checked = clsDetails.WillPrintGrandTotal; chkReservedAndCommit.Checked = clsDetails.ReservedAndCommit; // Added Oct 17, 2011 chkShowCustomerSelection.Checked = clsDetails.ShowCustomerSelection; cboGroupChargeType.SelectedIndex = cboGroupChargeType.Items.IndexOf(cboGroupChargeType.Items.FindByValue(clsDetails.GroupChargeType.ChargeTypeID.ToString())); cboPersonalChargeType.SelectedIndex = cboPersonalChargeType.Items.IndexOf(cboPersonalChargeType.Items.FindByValue(clsDetails.PersonalChargeType.ChargeTypeID.ToString())); // Added Sep 24, 2014 cboDefaultTransactionChargeCode.SelectedIndex = cboDefaultTransactionChargeCode.Items.IndexOf(cboDefaultTransactionChargeCode.Items.FindByValue(clsDetails.DefaultTransactionChargeCode)); cboDineInChargeCode.SelectedIndex = cboDineInChargeCode.Items.IndexOf(cboDineInChargeCode.Items.FindByValue(clsDetails.DineInChargeCode)); cboTakeOutChargeCode.SelectedIndex = cboTakeOutChargeCode.Items.IndexOf(cboTakeOutChargeCode.Items.FindByValue(clsDetails.TakeOutChargeCode)); cboDeliveryChargeCode.SelectedIndex = cboDeliveryChargeCode.Items.IndexOf(cboDeliveryChargeCode.Items.FindByValue(clsDetails.DeliveryChargeCode)); }
private void SaveRecord() { RewardPointsDetails clsDetails = new RewardPointsDetails(); clsDetails.EnableRewardPoints = chkEnableRewardPoints.Checked; clsDetails.RoundDownRewardPoints = chkRoundDownRewardPoints.Checked; clsDetails.RewardPointsMinimum = Convert.ToDecimal(txtRewardPointsMinimum.Text); clsDetails.RewardPointsEvery = Convert.ToDecimal(txtRewardPointsEvery.Text); clsDetails.RewardPoints = Convert.ToDecimal(txtRewardPoints.Text); clsDetails.EnableRewardPointsAsPayment = chkEnableRewardPointsAsPayment.Checked; clsDetails.RewardPointsMaxPercentageForPayment = Convert.ToDecimal(txtRewardPointsMaxPercentageForPayment.Text); clsDetails.RewardPointsPaymentValue = Convert.ToDecimal(txtRewardPointsPaymentValue.Text); clsDetails.RewardPointsPaymentCashEquivalent = Convert.ToDecimal(txtRewardPointsPaymentCashEquivalent.Text); Terminal clsTerminal = new Terminal(); clsTerminal.UpdateRewardPointSystem(clsDetails); clsTerminal.CommitAndDispose(); }
private void LoadOptions() { ProductGroup clsProductGroup = new ProductGroup(); DataClass clsDataClass = new DataClass(); cboGroup.DataTextField = "ProductGroupName"; cboGroup.DataValueField = "ProductGroupID"; cboGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName").DefaultView; cboGroup.DataBind(); cboGroup.SelectedIndex = cboGroup.Items.Count - 1; cboGroup_SelectedIndexChanged(null, System.EventArgs.Empty); Data.Unit clsUnit = new Data.Unit(); cboProductSubGroupUnit.DataTextField = "UnitName"; cboProductSubGroupUnit.DataValueField = "UnitID"; cboProductSubGroupUnit.DataSource = clsUnit.ListAsDataTable(SortField:"UnitName").DefaultView; cboProductSubGroupUnit.DataBind(); cboProductSubGroupUnit.SelectedIndex = cboProductSubGroupUnit.Items.Count - 1; Terminal clsTerminal = new Terminal(clsUnit.Connection, clsUnit.Transaction); TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString()); txtVAT.Text = clsTerminalDetails.VAT.ToString("###.#0"); txtEVAT.Text = clsTerminalDetails.EVAT.ToString("###.#0"); txtLocalTax.Text = clsTerminalDetails.LocalTax.ToString("###.#0"); clsUnit.CommitAndDispose(); if (cboGroup.Items.Count != 0) { Int32 BaseUnitID= clsProductGroup.Details(Convert.ToInt32(cboGroup.SelectedItem.Value)).UnitDetails.UnitID; cboProductSubGroupUnit.SelectedIndex = cboProductSubGroupUnit.Items.IndexOf( cboProductSubGroupUnit.Items.FindByValue(BaseUnitID.ToString())); } clsProductGroup.CommitAndDispose(); }
private void LoadOptions() { Int64 UID = Convert.ToInt64(Session["UID"]); Security.AccessRights clsAccessRights = new Security.AccessRights(); cboReportType.Items.Clear(); cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION)); if (clsAccessRights.Details(UID, (int)AccessTypes.SummarizedDailySales).Read) { cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.SummarizeDailySales, ReportTypes.SummarizeDailySales)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerDay, ReportTypes.SalesPerDay)); } //if (clsAccessRights.Details(UID, (int)AccessTypes.SummarizedDailySalesWithTF).Read) //{ // cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); // cboReportType.Items.Add(new ListItem(ReportTypes.SummarizeDailySalesWithTF, ReportTypes.SummarizeDailySalesWithTF)); // cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerDayWithTF, ReportTypes.SalesPerDayWithTF)); //} if (clsAccessRights.Details(UID, (int)AccessTypes.SalesTransactionReport).Read) { cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerHour, ReportTypes.SalesPerHour)); cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactions, ReportTypes.SalesTransactions)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomer, ReportTypes.SalesTransactionPerCustomer)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerPerGroup, ReportTypes.SalesTransactionPerCustomerPerGroup)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerPerGroupSummarized, ReportTypes.SalesTransactionPerCustomerPerGroupSummarized)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerWithCheque, ReportTypes.SalesTransactionPerCustomerWithCheque)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerPerItem, ReportTypes.SalesTransactionPerCustomerPerItem)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCashier, ReportTypes.SalesTransactionPerCashier)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCashierPerCustomer, ReportTypes.SalesTransactionPerCashierPerCustomer)); cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerTerminal, ReportTypes.SalesTransactionPerTerminal)); if (clsAccessRights.Details(UID, (int)AccessTypes.SalesTransactionPerItem).Read) { cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerItem, ReportTypes.SalesTransactionPerItem)); } if (clsAccessRights.Details(UID, (int)AccessTypes.SalesTransactionPerItemWoutPurchaseDetails).Read) { cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerItemWoutPurchaseDetails, ReportTypes.SalesTransactionPerItemWoutPurchaseDetails)); } cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.CashSalesDaily, ReportTypes.CashSalesDaily)); cboReportType.Items.Add(new ListItem(ReportTypes.CashSalesMonthly, ReportTypes.CashSalesMonthly)); cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.ChequePaymentList, ReportTypes.ChequePaymentList)); cboReportType.Items.Add(new ListItem(ReportTypes.ChequeSalesDaily, ReportTypes.ChequeSalesDaily)); cboReportType.Items.Add(new ListItem(ReportTypes.ChequeSalesMonthly, ReportTypes.ChequeSalesMonthly)); cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.CreditCardSalesDaily, ReportTypes.CreditCardSalesDaily)); cboReportType.Items.Add(new ListItem(ReportTypes.CreditCardSalesMonthly, ReportTypes.CreditCardSalesMonthly)); cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.DailySalesTransaction, ReportTypes.DailySalesTransaction)); cboReportType.Items.Add(new ListItem(ReportTypes.WeeklySalesTransaction, ReportTypes.WeeklySalesTransaction)); cboReportType.Items.Add(new ListItem(ReportTypes.MonthlySalesTransaction, ReportTypes.MonthlySalesTransaction)); } if (clsAccessRights.Details(UID, (int)AccessTypes.PaidOutDisburseROC).Read) { cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR)); cboReportType.Items.Add(new ListItem(ReportTypes.PaidOut, ReportTypes.PaidOut)); cboReportType.Items.Add(new ListItem(ReportTypes.Disburse, ReportTypes.Disburse)); cboReportType.Items.Add(new ListItem(ReportTypes.RecieveOnAccount, ReportTypes.RecieveOnAccount)); } cboReportType.SelectedIndex = 0; clsAccessRights.CommitAndDispose(); cboConsignment.Items.Clear(); cboConsignment.Items.Add(new ListItem("Both", "-1")); cboConsignment.Items.Add(new ListItem("Yes", true.ToString())); cboConsignment.Items.Add(new ListItem("No", false.ToString())); cboTransactionStatus.Items.Clear(); foreach(string status in Enum.GetNames(typeof(TransactionStatus))) { cboTransactionStatus.Items.Add(new ListItem(status, status)); } cboTransactionStatus.SelectedIndex = cboTransactionStatus.Items.IndexOf( cboTransactionStatus.Items.FindByText(TransactionStatus.NotYetApplied.ToString())); cboPaymentType.Items.Clear(); foreach(string PaymentType in Enum.GetNames(typeof(PaymentTypes))) { cboPaymentType.Items.Add(new ListItem(PaymentType, PaymentType)); } cboPaymentType.SelectedIndex = cboPaymentType.Items.IndexOf( cboPaymentType.Items.FindByText(PaymentTypes.NotYetAssigned.ToString())); txtStartValidityDate.Text = Common.ToShortDateString(DateTime.Now); txtEndValidityDate.Text = Common.ToShortDateString(DateTime.Now.AddDays(30)); txtStartTransactionDate.Text = Common.ToShortDateString(DateTime.Now.AddDays(-1)); txtEndTransactionDate.Text = Common.ToShortDateString(DateTime.Now); Customer clsCustomer = new Customer(); cboContactName.DataTextField = "ContactName"; cboContactName.DataValueField = "ContactID"; cboContactName.DataSource = clsCustomer.CustomersDataTable(txtContactName.Text, 0, false, "ContactName", SortOption.Ascending); cboContactName.DataBind(); if (string.IsNullOrEmpty(txtContactName.Text)) cboContactName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); else cboContactName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtContactName.Text, Constants.ZERO_STRING)); cboContactName.SelectedIndex = 0; ContactGroups clsContactGroups = new ContactGroups(clsCustomer.Connection, clsCustomer.Transaction); cboContactGroupName.DataTextField = "ContactGroupName"; cboContactGroupName.DataValueField = "ContactGroupID"; cboContactGroupName.DataSource = clsContactGroups.ListAsDataTable(ContactGroupCategory.CUSTOMER, txtContactGroupName.Text); cboContactGroupName.DataBind(); if (string.IsNullOrEmpty(txtContactName.Text)) cboContactGroupName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); else cboContactGroupName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtContactGroupName.Text, Constants.ZERO_STRING)); cboContactGroupName.SelectedIndex = 0; cboAgent.Items.Clear(); Contacts clsContact = new Contacts(clsCustomer.Connection, clsCustomer.Transaction); cboAgent.DataTextField = "ContactName"; cboAgent.DataValueField = "ContactID"; cboAgent.DataSource = clsContact.AgentsAsDataTable(txtAgent.Text, 0, "ContactName", SortOption.Ascending); cboAgent.DataBind(); if (string.IsNullOrEmpty(txtAgent.Text)) cboAgent.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); else cboAgent.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtAgent.Text, Constants.ZERO_STRING)); cboAgent.SelectedIndex = 0; Terminal clsTerminal = new Terminal(clsCustomer.Connection, clsCustomer.Transaction); cboTerminalNo.DataTextField = "TerminalNo"; cboTerminalNo.DataValueField = "TerminalNo"; cboTerminalNo.DataSource = clsTerminal.ListAsDataTable(); cboTerminalNo.DataBind(); cboTerminalNo.Items.Insert(0, new ListItem(Constants.ALL, Constants.ALL)); cboTerminalNo.SelectedIndex = 0; Branch clsBranch = new Branch(clsCustomer.Connection, clsCustomer.Transaction); cboBranch.DataTextField = "BranchCode"; cboBranch.DataValueField = "BranchID"; cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView; cboBranch.DataBind(); cboBranch.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); cboBranch.SelectedIndex = 0; Security.AccessUser clsAccessUser = new Security.AccessUser(clsCustomer.Connection, clsCustomer.Transaction); cboCashierName.DataTextField = "Name"; cboCashierName.DataValueField = "UID"; cboCashierName.DataSource = clsAccessUser.Cashiers(txtCashierName.Text, 0); cboCashierName.DataBind(); if (string.IsNullOrEmpty(txtCashierName.Text)) cboCashierName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); else cboCashierName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtCashierName.Text, Constants.ZERO_STRING)); cboCashierName.SelectedIndex = 0; ProductGroup clsProductGroup = new ProductGroup(clsCustomer.Connection, clsCustomer.Transaction); cboProductGroup.DataTextField = "ProductGroupName"; cboProductGroup.DataValueField = "ProductGroupName"; cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName"); cboProductGroup.DataBind(); cboProductGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); cboProductGroup.SelectedIndex = 0; clsCustomer.CommitAndDispose(); #region Sales Per Day cboMonth.Items.Add(new ListItem("January", "1")); cboMonth.Items.Add(new ListItem("February", "2")); cboMonth.Items.Add(new ListItem("March", "3")); cboMonth.Items.Add(new ListItem("April", "4")); cboMonth.Items.Add(new ListItem("May", "5")); cboMonth.Items.Add(new ListItem("June", "6")); cboMonth.Items.Add(new ListItem("July", "7")); cboMonth.Items.Add(new ListItem("August", "8")); cboMonth.Items.Add(new ListItem("September", "9")); cboMonth.Items.Add(new ListItem("October", "10")); cboMonth.Items.Add(new ListItem("November", "11")); cboMonth.Items.Add(new ListItem("Decemeber", "12")); cboMonth.SelectedIndex = DateTime.Now.Month - 1; int x = 2007; while (x <= DateTime.Now.Year) { cboYear.Items.Add(new ListItem(x.ToString(), x.ToString())); x++; } cboYear.SelectedIndex = cboYear.Items.Count - 1; #endregion }
private void LoadList() { Terminal clsTerminal = new Terminal(); string SortField = "TerminalNo"; 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); } string SearchKey = ""; if (Request.QueryString["Search"]!=null) { SearchKey = Common.Decrypt((string)Request.QueryString["search"],Session.SessionID); } PageData.DataSource = clsTerminal.ListAsDataTable(SearchKey, SortField, sortoption).DefaultView; clsTerminal.CommitAndDispose(); 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; }
public void GenerateItemsForReorderByRID(Int32 TerminalID, long POID, long RID, DateTime IDC_StartDate, DateTime IDC_EndDate) { try { GetConnection(); Terminal clsTerminal = new Terminal(base.Connection, base.Transaction); TerminalDetails clsTerminalDetails = clsTerminal.Details(TerminalID); PODetails clsPODetails = Details(POID); Products clsProduct = new Products(base.Connection, base.Transaction); // Aug 26, 2011 :Lemu // Insert UpdateProductReorderOverStockPerSupplier to update the MinThreshold & MaxThreshold using RID before getting the for stocking clsProduct.UpdateProductReorderOverStockPerSupplier(clsPODetails.SupplierID, RID, IDC_StartDate, IDC_EndDate); // end POItem clsPOItem = new POItem(base.Connection, base.Transaction); ProductInventories clsProductInventories = new ProductInventories(base.Connection, base.Transaction); System.Data.DataTable dt = clsProductInventories.ListAsDataTable(BranchID: Constants.BRANCH_ID_MAIN, SupplierID: clsPODetails.SupplierID, ForReorder: 1); foreach (System.Data.DataRow dr in dt.Rows) { if (decimal.Round(Convert.ToDecimal(dr["RIDReorderQty"].ToString())) > 0) { POItemDetails clsDetails = new POItemDetails(); clsDetails.POID = POID; clsDetails.ProductID = Convert.ToInt64(dr["ProductID"].ToString()); clsDetails.ProductCode = dr["ProductCode"].ToString(); clsDetails.BarCode = dr["BarCode"].ToString(); clsDetails.Description = dr["ProductDesc"].ToString(); clsDetails.ProductGroup = dr["ProductGroupCode"].ToString(); clsDetails.ProductSubGroup = dr["ProductSubGroupCode"].ToString(); clsDetails.ProductUnitID = Convert.ToInt32(dr["UnitID"]); clsDetails.ProductUnitCode = dr["UnitName"].ToString(); clsDetails.RID = Convert.ToInt64(dr["RID"]); clsDetails.Quantity = decimal.Round(Convert.ToDecimal(dr["RIDReorderQty"])); clsDetails.UnitCost = Convert.ToDecimal(dr["PurchasePrice"]); clsDetails.Discount = 0; clsDetails.DiscountApplied = 0; clsDetails.DiscountType = DiscountTypes.Percentage; clsDetails.Remarks = "added using auto generation"; decimal amount = clsDetails.Quantity * clsDetails.UnitCost; // Added Sep 27, 2010 4:20PM : for selling information clsDetails.SellingPrice = decimal.Parse(dr["Price"].ToString()); clsDetails.SellingVAT = clsTerminalDetails.VAT; clsDetails.SellingEVAT = clsTerminalDetails.EVAT; clsDetails.SellingLocalTax = clsTerminalDetails.LocalTax; clsDetails.OldSellingPrice = clsDetails.SellingPrice; if (Convert.ToDecimal(dr["VAT"]) > 0) { clsDetails.VatableAmount = amount; clsDetails.EVatableAmount = amount; clsDetails.LocalTax = amount; clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); clsDetails.IsVatable = true; } else { clsDetails.VAT = 0; clsDetails.VatableAmount = 0; clsDetails.EVAT = 0; clsDetails.EVatableAmount = 0; clsDetails.LocalTax = 0; clsDetails.IsVatable = false; } clsDetails.Amount = amount; clsDetails.VariationMatrixID = Convert.ToInt64(dr["MatrixID"]); clsDetails.MatrixDescription = dr["MatrixDescription"].ToString(); clsPOItem.Insert(clsDetails); } } } catch (Exception ex) { throw base.ThrowException(ex); } }