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