protected void btnPreview_Click(object sender, EventArgs e)
{
if (dtpStartDate.SelectedDate > dtpEndDate.SelectedDate || dtpStartDate.SelectedDate > DateTime.Now)
{
return;
}
if (dtpEndDate.SelectedDate.ToString().Trim() == string.Empty)
{
return;
}
if ((dtpStartDate.SelectedDate.ToString().Trim() == string.Empty))
{
dtpStartDate.SelectedDate = dtpStartDate.MinDate;
}
//Load All Valid Kas
KasQuery kasQ = new KasQuery("a");
PeriodeAnggaranQuery paQ = new PeriodeAnggaranQuery("b");
kasQ.InnerJoin(paQ).On(kasQ.PeriodeId == paQ.Id);
kasQ.Select(kasQ.KaCode, kasQ.KaName);
paQ.Where(paQ.IsClosed == false);
KasCollection kasC = new KasCollection();
kasC.Load(kasQ);
ReportBook rb = new ReportBook();
foreach (Kas k in kasC)
{
TransQuery tQ = new TransQuery("c");
tQ.Select(tQ.TransNumber, tQ.TransDate, tQ.Descript, tQ.DebitAmount, tQ.CreditAmount);
tQ.Where(tQ.TransDate >= dtpStartDate.SelectedDate, tQ.TransDate <= dtpEndDate.SelectedDate, tQ.KasId == k.KaCode);
TransCollection tColl = new TransCollection();
tColl.Load(tQ);
if (tColl.Count > 0)
{
RSCM_BKU_web.Report.LaporanKasBank report1 = new RSCM_BKU_web.Report.LaporanKasBank();
report1.ReportParameters[0].Value = k.KaName;
report1.ReportParameters[1].Value = dtpStartDate.SelectedDate;
report1.ReportParameters[2].Value = dtpEndDate.SelectedDate;
report1.DataSource = tColl;
rb.Reports.Add(report1);
}
}
//ReportViewer1.Report = rb;
//ReportViewer1.RefreshReport();
}
/// <summary>
/// Called when a upload ticket reply is received.
/// </summary>
public void OnUploadTicketReply(KasQuery query)
{
Logging.Log("Upload ticket received.");
AnpMsg m = query.Res;
ValidateTicketReply(m, true);
// Pass the ticket to the upload manager.
if (UploadManager.Status == UploadManagerStatus.Ticket) UploadManager.OnTicket(m);
// Pass the ticket to the meta-data manager.
else if (MetaDataManager.Status == MetaDataManagerStatus.Ticket) MetaDataManager.OnTicket(m);
// We do not need the ticket anymore.
else Logging.Log("Discarded unneeded upload ticket");
}
/// <summary>
/// Called when a download ticket reply is received.
/// </summary>
public void OnDownloadTicketReply(KasQuery query)
{
Logging.Log("Download ticket received.");
AnpMsg m = query.Res;
ValidateTicketReply(m, false);
// Pass the ticket to the download manager.
if (DownloadManager.Status == DownloadManagerStatus.Ticket) DownloadManager.OnTicket(m);
// We do not need the ticket anymore.
else Logging.Log("Discarded unneeded download ticket");
}
