示例#1
0
        private void LoadOptions()
        {
            ContactGroups clsContactGroup = new ContactGroups();

            cboGroup.DataTextField  = "ContactGroupName";
            cboGroup.DataValueField = "ContactGroupID";
            cboGroup.DataSource     = clsContactGroup.ListAsDataTable().DefaultView;
            cboGroup.DataBind();
            cboGroup.SelectedIndex = cboGroup.Items.Count - 1;

            Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboDepartment.DataTextField  = "DepartmentName";
            cboDepartment.DataValueField = "DepartmentID";
            cboDepartment.DataSource     = clsDepartment.ListAsDataTable().DefaultView;
            cboDepartment.DataBind();
            cboDepartment.SelectedIndex = 0;

            Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboPosition.DataTextField  = "PositionName";
            cboPosition.DataValueField = "PositionID";
            cboPosition.DataSource     = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView;
            cboPosition.DataBind();
            cboPosition.SelectedIndex = 0;

            clsContactGroup.CommitAndDispose();
        }
示例#2
0
        private void LoadOptions()
        {
            ContactGroups clsContactGroup = new ContactGroups();

            cboGroup.DataTextField  = "ContactGroupName";
            cboGroup.DataValueField = "ContactGroupID";
            cboGroup.DataSource     = clsContactGroup.ListAsDataTable().DefaultView;
            cboGroup.DataBind();
            cboGroup.SelectedIndex = 0; //cboGroup.Items.Count - 1;
            cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(ContactGroupCategory.CUSTOMER.ToString("d")));

            Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboDepartment.DataTextField  = "DepartmentName";
            cboDepartment.DataValueField = "DepartmentID";
            cboDepartment.DataSource     = clsDepartment.ListAsDataTable().DefaultView;
            cboDepartment.DataBind();
            cboDepartment.SelectedIndex = 0;

            Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboPosition.DataTextField  = "PositionName";
            cboPosition.DataValueField = "PositionID";
            cboPosition.DataSource     = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView;
            cboPosition.DataBind();
            cboPosition.SelectedIndex = 0;

            Salutation clsSalutation = new Salutation(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboSalutation.DataTextField  = "SalutationName";
            cboSalutation.DataValueField = "SalutationCode";
            cboSalutation.DataSource     = clsSalutation.ListAsDataTable().DefaultView;
            cboSalutation.DataBind();
            cboSalutation.SelectedIndex = 0;
            cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue("MR"));

            Contacts clsContacts = new Contacts(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboSoldBy.DataTextField  = "ContactName";
            cboSoldBy.DataValueField = "ContactCode";
            cboSoldBy.DataSource     = clsContacts.AgentsAsDataTable(SortField: "ContactName").DefaultView;
            cboSoldBy.DataBind();
            cboSoldBy.SelectedIndex = 0;

            Security.AccessUser clsAccessUser = new Security.AccessUser(clsContactGroup.Connection, clsContactGroup.Transaction);
            cboConfirmedBy.DataTextField  = "Name";
            cboConfirmedBy.DataValueField = "Name";
            cboConfirmedBy.DataSource     = clsAccessUser.ListAsDataTable(SortField: "Name").DefaultView;
            cboConfirmedBy.DataBind();
            cboConfirmedBy.SelectedIndex = 0;

            Security.Country clsCountry = new Security.Country(clsContactGroup.Connection, clsContactGroup.Transaction);
            cboCountry.DataTextField  = "CountryName";
            cboCountry.DataValueField = "CountryID";
            cboCountry.DataSource     = clsCountry.ListAsDataTable().DefaultView;
            cboCountry.DataBind();
            cboCountry.SelectedIndex = 0;

            clsContactGroup.CommitAndDispose();
        }
示例#3
0
        private void LoadOptions()
        {
            ContactGroups clsContactGroup = new ContactGroups();

            cboGroup.DataTextField  = "ContactGroupName";
            cboGroup.DataValueField = "ContactGroupID";
            cboGroup.DataSource     = clsContactGroup.ListAsDataTable(ContactGroupCategory.CUSTOMER).DefaultView;
            cboGroup.DataBind();
            cboGroup.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, "0"));
            cboGroup.SelectedIndex = 0;

            clsContactGroup.CommitAndDispose();

            cboModeOfTerms.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, "-1"));
            cboModeOfTerms.SelectedIndex = 0;
        }
示例#4
0
        private void LoadOptions()
        {
            cboReportType.Items.Clear();
            cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION));
            cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
            cboReportType.Items.Add(new ListItem(ReportTypes.CustomerCredit, ReportTypes.CustomerCredit));
            cboReportType.Items.Add(new ListItem(ReportTypes.CustomerCreditBill, ReportTypes.CustomerCreditBill));
            cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
            cboReportType.Items.Add(new ListItem(ReportTypes.CustomerCreditListWCredit, ReportTypes.CustomerCreditListWCredit));
            cboReportType.Items.Add(new ListItem(ReportTypes.CustomerCreditListLatestBill, ReportTypes.CustomerCreditListLatestBill));
            cboReportType.SelectedIndex = 0;

            Customer clsCustomer = new Customer();

            cboContactName.DataTextField  = "ContactName";
            cboContactName.DataValueField = "ContactID";
            cboContactName.DataSource     = clsCustomer.CustomersDataTable(txtContactName.Text, 0, true, "ContactName", SortOption.Ascending);
            cboContactName.DataBind();
            cboContactName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
            if (cboContactName.Items.Count > 1 && txtContactName.Text.Trim() != string.Empty)
            {
                cboContactName.SelectedIndex = 1;
            }
            else
            {
                cboContactName.SelectedIndex = 0;
            }

            ContactGroups clsContactGroup = new ContactGroups(clsCustomer.Connection, clsCustomer.Transaction);

            cboCustomerGroup.DataTextField  = "ContactGroupName";
            cboCustomerGroup.DataValueField = "ContactGroupCode";
            cboCustomerGroup.DataSource     = clsContactGroup.ListAsDataTable(ContactGroupCategory.CUSTOMER);
            cboCustomerGroup.DataBind();
            cboCustomerGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
            if (cboCustomerGroup.Items.Count > 1 && txtCustomerGroup.Text.Trim() != string.Empty)
            {
                cboCustomerGroup.SelectedIndex = 1;
            }
            else
            {
                cboCustomerGroup.SelectedIndex = 0;
            }

            clsCustomer.CommitAndDispose();
        }
示例#5
0
        protected void imgCustomerGroupSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            ContactGroups clsContactGroup = new ContactGroups();

            cboCustomerGroup.DataTextField  = "ContactGroupName";
            cboCustomerGroup.DataValueField = "ContactGroupCode";
            cboCustomerGroup.DataSource     = clsContactGroup.ListAsDataTable(ContactGroupCategory.CUSTOMER, txtCustomerGroup.Text.TrimEnd());
            cboCustomerGroup.DataBind();
            cboCustomerGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
            if (cboCustomerGroup.Items.Count > 1 && txtCustomerGroup.Text.Trim() != string.Empty)
            {
                cboCustomerGroup.SelectedIndex = 1;
            }
            else
            {
                cboCustomerGroup.SelectedIndex = 0;
            }
            clsContactGroup.CommitAndDispose();
        }
示例#6
0
        //protected void imgTerminalNoSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        //{
        //    Terminal clsTerminal = new Terminal();
        //    cboTerminalNo.DataTextField = "TerminalNo";
        //    cboTerminalNo.DataValueField = "TerminalNo";
        //    cboTerminalNo.DataSource = clsTerminal.ListAsDataTable(txtTerminalNo.Text);
        //    cboTerminalNo.DataBind();
        //    cboTerminalNo.Items.Insert(0, new ListItem(Constants.ALL, Constants.ALL));
        //    if (cboTerminalNo.Items.Count > 1 && txtTerminalNo.Text.Trim() != string.Empty) cboTerminalNo.SelectedIndex = 1; else cboTerminalNo.SelectedIndex = 0;
        //    clsTerminal.CommitAndDispose();
        //}

        protected void imgContactGroupNameSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            ContactGroups clsContactGroups = new ContactGroups();

            cboContactGroupName.DataTextField  = "ContactGroupName";
            cboContactGroupName.DataValueField = "ContactGroupID";
            cboContactGroupName.DataSource     = clsContactGroups.ListAsDataTable(ContactGroupCategory.CUSTOMER, txtContactGroupName.Text);
            cboContactGroupName.DataBind();
            clsContactGroups.CommitAndDispose();
            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;
        }
示例#7
0
        private void LoadOptions()
        {
            ContactGroups clsContactGroup = new ContactGroups();

            cboGroup.DataTextField  = "ContactGroupName";
            cboGroup.DataValueField = "ContactGroupID";
            cboGroup.DataSource     = clsContactGroup.ListAsDataTable(ContactGroupCategory.CUSTOMER).DefaultView;
            cboGroup.DataBind();
            cboGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
            cboGroup.SelectedIndex = 0;

            cboBirthMonth.Items.Add(new ListItem(Constants.ALL, Constants.ZERO_STRING));
            cboBirthMonth.Items.Add(new ListItem("January", "1"));
            cboBirthMonth.Items.Add(new ListItem("February", "2"));
            cboBirthMonth.Items.Add(new ListItem("March", "3"));
            cboBirthMonth.Items.Add(new ListItem("April", "4"));
            cboBirthMonth.Items.Add(new ListItem("May", "5"));
            cboBirthMonth.Items.Add(new ListItem("June", "6"));
            cboBirthMonth.Items.Add(new ListItem("July", "7"));
            cboBirthMonth.Items.Add(new ListItem("August", "8"));
            cboBirthMonth.Items.Add(new ListItem("September", "9"));
            cboBirthMonth.Items.Add(new ListItem("October", "10"));
            cboBirthMonth.Items.Add(new ListItem("November", "11"));
            cboBirthMonth.Items.Add(new ListItem("December", "12"));
            cboBirthMonth.SelectedIndex = DateTime.Now.Month;

            cboAnniversaryMonth.Items.Add(new ListItem(Constants.ALL, Constants.ZERO_STRING));
            cboAnniversaryMonth.Items.Add(new ListItem("January", "1"));
            cboAnniversaryMonth.Items.Add(new ListItem("February", "2"));
            cboAnniversaryMonth.Items.Add(new ListItem("March", "3"));
            cboAnniversaryMonth.Items.Add(new ListItem("April", "4"));
            cboAnniversaryMonth.Items.Add(new ListItem("May", "5"));
            cboAnniversaryMonth.Items.Add(new ListItem("June", "6"));
            cboAnniversaryMonth.Items.Add(new ListItem("July", "7"));
            cboAnniversaryMonth.Items.Add(new ListItem("August", "8"));
            cboAnniversaryMonth.Items.Add(new ListItem("September", "9"));
            cboAnniversaryMonth.Items.Add(new ListItem("October", "10"));
            cboAnniversaryMonth.Items.Add(new ListItem("November", "11"));
            cboAnniversaryMonth.Items.Add(new ListItem("December", "12"));
            cboAnniversaryMonth.SelectedIndex = 0;
        }
示例#8
0
        private void LoadOptions()
        {
            lblContactID.Text = Common.Decrypt(Request.QueryString["id"], Session.SessionID);

            ContactGroups clsContactGroup = new ContactGroups();

            cboGroup.DataTextField  = "ContactGroupName";
            cboGroup.DataValueField = "ContactGroupID";
            cboGroup.DataSource     = clsContactGroup.ListAsDataTable().DefaultView;
            cboGroup.DataBind();
            cboGroup.SelectedIndex = cboGroup.Items.Count - 1;

            Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboDepartment.DataTextField  = "DepartmentName";
            cboDepartment.DataValueField = "DepartmentID";
            cboDepartment.DataSource     = clsDepartment.ListAsDataTable("DepartmentName", SortOption.Ascending, 0).DefaultView;
            cboDepartment.DataBind();
            cboDepartment.SelectedIndex = 0;

            Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboPosition.DataTextField  = "PositionName";
            cboPosition.DataValueField = "PositionID";
            cboPosition.DataSource     = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView;
            cboPosition.DataBind();
            cboPosition.SelectedIndex = 0;


            Billing clsBilling = new Billing(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboBillingDate.DataTextField  = "BillingDate";
            cboBillingDate.DataValueField = "BillingFile";
            cboBillingDate.DataSource     = clsBilling.ListBillingDateAsDataTable(long.Parse(lblContactID.Text)).DefaultView;
            cboBillingDate.DataBind();
            cboBillingDate.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.PLEASE_SELECT));
            cboBillingDate.SelectedIndex = 0;

            clsContactGroup.CommitAndDispose();
        }
示例#9
0
        private void LoadOptions()
        {
            Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));

            lblContactID.Text = iID.ToString();

            ContactGroups clsContactGroup = new ContactGroups();

            cboGroup.DataTextField  = "ContactGroupName";
            cboGroup.DataValueField = "ContactGroupID";
            cboGroup.DataSource     = clsContactGroup.ListAsDataTable(ContactGroupCategory.CUSTOMER).DefaultView;
            cboGroup.DataBind();
            cboGroup.SelectedIndex = cboGroup.Items.Count - 1;

            Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboDepartment.DataTextField  = "DepartmentName";
            cboDepartment.DataValueField = "DepartmentID";
            cboDepartment.DataSource     = clsDepartment.ListAsDataTable().DefaultView;
            cboDepartment.DataBind();
            cboDepartment.SelectedIndex = 0;

            Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboPosition.DataTextField  = "PositionName";
            cboPosition.DataValueField = "PositionID";
            cboPosition.DataSource     = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView;
            cboPosition.DataBind();
            cboPosition.SelectedIndex = 0;

            cboCreditCardStatus.Items.Clear();
            foreach (CreditCardStatus selection in Enum.GetValues(typeof(CreditCardStatus)))
            {
                cboCreditCardStatus.Items.Add(new ListItem(selection.ToString("G"), selection.ToString("d")));
            }
            cboCreditCardStatus.SelectedIndex = cboCreditCardStatus.Items.IndexOf(cboCreditCardStatus.Items.FindByValue(CreditCardStatus.All.ToString("d")));

            Data.CardType clsCardType = new Data.CardType(clsContactGroup.Connection, clsContactGroup.Transaction);
            cboCreditCardType.Items.Clear();
            cboCreditCardType.DataTextField  = "CardTypeName";
            cboCreditCardType.DataValueField = "CardTypeID";
            cboCreditCardType.DataSource     = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal)).DefaultView;
            cboCreditCardType.DataBind();
            cboCreditCardType.SelectedIndex = 0;

            Billing clsBilling = new Billing(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboBillingDate.DataTextField  = "BillingDate";
            cboBillingDate.DataValueField = "BillingFile";
            cboBillingDate.DataSource     = clsBilling.ListBillingDateAsDataTable(CreditType.Group, long.Parse(lblContactID.Text), limit: 10).DefaultView;
            cboBillingDate.DataBind();
            cboBillingDate.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.PLEASE_SELECT));
            cboBillingDate.SelectedIndex = 0;

            Salutation clsSalutation = new Salutation(clsContactGroup.Connection, clsContactGroup.Transaction);

            cboSalutation.DataTextField  = "SalutationName";
            cboSalutation.DataValueField = "SalutationCode";
            cboSalutation.DataSource     = clsSalutation.ListAsDataTable().DefaultView;
            cboSalutation.DataBind();
            cboSalutation.SelectedIndex = 0;
            cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue("MR"));

            clsContactGroup.CommitAndDispose();

            if (Request.QueryString["showbills"] != null)
            {
                if (!bool.Parse(Common.Decrypt(Request.QueryString["showbills"].ToString(), Session.SessionID)))
                {
                    lblBillingSeparator.Visible = false;
                    labelBilling.Visible        = false;
                    cboBillingDate.Visible      = false;
                    imgPrintBilling.Visible     = false;
                    cmdPrintBilling.Visible     = false;
                }
            }
        }
示例#10
0
        private void LoadOptions()
        {
            cboReportType.Items.Clear();
            cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION));
            cboReportType.Items.Add(new ListItem(ReportTypes.ANALYTICS_All, ReportTypes.ANALYTICS_All));
            cboReportType.Items.Add(new ListItem(ReportTypes.ANALYTICS_All_Covers, ReportTypes.ANALYTICS_All_Covers));
            cboReportType.Items.Add(new ListItem(ReportTypes.ANALYTICS_ItemsForPOBasedOnSales, ReportTypes.ANALYTICS_ItemsForPOBasedOnSales));
            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;

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