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