protected void Button4_Click(object sender, EventArgs e)
{
try
{
if (Applcn_no.Text != "")
{
var ic_count = Applcn_no.Text.Length;
DataTable app_icno = new DataTable();
app_icno = DBCon.Ora_Execute_table("select app_applcn_no from jpa_application JA where '" + Applcn_no.Text + "' IN(JA.app_applcn_no, JA.app_new_icno)");
if (ic_count == 12)
{
cc_no = app_icno.Rows[0]["app_applcn_no"].ToString();
}
else
{
cc_no = Applcn_no.Text;
}
DataSet ds = new DataSet();
DataTable dtn = new DataTable();
dt = DBCon.Ora_Execute_table("select app_current_jbb_ind,month(getdate()) as cdate,year(getdate()) as cyear from jpa_application where app_applcn_no='" + cc_no + "'");
if (dt.Rows[0][0].ToString().Trim() == "N")
{
dtn = DBCon.Ora_Execute_table("select app_name,app_permnt_address,app_new_icno,app_loan_amt,appl_loan_dur,app_start_pay_dt,app_end_pay_dt,cal_profit_rate,cal_installment_amt,(jjn.jno_seq_no - 1) as seq_no,jjn.jno_balance_amt as bal_amt,jjn.jno_pay_date as pdate from jpa_application ja inner join jpa_calculate_fee jcf on jcf.cal_applcn_no=ja.app_applcn_no inner join jpa_jbb_normal jjn on jjn.jno_applcn_no=ja.app_applcn_no where ja.app_applcn_no='" + cc_no + "' and month(jjn.jno_pay_date)='" + dt.Rows[0][1].ToString() + "' and year(jjn.jno_pay_date)='" + dt.Rows[0][2].ToString() + "' and app_current_jbb_ind='" + dt.Rows[0][0].ToString() + "'");
}
else if (dt.Rows[0][0].ToString().Trim() == "E")
{
dtn = DBCon.Ora_Execute_table("select app_name,app_permnt_address,app_new_icno,app_loan_amt,appl_loan_dur,app_start_pay_dt,app_end_pay_dt,cal_profit_rate,cal_installment_amt,(jjn.ext_seq_no - 1) as seq_no,jjn.ext_balance_amt as bal_amt,jjn.ext_pay_date as pdate from jpa_application ja inner join jpa_calculate_fee jcf on jcf.cal_applcn_no=ja.app_applcn_no inner join jpa_jbb_extension jjn on jjn.ext_applcn_no=ja.app_applcn_no where ja.app_applcn_no='" + cc_no + "' and month(jjn.ext_pay_date)='" + dt.Rows[0][1].ToString() + "' and year(jjn.ext_pay_date)='" + dt.Rows[0][2].ToString() + "' and app_current_jbb_ind='" + dt.Rows[0][0].ToString() + "'");
}
else if (dt.Rows[0][0].ToString().Trim() == "H")
{
dtn = DBCon.Ora_Execute_table("select app_name,app_permnt_address,app_new_icno,app_loan_amt,appl_loan_dur,app_start_pay_dt,app_end_pay_dt,cal_profit_rate,cal_installment_amt,(jjn.hol_seq_no - 1) as seq_no,jjn.hol_balance_amt as bal_amt,jjn.hol_pay_date as pdate from jpa_application ja inner join jpa_calculate_fee jcf on jcf.cal_applcn_no=ja.app_applcn_no inner join jpa_jbb_holiday jjn on jjn.hol_applcn_no=ja.app_applcn_no where ja.app_applcn_no='" + cc_no + "' and month(jjn.hol_pay_date)='" + dt.Rows[0][1].ToString() + "' and year(jjn.hol_pay_date)='" + dt.Rows[0][2].ToString() + "' and app_current_jbb_ind='" + dt.Rows[0][0].ToString() + "'");
}
else if (dt.Rows[0][0].ToString().Trim() == "P")
{
dtn = DBCon.Ora_Execute_table("select app_name,app_permnt_address,app_new_icno,app_loan_amt,appl_loan_dur,app_start_pay_dt,app_end_pay_dt,cal_profit_rate,cal_installment_amt,(jjn.pjs_seq_no - 1) as seq_no,jjn.pjs_balance_amt as bal_amt,jjn.pjs_pay_date as pdate from jpa_application ja inner join jpa_calculate_fee jcf on jcf.cal_applcn_no=ja.app_applcn_no inner join jpa_jbb_pjs jjn on jjn.pjs_applcn_no=ja.app_applcn_no where ja.app_applcn_no='" + cc_no + "' and month(jjn.pjs_pay_date)='" + dt.Rows[0][1].ToString() + "' and year(jjn.pjs_pay_date)='" + dt.Rows[0][2].ToString() + "' and app_current_jbb_ind='" + dt.Rows[0][0].ToString() + "'");
}
else if (dt.Rows[0][0].ToString().Trim() == "L")
{
dtn = DBCon.Ora_Execute_table("select app_name,app_permnt_address,app_new_icno,app_loan_amt,appl_loan_dur,app_start_pay_dt,app_end_pay_dt,cal_profit_rate,cal_installment_amt,(jjn.jwo_seq_no - 1) as seq_no,jjn.jwo_balance_amt as bal_amt,jjn.jwo_pay_date as pdate from jpa_application ja inner join jpa_calculate_fee jcf on jcf.cal_applcn_no=ja.app_applcn_no inner join jpa_jbb_writeoff jjn on jjn.jwo_applcn_no=ja.app_applcn_no where ja.app_applcn_no='" + cc_no + "' and month(jjn.jwo_pay_date)='" + dt.Rows[0][1].ToString() + "' and year(jjn.jwo_pay_date)='" + dt.Rows[0][2].ToString() + "' and app_current_jbb_ind='" + dt.Rows[0][0].ToString() + "'");
}
DataTable dte = new DataTable();
dte = DBCon.Ora_Execute_table("select ext_upd_perm,ext_upd_Mes,ext_upd_Tmula,ext_upd_TTam,ext_upd_Bil,ext_paid_dur,ext_extension_dur,ext_new_pay_dur from jpa_extension where ext_applcn_no='" + cc_no + "'");
Rptviwer_cetakjbb.Reset();
ds.Tables.Add(dtn);
Rptviwer_cetakjbb.LocalReport.DataSources.Clear();
Rptviwer_cetakjbb.LocalReport.ReportPath = "PELABURAN_ANGGOTA/Tambahan.rdlc";
ReportDataSource rds = new ReportDataSource("DataSet1", dtn);
ReportDataSource rds1 = new ReportDataSource("DataSet2", dte);
Rptviwer_cetakjbb.LocalReport.DataSources.Add(rds);
Rptviwer_cetakjbb.LocalReport.DataSources.Add(rds1);
//Refresh
Rptviwer_cetakjbb.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string fname = DateTime.Now.ToString("dd_MM_yyyy");
string devinfo = "<DeviceInfo><ColorDepth>32</ColorDepth><DpiX>350</DpiX><DpiY>350</DpiY><OutputFormat>PDF</OutputFormat>" +
" <PageWidth>12.20in</PageWidth>" +
" <PageHeight>8.27in</PageHeight>" +
" <MarginTop>0.1in</MarginTop>" +
" <MarginLeft>0.5in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
byte[] bytes = Rptviwer_cetakjbb.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename= Perjanjian_Tambahan_" + cc_no + "." + extension);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
//Request.Redirect(url, false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var samp = Request.Url.Query;
string icno = string.Empty;
if (samp != "")
{
icno = Request.QueryString["jbb_icno"].ToString();
}
try
{
if (icno != "")
{
var ic_count = icno.Length;
//Path var ic_count = Applcn_no.Text.Length;
DataTable app_icno = new DataTable();
app_icno = DBCon.Ora_Execute_table("select app_applcn_no,isnull(app_current_jbb_ind,'') AS app_current_jbb_ind,app_loan_type_cd,app_loan_amt from jpa_application JA where '" + icno + "' IN(JA.app_applcn_no, JA.app_new_icno)");
if (ic_count == 12)
{
cc_no = app_icno.Rows[0]["app_applcn_no"].ToString();
}
else
{
cc_no = icno;
}
string sav_amt = string.Empty, emnth = string.Empty;
string s_1 = "51000.00";
string s_2 = "101000.00";
string s_3 = "201000.00";
string s_4 = "300000.00";
if (app_icno.Rows[0]["app_loan_type_cd"].ToString() != "P")
{
//sav_amt = ((0.1 / 100) * double.Parse(a1)).ToString("0.00");
emnth = "28";
if (double.Parse(app_icno.Rows[0]["app_loan_amt"].ToString()) < double.Parse(s_1))
{
sav_amt = "50.00";
}
else if (double.Parse(app_icno.Rows[0]["app_loan_amt"].ToString()) < double.Parse(s_2))
{
sav_amt = "100.00";
}
else if (double.Parse(app_icno.Rows[0]["app_loan_amt"].ToString()) < double.Parse(s_3))
{
sav_amt = "200.00";
}
else if (double.Parse(app_icno.Rows[0]["app_loan_amt"].ToString()) <= double.Parse(s_4))
{
sav_amt = "300.00";
}
}
else
{
sav_amt = "0.00";
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string c_jbb = string.Empty;
if (app_icno.Rows[0]["app_current_jbb_ind"].ToString().Trim() != "")
{
c_jbb = app_icno.Rows[0]["app_current_jbb_ind"].ToString();
if (c_jbb == "L")
{
//dt = Dblog.Ora_Execute_table("select * from (SELECT jn.jwo_applcn_no as app_no,FORMAT(jn.jwo_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.jwo_loan_amt,'')) when '0.00' then '' else ISNULL(jn.jwo_loan_amt,'') end as l_amt,jn.jwo_seq_no as seq_no,ISNULL(jn.jwo_approve_amt,'') as a_amt,ISNULL(jn.jwo_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.jwo_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.jwo_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.jwo_pay_amt,'') as p_amt,ISNULL(jn.jwo_actual_pay_amt,'') as ap_amt,ISNULL(jn.jwo_late_excess_amt,'') as le_amt,ISNULL(jn.jwo_saving_amt,'') as sa_amt,ISNULL(jn.jwo_actual_saving_amt,'') as as_amt,ISNULL(jn.jwo_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.jwo_total_pay_amt,'') as tp_amt,ISNULL(jn.jwo_balance_amt,'') as bal_amt,ISNULL(jn.jwo_total_saving_amt,'') as ts_amt,jn.jwo_day_late as dlate,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description FROM jpa_jbb_writeoff as jn left join jpa_application as ja on ja.app_applcn_no = jn.jwo_applcn_no left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where jn.jwo_applcn_no='" + cc_no + "' ) as a full outer join (select jwo_applcn_no,sum(jwo_pay_amt) as tot_pamt,sum(jwo_actual_pay_amt) as tot_apamt,sum(jwo_saving_amt) as tot_samt,sum(jwo_actual_saving_amt) as tot_asamt,sum(jwo_total_pay_amt) as tot_tpamt from jpa_jbb_writeoff where jwo_applcn_no='" + cc_no + "' group by jwo_applcn_no) as b on b.jwo_applcn_no=a.app_no full outer join (select * from jpa_calculate_fee where cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.jwo_applcn_no");
dt = Dblog.Ora_Execute_table("select * from (SELECT jn.jwo_applcn_no as jwo_applcn_no,FORMAT(jn.jwo_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.jwo_loan_amt,'')) when '0.00' then '' else ISNULL(jn.jwo_loan_amt,'') end as l_amt,jn.jwo_seq_no as seq_no,ISNULL(jn.jwo_approve_amt,'') as a_amt,ISNULL(jn.jwo_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.jwo_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.jwo_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.jwo_pay_amt,'') as p_amt,ISNULL(jn.jwo_actual_pay_amt,'') as ap_amt,ISNULL(jn.jwo_late_excess_amt,'') as le_amt,ISNULL(jn.jwo_saving_amt,'') as sa_amt,ISNULL(jn.jwo_actual_saving_amt,'') as as_amt,ISNULL(jn.jwo_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.jwo_total_pay_amt,'') as tp_amt,ISNULL(jn.jwo_balance_amt,'') as bal_amt,ISNULL(jn.jwo_total_saving_amt,'') as ts_amt,jn.jwo_day_late as dlate FROM jpa_jbb_writeoff as jn where jn.jwo_applcn_no='" + cc_no + "' ) as a full outer join (select jwo_applcn_no,sum(jwo_pay_amt) as tot_pamt,sum(jwo_actual_pay_amt) as tot_apamt,sum(jwo_saving_amt) as tot_samt,sum(jwo_actual_saving_amt) as tot_asamt,sum(jwo_total_pay_amt) as tot_tpamt from jpa_jbb_writeoff where jwo_applcn_no='" + cc_no + "' group by jwo_applcn_no) as b on b.jwo_applcn_no=a.jwo_applcn_no full outer join (select * from jpa_calculate_fee as jc where jc.cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.jwo_applcn_no full outer join (select ja.app_cumm_saving_amt as acs_amt,ja.app_applcn_no as app_no,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description from jpa_application as ja left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where ja.app_applcn_no = '" + cc_no + "') as d on d.app_no=c.cal_applcn_no");
}
else if (c_jbb == "H")
{
//dt = Dblog.Ora_Execute_table("select * from (SELECT jn.hol_applcn_no as app_no,FORMAT(jn.hol_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.hol_loan_amt,'')) when '0.00' then '' else ISNULL(jn.hol_loan_amt,'') end as l_amt,jn.hol_seq_no as seq_no,ISNULL(jn.hol_approve_amt,'') as a_amt,ISNULL(jn.hol_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.hol_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.hol_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.hol_pay_amt,'') as p_amt,ISNULL(jn.hol_actual_pay_amt,'') as ap_amt,ISNULL(jn.hol_late_excess_amt,'') as le_amt,ISNULL(jn.hol_saving_amt,'') as sa_amt,ISNULL(jn.hol_actual_saving_amt,'') as as_amt,ISNULL(jn.hol_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.hol_total_pay_amt,'') as tp_amt,ISNULL(jn.hol_balance_amt,'') as bal_amt,ISNULL(jn.hol_total_saving_amt,'') as ts_amt,jn.hol_day_late as dlate,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description FROM jpa_jbb_holiday as jn left join jpa_application as ja on ja.app_applcn_no = jn.hol_applcn_no left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where jn.hol_applcn_no='" + cc_no + "' ) as a full outer join (select hol_applcn_no,sum(hol_pay_amt) as tot_pamt,sum(hol_actual_pay_amt) as tot_apamt,sum(hol_saving_amt) as tot_samt,sum(hol_actual_saving_amt) as tot_asamt,sum(hol_total_pay_amt) as tot_tpamt from jpa_jbb_holiday where hol_applcn_no='" + cc_no + "' group by hol_applcn_no) as b on b.hol_applcn_no=a.app_no full outer join (select * from jpa_calculate_fee where cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.hol_applcn_no");
dt = Dblog.Ora_Execute_table("select * from (SELECT jn.hol_applcn_no as hol_applcn_no,FORMAT(jn.hol_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.hol_loan_amt,'')) when '0.00' then '' else ISNULL(jn.hol_loan_amt,'') end as l_amt,jn.hol_seq_no as seq_no,ISNULL(jn.hol_approve_amt,'') as a_amt,ISNULL(jn.hol_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.hol_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.hol_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.hol_pay_amt,'') as p_amt,ISNULL(jn.hol_actual_pay_amt,'') as ap_amt,ISNULL(jn.hol_late_excess_amt,'') as le_amt,ISNULL(jn.hol_saving_amt,'') as sa_amt,ISNULL(jn.hol_actual_saving_amt,'') as as_amt,ISNULL(jn.hol_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.hol_total_pay_amt,'') as tp_amt,ISNULL(jn.hol_balance_amt,'') as bal_amt,ISNULL(jn.hol_total_saving_amt,'') as ts_amt,jn.hol_day_late as dlate FROM jpa_jbb_holiday as jn where jn.hol_applcn_no='" + cc_no + "' ) as a full outer join (select hol_applcn_no,sum(hol_pay_amt) as tot_pamt,sum(hol_actual_pay_amt) as tot_apamt,sum(hol_saving_amt) as tot_samt,sum(hol_actual_saving_amt) as tot_asamt,sum(hol_total_pay_amt) as tot_tpamt from jpa_jbb_holiday where hol_applcn_no='" + cc_no + "' group by hol_applcn_no) as b on b.hol_applcn_no=a.hol_applcn_no full outer join (select * from jpa_calculate_fee as jc where jc.cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.hol_applcn_no full outer join (select ja.app_cumm_saving_amt as acs_amt,ja.app_applcn_no as app_no,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description from jpa_application as ja left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where ja.app_applcn_no = '" + cc_no + "') as d on d.app_no=c.cal_applcn_no");
}
else if (c_jbb == "P")
{
//dt = Dblog.Ora_Execute_table("select * from (SELECT jn.pjs_applcn_no as app_no,FORMAT(jn.pjs_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.pjs_loan_amt,'')) when '0.00' then '' else ISNULL(jn.pjs_loan_amt,'') end as l_amt,jn.pjs_seq_no as seq_no,ISNULL(jn.pjs_approve_amt,'') as a_amt,ISNULL(jn.pjs_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.pjs_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.pjs_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.pjs_pay_amt,'') as p_amt,ISNULL(jn.pjs_actual_pay_amt,'') as ap_amt,ISNULL(jn.pjs_late_excess_amt,'') as le_amt,ISNULL(jn.pjs_saving_amt,'') as sa_amt,ISNULL(jn.pjs_actual_saving_amt,'') as as_amt,ISNULL(jn.pjs_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.pjs_total_pay_amt,'') as tp_amt,ISNULL(jn.pjs_balance_amt,'') as bal_amt,ISNULL(jn.pjs_total_saving_amt,'') as ts_amt,jn.pjs_day_late as dlate,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description FROM jpa_jbb_pjs as jn left join jpa_application as ja on ja.app_applcn_no = jn.pjs_applcn_no left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where jn.pjs_applcn_no='" + cc_no + "' ) as a full outer join (select pjs_applcn_no,sum(pjs_pay_amt) as tot_pamt,sum(pjs_actual_pay_amt) as tot_apamt,sum(pjs_saving_amt) as tot_samt,sum(pjs_actual_saving_amt) as tot_asamt,sum(pjs_total_pay_amt) as tot_tpamt from jpa_jbb_pjs where pjs_applcn_no='" + cc_no + "' group by pjs_applcn_no) as b on b.pjs_applcn_no=a.app_no full outer join (select * from jpa_calculate_fee where cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.pjs_applcn_no");
dt = Dblog.Ora_Execute_table("select * from (SELECT jn.pjs_applcn_no as pjs_applcn_no,FORMAT(jn.pjs_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.pjs_loan_amt,'')) when '0.00' then '' else ISNULL(jn.pjs_loan_amt,'') end as l_amt,jn.pjs_seq_no as seq_no,ISNULL(jn.pjs_approve_amt,'') as a_amt,ISNULL(jn.pjs_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.pjs_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.pjs_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.pjs_pay_amt,'') as p_amt,ISNULL(jn.pjs_actual_pay_amt,'') as ap_amt,ISNULL(jn.pjs_late_excess_amt,'') as le_amt,ISNULL(jn.pjs_saving_amt,'') as sa_amt,ISNULL(jn.pjs_actual_saving_amt,'') as as_amt,ISNULL(jn.pjs_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.pjs_total_pay_amt,'') as tp_amt,ISNULL(jn.pjs_balance_amt,'') as bal_amt,ISNULL(jn.pjs_total_saving_amt,'') as ts_amt,jn.pjs_day_late as dlate FROM jpa_jbb_pjs as jn where jn.pjs_applcn_no='" + cc_no + "' ) as a full outer join (select pjs_applcn_no,sum(pjs_pay_amt) as tot_pamt,sum(pjs_actual_pay_amt) as tot_apamt,sum(pjs_saving_amt) as tot_samt,sum(pjs_actual_saving_amt) as tot_asamt,sum(pjs_total_pay_amt) as tot_tpamt from jpa_jbb_pjs where pjs_applcn_no='" + cc_no + "' group by pjs_applcn_no) as b on b.pjs_applcn_no=a.pjs_applcn_no full outer join (select * from jpa_calculate_fee as jc where jc.cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.pjs_applcn_no full outer join (select ja.app_cumm_saving_amt as acs_amt,ja.app_applcn_no as app_no,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description from jpa_application as ja left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where ja.app_applcn_no = '" + cc_no + "') as d on d.app_no=c.cal_applcn_no");
}
else if (c_jbb == "E")
{
//dt = Dblog.Ora_Execute_table("select * from (SELECT jn.ext_applcn_no as app_no,FORMAT(jn.ext_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.ext_loan_amt,'')) when '0.00' then '' else ISNULL(jn.ext_loan_amt,'') end as l_amt,jn.ext_seq_no as seq_no,ISNULL(jn.ext_approve_amt,'') as a_amt,ISNULL(jn.ext_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.ext_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.ext_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.ext_pay_amt,'') as p_amt,ISNULL(jn.ext_actual_pay_amt,'') as ap_amt,ISNULL(jn.ext_late_excess_amt,'') as le_amt,ISNULL(jn.ext_saving_amt,'') as sa_amt,ISNULL(jn.ext_actual_saving_amt,'') as as_amt,ISNULL(jn.ext_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.ext_total_pay_amt,'') as tp_amt,ISNULL(jn.ext_balance_amt,'') as bal_amt,ISNULL(jn.ext_total_saving_amt,'') as ts_amt,jn.ext_day_late as dlate,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description FROM jpa_jbb_extension as jn left join jpa_application as ja on ja.app_applcn_no = jn.ext_applcn_no left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where jn.ext_applcn_no='" + cc_no + "' ) as a full outer join (select ext_applcn_no,sum(ext_pay_amt) as tot_pamt,sum(ext_actual_pay_amt) as tot_apamt,sum(ext_saving_amt) as tot_samt,sum(ext_actual_saving_amt) as tot_asamt,sum(ext_total_pay_amt) as tot_tpamt from jpa_jbb_extension where ext_applcn_no='" + cc_no + "' group by ext_applcn_no) as b on b.ext_applcn_no=a.app_no full outer join (select * from jpa_calculate_fee where cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.ext_applcn_no");
dt = Dblog.Ora_Execute_table("select * from (SELECT jn.ext_applcn_no as ext_applcn_no,FORMAT(jn.ext_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.ext_loan_amt,'')) when '0.00' then '' else ISNULL(jn.ext_loan_amt,'') end as l_amt,jn.ext_seq_no as seq_no,ISNULL(jn.ext_approve_amt,'') as a_amt,ISNULL(jn.ext_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.ext_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.ext_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.ext_pay_amt,'') as p_amt,ISNULL(jn.ext_actual_pay_amt,'') as ap_amt,ISNULL(jn.ext_late_excess_amt,'') as le_amt,ISNULL(jn.ext_saving_amt,'') as sa_amt,ISNULL(jn.ext_actual_saving_amt,'') as as_amt,ISNULL(jn.ext_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.ext_total_pay_amt,'') as tp_amt,ISNULL(jn.ext_balance_amt,'') as bal_amt,ISNULL(jn.ext_total_saving_amt,'') as ts_amt,jn.ext_day_late as dlate FROM jpa_jbb_extension as jn where jn.ext_applcn_no='" + cc_no + "' ) as a full outer join (select ext_applcn_no,sum(ext_pay_amt) as tot_pamt,sum(ext_actual_pay_amt) as tot_apamt,sum(ext_saving_amt) as tot_samt,sum(ext_actual_saving_amt) as tot_asamt,sum(ext_total_pay_amt) as tot_tpamt from jpa_jbb_extension where ext_applcn_no='" + cc_no + "' group by ext_applcn_no) as b on b.ext_applcn_no=a.ext_applcn_no full outer join (select * from jpa_calculate_fee as jc where jc.cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.ext_applcn_no full outer join (select ja.app_cumm_saving_amt as acs_amt,ja.app_applcn_no as app_no,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description from jpa_application as ja left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where ja.app_applcn_no = '" + cc_no + "') as d on d.app_no=c.cal_applcn_no");
}
else
{
//dt = Dblog.Ora_Execute_table("select * from (SELECT jn.jno_applcn_no as app_no,FORMAT(jn.jno_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.jno_loan_amt,'')) when '0.00' then '' else ISNULL(jn.jno_loan_amt,'') end as l_amt,jn.jno_seq_no as seq_no,ISNULL(jn.jno_approve_amt,'') as a_amt,ISNULL(jn.jno_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.jno_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.jno_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.jno_pay_amt,'') as p_amt,ISNULL(jn.jno_actual_pay_amt,'') as ap_amt,ISNULL(jn.jno_late_excess_amt,'') as le_amt,ISNULL(jn.jno_saving_amt,'') as sa_amt,ISNULL(jn.jno_actual_saving_amt,'') as as_amt,ISNULL(jn.jno_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.jno_total_pay_amt,'') as tp_amt,ISNULL(jn.jno_balance_amt,'') as bal_amt,ISNULL(jn.jno_total_saving_amt,'') as ts_amt,jn.jno_day_late as dlate,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description FROM jpa_jbb_normal as jn left join jpa_application as ja on ja.app_applcn_no = jn.jno_applcn_no left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where jn.jno_applcn_no='" + cc_no + "' ) as a full outer join (select jno_applcn_no,sum(jno_pay_amt) as tot_pamt,sum(jno_actual_pay_amt) as tot_apamt,sum(jno_saving_amt) as tot_samt,sum(jno_actual_saving_amt) as tot_asamt,sum(jno_total_pay_amt) as tot_tpamt from jpa_jbb_normal where jno_applcn_no='" + cc_no + "' group by jno_applcn_no) as b on b.jno_applcn_no=a.app_no full outer join (select * from jpa_calculate_fee where cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.jno_applcn_no");
dt = Dblog.Ora_Execute_table("select * from (SELECT jn.jno_applcn_no as jno_applcn_no,FORMAT(jn.jno_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.jno_loan_amt,'')) when '0.00' then '' else ISNULL(jn.jno_loan_amt,'') end as l_amt,jn.jno_seq_no as seq_no,ISNULL(jn.jno_approve_amt,'') as a_amt,ISNULL(jn.jno_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.jno_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.jno_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.jno_pay_amt,'') as p_amt,ISNULL(jn.jno_actual_pay_amt,'') as ap_amt,ISNULL(jn.jno_late_excess_amt,'') as le_amt,ISNULL(jn.jno_saving_amt,'') as sa_amt,ISNULL(jn.jno_actual_saving_amt,'') as as_amt,ISNULL(jn.jno_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.jno_total_pay_amt,'') as tp_amt,ISNULL(jn.jno_balance_amt,'') as bal_amt,ISNULL(jn.jno_total_saving_amt,'') as ts_amt,jn.jno_day_late as dlate FROM jpa_jbb_normal as jn where jn.jno_applcn_no='" + cc_no + "' ) as a full outer join (select jno_applcn_no,sum(jno_pay_amt) as tot_pamt,sum(jno_actual_pay_amt) as tot_apamt,sum(jno_saving_amt) as tot_samt,sum(jno_actual_saving_amt) as tot_asamt,sum(jno_total_pay_amt) as tot_tpamt from jpa_jbb_normal where jno_applcn_no='" + cc_no + "' group by jno_applcn_no) as b on b.jno_applcn_no=a.jno_applcn_no full outer join (select * from jpa_calculate_fee as jc where jc.cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.jno_applcn_no full outer join (select ja.app_cumm_saving_amt as acs_amt,ja.app_applcn_no as app_no,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description from jpa_application as ja left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where ja.app_applcn_no = '" + cc_no + "') as d on d.app_no=c.cal_applcn_no");
}
}
else
{
//dt = Dblog.Ora_Execute_table("select * from (SELECT jn.jno_applcn_no as app_no,FORMAT(jn.jno_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.jno_loan_amt,'')) when '0.00' then '' else ISNULL(jn.jno_loan_amt,'') end as l_amt,jn.jno_seq_no as seq_no,ISNULL(jn.jno_approve_amt,'') as a_amt,ISNULL(jn.jno_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.jno_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.jno_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.jno_pay_amt,'') as p_amt,ISNULL(jn.jno_actual_pay_amt,'') as ap_amt,ISNULL(jn.jno_late_excess_amt,'') as le_amt,ISNULL(jn.jno_saving_amt,'') as sa_amt,ISNULL(jn.jno_actual_saving_amt,'') as as_amt,ISNULL(jn.jno_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.jno_total_pay_amt,'') as tp_amt,ISNULL(jn.jno_balance_amt,'') as bal_amt,ISNULL(jn.jno_total_saving_amt,'') as ts_amt,jn.jno_day_late as dlate,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description FROM jpa_jbb_normal as jn left join jpa_application as ja on ja.app_applcn_no = jn.jno_applcn_no left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where jn.jno_applcn_no='" + cc_no + "' ) as a full outer join (select jno_applcn_no,sum(jno_pay_amt) as tot_pamt,sum(jno_actual_pay_amt) as tot_apamt,sum(jno_saving_amt) as tot_samt,sum(jno_actual_saving_amt) as tot_asamt,sum(jno_total_pay_amt) as tot_tpamt from jpa_jbb_normal where jno_applcn_no='" + cc_no + "' group by jno_applcn_no) as b on b.jno_applcn_no=a.app_no full outer join (select * from jpa_calculate_fee where cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.jno_applcn_no");
dt = Dblog.Ora_Execute_table("select * from (SELECT jn.jno_applcn_no as jno_applcn_no,FORMAT(jn.jno_pay_date,'dd/MM/yyyy', 'en-us') as p_dt, case(ISNULL(jn.jno_loan_amt,'')) when '0.00' then '' else ISNULL(jn.jno_loan_amt,'') end as l_amt,jn.jno_seq_no as seq_no,ISNULL(jn.jno_approve_amt,'') as a_amt,ISNULL(jn.jno_profit_amt,'') as pr_amt,ISNULL(case when CONVERT(DATE, jn.jno_actual_pay_date) = '1900-01-01' then '' else CONVERT(CHAR(10), FORMAT(jn.jno_actual_pay_date,'dd/MM/yyyy', 'en-us'), 103) END, '') as ap_dt,ISNULL(jn.jno_pay_amt,'') as p_amt,ISNULL(jn.jno_actual_pay_amt,'') as ap_amt,ISNULL(jn.jno_late_excess_amt,'') as le_amt,ISNULL(jn.jno_saving_amt,'') as sa_amt,ISNULL(jn.jno_actual_saving_amt,'') as as_amt,ISNULL(jn.jno_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.jno_total_pay_amt,'') as tp_amt,ISNULL(jn.jno_balance_amt,'') as bal_amt,ISNULL(jn.jno_total_saving_amt,'') as ts_amt,jn.jno_day_late as dlate FROM jpa_jbb_normal as jn where jn.jno_applcn_no='" + cc_no + "' ) as a full outer join (select jno_applcn_no,sum(jno_pay_amt) as tot_pamt,sum(jno_actual_pay_amt) as tot_apamt,sum(jno_saving_amt) as tot_samt,sum(jno_actual_saving_amt) as tot_asamt,sum(jno_total_pay_amt) as tot_tpamt from jpa_jbb_normal where jno_applcn_no='" + cc_no + "' group by jno_applcn_no) as b on b.jno_applcn_no=a.jno_applcn_no full outer join (select * from jpa_calculate_fee as jc where jc.cal_applcn_no='" + cc_no + "') as c on c.cal_applcn_no=b.jno_applcn_no full outer join (select ja.app_cumm_saving_amt as acs_amt,ja.app_applcn_no as app_no,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno,rjp.Description from jpa_application as ja left join Ref_Jenis_Pelaburan as rjp on rjp.Description_Code=ja.app_loan_type_cd where ja.app_applcn_no = '" + cc_no + "') as d on d.app_no=c.cal_applcn_no");
}
Rptviwer_cetakjbb.Reset();
ds.Tables.Add(dt);
Rptviwer_cetakjbb.LocalReport.DataSources.Clear();
Rptviwer_cetakjbb.LocalReport.ReportPath = "Pelaburan_Anggota/s_jbb.rdlc";
ReportDataSource rds = new ReportDataSource("sjbb", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("samt", sav_amt)
};
Rptviwer_cetakjbb.LocalReport.SetParameters(rptParams);
Rptviwer_cetakjbb.LocalReport.DataSources.Add(rds);
//Refresh
Rptviwer_cetakjbb.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string fname = DateTime.Now.ToString("dd_MM_yyyy");
string devinfo = "<DeviceInfo><ColorDepth>32</ColorDepth><DpiX>350</DpiX><DpiY>350</DpiY><OutputFormat>PDF</OutputFormat>" +
" <PageWidth>12.20in</PageWidth>" +
" <PageHeight>8.27in</PageHeight>" +
" <MarginTop>0.1in</MarginTop>" +
" <MarginLeft>0.5in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
byte[] bytes = Rptviwer_cetakjbb.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "inline; filename=JBB_" + fname + "." + extension);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
//Request.Redirect(url, false);
}
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
if (Applcn_no.Text != "")
{
var ic_count = Applcn_no.Text.Length;
//Path var ic_count = Applcn_no.Text.Length;
DataTable app_icno = new DataTable();
app_icno = DBCon.Ora_Execute_table("select app_applcn_no,isnull(app_current_jbb_ind,'') AS app_current_jbb_ind from jpa_application JA where '" + Applcn_no.Text + "' IN(JA.app_applcn_no, JA.app_new_icno)");
if (ic_count == 12)
{
cc_no = app_icno.Rows[0]["app_applcn_no"].ToString();
}
else
{
cc_no = Applcn_no.Text;
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
//dt = Dblog.Ora_Execute_table("SELECT jn.jno_applcn_no as app_no,FORMAT(jn.jno_pay_date,'dd/MM/yyyy', 'en-us') as p_dt,ISNULL(jn.jno_loan_amt,'') as l_amt,jn.jno_seq_no as seq_no,ISNULL(jn.jno_approve_amt,'') as a_amt,ISNULL(jn.jno_profit_amt,'') as pr_amt,jn.jno_actual_pay_date as ap_dt,ISNULL(jn.jno_pay_amt,'') as p_amt,ISNULL(jn.jno_actual_pay_amt,'') as ap_amt,ISNULL(jn.jno_late_excess_amt,'') as le_amt,ISNULL(jn.jno_saving_amt,'') as sa_amt,ISNULL(jn.jno_actual_saving_amt,'') as as_amt,ISNULL(jn.jno_saving_late_excess_amt,'') as sle_amt,ISNULL(jn.jno_total_pay_amt,'') as tp_amt,ISNULL(jn.jno_balance_amt,'') as bal_amt,ISNULL(jn.jno_total_saving_amt,'') as ts_amt,jn.jno_day_late as dlate,ja.appl_loan_dur as a_dur,ja.app_name as a_name,ja.app_new_icno as a_icno FROM jpa_jbb_normal as jn left join jpa_application as ja on ja.app_applcn_no = jn.jno_applcn_no where jn.jno_applcn_no='" + cc_no + "'");
dt = Dblog.Ora_Execute_table("select app_applcn_no,convert(varchar,(CONVERT(date,GETDATE(),103)),103) as cdate,app_loan_type_cd,app_name,app_permnt_address,app_permnt_state_cd, case when COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) < 1 and COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) > 0 Then '1 Bulan' when COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) < 2 and COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) > 1 Then '2 Bulan' when COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) < 3 and COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) > 2 Then '3 Bulan' when COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) < 4 and COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) > 3 Then '4 Bulan' when COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) < 5 and COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) > 4 Then '5 Bulan' when COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) < 6 and COALESCE(app_backdated_amt/nullif(app_cumm_installment_amt,0),0) > 5 Then '6 Bulan' else '0 Bulan' end as Tempoh,app_bal_loan_amt,app_backdated_amt ,gua_name,rjp.Description as loan_type,rn.Decription,ISNULL(app_mailing_address,'') as app_mailing_address from jpa_application ja left join jpa_guarantor jg on ja.app_applcn_no=jg.gua_applcn_no left join Ref_Jenis_Pelaburan rjp on rjp.Description_Code=ja.app_loan_type_cd left join Ref_Negeri rn on rn.Decription_Code=ja.app_permnt_state_cd where app_applcn_no='" + cc_no + "' order by gua_name ");
//dt = DBCon.Ora_Execute_table("select ja.app_name,ja.app_new_icno,ja.app_applcn_no,ja.appl_loan_dur,ISNULL(ja.app_installment_amt,'') as app_installment_amt,ja.app_loan_type_cd,tp.tpj_approve_amt,tp.tpj_profit_amt,tp.tpj_pay_date,tp.tpj_actual_pay_date,tp.tpj_approve_amt,tp.tpj_pay_amt,tp.tpj_actual_pay_amt,tp.tpj_late_excess_amt,tp.tpj_saving_amt,tp.tpj_actual_saving_amt,tp.tpj_saving_late_excess_amt,tp.tpj_total_pay_amt,tp.tpj_balance_amt,tp.tpj_total_saving_amt,tp.tpj_day_late from jpa_jbb_temp_pjs as tp left join jpa_application as ja on ja.app_applcn_no=tp.tpj_applcn_no and ja.app_sts_cd='Y' where tp.tpj_applcn_no='" + cc_no + "'");
Rptviwer_cetakjbb.Reset();
ds.Tables.Add(dt);
Rptviwer_cetakjbb.LocalReport.DataSources.Clear();
Rptviwer_cetakjbb.LocalReport.ReportPath = "PELABURAN_ANGGOTA/AMARAN TERAKHIR.rdlc";
ReportDataSource rds = new ReportDataSource("Notis1", dt);
Rptviwer_cetakjbb.LocalReport.DataSources.Add(rds);
Rptviwer_cetakjbb.LocalReport.DisplayName = "AMARAN_TERAKHIR_" + DateTime.Now.ToString("ddMMyyyy");
//Refresh
Rptviwer_cetakjbb.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string fname = DateTime.Now.ToString("dd_MM_yyyy");
string devinfo = "<DeviceInfo><ColorDepth>32</ColorDepth><DpiX>350</DpiX><DpiY>350</DpiY><OutputFormat>PDF</OutputFormat>" +
" <PageWidth>12.20in</PageWidth>" +
" <PageHeight>8.27in</PageHeight>" +
" <MarginTop>0.1in</MarginTop>" +
" <MarginLeft>0.5in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
byte[] bytes = Rptviwer_cetakjbb.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename=Cetak_Notis_" + cc_no + "." + extension);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
//Request.Redirect(url, false);
}
}
