protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Load DataSource buat combo Kelompok Anggaran
ViewKelAnggaranCodeCombineNameCollection vkaccnc = new ViewKelAnggaranCodeCombineNameCollection();
vkaccnc.LoadAll();
cmbTransCode.DataSource = vkaccnc;
cmbTransCode.DataTextField = "KaCodeName";
cmbTransCode.DataValueField = "KaCode";
cmbTransCode.DataBind();
//Load DataSource buat combo Kas
KasCollection kasCollection = new KasCollection();
kasCollection.LoadAll();
cmbKasID.DataSource = kasCollection;
cmbKasID.DataTextField = "KaName";
cmbKasID.DataValueField = "KaCode";
cmbKasID.DataBind();
if (Request.QueryString["BKU_ID"] != null)
{
long BkuID = 0;
if (long.TryParse(Request.QueryString["BKU_ID"], out BkuID))
{
Trans trans = new Trans();
if (trans.LoadByPrimaryKey(BkuID))
{
txtTransID.Text = trans.BkuId.ToString();
txtTransNumber.Text = trans.TransNumber;
dtpTransDate.SelectedDate = (DateTime)trans.TransDate;
cmbTransCode.SelectedValue = trans.KaCode;
cmbKasID.SelectedValue = trans.KasId;
txtDescription.Text = trans.Descript;
txtCekBG.Text = trans.CekBgNumber;
txtDebitAmount.Text = trans.DebitAmount.ToString();
txtCreditAmount.Text = trans.CreditAmount.ToString();
}
}
}
else
txtTransNumber.Text = "{AUTO}";
}
}
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();
}
protected void cmdPreview_Click(object sender, EventArgs e)
{
if (dtfStartDate.IsEmpty)
dtfStartDate.SelectedDate = new DateTime(2011, 01, 01);
if (dtfEndDate.IsEmpty)
dtfEndDate.SelectedDate = DateTime.Now;
if (dtfStartDate.SelectedDate > dtfEndDate.SelectedDate)
return;
if (string.IsNullOrEmpty(cmbJenisKasBank.SelectedItem.Value))
{
cmbJenisKasBank.SelectedIndex = 0;
}
//ini untuk saldo awal
KasCollection saldoKas = new KasCollection();
saldoKas.Query.Select(saldoKas.Query.SaldoAwal);
saldoKas.Query.Where(saldoKas.Query.KaCode == cmbJenisKasBank.SelectedItem.Value);
saldoKas.Query.Load();
//hitung total kredit untuk semua transaksi sebelum tanggal awal
TransCollection transtotalCreditCollection = new TransCollection();
transtotalCreditCollection.Query.Select(transtotalCreditCollection.Query.CreditAmount.Sum().Coalesce("0"));
transtotalCreditCollection.Query.Where(transtotalCreditCollection.Query.TransDate < dtfStartDate.SelectedDate & transtotalCreditCollection.Query.KasId == cmbJenisKasBank.SelectedItem.Value);
//transtotalCreditCollection.Query.OrderBy(transtotalCreditCollection.Query.TransNumber.Ascending, transtotalCreditCollection.Query.BkuId.Ascending);
transtotalCreditCollection.Query.Load();
decimal totalCredit = 0;
if (!transtotalCreditCollection[0].CreditAmount.HasValue)
{
totalCredit = 0;
}
else
{
totalCredit = (decimal)transtotalCreditCollection[0].CreditAmount.Value;
}
//hitung total debit untuk semua transaksi sebelum tanggal awal
TransCollection transtotalDebitCollection = new TransCollection();
transtotalDebitCollection.Query.Select(transtotalDebitCollection.Query.DebitAmount.Sum().Coalesce("0"));
transtotalDebitCollection.Query.Where(transtotalDebitCollection.Query.TransDate < dtfStartDate.SelectedDate & transtotalDebitCollection.Query.KasId == cmbJenisKasBank.SelectedItem.Value);
transtotalDebitCollection.Query.Load();
decimal totalDebit = 0;
if (transtotalDebitCollection[0].DebitAmount.HasValue == false)
{
totalDebit = 0;
}
else
{
totalDebit = (decimal)transtotalDebitCollection[0].DebitAmount.Value;
}
//so, Saldo Awal adalah ...
decimal SaldoAwal = 0;
foreach(Kas kkkk in saldoKas)
{
SaldoAwal = (decimal)kkkk.SaldoAwal + totalDebit - totalCredit;
}
//TransQuery transQ = new TransQuery();
string zero = "0";
string zeros = "0.0";
string sawal = "SALDO AWAL";
decimal nol = 0;
DateTime skrg = DateTime.Now;
DateTime startdate = dtfStartDate.SelectedDate;
startdate = startdate.AddDays(-1);
var trans = from t in db.Trans
join k in db.KAs on t.KAS_ID equals k.KA_CODE
where t.TRANS_DATE >= dtfStartDate.SelectedDate && t.TRANS_DATE <= dtfEndDate.SelectedDate && t.KAS_ID == cmbJenisKasBank.SelectedItem.Value
select new { NUMBER = (string)t.TRANS_NUMBER, DATES = (DateTime)t.TRANS_DATE, DESCRIPTS = t.DESCRIPT, CREDIT = (decimal)t.CREDIT_AMOUNT, DEBIT = (decimal)t.DEBIT_AMOUNT, CODES = (String)k.KA_CODE, NAMES = (string)k.KA_NAME };
var Cash = from kas in db.KAs
where kas.KA_CODE == cmbJenisKasBank.SelectedItem.Value
select new { NUMBER = zero, DATES = startdate, DESCRIPTS = sawal, CREDIT = nol, DEBIT = SaldoAwal, CODES = zeros, NAMES = (string)kas.KA_NAME };
var Gab = trans.Union(Cash);
DataTable Gabungan = AnonymousToDataTable.ToDataTable(Gab);
Gabungan.Columns.Add("SALDO", typeof(decimal));
foreach (DataRow dr in Gabungan.Rows)
{
if (dr["DESCRIPTS"].ToString() == sawal)
{
dr["SALDO"] = SaldoAwal;
continue;
}
SaldoAwal = SaldoAwal + (Convert.ToDecimal(dr["DEBIT"])) - (Convert.ToDecimal(dr["CREDIT"]));
dr["SALDO"] = SaldoAwal;
Gabungan.AcceptChanges();
}
RSCM_BKU_web.Report.LaporanKasBank report1 = new RSCM_BKU_web.Report.LaporanKasBank();
report1.DataSource = Gabungan;
ReportViewer1.Report = report1;
ReportViewer1.RefreshReport();
}
virtual public void Combine(KasCollection collection)
{
base.Combine(collection);
}
