void PopulateItemGrid() { DataTable dataTable = new Repository.BaseDao().PopulateDataSourceData(Repository.Queries.ITEM_SELECT_QUERY); itemGridView.DataSource = dataTable; itemGridView.Columns["itemId"].Visible = false; }
void PopulateUnitGrid() { DataTable dataTable = new Repository.BaseDao().PopulateDataSourceData(Repository.Queries.UNIT_SELECT_QUERY); unitGridView.DataSource = dataTable; unitGridView.Columns["unitId"].Visible = false; }
void PopulateUserGrid() { DataTable dataTable = new Repository.BaseDao().PopulateDataSourceData(Repository.Queries.USER_SELECT_QUERY); userGridView.DataSource = dataTable; userGridView.Columns["password"].Visible = false; }
void DelayTextBoxTyping() { IDisposable subscription = Observable .FromEventPattern( h => txtUsername.TextChanged += h, h => txtUsername.TextChanged -= h) .Select(x => txtUsername.Text) .Throttle(TimeSpan.FromMilliseconds(700)) .Select(x => Observable.Start(() => x.ToLower())) .Switch() .ObserveOn(this) .Subscribe(x => { if (Regex.IsMatch(x, @"\s")) { MessageBox.Show("Dont use space in username"); btnAdd.Enabled = false; return; } if (!String.IsNullOrWhiteSpace(x)) { bool isExits = new Repository.BaseDao().IsRecordExits("user_auth", "username", x); if (isExits) { btnAdd.Enabled = false; MessageBox.Show("Username already exists! , Please use another username"); } else { btnAdd.Enabled = true; } } }); }
void PopulateCustomerGrid() { DataTable dataTable = new Repository.BaseDao().PopulateDataSourceData(Repository.Queries.CUSTOMER_SELECT_QUERY); customerGridView.DataSource = dataTable; customerGridView.Columns["customerId"].Visible = false; }
void LoadCustomers() { DataTable dataTable = new Repository.BaseDao().PopulateDataSourceData(Repository.Queries.CUSTOMER_SELECT_QUERY); this.customerCombo.DataSource = dataTable; this.customerCombo.DisplayMember = "name"; this.customerCombo.ValueMember = "customerId"; }
void LoadItems() { DataTable dataTable = new Repository.BaseDao().PopulateDataSourceData(Repository.Queries.ITEM_SELECT_QUERY); this.itemCombo.DataSource = dataTable; this.itemCombo.DisplayMember = "Name"; this.itemCombo.ValueMember = "itemId"; }
bool CheckIfUserExits(Model.User user) { bool isAvailable = new Repository.BaseDao().IsRecordExits("user_auth", "username", txtUsername.Text.Trim()); if (isAvailable) { MessageBox.Show("Username already exists! , Please use another username"); txtUsername.Focus(); txtUsername.Text = ""; } return(isAvailable); }
void PopulateOrderGrid() { DataTable dataTable = new Repository.BaseDao().PopulateDataSourceData(Repository.Queries.ORDER_SELECT_QUERY); dataTable.DefaultView.Sort = "creation_date desc"; orderGridView.DataSource = dataTable; orderGridView.Columns["date"].DefaultCellStyle.Format = "dd-MMM-yyyy"; orderGridView.Columns["orderId"].Visible = false; orderGridView.Columns["customerId"].Visible = false; orderGridView.Columns["itemId"].Visible = false; orderGridView.Columns["creation_date"].Visible = false; orderGridView.Columns["last_modified"].Visible = false; LoadStats(); }