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, ""); } }