protected void ExportToEXCEL(object sender, EventArgs e)
{
DataTable dt = new DataTable();
bind_details();
dt = DBCon.Ora_Execute_table(sqry);
if (dt.Rows.Count != 0)
{
RptviwerStudent.Reset();
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
double deb = 0, krd = 0;
if (countRow != 0)
{
StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "Imbangan_Duga_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("No Akaun,Keterangan,Debit (RM),Kredit (RM)" + Environment.NewLine);
for (int k = 0; k <= (dt.Rows.Count - 1); k++)
{
builder.Append(dt.Rows[k]["kod_akaun"].ToString() + " , " + dt.Rows[k]["nama_akaun"].ToString().Replace(",", "") + ", " + dt.Rows[k]["Amt1"].ToString() + "," + dt.Rows[k]["Amt2"].ToString() + Environment.NewLine);
deb += double.Parse(dt.Rows[k]["kw_Debit_amt"].ToString());
krd += double.Parse(dt.Rows[k]["kw_kredit_amt"].ToString());
if (k == (dt.Rows.Count - 1))
{
string val1 = "JUMLAH";
string val2 = string.Empty;
builder.Append(val1 + ", " + val2 + ", " + deb.ToString() + "," + krd.ToString() + Environment.NewLine);
}
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alert('Rekod tidak dijumpai. Sila pastikan semua maklumat dimasukkan dengan betul');", true);
// txtError.Text = "Rekod tidak dijumpai. Sila pastikan semua maklumat dimasukkan dengan betul.";
}
}
else
{
BindData();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
//void grid()
//{
// //SqlCommand cmd2 = new SqlCommand("select ht.trn_dur,upper(sp.stf_name) as stf_name from hr_post_his as ph left join hr_training as ht on ht.trn_staff_no=ph.pos_staff_no left join hr_staff_profile as sp on sp.stf_staff_no=ht.trn_staff_no where ht.trn_start_dt>=DATEADD(day, DATEDIFF(day, 0, '2016-01-12'), 0) and ht.trn_start_dt<=DATEADD(day, DATEDIFF(day, 0, '2016-01-16'), 0) and ph.pos_end_dt='9999-12-31' and ht.trn_cat_cd='' and ht.trn_type_cd='' and ht.trn_staff_no='0202020202' and ph.pos_org_id='s637456346' and ph.pos_dept_cd='01' and ph.pos_unit_cd='18'", con);
// SqlCommand cmd2 = new SqlCommand("select FORMAT(ha.atd_date,'dd/MM/yyyy', 'en-us') atd_date,ha.atd_clock_in,ha.atd_clock_out,sp.stf_working_hour from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Kaki_no.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0)", con);
// SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
// DataSet ds2 = new DataSet();
// da2.Fill(ds2);
// if (ds2.Tables[0].Rows.Count == 0)
// {
// ds2.Tables[0].Rows.Add(ds2.Tables[0].NewRow());
// GridView1.DataSource = ds2;
// GridView1.DataBind();
// int columncount = GridView1.Rows[0].Cells.Count;
// GridView1.Rows[0].Cells.Clear();
// GridView1.Rows[0].Cells.Add(new TableCell());
// GridView1.Rows[0].Cells[0].ColumnSpan = columncount;
// GridView1.Rows[0].Cells[0].Text = "<strong>Maklumat Carian Tidak Dijumpai</strong>";
// }
// else
// {
// GridView1.DataSource = ds2;
// GridView1.DataBind();
// }
//}
//protected void gvSelected_PageIndexChanging(object sender, GridViewPageEventArgs e)
//{
// GridView1.PageIndex = e.NewPageIndex;
// grid();
//}
void clk_print()
{
{
try
{
if (tm_date.Text != "" && ta_date.Text != "" && Kaki_no.Text != "")
{
DataTable select_kaki_jum = new DataTable();
select_kaki_jum = DBCon.Ora_Execute_table("select a.stf_staff_no,a.Hol,ISNULL(b.Late,'') as Late from (select sp.stf_staff_no,count(ha.atd_hol_late_ind) as Hol from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0) and ha.atd_hol_late_ind = 'H' group by sp.stf_staff_no) as a full outer join (select sp.stf_staff_no,count(ha.atd_hol_late_ind) as Late from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0) and ha.atd_hol_late_ind = 'L' group by sp.stf_staff_no) as b on b.stf_staff_no = a.stf_staff_no");
if (select_kaki_jum.Rows.Count != 0)
{
jm_hl.Text = select_kaki_jum.Rows[0]["Late"].ToString();
jm_hc.Text = select_kaki_jum.Rows[0]["Hol"].ToString();
DataTable sel_poshis = new DataTable();
sel_poshis = DBCon.Ora_Execute_table("select pos_spv_name1,sp.stf_name,rj.hr_jaw_desc from hr_post_his as ph left join hr_staff_profile sp on sp.stf_staff_no=ph.pos_spv_name1 left join Ref_hr_Jawatan rj on rj.hr_jaw_Code=sp.stf_curr_post_cd where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "'");
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = DBCon.Ora_Execute_table("select FORMAT(ha.atd_date,'dd/MM/yyyy', 'en-us') atd_date,ha.atd_clock_in,ha.atd_clock_out,sp.stf_working_hour,ha.atd_remark as stf_desc,stf_staff_no,UPPER(stf_name) as stf_name,UPPER(hr_gred_desc) as hr_gred_desc,UPPER(hr_jaba_desc) as hr_jaba_desc,UPPER(hr_jaw_desc) as hr_jaw_desc from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join Ref_hr_jabatan as JB on JB.hr_jaba_Code=SP.stf_curr_dept_cd left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=SP.stf_curr_post_cd left join Ref_hr_gred as GR on GR.hr_gred_Code=SP.stf_curr_grade_cd left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0)");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/hr_lrk.rdlc";
ReportDataSource rds = new ReportDataSource("hr_lrk", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("sup_name", sel_poshis.Rows[0]["stf_name"].ToString()),
new ReportParameter("jaw_name", sel_poshis.Rows[0]["hr_jaw_desc"].ToString()),
new ReportParameter("oname", txt_org.Text)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.DisplayName = "Laporan_Kehadiran_" + Applcn_no1.Text + "-" + DateTime.Now.ToString("ddMMyyyy");
//Refresh
RptviwerStudent.LocalReport.Refresh();
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
else
{
// grid();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
else
{
// grid();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
//protected void txt_changed_markah(object sender, EventArgs e)
//{
// GridViewRow row = ((GridViewRow)((System.Web.UI.WebControls.TextBox)sender).NamingContainer);
// System.Web.UI.WebControls.TextBox markah = (System.Web.UI.WebControls.TextBox)row.FindControl("lbl_markah");
// System.Web.UI.WebControls.TextBox bah_cd = (System.Web.UI.WebControls.TextBox)row.FindControl("Label2");
// System.Web.UI.WebControls.TextBox sub_cd = (System.Web.UI.WebControls.TextBox)row.FindControl("Label5");
// System.Web.UI.WebControls.TextBox sec_type = (System.Web.UI.WebControls.TextBox)row.FindControl("Label4");
// DataTable chk_apprisal = new DataTable();
// chk_apprisal = DBCon.Ora_Execute_table("select * from hr_staff_appraisal where sap_staff_no='" + Kaki_no.Text + "' and sap_section_cd ='" + bah_cd.Text + "' and sap_post_cat_cd='" + sub_cd.Text + "' and cse_sec_type='"+ sec_type.Text + "' and sap_year='"+ txt_tahun.Text +"'");
// if (chk_apprisal.Rows.Count != 0)
// {
// string Inssql1 = "Update hr_staff_appraisal set sap_ppp_score='" + markah.Text + "' where sap_staff_no='" + Kaki_no.Text + "' and sap_section_cd ='" + bah_cd.Text + "' and sap_post_cat_cd='" + sub_cd.Text + "' and cse_sec_type='" + sec_type.Text + "' and sap_year='" + txt_tahun.Text + "'";
// Status = DBCon.Ora_Execute_CommamdText(Inssql1);
// }
// grid_list();
//}
protected void clk_cetak(object sender, EventArgs e)
{
try
{
if (Kaki_no.Text != "")
{
string filename = string.Empty;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = DBCon.Ora_Execute_table("SELECT FORMAT(trn_start_dt,'dd/MM/yyyy') dari,trn_venue,trn_training_name,trn_dur,trn_organiser,trn_fee_amt,trn_catatan FROM hr_training WHERE year(trn_start_dt) ='" + txt_tahun.Text + "' AND trn_staff_no='" + Kaki_no.Text + "'");
ds.Tables.Add(dt);
DataTable dt1 = new DataTable();
dt1 = DBCon.Ora_Execute_table("select dis_staff_no,s2.hr_discipline_desc,FORMAT(dis_eff_dt,'dd/MM/yyyy') eff_dt,case when FORMAT(dis_exp_dt,'dd/MM/yyyy') ='01/01/1900' then '' else FORMAT(dis_exp_dt,'dd/MM/yyyy') end as exp_dt,s1.dis_catatan from hr_discipline s1 left join Ref_hr_discipline s2 on s2.hr_discipline_Code=dis_discipline_type_cd where dis_staff_no='" + Kaki_no.Text + "' and year(dis_eff_dt) = '" + txt_tahun.Text + "'");
ds.Tables.Add(dt1);
DataTable dt2 = new DataTable();
dt2 = DBCon.Ora_Execute_table("select * from (SELECT sap_section_cd,sap_post_cat_cd,sap_subject_cd,sap_staff_remark,sap_weightage,b.cse_section_desc,A.cse_sec_type,case when ISNULL(sap_ppp_score,'0')='0' then '0' else sap_ppp_score end as sap_ppp_score,case when ISNULL(sap_ppk_score,'0')='0' then '0' else sap_ppk_score end as sap_ppk_score FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A. sap_section_cd=B.cse_section_cd WHERE sap_staff_no='" + Kaki_no.Text + "' AND sap_year='" + txt_tahun.Text + "' AND cap_status='A' ) as a "
+ " outer apply(SELECT sap_section_cd, sum(sap_weightage) cnt,sum(ISNULL(sap_ppp_score,'0')) cnt1,sum(ISNULL(sap_ppk_score,'0')) cnt2 FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A.sap_section_cd = B.cse_section_cd WHERE sap_staff_no = '" + Kaki_no.Text + "' AND sap_year = '" + txt_tahun.Text + "' AND cap_status = 'A' group by sap_section_cd) as b where b.sap_section_cd = a.sap_section_cd ORDER BY a.sap_section_cd, a.sap_post_cat_cd");
ds.Tables.Add(dt2);
DataTable dt3 = new DataTable();
dt3 = DBCon.Ora_Execute_table("select a.*,cast(((((c3 + c4) /2) / c2) * ((c1 / tot_marks) * 100)) as int) purta from( "
+ " SELECT sap_section_cd, b.cse_section_desc, sum(cast(cse_marks as int)) c1, sum(sap_weightage) c2, sum(case when ISNULL(sap_ppp_score, '0') = '0' then '0' else sap_ppp_score end) as c3 "
+ " , sum(case when ISNULL(sap_ppk_score, '0') = '0' then '0' else sap_ppk_score end) as c4, c.tot_marks FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A.sap_section_cd = B.cse_section_cd "
+ " outer apply(SELECT cast(sum(cast(cse_marks as int)) as float) tot_marks FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A.sap_section_cd = B.cse_section_cd WHERE sap_year = '" + txt_tahun.Text + "' AND cap_status = 'A') as c WHERE sap_staff_no = '" + Kaki_no.Text + "' AND cap_status = 'A' group by sap_section_cd, b.cse_section_desc, c.tot_marks "
+ " ) as a");
ds.Tables.Add(dt3);
RptviwerStudent.Reset();
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/lap_pen_pertasi.rdlc";
RptviwerStudent.LocalReport.EnableExternalImages = true;
string imagePath = string.Empty;
//if (dt.Rows[0]["v25"].ToString() != "")
//{
// imagePath = new Uri(Server.MapPath("~/FILES/user/" + dt.Rows[0]["v25"].ToString() + "")).AbsoluteUri;
//}
//else
//{
// imagePath = new Uri(Server.MapPath("~/FILES/user/no_image.jpg")).AbsoluteUri;
//}
ReportDataSource rds = new ReportDataSource("lpp_DS1", dt);
ReportDataSource rds1 = new ReportDataSource("lpp_DS2", dt1);
ReportDataSource rds2 = new ReportDataSource("lpp_DS3", dt2);
ReportDataSource rds3 = new ReportDataSource("lpp_DS4", dt3);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("pv1", Kaki_no.Text),
new ReportParameter("pv2", txt_org.Text),
new ReportParameter("pv3", s_nama.Text),
new ReportParameter("pv4", s_gred.Text),
new ReportParameter("pv5", s_jab.Text),
new ReportParameter("pv6", s_kj.Text),
new ReportParameter("pv7", s_jaw.Text),
new ReportParameter("pv8", s_unit.Text),
new ReportParameter("pv9", txt_tahun.Text),
new ReportParameter("pv10", dt.Rows.Count.ToString()),
new ReportParameter("pv11", dt1.Rows.Count.ToString())
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.DataSources.Add(rds1);
RptviwerStudent.LocalReport.DataSources.Add(rds2);
RptviwerStudent.LocalReport.DataSources.Add(rds3);
RptviwerStudent.LocalReport.Refresh();
filename = string.Format("{0}.{1}", "PENILAIAN_PRESTASI_" + Kaki_no.Text + "_" + txt_tahun.Text + "", "pdf");
//}
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila masukan Maklumat Carian',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch
{
}
}
protected void ctk_values(object sender, EventArgs e)
{
string rcount = string.Empty;
int count1 = 0;
get_det();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = DBCon.Ora_Execute_table("select ph.Id,stf_staff_no,stf_name,FORMAT(lap_application_dt,'dd/MM/yyyy') lap_application_dt,lap_leave_type_cd,hjc.hr_jenis_desc,lap_leave_day,FORMAT(lap_leave_start_dt,'dd/MM/yyyy') as lap_leave_start_dt,FORMAT(lap_leave_end_dt, 'dd/MM/yyyy') as lap_leave_end_dt, lap_ref_no,case when lap_approve_sts_cd = '00' then 'MOHON' when lap_approve_sts_cd = '01' then 'SAH' when lap_approve_sts_cd = '02' then 'TIDAK SAH' when lap_approve_sts_cd = '03' then '' when lap_approve_sts_cd = '04' then 'BATAL' else '' end as app_stscd,case when lap_endorse_sts_cd = '01' then 'SAH' when lap_endorse_sts_cd = '02' then 'TIDAK SAH' else '' end as psts,lap_late_apply from hr_leave_application ph left join hr_staff_profile sp on sp.stf_staff_no = ph.lap_staff_no Left join Ref_hr_jenis_cuti hjc on hjc.hr_jenis_Code = ph.lap_leave_type_cd where stf_service_end_dt>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' and stf_service_end_dt <= '9999-12-31' and ph.lap_cancel_ind='N' " + sqry + " order by lap_ref_no desc");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
string sts_v1 = string.Empty, sts_v2 = string.Empty;
if (DropDownList1.SelectedValue == "")
{
sts_v1 = "-";
}
else
{
sts_v1 = DropDownList1.SelectedItem.Text;
}
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/cuti_list.rdlc";
ReportDataSource rds = new ReportDataSource("hr_cuti_info", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("s1", txt_tkcuti.Text),
new ReportParameter("s2", txt_hing.Text),
new ReportParameter("s3", sts_v1)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
if (sel_frmt.SelectedValue == "02")
{
StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "Semakan_Cuti_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("NAMA KAKITANGAN,NO KAKITANGAN, NO RUJUKAN,TARIKH MOHON, JENIS CUTI,HARI CUTI,TARIKH MULA, TARIKH SEHINGGA,LEWAT MOHON (HARI),STATUS KELULUSAN,STATUS PENGESAHAN" + Environment.NewLine);
for (int k = 0; k <= (dt.Rows.Count - 1); k++)
{
builder.Append(dt.Rows[k]["stf_name"].ToString() + " , " + dt.Rows[k]["stf_staff_no"].ToString() + "," + dt.Rows[k]["lap_ref_no"].ToString() + "," + dt.Rows[k]["lap_application_dt"].ToString() + "," + dt.Rows[k]["hr_jenis_desc"].ToString().ToUpper() + "," + dt.Rows[k]["lap_leave_day"].ToString() + "," + dt.Rows[k]["lap_leave_start_dt"].ToString() + "," + dt.Rows[k]["lap_leave_end_dt"].ToString() + "," + dt.Rows[k]["lap_late_apply"].ToString() + "," + dt.Rows[k]["app_stscd"].ToString() + "," + dt.Rows[k]["psts"].ToString() + Environment.NewLine);
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
else if (sel_frmt.SelectedValue == "01")
{
filename = string.Format("{0}.{1}", "Semakan_Cuti_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
BindData_Grid();
}
protected void ctk_values(object sender, EventArgs e)
{
if (txt_dar.Text != "" && txt_seh.Text != "")
{
DateTime pd = DateTime.ParseExact(txt_dar.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
dt1 = pd.ToString("yyyy-MM-dd");
DateTime pd1 = DateTime.ParseExact(txt_seh.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
dt2 = pd1.ToString("yyyy-MM-dd");
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = dbcon.Ora_Execute_table("select ho.org_name as org,UPPER(cs.cas_asset_desc) as naset,b.cnt as qty,dis_asset_age as uaset,dis_purchase_amt as hps,(dis_purchase_amt * b.cnt) as hpj,dis_curr_amt as nss,(dis_curr_amt * b.cnt) as nsj,kk.kaedah_desc as kp ,UPPER(ast_justifikasi_desc) as ast_justifikasi_desc from (select * from ast_dispose where dis_dispose_reg_dt>=DATEADD(day, DATEDIFF(day, 0, '" + dt1 + "'), 0) and dis_dispose_reg_dt<=DATEADD(day, DATEDIFF(day, 0, '" + dt2 + "'), +0)) as a left join ast_cmn_asset as cs on cs.cas_asset_cd=a.dis_asset_cd and cs.cas_asset_cat_cd=a.dis_asset_cat_cd and cs.cas_asset_sub_cat_cd=a.dis_asset_sub_cat_cd and cs.cas_asset_type_cd=a.dis_asset_type_cd left join Ref_ast_kaedah_palupusan as kk on kk.kaedah_id=a.dis_dispose_type_cd left join hr_organization as ho on ho.org_gen_id=a.dis_org_id left join ast_staff_asset as st on st.sas_asset_id=a.dis_asset_id and ISNULL(st.sas_justify_cd,'') != '' left join Ref_ast_justifikasi as J on J.ast_justifikasi_code=st.sas_justify_cd full outer join (select count(dis_asset_type_cd) as cnt,dis_asset_type_cd from ast_dispose where dis_dispose_reg_dt>=DATEADD(day, DATEDIFF(day, 0, '" + dt1 + "'), 0) and dis_dispose_reg_dt<=DATEADD(day, DATEDIFF(day, 0, '" + dt2 + "'), +0) group by dis_asset_type_cd) as b on b.dis_asset_type_cd=a.dis_asset_type_cd");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "Aset/ast_slupus.rdlc";
ReportDataSource rds = new ReportDataSource("astslupus", dt);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
if (sel_frmt.SelectedValue == "01")
{
filename = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (sel_frmt.SelectedValue == "02")
{
StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("Organisation ,Nama Aset,Kuantiti, Usia Aset, Seunit (RM), Jumlah (RM), Seunit (RM), Jumlah (RM), Kaedah Pelupusan, Justifikasi Pelupusan" + Environment.NewLine);
foreach (GridViewRow row in gvSelected.Rows)
{
string oname = ((Label)row.FindControl("Label3")).Text.ToString();
string naset = ((Label)row.FindControl("Label2")).Text.ToString();
string qty = ((Label)row.FindControl("Label6")).Text.ToString();
string uaset = ((Label)row.FindControl("Label7")).Text.ToString();
string hss = ((Label)row.FindControl("Label8")).Text.ToString();
string hsj = ((Label)row.FindControl("Label9")).Text.ToString();
string nss = ((Label)row.FindControl("Label10")).Text.ToString();
string nsj = ((Label)row.FindControl("Label11")).Text.ToString();
string jp = ((Label)row.FindControl("Label12")).Text.ToString();
string kp = ((Label)row.FindControl("lbl_kp")).Text.ToString();
builder.Append(oname + "," + naset + "," + qty + "," + uaset + "," + hss + "," + hsj + "," + nss.Replace(",", "") + "," + nsj.Replace(",", "") + "," + kp + "," + jp + Environment.NewLine);
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
else if (sel_frmt.SelectedValue == "03")
{
byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings);
filename = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc");
Response.Buffer = true;
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
Response.ContentType = mimeType;
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
else
{
BindGrid();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
protected void ctk_values(object sender, EventArgs e)
{
if (txt_dar.Text != "" && txt_seh.Text != "" || DropDownList3.SelectedValue != "")
{
select_qry();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = dbcon.Ora_Execute_table("" + sqry + "");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty;
if (DropDownList3.SelectedValue != "")
{
ss1 = DropDownList3.SelectedItem.Text;
}
if (dd_pen.SelectedValue != "")
{
ss2 = dd_pen.SelectedItem.Text;
}
if (dd_ajk1.SelectedValue != "")
{
ss3 = dd_ajk1.SelectedItem.Text;
}
if (dd_ajk2.SelectedValue != "")
{
ss4 = dd_ajk2.SelectedItem.Text;
}
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "Aset/ast_klupus.rdlc";
ReportDataSource rds = new ReportDataSource("astskupus", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("h1", txt_dar.Text),
new ReportParameter("h2", txt_seh.Text),
new ReportParameter("h3", ss1),
new ReportParameter("h4", TextBox2.Text),
new ReportParameter("h5", ss2),
new ReportParameter("h6", ss3),
new ReportParameter("h7", ss4),
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
if (sel_frmt.SelectedValue == "01")
{
filename = string.Format("{0}.{1}", "Kelulusan_Rekod_Pelupusan_Aset_" + DateTime.Now.ToString("ddMMyyyy") + ".", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (sel_frmt.SelectedValue == "02")
{
StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("Organisation ,Nama Aset,Kuantiti, Usia Aset, Seunit (RM), Jumlah (RM), Seunit (RM), Jumlah (RM), Kaedah Pelupusan, NILAI REZAB (RM)" + Environment.NewLine);
foreach (GridViewRow row in gvSelected.Rows)
{
string oname = ((Label)row.FindControl("Label3")).Text.ToString();
string naset = ((Label)row.FindControl("Label2")).Text.ToString();
string qty = ((Label)row.FindControl("Label6")).Text.ToString();
string uaset = ((Label)row.FindControl("Label7")).Text.ToString();
string hss = ((Label)row.FindControl("Label8")).Text.ToString();
string hsj = ((Label)row.FindControl("Label9")).Text.ToString();
string nss = ((Label)row.FindControl("Label10")).Text.ToString();
string nsj = ((Label)row.FindControl("Label11")).Text.ToString();
string res_amt = ((Label)row.FindControl("lbl_ramt")).Text.ToString();
string kp = ((DropDownList)row.FindControl("lbl_kp")).Text.ToString();
builder.Append(oname + "," + naset + "," + qty + "," + uaset + "," + hss + "," + hsj + "," + nss + "," + nsj + "," + res_amt + "," + kp + Environment.NewLine);
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
else if (sel_frmt.SelectedValue == "03")
{
byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings);
filename = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc");
Response.Buffer = true;
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
Response.ContentType = mimeType;
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
else
{
BindGrid();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
//void grid()
//{
// con.Open();
// DataTable ddicno = new DataTable();
// ddicno = DBCon.Ora_Execute_table("select stf_staff_no,str_curr_org_cd,stf_curr_dept_cd,OG.org_name,hr_jaba_desc From hr_staff_profile as ST left join hr_organization as OG on OG.org_id=ST.str_curr_org_cd left join Ref_hr_jabatan as JB on JB.hr_jaba_Code=ST.stf_curr_dept_cd where stf_icno='" + Session["New"].ToString() + "' ");
// string stffno = ddicno.Rows[0]["stf_staff_no"].ToString();
// DD_Orgnsi.SelectedValue = ddicno.Rows[0]["str_curr_org_cd"].ToString();
// DD_JABAT.SelectedValue = ddicno.Rows[0]["stf_curr_dept_cd"].ToString();
// String fromdate = string.Empty, todate = string.Empty;
// if (txt_tmula.Text != "")
// {
// string datedari = txt_tmula.Text;
// DateTime dt = DateTime.ParseExact(datedari, "dd/MM/yyyy", CultureInfo.InvariantCulture);
// fromdate = dt.ToString("yyyy-MM-dd");
// }
// else
// {
// fromdate = "";
// }
// if (txt_takhir.Text != "")
// {
// string datedari1 = txt_takhir.Text;
// DateTime dt1 = DateTime.ParseExact(datedari1, "dd/MM/yyyy", CultureInfo.InvariantCulture);
// todate = dt1.ToString("yyyy-MM-dd");
// }
// else
// {
// todate = "";
// }
// SqlCommand cmd = new SqlCommand("select stf_staff_no,stf_name,hr_jaw_desc,a.LIND,b.HIND from hr_staff_profile as SF left join hr_attendance as AT on AT.atd_staff_no=SF.stf_staff_no left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=stf_curr_post_cd full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as LIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='L' group by atd_staff_no,atd_hol_late_ind) a on a.atd_staff_no=SF.stf_staff_no full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as HIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='H' group by atd_staff_no,atd_hol_late_ind) b on b.atd_staff_no=SF.stf_staff_no where stf_staff_no='" + stffno + "' and ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) group by a.LIND,b.HIND,stf_staff_no,stf_name,hr_jaw_desc", con);
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// DataSet ds = new DataSet();
// da.Fill(ds);
// if (ds.Tables[0].Rows.Count == 0)
// {
// ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
// GridView1.DataSource = ds;
// GridView1.DataBind();
// int columncount = GridView1.Rows[0].Cells.Count;
// GridView1.Rows[0].Cells.Clear();
// GridView1.Rows[0].Cells.Add(new TableCell());
// GridView1.Rows[0].Cells[0].ColumnSpan = columncount;
// GridView1.Rows[0].Cells[0].Text = "<center>Maklumat Carian Tidak Dijumpai</center>";
// //btn_hups.Visible = false;
// }
// else
// {
// GridView1.DataSource = ds;
// GridView1.DataBind();
// }
// con.Close();
//}
//protected void btn_cetak_Click(object sender, EventArgs e)
//{
// try
// {
// Page.Header.Title = "Portal Laporan Pembiayaan CMCCS ";
// //string datedari = Convert.ToDateTime(txt_tmula.Text).ToString("yyyy/MM/dd");
// //string datehingga = Convert.ToDateTime(txt_takhir.Text).ToString("yyyy/MM/dd");
// string datefrom = txt_tmula.Text;
// DateTime dts = DateTime.ParseExact(datefrom, "dd/mm/yyyy", CultureInfo.InvariantCulture);
// String datedari = dts.ToString("yyyy-mm-dd");
// string dateto = txt_takhir.Text;
// DateTime dt1 = DateTime.ParseExact(dateto, "dd/mm/yyyy", CultureInfo.InvariantCulture);
// String datehingga = dt1.ToString("yyyy-mm-dd");
// Session["fformat"] = ddfformat.SelectedItem.Text;
// string ffile = Session["fformat"].ToString();
// if ((txt_tmula.Text != "") && (txt_takhir.Text != ""))
// {
// DataTable ddicno = new DataTable();
// ddicno = DBCon.Ora_Execute_table("select stf_staff_no From hr_staff_profile where stf_icno='" + Session["New"].ToString() + "' ");
// string stffno = ddicno.Rows[0]["stf_staff_no"].ToString();
// DataSet dsCustomers = GetData("select stf_staff_no,stf_name,hr_jaw_desc,a.LIND,b.HIND from hr_staff_profile as SF left join hr_attendance as AT on AT.atd_staff_no=SF.stf_staff_no left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=stf_curr_post_cd full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as LIND From hr_attendance where ((atd_date) between ('" + datedari + "') And ('" + datehingga + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='L' group by atd_staff_no,atd_hol_late_ind) a on a.atd_staff_no=SF.stf_staff_no full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as HIND From hr_attendance where ((atd_date) between ('" + datedari + "') And ('" + datehingga + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='H' group by atd_staff_no,atd_hol_late_ind) b on b.atd_staff_no=SF.stf_staff_no where stf_staff_no='" + stffno + "' and ((atd_date) between ('" + datedari + "') And ('" + datehingga + "')) group by a.LIND,b.HIND,stf_staff_no,stf_name,hr_jaw_desc");
// dt = dsCustomers.Tables[0];
// }
// ReportViewer1.Reset();
// List<DataRow> listResult = dt.AsEnumerable().ToList();
// listResult.Count();
// int countRow = 0;
// countRow = listResult.Count();
// if (countRow != 0)
// {
// //txtError.Text = "";
// //Display Report
// ReportViewer1.LocalReport.DataSources.Clear();
// ReportDataSource rds = new ReportDataSource("DataSet1", dt);
// ReportViewer1.LocalReport.DataSources.Add(rds);
// //Path
// ReportViewer1.LocalReport.ReportPath = "HR_REKOD_KEHADIRAN.rdlc";
// //Parameters
// ReportParameter[] rptParams = new ReportParameter[]{
// //new ReportParameter("fromDate",FromDate .Text ),
// //new ReportParameter("toDate",ToDate .Text )
// //new ReportParameter("fromDate",datedari ),
// //new ReportParameter("toDate",datehingga ),
// //new ReportParameter("caw",branch ),
// //new ReportParameter("Cdate",DateTime.Now.ToString("dd/MM/yyyy") ),
// //new ReportParameter("Date",DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") )
// };
// ReportViewer1.LocalReport.SetParameters(rptParams);
// //ReportViewer1.LocalReport.ExecuteReportInCurrentAppDomain(AppDomain.CurrentDomain.Evidence);
// //Refresh
// ReportViewer1.LocalReport.Refresh();
// if (ffile == "PDF")
// {
// Warning[] warnings;
// string[] streamids;
// string mimeType;
// string encoding;
// string extension;
// // string devinfo = "<DeviceInfo>" +
// //" <OutputFormat>PDF</OutputFormat>" +
// //" <PageSize>A4</PageSize>" +
// //" <PageWidth>8.5in</PageWidth>" +
// //" <PageHeight>11in</PageHeight>" +
// //" <MarginTop>0.25in</MarginTop>" +
// //" <MarginLeft>0.5in</MarginLeft>" +
// //" <MarginRight>0.5in</MarginRight>" +
// //" <MarginBottom>0.5in</MarginBottom>" +
// //"</DeviceInfo>";
// byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
// Response.Buffer = true;
// Response.Clear();
// Response.ContentType = mimeType;
// string extfile = DateTime.Now.ToString("dd_MM_yyyy.");
// Response.AddHeader("content-disposition", "inline; filename=REKOD_KEHADIRAN" + extfile + extension);
// Response.BinaryWrite(bytes);
// Response.Flush();
// Response.End();
// }
// else if (ffile == "Excel")
// {
// Warning[] warnings;
// string[] streamids;
// string mimeType;
// string encoding;
// string extension;
// string filename;
// byte[] bytes = ReportViewer1.LocalReport.Render(
// "Excel", null, out mimeType, out encoding,
// out extension,
// out streamids, out warnings);
// filename = string.Format("{0}.{1}", "Laporan", "xls");
// Response.Buffer = true;
// Response.Clear();
// Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
// Response.ContentType = mimeType;
// Response.BinaryWrite(bytes);
// Response.Flush();
// Response.End();
// }
// else
// {
// Warning[] warnings;
// string[] streamids;
// string mimeType;
// string encoding;
// string extension;
// byte[] bytes = ReportViewer1.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=myfile." + extension);
// Response.BinaryWrite(bytes);
// Response.Flush();
// Response.End();
// }
// }
// else if (countRow == 0)
// {
// ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alert('Rekod tidak dijumpai. Sila pastikan semua maklumat dimasukkan dengan betul.');", true);
// }
// }
// catch (Exception ex)
// {
// //txtError.Text = ex.ToString();
// }
//}
void clk_print()
{
{
try
{
if (DD_Orgnsi.SelectedValue != "" || dd_org_pen.SelectedValue != "" || DD_JABAT.SelectedValue != "")
{
if (txt_tmula.Text != "")
{
string datedari = txt_tmula.Text;
DateTime dt2 = DateTime.ParseExact(datedari, "dd/MM/yyyy", CultureInfo.InvariantCulture);
fromdate = dt2.ToString("yyyy/MM/dd");
}
else
{
fromdate = "";
}
if (txt_takhir.Text != "")
{
string datedari1 = txt_takhir.Text;
DateTime dt1 = DateTime.ParseExact(datedari1, "dd/MM/yyyy", CultureInfo.InvariantCulture);
todate = dt1.ToString("yyyy/MM/dd");
}
else
{
todate = "";
}
selqry();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
//dt = DBCon.Ora_Execute_table("select stf_staff_no,stf_name,hr_jaw_desc,a.LIND,b.HIND from hr_staff_profile as SF left join hr_attendance as AT on AT.atd_staff_no=SF.stf_staff_no left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=stf_curr_post_cd full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as LIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_hol_late_ind='L' group by atd_staff_no,atd_hol_late_ind) a on a.atd_staff_no=SF.stf_staff_no full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as HIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_hol_late_ind='H' group by atd_staff_no,atd_hol_late_ind) b on b.atd_staff_no=SF.stf_staff_no where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) group by a.LIND,b.HIND,stf_staff_no,stf_name,hr_jaw_desc");
dt = DBCon.Ora_Execute_table("select a.stf_staff_no,UPPER(a.stf_name) as stf_name,UPPER(ISNULL(jw.hr_jaw_desc,'')) as hr_jaw_desc,UPPER(ISNULL(op.op_perg_name,'')) as op_perg_name,UPPER(ISNULL(JB.oj_jaba_desc,'')) as oj_jaba_desc,ISNULL(b.LIND,'') LIND,ISNULL(c.HIND,'') HIND from (select * from hr_staff_profile as hp where " + sqry1 + ") as a full outer join (select hp.stf_staff_no,COUNT(atd_hol_late_ind) as LIND from hr_staff_profile as hp left join hr_attendance as ha on ha.atd_staff_no = hp.stf_staff_no and atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + fromdate + "'), 0) and atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + todate + "'), 0) where atd_hol_late_ind='L' and " + sqry1 + " group by stf_staff_no) as b on b.stf_staff_no=a.stf_staff_no full outer join (select hp.stf_staff_no,COUNT(atd_hol_late_ind) as HIND from hr_staff_profile as hp left join hr_attendance as ha on ha.atd_staff_no = hp.stf_staff_no and atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + fromdate + "'), 0) and atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + todate + "'), 0) where atd_hol_late_ind='H' and " + sqry1 + " group by stf_staff_no) as c on c.stf_staff_no=a.stf_staff_no left join hr_organization_jaba JB on jb.oj_jaba_cd=a.stf_curr_dept_cd and jb.oj_perg_code=a.stf_cur_sub_org left join hr_organization_pern OP on op.op_perg_code=a.stf_cur_sub_org left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=a.stf_curr_post_cd order by op.op_perg_code,jb.oj_jaba_cd");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
if (DD_JABAT.SelectedValue != "")
{
sqry2 = DD_JABAT.SelectedItem.Text;
}
else
{
sqry2 = "SEMUA";
}
if (dd_org_pen.SelectedValue != "")
{
sqry3 = dd_org_pen.SelectedItem.Text;
}
else
{
sqry3 = "SEMUA";
}
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
shw_hdr1.Visible = true;
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/HR_REKOD_KEHADIRAN.rdlc";
ReportDataSource rds = new ReportDataSource("HR_rk", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("s1", DD_Orgnsi.SelectedItem.Text),
new ReportParameter("s2", sqry2),
new ReportParameter("s3", txt_tmula.Text),
new ReportParameter("s4", txt_takhir.Text),
new ReportParameter("s5", sqry3),
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DisplayName = "Rekod_Kehadiran -" + DateTime.Now.ToString("ddMMyyyy");
RptviwerStudent.LocalReport.DataSources.Add(rds);
//Refresh
RptviwerStudent.LocalReport.Refresh();
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
else
{
//grid();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
void clk_print()
{
{
try
{
if (dd_org.SelectedValue != "" || dd_jabatan.SelectedValue.Trim() != "" || dd_unit.SelectedValue != "" || tm_date.Text != "" || ta_date.Text != "")
{
if (tm_date.Text != "" && ta_date.Text != "")
{
string d1 = tm_date.Text;
DateTime today1 = DateTime.ParseExact(d1, "dd/MM/yyyy", CultureInfo.InvariantCulture);
phdate1 = today1.ToString("yyyy-MM-dd");
string d2 = ta_date.Text;
DateTime today2 = DateTime.ParseExact(d2, "dd/MM/yyyy", CultureInfo.InvariantCulture);
phdate2 = today2.ToString("yyyy-MM-dd");
}
else
{
phdate1 = "";
phdate2 = "";
}
if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text == "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "'";
}
else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text == "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "'";
}
else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue != "" && tm_date.Text == "" && ta_date.Text == "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "'";
}
else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text == "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "'";
}
else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue != "" && tm_date.Text == "" && ta_date.Text == "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "'";
}
else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text == "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_start_dt='" + phdate1 + "'";
}
else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text != "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_end_dt='" + phdate2 + "'";
}
else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue != "" && tm_date.Text == "" && ta_date.Text == "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "' and aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "'";
}
else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text != "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)";
}
else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue != "" && tm_date.Text != "" && ta_date.Text != "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)";
}
else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text != "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)";
}
else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue != "" && tm_date.Text != "" && ta_date.Text != "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "' and aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)";
}
else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text != "")
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)";
}
else
{
val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id=''";
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = DBCon.Ora_Execute_table("" + val1 + "");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
hdr_txt.Visible = true;
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/hr_lppk.rdlc";
ReportDataSource rds = new ReportDataSource("hr_lppk", dt);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.DisplayName = " PENILAIAN_PRESTASI_" + DateTime.Now.ToString("ddMMyyyy");
//Refresh
RptviwerStudent.LocalReport.Refresh();
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
else
{
//grid();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (TextBox4.Text != "" && DropDownList1.SelectedValue != "")
{
string chk_stf = string.Empty;
act_dt = TextBox4.Text + "-" + DropDownList1.SelectedValue;
DataTable dd_hrsal = new DataTable();
if (Session["roles"].ToString() == "R0001")
{
if (TextBox2.Text == "")
{
chk_stf = TextBox1.Text;
}
else
{
chk_stf = TextBox2.Text;
}
}
else
{
chk_stf = TextBox1.Text;
}
dd_hrsal = DBCon.Ora_Execute_table("select * from hr_income where inc_staff_no='" + chk_stf + "' and inc_month='" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "' and inc_app_sts='A'");
string fmyr = DateTime.Now.ToString("yyyy") + "01";
string cmyr = DateTime.Now.ToString("yyyy") + DateTime.Now.ToString("MM");
DataTable dd_hrsal_dt = new DataTable();
dd_hrsal_dt = DBCon.Ora_Execute_table("select sum(inc_kwsp_amt) as k1,sum(inc_emp_kwsp_amt) as k2,sum(inc_perkeso_amt) as k3,sum(inc_emp_perkeso_amt) as k4,sum(inc_SIP_amt) as k5,sum(inc_emp_SIP_amt) as k6 from hr_income where inc_staff_no='" + chk_stf + "' and inc_month between '01' and '" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "'");
if (dd_hrsal.Rows.Count != 0)
{
DataTable dd_incsum = new DataTable();
dd_incsum = DBCon.Ora_Execute_table("select (sum(inc_pcb_amt) + sum(inc_cp38_amt) + sum(inc_cp38_amt2)) as tt_amt1 from hr_income where inc_staff_no='" + chk_stf + "' and inc_month between '01' and '" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "'");
string incamt = string.Empty;
if (dd_incsum.Rows[0]["tt_amt1"].ToString() != "")
{
incamt = dd_incsum.Rows[0]["tt_amt1"].ToString();
}
else
{
incamt = "0.00";
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = DBCon.Ora_Execute_table("select hsp.stf_name,hsp.stf_epf_no,hsp.stf_tax_no,hsp.stf_socso_no,hsp.str_curr_org_cd,FORMAT(hsp.stf_service_start_dt,'dd/MM/yyyy', 'en-us') as stf_service_start_dt,hsp.stf_staff_no,ISNULL(hsp.stf_bank_acc_no,'') as stf_bank_acc_no,ISNULL(nb.Bank_Name,'') as Bank_Name,hsp.stf_icno,inc_dept_cd,inc_grade_cd,pos_post_cd,ISNULL(jb.hr_jaw_desc,'') as hr_jaba_desc,ISNULL(pt.hr_traf_desc,'') as job_sts from hr_income hi left join hr_staff_profile hsp on hsp.stf_staff_no=hi.inc_staff_no left join hr_post_his hph on hph.pos_staff_no=hsp.stf_staff_no left join Ref_hr_Jawatan as jb on jb.hr_jaw_Code= hsp.stf_curr_post_cd left join Ref_Nama_Bank as nb on nb.Bank_Code=hsp.stf_bank_cd left join Ref_hr_penj_traf pt on pt.hr_traf_Code=pos_job_sts_cd where hsp.stf_staff_no='" + chk_stf + "' and pos_end_dt = '9999-12-31' and hi.inc_month='" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "'");
ds.Tables.Add(dt);
DataTable dt1 = new DataTable();
dt1 = DBCon.Ora_Execute_table("select hd.ded_staff_no,po.hr_poto_desc,ded_deduct_amt,hd.ded_deduct_type_cd from hr_deduction as hd inner join Ref_hr_potongan as PO on PO.hr_poto_Code=hd.ded_deduct_type_cd where hd.ded_staff_no='" + chk_stf + "' and (('" + act_dt.ToString() + "') between FORMAT(hd.ded_start_dt,'yyyy-MM') And FORMAT(hd.ded_end_dt,'yyyy-MM'))");
ds.Tables.Add(dt1);
DataTable dt2 = new DataTable();
dt2 = DBCon.Ora_Execute_table("select a.fxa_staff_no,el.hr_elau_desc as hr_elaun_desc,a.fxa_allowance_amt from (select * from hr_fixed_allowance as fx where ('" + act_dt.ToString() + "' between FORMAT(fx.fxa_eff_dt,'yyyy-MM') And FORMAT(fx.fxa_end_dt,'yyyy-MM')) and fx.fxa_staff_no='" + chk_stf + "') as a left join Ref_hr_jenis_elaun as EL on EL.hr_elau_Code=a.fxa_allowance_type_cd");
ds.Tables.Add(dt2);
DataTable dt3 = new DataTable();
dt3 = DBCon.Ora_Execute_table("select a.xta_staff_no,EL.hr_elau_desc as hr_elaun_desc,a.xta_allowance_amt from (select * from hr_extra_allowance as ea where ea.xta_staff_no='" + chk_stf + "' and ('" + act_dt.ToString() + "' between FORMAT(ea.xta_eff_dt,'yyyy-MM') And FORMAT(ea.xta_end_dt,'yyyy-MM'))) as a left join Ref_hr_jenis_elaun as EL on EL.hr_elau_Code=a.xta_allowance_type_cd");
ds.Tables.Add(dt3);
DataTable dt5 = new DataTable();
dt5 = DBCon.Ora_Execute_table("select *,hr_tung_desc from hr_tunggakan left join Ref_hr_tunggakan on hr_tung_Code=tun_type_cd where tun_staff_no='" + chk_stf + "' and tun_year='" + TextBox4.Text + "' and tun_month='" + DropDownList1.SelectedValue + "'");
ds.Tables.Add(dt5);
DataTable dt6 = new DataTable();
dt6 = DBCon.Ora_Execute_table("select s2.typeklm_desc +' ' + otl_remark as nm1,otl_remark,otl_ot_amt from hr_ot s1 left join Ref_hr_type_klm s2 on s2.typeklm_cd=s1.otl_ot_type_cd where otl_staff_no='" + chk_stf + "' and year(otl_work_dt) = '" + TextBox4.Text + "' and Month(otl_work_dt) = '" + DropDownList1.SelectedValue + "'");
ds.Tables.Add(dt6);
RptviwerStudent.Reset();
string filename;
DataTable dd_org = new DataTable();
dd_org = DBCon.Ora_Execute_table("select org_epf_no,org_socso_no,org_temp_ind,org_income_tax_no,org_name from hr_organization where org_gen_id='" + dt.Rows[0]["str_curr_org_cd"].ToString() + "'");
decimal sal_amt = decimal.Parse(dd_hrsal.Rows[0]["inc_salary_amt"].ToString());
decimal el_amt = decimal.Parse(dd_hrsal.Rows[0]["inc_cumm_fix_allwnce_amt"].ToString());
decimal ll_amt = decimal.Parse(dd_hrsal.Rows[0]["inc_cumm_xtra_allwnce_amt"].ToString());
DataTable dd_hrsal4 = new DataTable();
dd_hrsal4 = DBCon.Ora_Execute_table("select fx.ded_staff_no,sum(fx.ded_deduct_amt) as samt from hr_deduction as fx where ('" + act_dt.ToString() + "' between FORMAT(fx.ded_start_dt,'yyyy-MM') And FORMAT(fx.ded_end_dt,'yyyy-MM')) and fx.ded_staff_no='" + chk_stf + "' group by fx.ded_staff_no");
string hrs4_amt = string.Empty;
if (dd_hrsal4.Rows.Count != 0 && dd_hrsal4.Rows[0]["samt"].ToString() != "")
{
hrs4_amt = double.Parse(dd_hrsal4.Rows[0]["samt"].ToString()).ToString("C").Replace("$", "").Replace("RM", "");
}
else
{
hrs4_amt = "0.00";
}
DataTable dd_inc_tax = new DataTable();
dd_inc_tax = DBCon.Ora_Execute_table("select tax_pcb_amt from hr_income_tax where ('" + act_dt.ToString() + "' between FORMAT(tax_pcb_start_dt ,'yyyy-MM') And FORMAT(tax_pcb_end_dt,'yyyy-MM')) and tax_staff_no='" + chk_stf + "'");
string pcb4_amt = string.Empty;
if (dd_inc_tax.Rows.Count != 0 && dd_inc_tax.Rows[0]["tax_pcb_amt"].ToString() != "")
{
pcb4_amt = double.Parse(dd_inc_tax.Rows[0]["tax_pcb_amt"].ToString()).ToString("C").Replace("$", "").Replace("RM", "");
}
else
{
pcb4_amt = "0.00";
}
DataTable dd_inc_cp38 = new DataTable();
dd_inc_cp38 = DBCon.Ora_Execute_table("select tax_cp38_amt1 from hr_income_tax where ('" + act_dt.ToString() + "' between FORMAT(tax_cp38_start_dt1 ,'yyyy-MM') And FORMAT(tax_cp38_end_dt1,'yyyy-MM')) and tax_type ='2' and tax_staff_no='" + chk_stf + "'");
string hr_cpamt2 = string.Empty;
if (dd_inc_cp38.Rows.Count != 0 && dd_inc_cp38.Rows[0]["tax_cp38_amt1"].ToString() != "")
{
double cp2 = double.Parse(dd_inc_cp38.Rows[0]["tax_cp38_amt1"].ToString());
hr_cpamt2 = cp2.ToString("C").Replace("$", "").Replace("RM", "");
}
else
{
hr_cpamt2 = "0.00";
}
DataTable dd_tun = new DataTable();
dd_tun = DBCon.Ora_Execute_table("select sum(clm_claim_amt) as camt from hr_claim where clm_staff_no='" + chk_stf + "' and clm_month='" + DropDownList1.SelectedValue + "' and clm_year='" + TextBox4.Text + "'");
string ded_at = string.Empty;
DataTable dd_deduct = new DataTable();
//dd_deduct = DBCon.Ora_Execute_table("select sum(ind_deduct_amt) as amt1,ind_ref_no from hr_income_deduct where ind_staff_no='" + TextBox1.Text + "' and ind_deduct_type_cd='04' and ind_month between '01' and '" + DropDownList1.SelectedValue + "' and ind_year='" + TextBox4.Text + "' group by ind_ref_no");
dd_deduct = DBCon.Ora_Execute_table("SELECT top(1) a.amt1,b.ind_ref_no FROM (select sum(ISNULL(ind_deduct_amt,'')) as amt1 from hr_income_deduct where ind_staff_no='" + chk_stf + "' and ind_deduct_type_cd='04' and ind_month between '01' and '" + DropDownList1.SelectedValue + "' and ind_year='" + TextBox4.Text + "') as a full outer join (select * from hr_income_deduct where ind_staff_no='" + chk_stf + "' and ind_deduct_type_cd='04' and ind_month between '01' and '" + DropDownList1.SelectedValue + "' and ind_year='" + TextBox4.Text + "') as b on b.ind_staff_no='" + chk_stf + "'");
if (dd_deduct.Rows.Count != 0 && dd_deduct.Rows[0]["amt1"].ToString() != "")
{
ded_at = dd_deduct.Rows[0]["amt1"].ToString();
}
else
{
ded_at = "0.00";
}
string tun_amt = string.Empty;
if (dd_tun.Rows[0]["camt"].ToString() != "")
{
tun_amt = dd_tun.Rows[0]["camt"].ToString();
}
else
{
tun_amt = "0.00";
}
string aq1 = string.Empty, aq2 = string.Empty, aq3 = string.Empty, aq4 = string.Empty, aq5 = string.Empty, aq6 = string.Empty, aq7 = string.Empty;
string kq1 = string.Empty, kq2 = string.Empty, kq3 = string.Empty, kq4 = string.Empty, kq5 = string.Empty, kq6 = string.Empty;
if (dd_hrsal.Rows[0]["inc_emp_kwsp_amt"].ToString() != "")
{
aq1 = dd_hrsal.Rows[0]["inc_emp_kwsp_amt"].ToString();
}
else
{
aq1 = "0.00";
}
if (dd_hrsal.Rows[0]["inc_emp_perkeso_amt"].ToString() != "")
{
aq2 = dd_hrsal.Rows[0]["inc_emp_perkeso_amt"].ToString();
}
else
{
aq2 = "0.00";
}
if (dd_hrsal.Rows[0]["inc_bonus_amt"].ToString() != "")
{
aq3 = dd_hrsal.Rows[0]["inc_bonus_amt"].ToString();
}
else
{
aq3 = "0.00";
}
if (dd_hrsal.Rows[0]["inc_kpi_bonus_amt"].ToString() != "")
{
aq4 = dd_hrsal.Rows[0]["inc_kpi_bonus_amt"].ToString();
}
else
{
aq4 = "0.00";
}
if (dd_hrsal.Rows[0]["inc_ot_amt"].ToString() != "")
{
aq5 = dd_hrsal.Rows[0]["inc_ot_amt"].ToString();
}
else
{
aq5 = "0.00";
}
if (dd_hrsal.Rows[0]["inc_tunggakan_amt"].ToString() != "")
{
aq6 = dd_hrsal.Rows[0]["inc_tunggakan_amt"].ToString();
}
else
{
aq6 = "0.00";
}
if (dd_hrsal.Rows[0]["inc_emp_sip_amt"].ToString() != "")
{
aq7 = dd_hrsal.Rows[0]["inc_emp_sip_amt"].ToString();
}
else
{
aq7 = "0.00";
}
if (dd_hrsal_dt.Rows[0]["k1"].ToString() != "")
{
kq1 = dd_hrsal_dt.Rows[0]["k1"].ToString();
}
else
{
kq1 = "0.00";
}
if (dd_hrsal_dt.Rows[0]["k2"].ToString() != "")
{
kq2 = dd_hrsal_dt.Rows[0]["k2"].ToString();
}
else
{
kq2 = "0.00";
}
if (dd_hrsal_dt.Rows[0]["k3"].ToString() != "")
{
kq3 = dd_hrsal_dt.Rows[0]["k3"].ToString();
}
else
{
kq3 = "0.00";
}
if (dd_hrsal_dt.Rows[0]["k4"].ToString() != "")
{
kq4 = dd_hrsal_dt.Rows[0]["k4"].ToString();
}
else
{
kq4 = "0.00";
}
if (dd_hrsal_dt.Rows[0]["k5"].ToString() != "")
{
kq5 = dd_hrsal_dt.Rows[0]["k5"].ToString();
}
else
{
kq5 = "0.00";
}
if (dd_hrsal_dt.Rows[0]["k6"].ToString() != "")
{
kq6 = dd_hrsal_dt.Rows[0]["k6"].ToString();
}
else
{
kq6 = "0.00";
}
string jum_pend = (double.Parse(sal_amt.ToString()) + double.Parse(el_amt.ToString()) + double.Parse(ll_amt.ToString()) + double.Parse(aq3.ToString()) + double.Parse(aq4.ToString()) + double.Parse(aq5.ToString()) + double.Parse(aq6.ToString())).ToString("C").Replace("$", "").Replace("RM", "");
//string jum_pote = (double.Parse(dd_hrsal.Rows[0]["inc_ctg_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_kwsp_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_perkeso_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_pcb_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()) + double.Parse(hr_cpamt2.ToString()) + double.Parse(hrs4_amt.ToString())).ToString("C").Replace("$", "").Replace("RM", "");
string jum_pote = (double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_SIP_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_ctg_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_kwsp_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_perkeso_amt"].ToString()) + double.Parse(pcb4_amt.ToString()) /*double.Parse(dd_hrsal.Rows[0]["inc_pcb_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()) +*/ + double.Parse(hrs4_amt.ToString())).ToString("C").Replace("$", "").Replace("RM", "");
string tot_nettamt = (double.Parse(jum_pend) - double.Parse(jum_pote)).ToString("C").Replace("$", "").Replace("RM", "");
string org_typ = string.Empty;
string fname1 = string.Empty;
//if (dd_org.Rows[0]["org_temp_ind"].ToString() == "A")
//{
// org_typ = "ar-rahnu.rdlc";
// //org_typ = "koop_sahabat.rdlc";
// //fname1 = "AR-RAHNU";
//}
//else if (dd_org.Rows[0]["org_temp_ind"].ToString() == "k")
//{
// org_typ = "koop_sahabat.rdlc";
// //fname1 = "KOOP_SAHABAT";
//}
//else if (dd_org.Rows[0]["org_temp_ind"].ToString() == "G")
//{
// org_typ = "GEMALAI_PLANTATION.rdlc";
// //fname1 = "GEMALAI_PLANTATION";
//}
//else
//{
// org_typ = "koop_sahabat.rdlc";
// //fname1 = "KOOP_SAHABAT";
//}
//string img_name = Server.MapPath("~/FILES/org_logo/logo4.png");
//ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc");
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/KTHB_PAYSLIP.rdlc";
RptviwerStudent.LocalReport.EnableExternalImages = true;
string imagePath = new Uri(Server.MapPath("~/FILES/org_logo/" + dd_org.Rows[0]["org_temp_ind"].ToString() + "")).AbsoluteUri;
ReportDataSource rds = new ReportDataSource("ks", dt);
ReportDataSource rds1 = new ReportDataSource("ks1", dt1);
ReportDataSource rds2 = new ReportDataSource("ks2", dt2);
ReportDataSource rds3 = new ReportDataSource("ks3", dt3);
ReportDataSource rds4 = new ReportDataSource("ks5", dt5);
ReportDataSource rds5 = new ReportDataSource("ks6", dt6);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("sal_amt", sal_amt.ToString("C").Replace("$", "")),
new ReportParameter("et_amt", el_amt.ToString("C").Replace("$", "")),
new ReportParameter("ll_amt", ll_amt.ToString("C").Replace("$", "")),
new ReportParameter("tun_amt", double.Parse(tun_amt.ToString()).ToString("C").Replace("$", "")),
new ReportParameter("jum_pen", jum_pend.ToString()),
new ReportParameter("pctg_amt", double.Parse(dd_hrsal.Rows[0]["inc_ctg_amt"].ToString()).ToString("C").Replace("$", "")),
new ReportParameter("ckwsp_amt", double.Parse(dd_hrsal.Rows[0]["inc_kwsp_amt"].ToString()).ToString("C").Replace("$", "")),
new ReportParameter("perk_amt", double.Parse(dd_hrsal.Rows[0]["inc_perkeso_amt"].ToString()).ToString("C").Replace("$", "")),
new ReportParameter("ppcb_amt", double.Parse(dd_hrsal.Rows[0]["inc_pcb_amt"].ToString()).ToString("C").Replace("$", "")),
new ReportParameter("cp38_amt1", double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()).ToString("C").Replace("$", "")),
new ReportParameter("cp38_amt2", hr_cpamt2.ToString()),
new ReportParameter("jum_pote", jum_pote.ToString()),
new ReportParameter("nett_amt", tot_nettamt),
new ReportParameter("kwsp_maj", double.Parse(aq1).ToString("C").Replace("$", "")),
new ReportParameter("perk_maj", double.Parse(aq2).ToString("C").Replace("$", "")),
new ReportParameter("sip_maj", double.Parse(aq7).ToString("C").Replace("$", "")),
new ReportParameter("kwsp_pek", dt.Rows[0]["stf_epf_no"].ToString()),
new ReportParameter("kwsp_majno", dd_org.Rows[0]["org_epf_no"].ToString()),
new ReportParameter("per_pek", dt.Rows[0]["stf_socso_no"].ToString()),
new ReportParameter("per_majno", dd_org.Rows[0]["org_socso_no"].ToString()),
new ReportParameter("sip_pek", dt.Rows[0]["stf_tax_no"].ToString()),
new ReportParameter("sip_majno", dd_org.Rows[0]["org_income_tax_no"].ToString()),
new ReportParameter("cuk_pen", dt.Rows[0]["stf_tax_no"].ToString()),
new ReportParameter("k1", double.Parse(kq1).ToString("C").Replace("$", "")),
new ReportParameter("k2", double.Parse(kq2).ToString("C").Replace("$", "")),
new ReportParameter("k3", double.Parse(kq3).ToString("C").Replace("$", "")),
new ReportParameter("k4", double.Parse(kq4).ToString("C").Replace("$", "")),
new ReportParameter("k5", double.Parse(incamt.ToString()).ToString("C").Replace("$", "")),
new ReportParameter("k6", dd_deduct.Rows[0]["ind_ref_no"].ToString()),
new ReportParameter("k7", double.Parse(ded_at.ToString()).ToString("C").Replace("$", "")),
new ReportParameter("k8", DropDownList1.SelectedItem.Text.ToUpper()),
new ReportParameter("k9", TextBox4.Text),
new ReportParameter("imgname", imagePath),
new ReportParameter("org", dd_org.Rows[0]["org_name"].ToString()),
new ReportParameter("k10", double.Parse(aq3).ToString("C").Replace("$", "")),
new ReportParameter("k11", double.Parse(aq4).ToString("C").Replace("$", "")),
new ReportParameter("k12", double.Parse(aq5).ToString("C").Replace("$", "")),
new ReportParameter("k13", double.Parse(dd_hrsal.Rows[0]["inc_SIP_amt"].ToString()).ToString("C").Replace("$", "")),
new ReportParameter("k14", double.Parse(dd_hrsal.Rows[0]["inc_emp_SIP_amt"].ToString()).ToString("C").Replace("$", "")),
new ReportParameter("k15", double.Parse(kq5).ToString("C").Replace("$", "")),
new ReportParameter("k16", double.Parse(kq6).ToString("C").Replace("$", "")),
new ReportParameter("k17", dt.Rows[0]["job_sts"].ToString()),
new ReportParameter("k18", double.Parse(pcb4_amt).ToString("C").Replace("$", ""))
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.DataSources.Add(rds1);
RptviwerStudent.LocalReport.DataSources.Add(rds2);
RptviwerStudent.LocalReport.DataSources.Add(rds3);
RptviwerStudent.LocalReport.DataSources.Add(rds4);
RptviwerStudent.LocalReport.DataSources.Add(rds5);
RptviwerStudent.LocalReport.DisplayName = "" + dt.Rows[0]["stf_staff_no"].ToString().ToUpper().Trim() + "_" + DropDownList1.SelectedValue + "" + TextBox4.Text + "";
RptviwerStudent.LocalReport.Refresh();
filename = string.Format("{0}.{1}", "" + dt.Rows[0]["stf_staff_no"].ToString().ToUpper().Trim() + "_" + DropDownList1.SelectedValue + "" + TextBox4.Text + "", "pdf");
//}
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila masukan Input Carian',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Issue',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
protected void ctk_values(object sender, EventArgs e)
{
sel_qry();
string stdt1 = string.Empty, eddt1 = string.Empty, vv1 = string.Empty, vv2 = string.Empty;
if (TextBox1.Text != "")
{
DateTime dt_1 = DateTime.ParseExact(TextBox1.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
stdt1 = dt_1.ToString("yyyy-MM-dd");
}
else
{
stdt1 = "SEMUA";
}
if (TextBox3.Text != "")
{
DateTime dt_2 = DateTime.ParseExact(TextBox3.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
eddt1 = dt_2.ToString("yyyy-MM-dd");
}
else
{
eddt1 = "SEMUA";
}
if (ddkat_jaw.SelectedValue != "")
{
vv1 = ddkat_jaw.SelectedItem.Text;
}
else
{
vv1 = "SEMUA";
}
if (dd_unit.SelectedValue != "")
{
vv2 = dd_unit.SelectedItem.Text;
}
else
{
vv2 = "SEMUA";
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = dbcon.Ora_Execute_table("" + val1 + "");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "HR_pen_pertasi1.rdlc";
ReportDataSource rds = new ReportDataSource("HR_pen_pertasi1", dt);
RptviwerStudent.LocalReport.DataSources.Add(rds);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("s1", stdt1),
new ReportParameter("s2", eddt1),
new ReportParameter("s3", vv1),
new ReportParameter("s4", vv2)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
filename = string.Format("{0}.{1}", "Kemaskini_Dokumen_Penilaian_Prestasi_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul');", true);
}
}
protected void ctk_values(object sender, EventArgs e)
{
string rcount = string.Empty;
int count1 = 0;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = DBCon.Ora_Execute_table("select *,s1.stf_name as nama,Format(otd_work_dt,'dd/MM/yyyy') as tdt from hr_daily_ot left join hr_staff_profile s1 on s1.stf_staff_no=otd_staff_no where otd_staff_no='" + Session["New"].ToString() + "' and otd_month='" + DropDownList1.SelectedValue + "' and otd_year='" + Tahun_kew.SelectedItem.Text + "'");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
if (sel_frmt.SelectedValue == "01")
{
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/jadual_klm.rdlc";
ReportDataSource rds = new ReportDataSource("jadualklm", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("s1", Tahun_kew.SelectedItem.Text),
new ReportParameter("s2", DropDownList1.SelectedItem.Text)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
filename = string.Format("{0}.{1}", "Jadual_KLM_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (sel_frmt.SelectedValue == "02")
{
System.Text.StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "Jadual_KLM_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("No Kakitangan ,Nama Kakitangan, Tarikh, Masa Mula, Masa Akhir, Keterangan, Jumlah Jam" + Environment.NewLine);
for (int i = 0; i < dt.Rows.Count; i++)
{
builder.Append(dt.Rows[i]["otd_staff_no"].ToString() + "," + txt_nama.Text + "," + dt.Rows[i]["tdt"].ToString() + "," + dt.Rows[i]["otd_time_start"].ToString() + "," + dt.Rows[i]["otd_time_end"].ToString() + "," + dt.Rows[i]["otd_desc"].ToString() + "," + dt.Rows[i]["otd_total_hour"].ToString() + Environment.NewLine);
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
grid();
}
protected void Click_print(object sender, EventArgs e)
{
try
{
string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty;
if (Txtnokp.Text != "")
{
if (DropDownList4.SelectedValue != "")
{
//Path
DataSet ds = new DataSet();
DataTable dt = new DataTable();
//dt = DBCon.Ora_Execute_table("SELECT DISTINCT A.mem_member_no, A.mem_name, A.mem_address, A.mem_new_icno, A.mem_phone_m, A.gender_desc, A.Bangsa_Name, A.Wilayah_Name, A.mem_centre, A.cawangan_name, A.mem_fee_amount, CONVERT(VARCHAR(10),GETDATE(),105) as cdate, B.ftunai,B.fpst,B.SPST,B.STUNAI,B.jumlah,c.sha_approve_Dt, C.sha_item,C. sha_reference_ind,C. sha_debit_amt,C. sha_credit_amt,c.Jumla,d.div_pay_dt,d.div_remark,d.Bank_Name as bname,d.div_bank_acc_no,d.div_debit_amt,a.Applicant_Name,e.ast_end_date,e.ast_monthly_collect_amt,e.ast_st_balance_amt FROM ((select mem_member_no,mem_name,mem_address,mem_new_icno,mem_phone_m,rg.gender_desc,rb.Bangsa_Name,rw.Wilayah_Name,mm.mem_centre,mem_fee_amount,ra.Applicant_Name,br.branch_desc as cawangan_name from mem_member as mm Left join Ref_Wilayah AS rw ON mm.mem_region_cd = rw.Wilayah_Code Left join Ref_Cawangan AS rc ON mm.mem_area_cd=rc.kawasan_code inner join Ref_Bangsa rb on rb.Bangsa_Code=mm.mem_race_cd inner join ref_gender rg on rg.gender_cd=mm.mem_gender_cd inner join Ref_Applicant_Category ra on ra.Applicant_Code=mm.mem_applicant_type_cd left join ref_branch br on br.branch_cd=mm.mem_branch_cd ) a FULL OUTER JOIN (select b.FTUNAI,b.FPST,a.STUNAI,a.SPST, a.STUNAI + a.SPST as Jumlah,a.sha_new_icno from (select * from (select isnull([STUNAI],'') as STUNAI,isnull([SPST],'') as SPST,sha_new_icno from (select SUM(sha_debit_amt) - sum(sha_credit_amt) as Tran_count, case (sha_reference_ind) WHEN 'C' THEN 'STUNAI' WHEN 'P' THEN 'SPST' END MONTHNAME,sha_new_icno from mem_share where sha_new_icno='" + Txtnokp.Text + "' and sha_refund_ind='N' and year(sha_approve_dt) = '" + DropDownList4.SelectedValue + "' group by sha_reference_ind,sha_new_icno ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([STUNAI], [SPST]))AS PivotTable) as final )a full outer join (select * from (select isnull([FTUNAI],'') as FTUNAI,isnull([FPST],'') as FPST,fee_new_icno from (select SUM(fee_amount) as Tran_count, case (fee_payment_type_cd) WHEN 'C' THEN 'FTUNAI' WHEN 'P' THEN 'FPST' END MONTHNAME,fee_new_icno from mem_fee where fee_new_icno='860715235832' and fee_refund_ind='N' group by fee_payment_type_cd,fee_new_icno ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([FTUNAI], [FPST]))AS PivotTable) as final )b on b.fee_new_icno=a.sha_new_icno)b on A.mem_new_icno= '" + Txtnokp.Text + "' FULL OUTER JOIN (select ISNULL(CASE WHEN sha_approve_Dt = '1900-01-01 00:00:00.000' THEN '' ELSE sha_approve_Dt END, '') AS sha_approve_Dt, UPPER(sha_item) as sha_item,case(sha_reference_ind) when 'C' then 'TUNAI' when 'P' then 'PST' end as sha_reference_ind,sha_debit_amt,sha_credit_amt,Jumla=(sum(sha_debit_amt)-Sum(sha_credit_amt)),ms.sha_new_icno from mem_member AS mm left join Ref_Nama_Bank as bn ON mm.mem_bank_cd=bn.Bank_Code Left join mem_share AS ms ON ms.sha_new_icno = mm.mem_new_icno and ms.sha_refund_ind='N' and year(sha_approve_dt) = '" + DropDownList4.SelectedValue + "' group by sha_approve_Dt,sha_item,sha_reference_ind ,sha_debit_amt,sha_credit_amt,sha_new_icno )c on c.sha_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(CHAR(10), div_pay_dt, 105) as div_pay_dt,div_remark,Bank_Name,div_bank_acc_no,div_debit_amt,div_new_icno from mem_member AS mm left join Ref_Nama_Bank as bn ON mm.mem_bank_cd=bn.Bank_Code Left join mem_divident AS md ON md.div_new_icno = mm.mem_new_icno and year(md.div_pay_dt)='" + DropDownList4.SelectedValue + "') d on d.div_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(char(10),ast_end_date,105) as ast_end_date,ast_st_balance_amt,ast_monthly_collect_amt,ast_new_icno from aim_st ) e on e.ast_new_icno=a.mem_new_icno) where a.mem_new_icno='" + Txtnokp.Text + "'");
dt = DBCon.Ora_Execute_table("SELECT DISTINCT Format(fee_approval_dt, 'dd/MM/yyyy') fee_approval_dt,A.mem_member_no, A.mem_name, A.mem_address, A.mem_new_icno, ISNULL(CASE WHEN A.mem_phone_m = 'NULL' THEN '' else A.mem_phone_m END, '') as mem_phone_m, A.gender_desc, A.Bangsa_Name, A.Wilayah_Name, A.mem_centre, A.cawangan_name, A.mem_fee_amount, CONVERT(VARCHAR(10),GETDATE(),105) as cdate, B.ftunai,B.fpst,B.SPST,B.STUNAI,B.jumlah, Convert(CHAR(10),c.sha_txn_dt,105) as sha_approve_Dt, C.sha_item,C. sha_reference_ind,C. sha_debit_amt,C. sha_credit_amt,c.Jumla,d.div_pay_dt,d.div_remark,d.Bank_Name as bname,d.div_bank_acc_no,d.div_debit_amt,a.Applicant_Name,e.ast_end_date,e.ast_monthly_collect_amt,e.ast_st_balance_amt FROM ((select mem_member_no,mem_name,mem_address,mem_new_icno,mem_phone_m,rg.gender_desc,rb.Bangsa_Name,rw.Wilayah_Name,mm.mem_centre,mem_fee_amount,ra.Applicant_Name,br.branch_desc as cawangan_name from mem_member as mm Left join Ref_Wilayah AS rw ON mm.mem_region_cd = rw.Wilayah_Code Left join Ref_Cawangan AS rc ON mm.mem_area_cd=rc.kawasan_code left join Ref_Bangsa rb on rb.Bangsa_Code=mm.mem_race_cd left join ref_gender rg on rg.gender_cd=mm.mem_gender_cd Left join Ref_Applicant_Category ra on ra.Applicant_Code=mm.mem_applicant_type_cd left join ref_branch br on br.branch_cd=mm.mem_branch_cd where mm.Acc_sts='Y') a FULL OUTER JOIN (select b.FTUNAI,b.FPST,a.STUNAI,a.SPST, a.STUNAI + a.SPST as Jumlah,a.sha_new_icno,fee_approval_dt from (select * from (select isnull([STUNAI],'0.00') as STUNAI,isnull([SPST],'0.00') as SPST,sha_new_icno from (select SUM(ISNULL(sha_debit_amt,'0.00')) - sum(ISNULL(sha_credit_amt,'0.00')) as Tran_count, case (sha_reference_ind) WHEN 'C' THEN 'STUNAI' WHEN 'P' THEN 'SPST' END MONTHNAME,sha_new_icno from mem_share where sha_new_icno='" + Txtnokp.Text + "' and Acc_sts ='Y' and sha_refund_ind='N' group by sha_reference_ind,sha_new_icno ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([STUNAI], [SPST]))AS PivotTable) as final )a full outer join (select * from (select isnull([FTUNAI],'') as FTUNAI,isnull([FPST],'') as FPST,fee_new_icno,fee_approval_dt from (select SUM(fee_amount) as Tran_count, case (fee_payment_type_cd) WHEN 'C' THEN 'FTUNAI' WHEN 'P' THEN 'FPST' END MONTHNAME,fee_new_icno,fee_approval_dt from mem_fee where fee_new_icno='" + Txtnokp.Text + "' and Acc_sts ='Y' and fee_refund_ind='N' group by fee_payment_type_cd,fee_new_icno,fee_approval_dt ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([FTUNAI], [FPST]))AS PivotTable) as final )b on b.fee_new_icno=a.sha_new_icno)b on A.mem_new_icno= '" + Txtnokp.Text + "' FULL OUTER JOIN (select ISNULL(CASE WHEN sha_txn_dt = '1900-01-01 00:00:00.000' THEN '' ELSE sha_txn_dt END, '') AS sha_txn_dt, UPPER(sha_item) as sha_item,case(sha_reference_ind) when 'C' then 'TUNAI' when 'P' then 'PST' end as sha_reference_ind,ISNULL(sha_debit_amt,'0.00')sha_debit_amt,ISNULL(sha_credit_amt,'0.00') sha_credit_amt,Jumla=(sum(ISNULL(sha_debit_amt,'0.00'))-Sum(ISNULL(sha_credit_amt,'0.00'))),ms.sha_new_icno from mem_member AS mm left join Ref_Nama_Bank as bn ON mm.mem_bank_cd=bn.Bank_Code Left join mem_share AS ms ON ms.sha_new_icno = mm.mem_new_icno and ms.Acc_sts ='Y' where mm.Acc_sts ='Y' and ms.sha_refund_ind='N' and year(sha_txn_dt) <= '" + DropDownList4.SelectedItem.Text + "' and ms.sha_new_icno='" + Txtnokp.Text + "' group by sha_txn_dt,sha_item,sha_reference_ind ,sha_debit_amt,sha_credit_amt,sha_new_icno )c on c.sha_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(CHAR(10), div_pay_dt, 105) as div_pay_dt,div_remark,Bank_Name,div_bank_acc_no,div_debit_amt,div_new_icno from mem_member AS mm Left join mem_divident AS md ON md.div_new_icno = mm.mem_new_icno left join Ref_Nama_Bank as bn ON md.div_bank_cd=bn.Bank_Code and md.Acc_sts ='Y' where md.div_approve_ind='SA' and mm.Acc_sts ='Y' and md.div_new_icno='" + Txtnokp.Text + "' and year(md.div_pay_dt) <='" + DropDownList4.SelectedItem.Text + "') d on d.div_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(char(10),ast_end_date,105) as ast_end_date,ast_st_balance_amt,ast_monthly_collect_amt,ast_new_icno from aim_st ) e on e.ast_new_icno=a.mem_new_icno) where a.mem_new_icno='" + Txtnokp.Text + "' order by sha_approve_Dt desc");
if (DropDownList4.SelectedValue != "")
{
ss1 = DropDownList4.SelectedItem.Text;
}
if (ddlnegri.SelectedValue != "")
{
ss2 = ddlnegri.SelectedItem.Text;
}
RptviwerStudent.Reset();
ds.Tables.Add(dt);
RptviwerStudent.LocalReport.DataSources.Clear();
//ReportDataSource RDS1 = new ReportDataSource("BANKSLIP", dt1);
//ReportViewer1.ProcessingMode = ProcessingMode.Local;
RptviwerStudent.LocalReport.ReportPath = "keanggotan/Report2.rdlc";
//ReportViewer1.LocalReport.DataSources.Add(RDS1);
ReportDataSource rds = new ReportDataSource("list", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("pyear", ss1),
new ReportParameter("negri", ss2),
new ReportParameter("pscd", TextBox3.Text),
new ReportParameter("app_dt", dt.Rows[0]["fee_approval_dt"].ToString())
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
//Refresh
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
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 = RptviwerStudent.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", "attachment; filename=myfile." + extension);
Response.BinaryWrite(bytes);
//Response.Write("<script>");
//Response.Write("window.open('', '_newtab');");
//Response.Write("</script>");
Response.Flush();
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Sila Pilih Tahun');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Medan Input Adalah Mandatori');", true);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void ctk_values(object sender, EventArgs e)
{
string rcount = string.Empty;
int count1 = 0;
get_det();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = dbcon.Ora_Execute_table("select stf_staff_no,stf_name,stf_icno,clm_rec_dt,format(clm_rec_dt,'dd/MM/yyyy') clm_rec_dt1,ht.hr_tun_desc,clm_claim_amt,format(clm_rec_dt,'dd/MM/yyyy') clm_app_dt1,ISNULL(clm_app_sts,'') as sts,clm_claim_cd,file_name,case when ISNULL(clm_app_sts,'') = '' then 'PENDING' when ISNULL(clm_app_sts,'') = '01' then 'SAH' when ISNULL(clm_app_sts,'')='02' then 'TIDAK SAH' end as sts_desc,case when ISNULL(clm_approve_sts_cd,'') = '' then 'PENDING' when ISNULL(clm_approve_sts_cd,'') = '01' then 'SAH' when ISNULL(clm_approve_sts_cd,'')='02' then 'TIDAK SAH' end as sts_desc1,clm_balance_amt,clm_sebap from hr_claim_new left join hr_staff_profile sp on sp.stf_staff_no=clm_staff_no left join Ref_hr_tuntutan ht on ht.hr_tun_Code=clm_claim_cd " + sqry + "");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/pen_tuntutan.rdlc";
ReportDataSource rds = new ReportDataSource("hrpentut", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("s1", txt_tahun.SelectedItem.Text),
new ReportParameter("s2", DD_bulancaruman.SelectedItem.Text)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
if (sel_frmt.SelectedValue == "01")
{
filename = string.Format("{0}.{1}", "STATUS_TUNTUTAN_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (sel_frmt.SelectedValue == "02")
{
System.Text.StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "STATUS_TUNTUTAN_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("No Kakitangan ,Ic No,Nama Kakitangan, Reciept Date, Apply Date, Jenis Tuntutan, clm_sebap, Amaun (RM), Baki / Jumlah Terkini (RM), Status Kelulusan, Status Pengesahan" + Environment.NewLine);
foreach (GridViewRow row in gvSelected.Rows)
{
string stfno = ((Label)row.FindControl("Label2")).Text.ToString();
string icno = ((Label)row.FindControl("Label3")).Text.ToString();
string name = ((Label)row.FindControl("Label2_name")).Text.ToString();
string rec_dt = ((Label)row.FindControl("Label2_yr")).Text.ToString();
string app_dt = ((Label)row.FindControl("Label4")).Text.ToString();
string jenis = ((Label)row.FindControl("Label5")).Text.ToString();
string amt = ((Label)row.FindControl("Label6_amt")).Text.ToString();
string amt1 = ((Label)row.FindControl("Label6_amt1")).Text.ToString();
string sts = ((Label)row.FindControl("Label5_sts")).Text.ToString();
string sts1 = ((Label)row.FindControl("Label5_sts1")).Text.ToString();
string sebab = ((Label)row.FindControl("Label4_seb")).Text.ToString();
builder.Append(stfno + "," + icno + "," + name + "," + rec_dt + "," + app_dt + "," + jenis + "," + sebab + "," + amt.Replace(",", "") + "," + amt1.Replace(",", "") + "," + sts + "," + sts1 + Environment.NewLine);
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
//else if (sel_frmt.SelectedValue == "03")
//{
// byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings);
// filename = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc");
// Response.Buffer = true;
// Response.Clear();
// Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
// Response.ContentType = mimeType;
// Response.BinaryWrite(bytes);
// Response.Flush();
// Response.End();
//}
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
grid();
}
protected void ctk_values(object sender, EventArgs e)
{
string stdt = string.Empty, eddt = string.Empty;
if (TextBox1.Text != "")
{
DateTime dt_1 = DateTime.ParseExact(TextBox1.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
stdt = dt_1.ToString("yyyy-MM-dd");
}
if (TextBox3.Text != "")
{
DateTime dt_2 = DateTime.ParseExact(TextBox3.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
eddt = dt_2.ToString("yyyy-MM-dd");
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = dbcon.Ora_Execute_table("select FORMAT(a.cap_start_dt,'dd/MM/yyyy') as dt1,FORMAT(a.cap_end_dt,'dd/MM/yyyy') as dt2,a.cap_post_cat_cd,a.cap_unit_cd,a.cap_section_cd,a.cap_subject_cd,a.cap_seq_no,cas.cse_section_desc,cs.csb_subject_desc,a.cap_weightage,c1.hr_jaw_desc,c2.hr_unit_desc from (select * from hr_cmn_appraisal as ca where ca.cap_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + stdt + "'), 0) and ca.cap_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + eddt + "'), +0) and ca.cap_post_cat_cd ='" + ddkat_jaw.SelectedValue + "' and ca.cap_unit_cd ='" + dd_unit.SelectedValue + "') a left join hr_cmn_appr_section as cas on cas.cse_section_cd=a.cap_section_cd left join hr_cmn_subject as cs on cs.csb_subject_cd=a.cap_subject_cd left join Ref_hr_Jawatan c1 on c1.hr_jaw_Code=a.cap_post_cat_cd left join Ref_hr_unit c2 on c2.hr_unit_Code=a.cap_unit_cd");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/HR_pen_pertasi.rdlc";
ReportDataSource rds = new ReportDataSource("HR_pen_pertasi", dt);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
filename = string.Format("{0}.{1}", "JANA_DOKUMEN_PENILAIAN_PRESTASI_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
protected void pdf_Click(object sender, EventArgs e)
{
try
{
sql_info();
DataTable dt = new DataTable();
dt = DBCon.Ora_Execute_table(val1);
//Reset
RptviwerStudent.Reset();
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
if (countRow != 0)
{
// Label1.Text = "";
//Label2.Text = "";
ReportDataSource rds = new ReportDataSource("lapkursus", dt);
RptviwerStudent.LocalReport.DataSources.Add(rds);
//Path
RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/lap_kursus.rdlc";
//ToDate.Text = today.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);
//Parameters
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("d1", tm_date.Text),
new ReportParameter("d2", ta_date.Text),
new ReportParameter("d3", ""),
new ReportParameter("d4", ""),
new ReportParameter("d5", "")
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DisplayName = "LAPORAN_KURSUS_" + DateTime.Now.ToString("ddMMyyyy");
//Refresh
RptviwerStudent.LocalReport.Refresh();
string filename = string.Format("{0}.{1}", "LAPORAN_KURSUS_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
//}
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Tiada Rekod Dijumpai Dalam Julat Tarikh Yang Dimasukkan.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
//Label2.Text = ex.ToString();
}
string script1 = "$(function () { $('[id*=GridView1]').prepend($('<thead></thead>').append($(this).find('tr:first'))).DataTable({ 'responsive': true, 'sPaginationType': 'full_numbers' }); });";
ScriptManager.RegisterStartupScript(this, this.GetType(), "", script1, true);
}
void gen_barcode()
{
try
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
//dt = DBCon.Ora_Execute_table("select ho.org_name,rk.ast_kategori_desc,rja.ast_jeniaset_desc,aca.cas_asset_desc,a.sas_asset_id,a.sas_curr_price_amt,a.sas_asset_cat_cd,a.sas_asset_sub_cat_cd,a.sas_asset_type_cd,a.sas_asset_cd,a.sas_org_id, case a.sas_asset_cat_cd when '01' then (select FORMAT(com_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_component where com_asset_cat_cd=a.sas_asset_cat_cd and com_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and com_asset_type_cd=a.sas_asset_type_cd and com_asset_cd=a.sas_asset_cd) when '02' then (select FORMAT(car_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_car where car_asset_cat_cd=a.sas_asset_cat_cd and car_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and car_asset_type_cd=a.sas_asset_type_cd and car_asset_cd=a.sas_asset_cd) when '03' then (select FORMAT(inv_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_inventory where inv_asset_cat_cd=a.sas_asset_cat_cd and inv_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and inv_asset_type_cd=a.sas_asset_type_cd and inv_asset_cd=a.sas_asset_cd) end as a1, case a.sas_asset_cat_cd when '01' then (select DATEDIFF(day,com_reg_dt,GETDATE()) as u_dt from ast_component where com_asset_cat_cd=a.sas_asset_cat_cd and com_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and com_asset_type_cd=a.sas_asset_type_cd and com_asset_cd=a.sas_asset_cd) when '02' then (select DATEDIFF(day,car_reg_dt,GETDATE()) as u_dt from ast_car where car_asset_cat_cd=a.sas_asset_cat_cd and car_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and car_asset_type_cd=a.sas_asset_type_cd and car_asset_cd=a.sas_asset_cd) when '03' then (select DATEDIFF(day,inv_reg_dt,GETDATE()) as u_dt from ast_inventory where inv_asset_cat_cd=a.sas_asset_cat_cd and inv_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and inv_asset_type_cd=a.sas_asset_type_cd and inv_asset_cd=a.sas_asset_cd) end as a2, case a.sas_asset_cat_cd when '01' then (select com_price_amt from ast_component where com_asset_cat_cd=a.sas_asset_cat_cd and com_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and com_asset_type_cd=a.sas_asset_type_cd and com_asset_cd=a.sas_asset_cd) when '02' then (select car_price_amt from ast_car where car_asset_cat_cd=a.sas_asset_cat_cd and car_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and car_asset_type_cd=a.sas_asset_type_cd and car_asset_cd=a.sas_asset_cd) when '03' then (select inv_price_amt from ast_inventory where inv_asset_cat_cd=a.sas_asset_cat_cd and inv_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and inv_asset_type_cd=a.sas_asset_type_cd and inv_asset_cd=a.sas_asset_cd) end as a3 from (select * from ast_staff_asset where sas_cond_sts_cd = 'DI' and sas_dispose_cfm_ind !='Y') as a left join Ref_ast_kategori as rk on rk.ast_kategori_code=a.sas_asset_cat_cd left join Ref_ast_jenis_aset as rja on rja.ast_jeniaset_Code=a.sas_asset_type_cd left join ast_cmn_asset as aca on aca.cas_asset_cd=a.sas_asset_cd left join hr_organization as ho on ho.org_gen_id=a.sas_org_id");
dt = DBCon.Ora_Execute_table("select sas_asset_id,sas_asset_cat_cd,sas_asset_sub_cat_cd,sas_asset_type_cd,sas_asset_cd,sas_location_cd,s1.ast_jeniaset_desc from ast_staff_asset left join Ref_ast_jenis_aset as s1 on s1.ast_jeniaset_Code=sas_asset_type_cd and s1.ast_sub_cat_Code=sas_asset_sub_cat_cd where sas_asset_id='" + lblid1 + "' order by sas_crt_dt desc");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "Aset/Ast_Barcode.rdlc";
ReportDataSource rds = new ReportDataSource("Bcode", dt);
string bar_code = dt.Rows[0]["sas_asset_id"].ToString();
string ast_type = dt.Rows[0]["ast_jeniaset_desc"].ToString();
string ast_cd = dt.Rows[0]["sas_asset_cd"].ToString();
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("bcode", bar_code),
new ReportParameter("asttype", ast_type),
new ReportParameter("astcd", ast_cd)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
filename = string.Format("{0}.{1}", "Barcode_" + bar_code.ToUpper() + "_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
//string script = " $(function () {$(" + GridView1.ClientID + ").prepend($('<thead></thead>').append($(this).find('tr:first'))).DataTable({'responsive': true,'sPaginationType': 'full_numbers', 'iDisplayLength': 15,'aLengthMenu': [[15, 30, 50, 100], [15, 30, 50, 100]]});});";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "", script, true);
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
catch
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Issue.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
protected void ctk_values(object sender, EventArgs e)
{
string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, ss6 = string.Empty, ss7 = string.Empty, ss8 = string.Empty, ss9 = string.Empty, ss10 = string.Empty, ss11 = string.Empty;
DataSet ds1 = new DataSet();
DataTable dt = new DataTable();
DataTable dh = new DataTable();
DataTable dh1 = new DataTable();
bind_details();
dt = Dbcon.Ora_Execute_table(sqry);
ds1.Tables.Add(dt);
RptviwerStudent.Reset();
RptviwerStudent.LocalReport.Refresh();
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
if (countRow != 0)
{
//ss1_stap1.Visible = true;
DataTable get_pfl = new DataTable();
get_pfl = DBCon.Ora_Execute_table("select syar_logo from KW_Profile_syarikat where cur_sts='1' and Status='A'");
string imagePath = string.Empty;
if (get_pfl.Rows[0]["syar_logo"].ToString() != "")
{
imagePath = new Uri(Server.MapPath("~/FILES/Profile_syarikat/" + get_pfl.Rows[0]["syar_logo"].ToString() + "")).AbsoluteUri;
}
else
{
imagePath = new Uri(Server.MapPath("~/FILES/Profile_syarikat/user.png")).AbsoluteUri;
}
RptviwerStudent.LocalReport.EnableExternalImages = true;
RptviwerStudent.LocalReport.DataSources.Clear();
ReportDataSource rds = new ReportDataSource("Imbungan", dt);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.ReportPath = "kewengan/Kw_Imbungan.rdlc";
// string branch;
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("d1", DropDownList1.SelectedItem.Text),
new ReportParameter("d2", kat_bajet.SelectedItem.Text),
new ReportParameter("d3", imagePath)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
//Refresh
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytes = RptviwerStudent.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", "attatchment; filename=MAKLUMAT_PERIBADI_ANGGOTA." + extension);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
}
void grid()
{
clk_jana();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = dbcon.Ora_Execute_table("select ISNULL(ho.org_name,'') as org_name,rak.ast_kategori_desc,rsk.ast_subkateast_desc,ja.ast_jeniaset_desc,b.amt1 from (select dis_org_id,dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd from ast_dispose where " + vv1 + " group by dis_org_id,dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd) as asa left join Ref_ast_kategori as rak on rak.ast_kategori_code=asa.dis_asset_cat_cd left join Ref_ast_sub_kategri_Aset as rsk on rsk.ast_subkateast_Code=asa.dis_asset_sub_cat_cd left join Ref_ast_jenis_aset as ja on ja.ast_jeniaset_Code=asa.dis_asset_type_cd left join hr_organization as ho on ho.org_gen_id=asa.dis_org_id full outer join (select dis_org_id,dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd,sum(dis_purchase_amt) as amt1 from ast_dispose where " + vv1 + " group by dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd,dis_org_id) as b on b.dis_org_id=asa.dis_org_id and b.dis_asset_cat_cd=asa.dis_asset_cat_cd and b.dis_asset_sub_cat_cd=asa.dis_asset_sub_cat_cd and b.dis_asset_type_cd=asa.dis_asset_type_cd");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, ss6 = string.Empty;
if (DD_Kategori.SelectedValue != "")
{
ss1 = DD_Kategori.SelectedItem.Text.ToUpper();
}
else
{
ss1 = "SEMUA";
}
if (DD_Sub_Kateg.SelectedValue != "")
{
ss2 = DD_Sub_Kateg.SelectedItem.Text.ToUpper();
}
else
{
ss2 = "SEMUA";
}
if (DD_Jenis_ast.SelectedValue != "")
{
ss3 = DD_Jenis_ast.SelectedItem.Text.ToUpper();
}
else
{
ss3 = "SEMUA";
}
if (DD_NAMAAST.SelectedValue != "")
{
ss4 = DD_NAMAAST.SelectedItem.Text.ToUpper();
}
else
{
ss4 = "SEMUA";
}
if (DD_organ.SelectedValue != "")
{
ss5 = DD_organ.SelectedItem.Text.ToUpper();
}
else
{
ss5 = "SEMUA";
}
if (dd_pel.SelectedValue != "")
{
ss6 = dd_pel.SelectedItem.Text.ToUpper();
}
else
{
ss6 = "SEMUA";
}
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
disp_hdr_txt.Visible = true;
RptviwerStudent.LocalReport.ReportPath = "Aset/AST_Laporannayd.rdlc";
ReportDataSource rds = new ReportDataSource("astlastlaporannaydapnamo", dt);
ReportParameter[] rptParams = new ReportParameter[] {
//new ReportParameter("fromDate",FromDate .Text ),
//new ReportParameter("toDate",ToDate .Text )
new ReportParameter("s7", txt_dar.Text),
new ReportParameter("s8", txt_seh.Text),
new ReportParameter("s1", ss1),
new ReportParameter("s2", ss2),
new ReportParameter("s3", ss3),
new ReportParameter("s4", ss4),
new ReportParameter("s5", ss5),
new ReportParameter("s6", ss6)
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.DisplayName = "Laporan_Nilai_Keseluruhan_Aset_" + DateTime.Now.ToString("ddMMyyyy");
RptviwerStudent.LocalReport.Refresh();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
protected void ctk_values(object sender, EventArgs e)
{
if (txt_dar.Text != "" && txt_seh.Text != "")
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string rcount = string.Empty, rcount1 = string.Empty;
int count = 0;
double sum = 0;
dt.Columns.AddRange(new DataColumn[4] {
new DataColumn("nast"), new DataColumn("qnty"), new DataColumn("ast_id"), new DataColumn("ns_rm")
});
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[4].FindControl("chkRow") as CheckBox);
if (chkRow.Checked)
{
string naset = (row.Cells[1].FindControl("Label3") as Label).Text;
string qty = (row.Cells[2].FindControl("Label2") as Label).Text;
string aid = (row.Cells[3].FindControl("Label1") as Label).Text;
string ns = (row.Cells[4].FindControl("Label7") as Label).Text;
dt.Rows.Add(naset, qty, aid, ns);
count++;
double amount = Convert.ToDouble((row.Cells[4].FindControl("Label7") as Label).Text);
sum += amount;
}
rcount = count.ToString();
rcount1 = sum.ToString("0.00");
}
}
string vv1 = string.Empty;
if (DD_nama.SelectedValue != "")
{
vv1 = DD_nama.SelectedItem.Text;
}
//dt = dbcon.Ora_Execute_table("" + mqry + "");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (rcount != "0")
{
RptviwerStudent.LocalReport.ReportPath = "Aset/AST_Hadiah.rdlc";
ReportDataSource rds = new ReportDataSource("asthadiah", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("tot_amt", rcount1),
new ReportParameter("h1", txt_dar.Text),
new ReportParameter("h2", txt_seh.Text),
new ReportParameter("h3", TextBox2.Text),
new ReportParameter("h4", TextBox1.Text),
new ReportParameter("h5", vv1),
new ReportParameter("h6", TextBox3.Text),
new ReportParameter("h7", TextBox4.Text),
//new ReportParameter("h8",TextBox4.Text ),
};
RptviwerStudent.LocalReport.SetParameters(rptParams);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
if (sel_frmt.SelectedValue == "01")
{
filename = string.Format("{0}.{1}", "Pendaftaran_Maklumat_Hadiah_" + DateTime.Now.ToString("ddMMyyyy") + ".", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (sel_frmt.SelectedValue == "02")
{
StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "LAPORAN_NILAI_ASET_YANG" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("Nama Aset,Kuantiti,Nilai Semasa (RM)" + Environment.NewLine);
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[4].FindControl("chkRow") as CheckBox);
if (chkRow.Checked)
{
string nast = ((Label)row.FindControl("Label3")).Text.ToString();
string qty = ((Label)row.FindControl("Label2")).Text.ToString();
string kb = ((Label)row.FindControl("Label7")).Text.ToString();
builder.Append(nast + "," + qty + "," + kb + Environment.NewLine);
}
}
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
else if (sel_frmt.SelectedValue == "03")
{
byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings);
filename = string.Format("{0}.{1}", "LAPORAN_NILAI_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc");
Response.Buffer = true;
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
Response.ContentType = mimeType;
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukan Maklumat.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
protected void ctk_values(object sender, EventArgs e)
{
string rcount = string.Empty;
int count1 = 0;
foreach (GridViewRow gvrow in gvSelected.Rows)
{
var rb = gvrow.FindControl("RadioButton1") as System.Web.UI.WebControls.RadioButton;
if (rb.Checked)
{
count1++;
}
rcount = count1.ToString();
}
if (rcount != "0")
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = dbcon.Ora_Execute_table("select ISNULL(ho.org_name,'') as org_name,ISNULL(dd.dis_dispose_type_cd,'') as dis_dispose_type_cd,rk.ast_kategori_desc,ISNULL(kk.kaedah_desc,'') kaedah_desc,rja.ast_jeniaset_desc,aca.cas_asset_desc,a.sas_asset_id,a.sas_curr_price_amt, a.sas_asset_cat_cd,a.sas_asset_sub_cat_cd,a.sas_asset_type_cd,a.sas_asset_cd,a.sas_org_id, case a.sas_asset_cat_cd when '01' then (select FORMAT(com_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_component where com_asset_id=a.sas_asset_id) when '02' then (select FORMAT(car_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_car where car_asset_id=a.sas_asset_id) when '04' then (select FORMAT(pro_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_property where pro_asset_id=a.sas_asset_id) when '03' then (select FORMAT(inv_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_inventory where inv_asset_id=a.sas_asset_id) end as a1, case a.sas_asset_cat_cd when '01' then (select DATEDIFF(day,com_reg_dt,GETDATE()) as u_dt from ast_component where com_asset_id=a.sas_asset_id) when '02' then (select DATEDIFF(day,car_reg_dt,GETDATE()) as u_dt from ast_car where car_asset_id=a.sas_asset_id) when '04' then (select DATEDIFF(day,pro_reg_dt,GETDATE()) as u_dt from ast_property where pro_asset_id=a.sas_asset_id) when '03' then (select DATEDIFF(day,inv_reg_dt,GETDATE()) as u_dt from ast_inventory where inv_asset_id=a.sas_asset_id) end as a2, case a.sas_asset_cat_cd when '01' then (select com_price_amt from ast_component where com_asset_id=a.sas_asset_id) when '02' then (select car_price_amt from ast_car where car_asset_id=a.sas_asset_id) when '04' then (select pro_buy_amt from ast_property where pro_asset_id=a.sas_asset_id) when '03' then (select inv_price_amt from ast_inventory where inv_asset_id=a.sas_asset_id) end as a3 from (select * from ast_staff_asset where sas_dispose_cfm_ind !='Y' or sas_dispose_cfm_ind IS NULL and sas_cond_sts_cd = '03') as a left join Ref_ast_kategori as rk on rk.ast_kategori_code=a.sas_asset_cat_cd left join Ref_ast_jenis_aset as rja on rja.ast_jeniaset_Code=a.sas_asset_type_cd left join ast_cmn_asset as aca on aca.cas_asset_cd=a.sas_asset_cd and aca.cas_asset_cat_cd=a.sas_asset_cat_cd and aca.cas_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and aca.cas_asset_type_cd=a.sas_asset_type_cd left join hr_organization as ho on ho.org_gen_id=a.sas_org_id left join ast_dispose as dd on dd.dis_asset_id=a.sas_asset_id left join Ref_ast_kaedah_palupusan as kk on kk.kaedah_id=dd.dis_dispose_type_cd");
RptviwerStudent.Reset();
ds.Tables.Add(dt);
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
RptviwerStudent.LocalReport.DataSources.Clear();
if (countRow != 0)
{
RptviwerStudent.LocalReport.ReportPath = "Aset/ast_prp.rdlc";
ReportDataSource rds = new ReportDataSource("astprp", dt);
RptviwerStudent.LocalReport.DataSources.Add(rds);
RptviwerStudent.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string filename;
if (sel_frmt.SelectedValue == "01")
{
filename = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf");
byte[] bytes = RptviwerStudent.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", "attachment; filename=" + filename);
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else if (sel_frmt.SelectedValue == "02")
{
StringBuilder builder = new StringBuilder();
string strFileName = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv");
builder.Append("Organisation ,Kategori Aset,Jenis Aset, Nama Aset, Aset ID, Tarikh Perolehan, Usia Aset, Nilai Perolehan (RM), Nilai Semasa (RM), Kaedah Pelupusan" + Environment.NewLine);
foreach (GridViewRow row in gvSelected.Rows)
{
string oname = ((Label)row.FindControl("Label3")).Text.ToString();
string kaset = ((Label)row.FindControl("Label2")).Text.ToString();
string jaset = ((Label)row.FindControl("Label6")).Text.ToString();
string naset = ((Label)row.FindControl("Label7")).Text.ToString();
string asid = ((Label)row.FindControl("Label8")).Text.ToString();
string tp = ((Label)row.FindControl("Label9")).Text.ToString();
string ua = ((Label)row.FindControl("Label10")).Text.ToString();
string np = ((Label)row.FindControl("Label11")).Text.ToString();
string ns = ((Label)row.FindControl("Label12")).Text.ToString();
string kp = ((DropDownList)row.FindControl("dd_lab1")).SelectedItem.Text.ToString();
builder.Append(oname + "," + kaset + "," + jaset + "," + naset + "," + asid + "," + tp + "," + ua + "," + np + "," + ns + "," + kp + Environment.NewLine);
}
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Write(builder.ToString());
Response.End();
}
//else if (sel_frmt.SelectedValue == "03")
//{
// byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings);
// filename = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc");
// Response.Buffer = true;
// Response.Clear();
// Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
// Response.ContentType = mimeType;
// Response.BinaryWrite(bytes);
// Response.Flush();
// Response.End();
//}
}
else if (countRow == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
}
else
{
BindGrid();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Pilih Rekod Yang Ingin Dihapuskan.',{'type': 'warning','title': 'warning','auto_close': 2000});", true);
}
string script = " $(function () {$(" + gvSelected.ClientID + ") .prepend($('<thead></thead>').append($(this).find('tr:first'))).DataTable({'responsive': true,'sPaginationType': 'full_numbers', 'iDisplayLength': 15,'aLengthMenu': [[15, 30, 50, 100], [15, 30, 50, 100]]});});";
ScriptManager.RegisterStartupScript(this, this.GetType(), "", script, true);
}
