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