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(); }
private DataTable GetDataTableKas() { KasQuery kaQ = new KasQuery(); kaQ.es2.Connection.Name = "LIVE"; kaQ.Select(kaQ.KaCode, kaQ.KaName); dtKas = kaQ.LoadDataTable(); return dtKas; }