Esempio n. 1
0
        private void LoadWaiterData()
        {
            Security.AccessUser clsAccessUser = new Security.AccessUser();

            try
            {
                string searchkey = "" + txtSearch.Text;

                if (searchkey.Length >= 16) // this is the defined no of burnt card no
                {
                    searchkey = searchkey.Replace("%", "").Replace("?", "");

                    //strPassword = searchkey.Remove(0, 10);
                    searchkey = searchkey.Remove(10, searchkey.Length - 10);
                }

                System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending);
                clsAccessUser.CommitAndDispose();

                this.dgStyle.MappingName = dt.TableName;
                dgWaiter.DataSource      = dt;
                dgWaiter.Select(0);
                dgWaiter.CurrentRowIndex = 0;
            }
            catch (IndexOutOfRangeException) {}
            catch (Exception ex)
            {
                clsAccessUser.CommitAndDispose();
                MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Esempio n. 2
0
        private void LoadWaiterData()
        {
            Security.AccessUser clsAccessUser = new Security.AccessUser();

            try
            {
                string searchkey         = "" + txtSearch.Text;
                System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending);
                clsAccessUser.CommitAndDispose();

                dgWaiter.DataSource = dt;
                dgWaiter.Select(0);
                dgWaiter.CurrentRowIndex = 0;
            }
            catch (IndexOutOfRangeException) {}
            catch (Exception ex)
            {
                clsAccessUser.CommitAndDispose();
                MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Esempio n. 3
0
 protected void imgCashierNameSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
 {
     Security.AccessUser clsAccessUser = new Security.AccessUser();
     cboCashierName.DataTextField  = "Name";
     cboCashierName.DataValueField = "UID";
     cboCashierName.DataSource     = clsAccessUser.Cashiers(txtCashierName.Text, 0);
     cboCashierName.DataBind();
     clsAccessUser.CommitAndDispose();
     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;
 }
Esempio n. 4
0
		private void LoadWaiterData()
		{	
			Security.AccessUser clsAccessUser = new Security.AccessUser();

			try
			{
				string searchkey = "" + txtSearch.Text;
                System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending);
                clsAccessUser.CommitAndDispose();

                this.dgStyle.MappingName = dt.TableName;
				dgWaiter.DataSource = dt;
				dgWaiter.Select(0);
				dgWaiter.CurrentRowIndex=0;
			}
			catch (IndexOutOfRangeException){}
			catch (Exception ex)
			{
                clsAccessUser.CommitAndDispose();
				MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); 
			}
		}
Esempio n. 5
0
 protected void imgCashierNameSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
 {
     Security.AccessUser clsAccessUser = new Security.AccessUser();
     cboCashierName.DataTextField = "Name";
     cboCashierName.DataValueField = "UID";
     cboCashierName.DataSource = clsAccessUser.Cashiers(txtCashierName.Text, 0);
     cboCashierName.DataBind();
     clsAccessUser.CommitAndDispose();
     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;            
 }
Esempio n. 6
0
		private void LoadWaiterData()
		{	
			Security.AccessUser clsAccessUser = new Security.AccessUser();

			try
			{
				string searchkey = "" + txtSearch.Text;

                if (searchkey.Length >= 16) // this is the defined no of burnt card no
                {
                    searchkey = searchkey.Replace("%", "").Replace("?", "");

                    //strPassword = searchkey.Remove(0, 10);
                    searchkey = searchkey.Remove(10, searchkey.Length - 10);
                }

                System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending);
                clsAccessUser.CommitAndDispose();

                this.dgStyle.MappingName = dt.TableName;
				dgWaiter.DataSource = dt;
				dgWaiter.Select(0);
				dgWaiter.CurrentRowIndex=0;
			}
			catch (IndexOutOfRangeException){}
			catch (Exception ex)
			{
                clsAccessUser.CommitAndDispose();
				MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); 
			}
		}