/// <summary> /// Join and return a db DiskRent /// </summary> /// <returns></returns> public static List<DiskInfoRent> DBDiskRent() { DiskTypeBUL dbDiskType= new DiskTypeBUL(); TitleBUL dbTitle = new TitleBUL(); DiskBUL dbDisk = new DiskBUL(); List<DiskInfoRent> lst = new List<DiskInfoRent>(); List<Disk> disks = dbDisk.GetDisks(); List<DiskType> diskTypes = dbDiskType.GetDiskTypes(); List<Title> titles = dbTitle.GetTitles(); var db = dbDisk.GetDisks() .Join(dbTitle.GetTitles(), d => d.IdTitle, t => t.IdTitle, (d, t) => new { d, t }) .Join(dbDiskType.GetDiskTypes(), dt => dt.t.IdDiskType, ty => ty.IdDiskType, (dt, ty) => new { dt, ty }) .Select(x => new { IdDisk = x.dt.d.IdDisk, Title = x.dt.t.NameTitle, TypeName = x.ty.TypeName, TimeRented = x.ty.TimeRented, LateFee = x.ty.LateFee, Price = x.ty.Price, DiskRentalStatus = x.dt.d.DiskRentalStatus }).ToList(); foreach (var item in db) lst.Add(new DiskInfoRent { IdDisk = item.IdDisk, LateFee = (int)item.LateFee, Price = (int)item.Price, TimeRented = (int)item.TimeRented, Title = item.Title, TypeName = item.TypeName, DiskRentalStatus = item.DiskRentalStatus }); return lst; }
public FormLoaiDia(string auth) { InitializeComponent(); btn_XacNhan.Enabled = false; this.auth = auth; db = new DiskTypeBUL(); binding = new BindingSource(); }
/// <summary> /// Thêm vào combobox các loại đĩa : Phim và Game /// </summary> /// <param name="cbx"></param> public static void AddToComboBoxKindOfTitle(System.Windows.Forms.ComboBox cbx) { ConfigComboBox(cbx); var lst = new DiskTypeBUL().GetDiskTypes(); cbx.DataSource = lst; cbx.DisplayMember = "TypeName"; cbx.ValueMember = "IdDiskType"; }
public FormLienHeDatTruoc() { InitializeComponent(); dbDetail = new DetailPreOrderBUL(); dbListPreOrder = new ListTitlePreOrderBUL(); dbListPreOrder = new ListTitlePreOrderBUL(); dbTitle = new TitleBUL(); dbDisk = new DiskBUL(); dbDiskType = new DiskTypeBUL(); dbCustomer = new CustomerBUL(); bindingDSTilte = new BindingSource(); bindingDSDatTruoc = new BindingSource(); }