private void LoaiBoDatTruoc(int idListTitlePreOrder)
{
//Neu update truoc thi dia lien tuc duoc them vao gay ra loi
List <Disk> lstUpdate = new List <Disk>();
//Xóa detail và cập nhật trạng thái đĩa
foreach (var item in dbDetailPre.GetDetailPreOrders())
{
if (item.IdListTitlePreOrder == idListTitlePreOrder)
{
var disk = dbDisk.GetDisk((int)item.IdDisk);
dbDetailPre.DeleteDetailPreOrder(item.IdDetailPreOrder);
lstUpdate.Add(disk);
}
}
dbListTitlePre.DeleteListTitlePreOrder(idListTitlePreOrder);
foreach (var item in lstUpdate)
{
item.DiskRentalStatus = STATUS_ONSHELF;
dbDisk.UpdateDisk(item);
}
DialogResult result = MessageBox.Show("Hủy Mục Thành Công", "Hủy đặt trước", MessageBoxButtons.OK, MessageBoxIcon.Information);
dbDisk = new DiskBUL();
dbDetailPre = new DetailPreOrderBUL();
LoadView();
}
public FormDanhSachDatTruoc()
{
InitializeComponent();
dbDetailPre = new DetailPreOrderBUL();
dbListTitlePre = new ListTitlePreOrderBUL();
dbTitle = new TitleBUL();
dbDisk = new DiskBUL();
dbCus = new CustomerBUL();
bindingChiTietDatTruoc = new BindingSource();
bindingDSDatTruoc = new BindingSource();
}
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();
}
private void LoadNhungTieuDeDangChoAccept()
{
//Load những cái tiêu đề nào có đĩa đang chờ được accept
var db = dbDetail.GetDetailPreOrders().Where(x => x.Accepted == false)
.Join(dbDisk.GetDisks(), dt => dt.IdDisk, d => d.IdDisk, (dt, d) => new { dt, d })
.Join(dbTitle.GetTitles(), dtd => dtd.d.IdTitle, t => t.IdTitle, (dtd, t) => new { dtd, t }).ToList();
var lstTitle = dbTitle.GetTitles().Where(x => db.Find(k => k.t.IdTitle == x.IdTitle) != null).ToList()
.Join(dbDiskType.GetDiskTypes(), t => t.IdDiskType, dt => dt.IdDiskType, (t, dt) => new TitleOrder {
IdTitle = t.IdTitle, NameTitle = t.NameTitle, TitleType = dt.TypeName
});
bindingDSTilte.DataSource = lstTitle;
dbDetail = new DetailPreOrderBUL();
dbDisk = new DiskBUL();
dbTitle = new TitleBUL();
}
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();
}
private void ThucHienLayDiaDatTruoc()
{
if (txtMaKH.CheckMa() == false)
{
return;
}
DetailPreOrderBUL dbpre = new DetailPreOrderBUL();
int idCustomer = Int32.Parse(txtMaKH.Text.ToString());
for (int i = 0; i < lsvOnHold.Items.Count; i++)
{
if (lsvOnHold.Items[i].Checked)
{
dbRented.AddListRented(ListItemToListRented(lsvOnHold.Items[i]));
}
DetailPreOrder pre = lsvOnHold.Items[i].Tag as DetailPreOrder;
dbpre.DeleteDetailPreOrder(pre.IdDetailPreOrder);
}
AddInfoListView();
}
