private void Frm_FormClosing(object sender, FormClosingEventArgs e) { try { binding.DataSource = db.GetCustomers(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoadDataToGridView() { var dbAllRented = dbRented.GetListRenteds(); List <ReportCustomer> lst = new List <ReportCustomer>(); List <Customer> customers = dbCustomer.GetCustomers(); switch (cbx_ThongKeKH.SelectedIndex) { case 1: customers = customers.Where(x => dbAllRented.Find(rt => rt.IdCustomer == x.IdCustomer && rt.ExpectedReturnDate < DateTime.Today && rt.ActualReturnDate == null) != null).ToList(); break; case 2: customers = customers.Where(x => dbAllRented.Find(rt => rt.IdCustomer == x.IdCustomer && rt != null && rt.StatusOnBill != null && rt.StatusOnBill.Equals(STATUS_UNPAID)) != null).ToList(); break; } foreach (var item in customers) { int sodiathue = dbAllRented.Where(x => x.IdCustomer == item.IdCustomer && x.StatusOnBill == null).Count(); lst.Add(new ReportCustomer { Address = item.Address, CustomerName = item.CustomerName, idCustomer = item.IdCustomer, PhoneNumber = item.PhoneNumber, TotalDiskRent = sodiathue }); } bindingCustomer.DataSource = lst; }
private void LoadDanhSachDatTruoc() { // Load những list nào đang imcomplete và những list nào complete nhưng id list vẫn còn ở dưới detail var data = dbListTitlePre.GetListTitlePreOrders().Where(x => x.StatusProcess.Equals(STATUS_INCOMPLETED) || dbDetailPre.GetDetailPreOrders().Find(d => d.IdListTitlePreOrder == x.IdListTitlePreOrder) != null) .Join(dbTitle.GetTitles(), dt => dt.IdTitle, t => t.IdTitle, (dt, t) => new { dt, t }) .Join(dbCus.GetCustomers(), dtt => dtt.dt.IdCustomer, c => c.IdCustomer, (dtt, c) => new MyListTitlePreOrder { IdCustomer = c.IdCustomer, IdListPreOrder = dtt.dt.IdListTitlePreOrder, NameCustomer = c.CustomerName, NameTitle = dtt.t.NameTitle }); bindingDSDatTruoc.DataSource = data; dbListTitlePre = new ListTitlePreOrderBUL(); dbCus = new CustomerBUL(); dbTitle = new TitleBUL(); dbDetailPre = new DetailPreOrderBUL(); }
/// <summary> /// Trả về cái list có return db join từ 3 bảng và thông tin của khách hahgnf đó /// </summary> /// <returns></returns> public static List<DiskInfoReturn> DBDiskReturn() { List<DiskInfoReturn> lst = new List<DiskInfoReturn>(); CustomerBUL dbCustomer = new CustomerBUL(); TitleBUL dbTitle = new TitleBUL(); DiskBUL dbDisk = new DiskBUL(); ListRentedBUL dbRented = new ListRentedBUL(); var db = dbRented.GetListRenteds().Where(x => x.StatusOnBill == null) .Join(dbDisk.GetDisks(), rt => rt.IdDisk, d => d.IdDisk, (rt, d) => new { rt, d }) .Join(dbTitle.GetTitles(), rtd => rtd.d.IdTitle, t => t.IdTitle, (rtd, t) => new { rtd, t }) .Join(dbCustomer.GetCustomers(), rtdt => rtdt.rtd.rt.IdCustomer, c => c.IdCustomer, (rtdt, c) => new { rtdt, c }); foreach (var item in db) { lst.Add(new DiskInfoReturn { Address = item.c.Address, CustomerName = item.c.CustomerName, ExpectedDate = (DateTime)item.rtdt.rtd.rt.ExpectedReturnDate, IdCustomer = (int)item.rtdt.rtd.rt.IdCustomer, IdDisk = (int)item.rtdt.rtd.rt.IdDisk, PhoneNumber = item.c.PhoneNumber, RentedDate = (DateTime)item.rtdt.rtd.rt.RentalDate, Title = item.rtdt.t.NameTitle,IdListRented=item.rtdt.rtd.rt.IdListRented }); } return lst; }