private MemoryStream PrintPayrollSilp(string master, string dateTime1, string dateTime2, string person)
{
string dateFrom = Helper.Safe.SafeDateStr(dateTime1);
string dateTo = Helper.Safe.SafeDateStr(dateTime2);
DateTime from = DateTime.ParseExact(dateFrom, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
DateTime to = DateTime.ParseExact(dateTo, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
string user = HttpContext.Current.User.Identity.Name;
XtraReport rpt = new XtraReport();
string role = SafeValue.SafeString(ConnectSql_mb.ExecuteScalar(string.Format(@"select HrRole from Hr_Person where Id={0}", person)));
if (role.ToLower() == "driver")
{
rpt.LoadLayout(Server.MapPath(@"~\Modules\Hr\Report\repx\PayrollSlip_driver.repx"));
}
else
{
rpt.LoadLayout(Server.MapPath(@"~\Modules\Hr\Report\repx\PayrollSlip.repx"));
}
DataSet set = HrPrint.PrintPaySlip(master, from, to);
DataTable tab_mast = set.Tables[0];
DataTable tab_det = set.Tables[1];
DataTable tab_det1 = set.Tables[2];
if (tab_det.Rows.Count > 0)
{
DevExpress.XtraReports.UI.PageHeaderBand header = rpt.Report.Bands["PageHeader"] as DevExpress.XtraReports.UI.PageHeaderBand;
if (header != null)
{
DevExpress.XtraReports.UI.XRSubreport subReport_Ot = header.FindControl("Overtime_sub", true) as DevExpress.XtraReports.UI.XRSubreport;
subReport_Ot.Name = "Overtime_sub";
XtraReport rpt_Inv = new XtraReport();
rpt_Inv.LoadLayout(Server.MapPath(@"~\Modules\Hr\Report\repx\PayrollSlip_sub.repx"));
subReport_Ot.ReportSource = rpt_Inv;
rpt_Inv.DataSource = tab_det;
}
}
if (tab_det1.Rows.Count > 0)
{
DevExpress.XtraReports.UI.PageHeaderBand header = rpt.Report.Bands["PageHeader"] as DevExpress.XtraReports.UI.PageHeaderBand;
if (header != null)
{
DevExpress.XtraReports.UI.XRSubreport subReport_Ot = header.FindControl("Overtime_sub2", true) as DevExpress.XtraReports.UI.XRSubreport;
subReport_Ot.Name = "Overtime_sub2";
XtraReport rpt_Inv = new XtraReport();
rpt_Inv.LoadLayout(Server.MapPath(@"~\Modules\Hr\Report\repx\PayrollSlip_sub.repx"));
subReport_Ot.ReportSource = rpt_Inv;
rpt_Inv.DataSource = tab_det1;
}
}
rpt.DataSource = set;
System.IO.MemoryStream str = new MemoryStream();
rpt.ExportToPdf(str);
return(str);
}
private MemoryStream PrintCPFContribution(string date1, string date2)
{
XtraReport rpt = new XtraReport();
rpt.LoadLayout(Server.MapPath(@"~\Modules\Hr\Report\repx\CPF_Contribution.repx"));
string[] s1 = date1.Split('/');
string[] s2 = date2.Split('/');
DateTime d1 = new DateTime(SafeValue.SafeInt(s1[2], 0), SafeValue.SafeInt(s1[1], 0), SafeValue.SafeInt(s1[0], 0));
DateTime d2 = new DateTime(SafeValue.SafeInt(s2[2], 0), SafeValue.SafeInt(s2[1], 0), SafeValue.SafeInt(s2[0], 0));
rpt.DataSource = HrPrint.PrintCPFContribution(d1, d2);
System.IO.MemoryStream str = new MemoryStream();
if (docType == "1")
{
rpt.ExportToXls(str);
}
else
{
rpt.ExportToPdf(str);
}
return(str);
}
