private void LoadCustomers()
{
using (var ctx = new PhoneStoreManageEntities())
{
var query = from q in ctx.KhachHangs
select new
{
q.MaKH,
q.TenKH,
q.GioiTinh,
q.NgaySinh,
q.SoDienThoai,
q.Email,
q.DiaChi
};
if (txtSearchCus.Text == "")
{
dgvMC.DataSource = query.ToList();
}
else
{
var proc = ctx.pro_SearchCustomers(txtSearchCus.Text);
var result = from pr in proc
join q in query on pr.MaKH equals q.MaKH
select pr;
dgvMC.DataSource = result.ToList();
}
dgvMC.Columns[2].Visible = false;
dgvMC.Columns[6].Visible = false;
dgvMC.Columns[0].HeaderText = "Mã KH";
dgvMC.Columns[1].HeaderText = "Khách hàng";
dgvMC.Columns[3].HeaderText = "Ngày sinh";
dgvMC.Columns[4].HeaderText = "Số đ.thoại";
dgvMC.Columns[5].HeaderText = "Email";
dgvMC.Refresh();
}
}
