private void LoadCustomers() { var customers = db.Customers.OrderByDescending(aa => aa.CustomerId).Take(pageSize).ToList(); var helper = new Helpers.CustomerHelper(); var customerss = helper.CustomerForDataGrid(customers); dataGridView1.DataSource = customerss; dataGridView1.DefaultCellStyle.ForeColor = System.Drawing.Color.Black; }
private void EditCustomer_FormClosing(object sender, FormClosingEventArgs e) { FaridiaIronStoreEntities db1 = new FaridiaIronStoreEntities(); var customers = db1.Customers.OrderByDescending(aa => aa.CustomerId).Take(pageSize).ToList(); var helper = new Helpers.CustomerHelper(); var customerss = helper.CustomerForDataGrid(customers); dataGridView1.DataSource = customerss; dataGridView1.DefaultCellStyle.ForeColor = System.Drawing.Color.Black; }
// event for search button private void button5_Click(object sender, EventArgs e) { if (!(string.IsNullOrEmpty(SearchBox.Text))) { string name = SearchBox.Text; var customers = db.Customers.Where(aa => aa.Name.ToUpper().Contains(name.ToUpper())).ToList(); var helper = new Helpers.CustomerHelper(); var customerss = helper.CustomerForDataGrid(customers); dataGridView1.DataSource = customerss; } }
private void PreviousButton_Click(object sender, EventArgs e) { if (dataGridPage > 1) { dataGridPage--; var customers = db.Customers.OrderByDescending(aa => aa.CustomerId).Skip((dataGridPage - 1) * pageSize).Take(pageSize).ToList(); var helper = new Helpers.CustomerHelper(); var customerss = helper.CustomerForDataGrid(customers); dataGridView1.DataSource = customerss; PageLabel.Text = dataGridPage.ToString() + "/" + totalPages.ToString(); } }