private void LoadOptions() { DataClass clsDataClass = new DataClass(); lblGroupID.Text = Common.Decrypt((string)Request.QueryString["groupid"], Session.SessionID); lblMatrixID.Text = Common.Decrypt(Request.QueryString["id"], Session.SessionID); ProductGroupVariations clsProductGroupVariation = new ProductGroupVariations(); lstItem.DataSource = clsDataClass.DataReaderToDataTable(clsProductGroupVariation.List(Convert.ToInt32(lblGroupID.Text), "VariationType", SortOption.Ascending)).DefaultView; lstItem.DataBind(); clsProductGroupVariation.CommitAndDispose(); Data.Unit clsUnit = new Data.Unit(); cboUnit.DataTextField = "UnitName"; cboUnit.DataValueField = "UnitID"; cboUnit.DataSource = clsUnit.ListAsDataTable(SortField: "UnitName").DefaultView; cboUnit.DataBind(); cboUnit.SelectedIndex = cboUnit.Items.Count - 1; clsUnit.CommitAndDispose(); ProductGroup clsProductGroup = new ProductGroup(); ProductGroupDetails clsProductGroupDetails = clsProductGroup.Details(Convert.ToInt32(lblGroupID.Text)); cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsProductGroupDetails.UnitDetails.UnitID.ToString())); txtProductPrice.Text = clsProductGroupDetails.Price.ToString("#,##0.#0"); txtPurchasePrice.Text = clsProductGroupDetails.PurchasePrice.ToString("#,##0.#0"); chkIncludeInSubtotalDiscount.Checked = clsProductGroupDetails.IncludeInSubtotalDiscount; txtVAT.Text = clsProductGroupDetails.VAT.ToString("#,##0.#0"); txtEVAT.Text = clsProductGroupDetails.EVAT.ToString("#,##0.#0"); txtLocalTax.Text = clsProductGroupDetails.LocalTax.ToString("#,##0.#0"); }
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; 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; 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() { 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; 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; 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() { DataClass clsDataClass = new DataClass(); Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID)); Data.Unit clsUnit = new Data.Unit(); cboProductGroupUnit.DataTextField = "UnitName"; cboProductGroupUnit.DataValueField = "UnitID"; cboProductGroupUnit.DataSource = clsUnit.ListAsDataTable().DefaultView; cboProductGroupUnit.DataBind(); cboProductGroupUnit.SelectedIndex = cboProductGroupUnit.Items.Count - 1; clsUnit.CommitAndDispose(); ProductGroupUnitsMatrix clsUnitMatrix = new ProductGroupUnitsMatrix(); ProductGroupUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(iID); clsUnitMatrix.CommitAndDispose(); if (clsUnitDetails.BottomUnitName == null) { cboProductGroupUnit.Enabled = true; } }
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 LoadOptions() { Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"],Session.SessionID)); 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; clsUnit.CommitAndDispose(); }
private void LoadOptions() { Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID)); 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; clsUnit.CommitAndDispose(); }
private void LoadOptions() { DataClass clsDataClass = new DataClass(); 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; 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; //// Added July 9, 2010 // Remove Nov 22, 2011 - overwritten when a subgroup is selected //Terminal clsTerminal = new Terminal(clsProductGroup.Connection, clsProductGroup.Transaction); //TerminalDetails clsTerminalDetails = clsTerminal.Details(1); //txtWSPriceMarkUp.Text = clsTerminalDetails.WSPriceMarkUp.ToString(); //txtMargin.Text = clsTerminalDetails.RETPriceMarkUp.ToString(); //txtVAT.Text = clsTerminalDetails.VAT.ToString("###.#0"); //txtEVAT.Text = clsTerminalDetails.EVAT.ToString("###.#0"); //txtLocalTax.Text = clsTerminalDetails.LocalTax.ToString("###.#0"); clsProductGroup.CommitAndDispose(); cboProductGroup_SelectedIndexChanged(null, null); }
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 LoadOptions() { DataClass clsDataClass = new DataClass(); lblSubGroupID.Text = Common.Decrypt((string)Request.QueryString["subgroupid"], Session.SessionID); lblMatrixID.Text = Common.Decrypt(Request.QueryString["id"], Session.SessionID); ProductSubGroupVariations clsProductSubGroupVariation = new ProductSubGroupVariations(); lstItem.DataSource = clsDataClass.DataReaderToDataTable(clsProductSubGroupVariation.List(Convert.ToInt32(lblSubGroupID.Text), "VariationType", SortOption.Ascending)).DefaultView; lstItem.DataBind(); clsProductSubGroupVariation.CommitAndDispose(); Data.Unit clsUnit = new Data.Unit(); cboUnit.DataTextField = "UnitName"; cboUnit.DataValueField = "UnitID"; cboUnit.DataSource = clsUnit.ListAsDataTable(SortField: "UnitName").DefaultView; cboUnit.DataBind(); cboUnit.SelectedIndex = cboUnit.Items.Count - 1; clsUnit.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() { 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 LoadOptions() { DataClass clsDataClass = new DataClass(); lblGroupID.Text = Common.Decrypt((string)Request.QueryString["groupid"],Session.SessionID); lblMatrixID.Text = Common.Decrypt(Request.QueryString["id"],Session.SessionID); ProductGroupVariations clsProductGroupVariation = new ProductGroupVariations(); lstItem.DataSource = clsDataClass.DataReaderToDataTable(clsProductGroupVariation.List(Convert.ToInt32(lblGroupID.Text),"VariationType",SortOption.Ascending)).DefaultView; lstItem.DataBind(); clsProductGroupVariation.CommitAndDispose(); Data.Unit clsUnit = new Data.Unit(); cboUnit.DataTextField = "UnitName"; cboUnit.DataValueField = "UnitID"; cboUnit.DataSource = clsUnit.ListAsDataTable(SortField:"UnitName").DefaultView; cboUnit.DataBind(); cboUnit.SelectedIndex = cboUnit.Items.Count - 1; clsUnit.CommitAndDispose(); ProductGroup clsProductGroup = new ProductGroup(); ProductGroupDetails clsProductGroupDetails = clsProductGroup.Details(Convert.ToInt32(lblGroupID.Text)); cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsProductGroupDetails.UnitDetails.UnitID.ToString())); txtProductPrice.Text = clsProductGroupDetails.Price.ToString("#,##0.#0"); txtPurchasePrice.Text = clsProductGroupDetails.PurchasePrice.ToString("#,##0.#0"); chkIncludeInSubtotalDiscount.Checked = clsProductGroupDetails.IncludeInSubtotalDiscount; txtVAT.Text = clsProductGroupDetails.VAT.ToString("#,##0.#0"); txtEVAT.Text = clsProductGroupDetails.EVAT.ToString("#,##0.#0"); txtLocalTax.Text = clsProductGroupDetails.LocalTax.ToString("#,##0.#0"); }
private void LoadOptions() { DataClass clsDataClass = new DataClass(); lblSubGroupID.Text = Common.Decrypt((string)Request.QueryString["subgroupid"],Session.SessionID); lblMatrixID.Text = Common.Decrypt(Request.QueryString["id"],Session.SessionID); ProductSubGroupVariations clsProductSubGroupVariation = new ProductSubGroupVariations(); lstItem.DataSource = clsDataClass.DataReaderToDataTable(clsProductSubGroupVariation.List(Convert.ToInt32(lblSubGroupID.Text),"VariationType",SortOption.Ascending)).DefaultView; lstItem.DataBind(); clsProductSubGroupVariation.CommitAndDispose(); Data.Unit clsUnit = new Data.Unit(); cboUnit.DataTextField = "UnitName"; cboUnit.DataValueField = "UnitID"; cboUnit.DataSource = clsUnit.ListAsDataTable(SortField:"UnitName").DefaultView; cboUnit.DataBind(); cboUnit.SelectedIndex = cboUnit.Items.Count - 1; clsUnit.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() { DataClass clsDataClass = new DataClass(); 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; 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; //// Added July 9, 2010 // Remove Nov 22, 2011 - overwritten when a subgroup is selected //Terminal clsTerminal = new Terminal(clsProductGroup.Connection, clsProductGroup.Transaction); //TerminalDetails clsTerminalDetails = clsTerminal.Details(1); //txtWSPriceMarkUp.Text = clsTerminalDetails.WSPriceMarkUp.ToString(); //txtMargin.Text = clsTerminalDetails.RETPriceMarkUp.ToString(); //txtVAT.Text = clsTerminalDetails.VAT.ToString("###.#0"); //txtEVAT.Text = clsTerminalDetails.EVAT.ToString("###.#0"); //txtLocalTax.Text = clsTerminalDetails.LocalTax.ToString("###.#0"); clsProductGroup.CommitAndDispose(); cboProductGroup_SelectedIndexChanged(null, null); }
private void LoadOptions() { DataClass clsDataClass = new DataClass(); Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"],Session.SessionID)); Data.Unit clsUnit = new Data.Unit(); cboProductGroupUnit.DataTextField = "UnitName"; cboProductGroupUnit.DataValueField = "UnitID"; cboProductGroupUnit.DataSource = clsUnit.ListAsDataTable().DefaultView; cboProductGroupUnit.DataBind(); cboProductGroupUnit.SelectedIndex = cboProductGroupUnit.Items.Count - 1; clsUnit.CommitAndDispose(); ProductGroupUnitsMatrix clsUnitMatrix = new ProductGroupUnitsMatrix(); ProductGroupUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(iID); clsUnitMatrix.CommitAndDispose(); if (clsUnitDetails.BottomUnitName == null) { cboProductGroupUnit.Enabled = true; } }
private void LoadList() { Data.Unit clsUnit = new Data.Unit(); DataClass clsDataClass = new DataClass(); string SortField = "UnitName"; 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 = clsUnit.ListAsDataTable(SearchKey, SortField: SortField, SortOrder: sortoption).DefaultView; clsUnit.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; }
private void LoadList() { Data.Unit clsUnit = new Data.Unit(); DataClass clsDataClass = new DataClass(); string SortField = "UnitName"; 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 = clsUnit.ListAsDataTable(SearchKey, SortField: SortField, SortOrder: sortoption).DefaultView; clsUnit.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; }