public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crptPaySlip rpt = new crptPaySlip();
rpt.Site = this.Site;
return(rpt);
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
crptPaySlip rpt = new crptPaySlip();
rpt.Site = this.Site;
return rpt;
}
/// <summary>
/// Function to print PaySlip in curresponding Crystal report
/// </summary>
/// <param name="dsPaySlip"></param>
internal void PaySlipPrinting(DataSet dsPaySlip)
{
try
{
decimal decTotalAdd = 0;
decimal decTotalDed = 0;
decimal decNetPay = 0;
crptPaySlip crptPaySlip = new crptPaySlip();
foreach (DataTable dtbl in dsPaySlip.Tables)
{
if (dtbl.TableName == "Table")
{
crptPaySlip.Database.Tables["dtblCompanyDetails"].SetDataSource(dtbl);
}
else if (dtbl.TableName == "Table1")
{
crptPaySlip.Database.Tables["dtblEmployeeDetails"].SetDataSource(dtbl);
foreach (DataRow drow in dtbl.Rows)
{
if (drow["ADDamount"].ToString() != string.Empty)
{
decTotalAdd += Convert.ToDecimal(drow["ADDamount"].ToString());
}
if (drow["DEDamount"].ToString() != string.Empty)
{
decTotalDed += Convert.ToDecimal(drow["DEDamount"].ToString());
}
}
foreach (DataRow drow in dtbl.Rows)
{
if (drow["LOP"].ToString() != string.Empty)
{
decTotalDed += Convert.ToDecimal(drow["LOP"].ToString());
}
if (drow["Deduction"].ToString() != string.Empty)
{
decTotalDed += Convert.ToDecimal(drow["Deduction"].ToString());
}
if (drow["Advance"].ToString() != string.Empty)
{
decTotalDed += Convert.ToDecimal(drow["Advance"].ToString());
}
if (drow["Bonus"].ToString() != string.Empty)
{
decTotalAdd += Convert.ToDecimal(drow["Bonus"].ToString());
}
break;
}
}
else if (dtbl.TableName == "Table2")
{
DataColumn dtClmn = new DataColumn("AmountInWords");
dtbl.Columns.Add(dtClmn);
decNetPay = decTotalAdd - decTotalDed;
foreach (DataRow drow in dtbl.Rows)
{
drow["AmountInWords"] = new NumToText().AmountWords(decNetPay, PublicVariables._decCurrencyId);
}
crptPaySlip.Database.Tables["dtblOther"].SetDataSource(dtbl);
}
}
this.crptViewer.ReportSource = crptPaySlip;
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("DirectPrint") == "No")
{
base.Show();
this.BringToFront();
}
else
{
crptPaySlip.PrintToPrinter(1, false, 0, 0);
}
}
catch (Exception ex)
{
MessageBox.Show("CRV2 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}