protected void LoadEmployeeMonthlyPayrollInfo(Int32 EmpId, String MonthYear)
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeMonthlyPayrollInfo(EmpId, MonthYear, Int32.Parse(Page.User.Identity.Name.ToString()));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Standard Pay Components.
{
Tab1Grid.DataSource = _DataList.Tables[0];
Tab1Grid.DataBind();
}
else
{
Tab1Grid.DataSource = null;
Tab1Grid.DataBind();
this.message.Visible = true;
this.message.Text = "Standard Benefit Components(Allowances/Ded) are not setup for this employee.Please setup benefit records via Manage Benefit Screen before payroll process";
this.message.CssClass = "errorMessage";
Payroll_Save.Enabled = false;
return;
}
if (_DataList.Tables[1].Rows.Count > 0) // Adhoc Pay Components
{
Tab2Grid.DataSource = _DataList.Tables[1];
Tab2Grid.DataBind();
}
else
{
Tab2Grid.DataSource = null;
Tab2Grid.DataBind();
}
if (_DataList.Tables[2].Rows.Count > 0) // Leave/Bank Information
{
DataRow _DataRow = _DataList.Tables[2].Rows[0];
Tab1_CurrenyLabel1.Text = "(All Figures in " + _DataRow["CurrencyCode"].ToString() + ")";
Tab1_NoOfDaysPayCycle.Text = _DataRow["TotalDays_PayCycle"].ToString();
Tab1_NofUnpaidDays.Text = _DataRow["TotalDays_Unpaid"].ToString();
Tab1_NetPayDays.Text = _DataRow["NetPayDays"].ToString();
Tab1_UnusedVacDays.Text = _DataRow["UnusedVacDays"].ToString();
payperiod.Visible = true;
Tab1_PayStartDate.Text = _DataRow["PayStartDate"].ToString();
Tab1_PayEndDate.Text = _DataRow["PayEndDate"].ToString();
if (_DataRow["BankAccount"].ToString() != "")
{
Tab1_EmployeeBankAccount.Text = _DataRow["BankAccount"].ToString();
}
if (_DataRow["BankId"].ToString() != "")
{
Tab1_BankName.SelectedValue = _DataRow["BankId"].ToString();
}
if (_DataRow["PayrollNote"].ToString() != "")
{
Tab1_Note.Text = _DataRow["PayrollNote"].ToString();
}
else
{
Tab1_Note.Text = "";
}
LoadPayrollStatusTypeLookup(Tab1_PayrollStatusType, (int)Constants.PayrollStatusType.Preview);
if (Int32.Parse(_DataRow["PayrollStatusTypeID"].ToString()) == (int)Constants.PayrollStatusType.Processed) // Allow to view pay slip
{
LoadPayrollStatusTypeLookup(Tab1_PayrollStatusType, (int)Constants.PayrollStatusType.Processed);
Payroll_Save.Enabled = false;
Payroll_StartOver.Enabled = false;
// Enable payroll download link
WPSDownloadLink.Visible = true;
WPSDownloadLink.Text = "Click here to view this pay slip";
WPSDownloadLink.CssClass = "validationtxt";
WPSDownloadLink.NavigateUrl = "~/Payroll/ViewPayStub.aspx?empId=" + EmpId + "&PayMonthYear=" + MonthYear;
WPSDownloadLink.Target = "_blank";
}
else
{
Payroll_Save.Enabled = true;
Payroll_StartOver.Enabled = true;
}
if (Int32.Parse(_DataRow["PayrollStatusTypeID"].ToString()) == (int)Constants.PayrollStatusType.Pending) // Allow Preview
{
// Enable payroll download link
WPSDownloadLink.Visible = true;
WPSDownloadLink.Text = "Click here to preview this pay slip";
WPSDownloadLink.CssClass = "validationtxt";
WPSDownloadLink.NavigateUrl = "~/Payroll/ViewPayStub.aspx?empId=" + EmpId + "&PayMonthYear=" + MonthYear;
WPSDownloadLink.Target = "_blank";
}
if (Int32.Parse(_DataRow["PayrollStatusTypeID"].ToString()) == (int)Constants.PayrollStatusType.New) // New. Hide the link
{
WPSDownloadLink.Visible = false;
}
if (_DataRow["PayrollStatusTypeID"].ToString() != "")
{
Tab1_PayrollStatusType.SelectedValue = _DataRow["PayrollStatusTypeID"].ToString();
}
Tab1_NetPay.Text = _DataRow["NetPay"].ToString();
if (_DataRow["EOSPayout"].ToString() == "1")
{
Tab1_EOSCheckBox.Checked = true;
}
else
{
Tab1_EOSCheckBox.Checked = false;
}
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "");
}
}
protected void LoadEmployeeMonthlyPayrollInfo(Int32 EmpId, String MonthYear)
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeMonthlyPayrollHistoryInfo(EmpId, MonthYear);
if (_DataList.Tables.Count > 0)
{
this.message.Text = "";
if (_DataList.Tables[0].Rows.Count > 0) // Standard Pay Components.
{
Tab1Grid.DataSource = _DataList.Tables[0];
Tab1Grid.DataBind();
}
else
{
Tab1Grid.DataSource = null;
Tab1Grid.DataBind();
}
if (_DataList.Tables[1].Rows.Count > 0) // Leave/Bank Information
{
DataRow _DataRow = _DataList.Tables[1].Rows[0];
Tab1_CurrenyLabel1.Text = "(All Figures in " + _DataRow["CurrencyCode"].ToString() + ")";
Tab1_NoOfDaysPayCycle.Text = _DataRow["TotalDays_PayCycle"].ToString();
Tab1_NofUnpaidDays.Text = _DataRow["TotalDays_Unpaid"].ToString();
Tab1_NetPayDays.Text = _DataRow["NetPayDays"].ToString();
Tab1_NetPay.Text = _DataRow["NetPay"].ToString();
if (_DataRow["BankAccount"].ToString() != "")
{
Tab1_EmployeeBankAccount.Text = _DataRow["BankAccount"].ToString();
}
if (_DataRow["BankId"].ToString() != "")
{
Tab1_BankName.SelectedValue = _DataRow["BankId"].ToString();
}
if (_DataRow["PayrollNote"].ToString() != "")
{
Tab1_Note.Text = _DataRow["PayrollNote"].ToString();
}
LoadPayrollStatusTypeLookup(Tab1_PayrollStatusType, (int)Constants.PayrollStatusType.Preview);
if (_DataRow["PayrollStatusTypeID"].ToString() == "3") // Processed. Change this later.
{
LoadPayrollStatusTypeLookup(Tab1_PayrollStatusType, (int)Constants.PayrollStatusType.Processed);
}
if (_DataRow["PayrollStatusTypeID"].ToString() != "")
{
Tab1_PayrollStatusType.SelectedValue = _DataRow["PayrollStatusTypeID"].ToString();
}
if (_DataRow["EOSPayout"].ToString() == "1")
{
Tab1_EOSCheckBox.Checked = true;
}
else
{
Tab1_EOSCheckBox.Checked = false;
}
// Enable payroll download link
WPSDownloadLink.Visible = true;
WPSDownloadLink.Text = "Click here to view this pay slip";
WPSDownloadLink.CssClass = "validationtxt";
// Page.ClientScript.RegisterStartupScript(this.GetType(), "windowopen", @"<script>function openWindow(link){window.open (link,'mywindow','status=1,toolbar=1');return false; }</script>", true);
// WPSDownloadLink.NavigateUrl = "javascript:openWindow('http://localhost:64739/HRMSNet/Payroll/ViewPayStub.aspx?empId='" + EmpId + "'&PayMonthYear='" + MonthYear + ")";
WPSDownloadLink.NavigateUrl = "~/Payroll/ViewPayStub.aspx?empId=" + EmpId + "&PayMonthYear=" + MonthYear;
WPSDownloadLink.Target = "_blank";
}
}
else
{
this.message.Visible = true;
WPSDownloadLink.Visible = false;
this.message.Text = "No Processed payroll data available for this Pay Period.";
this.message.CssClass = "errorMessage";
return;
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "");
}
}
