Beispiel #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);
            }
        }
Beispiel #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);
            }
        }
Beispiel #3
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); 
			}
		}
Beispiel #4
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); 
			}
		}