private void ConfigToSuccessForm()
{
tablePanel1.Rows[0].Height = tablePanel1.Rows[1].Height;
ExpressionMethod.EditGridView(grvDSTieuDe);
ExpressionMethod.EditGridView(grvDSGanDia);
bindingDSTilte.DataSource = null;
ExpressionMethod.LoadGridControl(grcDSTieuDe, grvDSTieuDe, bindingDSTilte);
ExpressionMethod.LoadGridControl(grc_DSGanDia, grvDSGanDia, bindingDSDatTruoc);
}
private void LoadView()
{
try
{
binding.DataSource = db.GetTitles();
ExpressionMethod.LoadGridControl(grd_TieuDe, grv_TieuDe, binding);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void LoadDuDoanGridView(int idCustomer)
{
var dbAllRented = dbRented.GetListRenteds();
var lstDuDoan = dbAllRented.Where(x => x.IdCustomer == idCustomer && x.StatusOnBill == null && x.ExpectedReturnDate < DateTime.Today).Select(x => new { IdDisk = x.IdDisk, ExpectedReturnDate = x.ExpectedReturnDate })
.Join(dbDisk.GetDisks(), dd => dd.IdDisk, d => d.IdDisk, (dd, d) => new { dd, d })
.Join(dbTitle.GetTitles(), ddd => ddd.d.IdTitle, t => t.IdTitle, (ddd, t) => new{ IdDisk = ddd.dd.IdDisk, ExpectedReturnDate = ddd.dd.ExpectedReturnDate, Title = t.NameTitle });
var bindingDuDoan = new BindingSource();
bindingDuDoan.DataSource = lstDuDoan;
ExpressionMethod.LoadGridControl(grcDuDoan, grvDuDoan, bindingDuDoan);
var lstTreHan = dbAllRented.Where(x => x.IdCustomer == idCustomer && x.StatusOnBill != null && x.StatusOnBill.Equals(STATUS_UNPAID)).Select(x => new{ IdDisk = x.IdDisk, ExpectedReturnDate = x.ExpectedReturnDate, ActualReturnDate = x.ActualReturnDate, LateFee = x.LateFee });
var bindingTreHan = new BindingSource();
bindingTreHan.DataSource = lstTreHan;
ExpressionMethod.LoadGridControl(grcTreHan, grvTreHan, bindingTreHan);
double?phitrehan = 0;
foreach (var item in lstTreHan)
{
phitrehan += item.LateFee;
}
txtTongPhiNo.Text = phitrehan.ToString();
}
private void ReportTitle()
{
var dbBSThueCuaTitle = (from d in dbDisk.GetDisks()
group d by d.IdTitle into titleGroup
select new
{
Title = titleGroup.Key,
SoLuongThue = titleGroup.Where(x => x.DiskRentalStatus.Equals(STATUS_RENTED)).Count(),
SoLuongBSDatTruoc = titleGroup.Where(x => x.DiskRentalStatus.Equals(STATUS_ONHOLD)).Count(),
})
.Join(dbTitle.GetTitles(), bs => bs.Title, t => t.IdTitle, (bs, t) => new { idTitle = t.IdTitle, TitleName = t.NameTitle, SoLuongTrenKe = t.TotalDiskOnShelf, SoLuongThue = bs.SoLuongThue, SoLuongBSDatTruoc = bs.SoLuongBSDatTruoc });
var dbDSDatTruoc = from pre in dbListPre.GetListTitlePreOrders().Where(x => x.StatusProcess.Equals(STATUS_INCOMPLETE))
group pre by pre.IdTitle into preListGroup
select new
{
idTitle = preListGroup.Key,
TongDatTruoc = preListGroup.Sum(x => x.NumberOfDisk)
};
var db = dbBSThueCuaTitle
.GroupJoin(dbDSDatTruoc, bss => bss.idTitle, dt => dt.idTitle, (bss, dt) => new { bss, dt })
.SelectMany(temp => temp.dt.DefaultIfEmpty(), (bs, temp) => new { bs = bs, dt = temp });
List <ReportTitle> lst = new List <ReportTitle>();
foreach (var item in db)
{
int?tongsodattruoc = 0;
if (item.dt != null)
{
tongsodattruoc = item.dt.TongDatTruoc;
}
lst.Add(new ReportTitle {
TitleName = item.bs.bss.TitleName, TongSoBanSao = item.bs.bss.SoLuongThue + item.bs.bss.SoLuongTrenKe + item.bs.bss.SoLuongBSDatTruoc, TongSoBanSaoDuocDatTruoc = tongsodattruoc, TongSoBanSaoDuocThue = item.bs.bss.SoLuongThue, TongSoBanSaoTrongKho = item.bs.bss.SoLuongTrenKe, TongSoDatTruocDangXuLi = item.bs.bss.SoLuongBSDatTruoc
});
}
bindingTitle.DataSource = lst;
ExpressionMethod.LoadGridControl(grcTieuDe, grvTieuDe, bindingTitle);
}
private void LoadView()
{
binding.DataSource = db.GetCustomers();
ExpressionMethod.LoadGridControl(grd_KhachHang, grv_KhachHang, binding);
}
private void LoadView()
{
binding.DataSource = new List <DiskInfoRent>();
ExpressionMethod.LoadGridControl(grdc_DSThueDia, grv_ThueDia, binding);
}
private void LoadView()
{
ReportTitle();
ExpressionMethod.LoadGridControl(grcKH, grvKH, bindingCustomer);
}
private void LoadView()
{
binding.DataSource = db.GetDisks();
ExpressionMethod.LoadGridControl(grdc_CD, grv_CD, binding);
}
private void ConfigToSuccessView()
{
ExpressionMethod.EditGridView(grvDSDatTruoc);
ExpressionMethod.LoadGridControl(grdc_DanhSach, grvDSDatTruoc, bindingDSDatTruoc);
}
private void LoadView()
{
binding.DataSource = db.GetDiskTypes();
ExpressionMethod.LoadGridControl(grd_LoaiDia, grv_LoaiDia, binding);
}
private void LoadView()
{
binding.DataSource = new List <DiskInfoReturn>();
ExpressionMethod.LoadGridControl(grc_TraDia, grv_TraDia, binding);
}
