protected void RadGrid1_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
Int32 KasId = 0;
GridEditableItem editedItem = e.Item as GridEditableItem;
UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
Kas kas = new Kas();
KasId = Convert.ToInt32((userControl.FindControl("txtBkuId") as RadTextBox).Text.Trim());
if (kas.LoadByPrimaryKey(KasId))
{
kas.KaName = (userControl.FindControl("txtKaName") as RadTextBox).Text.Trim();
kas.SaldoAwal = Convert.ToDecimal((userControl.FindControl("txtSaldo") as RadTextBox).Text.Trim());
kas.Save();
}
MutasiKasQuery mkQ = new MutasiKasQuery();
mkQ.SelectAll();
mkQ.Where(mkQ.Code == "0.0.1", mkQ.PeriodId == (Int32)HttpContext.Current.Session["_periodeId"]);
MutasiKasCollection mkC = new MutasiKasCollection();
mkC.Load(mkQ);
if (mkC.Count > 0)
{
KasQuery kasQ = new KasQuery();
kasQ.Select(kasQ.SaldoAwal.Sum());
kasQ.Where(kasQ.PeriodeId == (Int32)HttpContext.Current.Session["_periodeId"]);
}
}
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();
}
public bool Load(KasQuery query)
{
this.query = query;
base.InitQuery(this.query);
return(this.Query.Load());
}
private DataTable GetDataTableKas()
{
KasQuery kaQ = new KasQuery();
kaQ.es2.Connection.Name = "LIVE";
kaQ.Select(kaQ.KaCode, kaQ.KaName);
dtKas = kaQ.LoadDataTable();
return dtKas;
}
