private void btnSearchPaystubs_Click(object sender, EventArgs e)
{
if (dtpStartDate.Value > dtpEndDate.Value)
{
MessageBox.Show("Start Date must be before end date.");
}
else
{
try
{
List <PayStub> paystubs = PaystubFactory.RetrievePaystubsForEmpBetweenDates(emp[listBoxResults.SelectedIndex].EmpID, dtpStartDate.Value, dtpEndDate.Value);
dataGridViewPaystubs.DataSource = paystubs;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
lblError.Text = "";
lblSuccess.Text = "";
if (dtpStart.SelectedDate > dtpEnd.SelectedDate)
{
lblError.Text = "Start Date must be before end date.";
}
else
{
try
{
if (Session["empID"] != null)
{
Calendar date = new Calendar();
//date.TodaysDate.AddYears(-1000)
if (dtpStart.SelectedDate < date.TodaysDate.AddYears(-1000) || dtpEnd.SelectedDate < date.TodaysDate.AddYears(-1000))
{
lblError.Text = "Must select a start and a end date.";
}
else
{
List <PayStub> paystubs = PaystubFactory.RetrievePaystubsForEmpBetweenDates(Convert.ToInt32(Session["empID"]), dtpStart.SelectedDate, dtpEnd.SelectedDate);
dgvItems.DataSource = paystubs;
dgvItems.DataBind();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
}
private void loadDataGrid()
{
List <PayStub> payStubs = PaystubFactory.RetrievePayStubsToday();
dataGridViewPayStubs.DataSource = payStubs;
}
private string createPayStub(Employee emp)
{
PayStub payStub = PaystubFactory.RetrievePayStubByID(emp.EmpID);
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
//HEADER
sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>");
sb.Append("<tr><td align='center' style='background-color: #18B5F0' colspan = '2'><b>Paystub</b></td></tr>");
sb.Append("<tr><td colspan = '2'></td></tr>");
sb.Append("<tr><td><b>Employee ID: </b>");
sb.Append(payStub.EmpID);
sb.Append("</td><td><b>Date: </b>");
sb.Append(payStub.CreationDate);
sb.Append(" </td></tr>");
sb.Append("<tr><td colspan = '2'><b>Employee Name : </b>");
sb.Append(emp.FirstName + ' ' + emp.LastName);
sb.Append("</td></tr>");
sb.Append("</table>");
sb.Append("<br />");
sb.Append("<table border = '1'>");
sb.Append("<tr>");
//COLUMN HEADERS
sb.Append("<th>Employee ID</th>");
sb.Append("<th>Bi-Weekly Rate</th>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(payStub.EmpID);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(emp.BiWeeklyRate);
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</table>");
sb.Append("<br />");
sb.Append("<table border = '1'>");
sb.Append("<tr>");
sb.Append("<th>NetPay</th>");
sb.Append("<th>Gross Pay</th>");
sb.Append("<th>");
sb.Append("Deductions");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("CPP");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("EI");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("Company Pension Deductions");
sb.Append("</th>");
sb.Append("</tr>");
//BODY
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(payStub.Netpay);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.GrossPay);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.Deductions);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.CPP);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.EI);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.CompanyPensionDeduction);
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</table>");
sb.Append("<br />");
// YTD
sb.Append("<table border = '1'>");
sb.Append("<tr>");
sb.Append("<th>");
sb.Append("YTD NetPay");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("YTD Gross Pay");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("YTD Deductions");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("YTD CPP");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("YTD EI");
sb.Append("</th>");
sb.Append("<th>");
sb.Append("YTD Company Pension Deductions");
sb.Append("</th>");
sb.Append("</tr>");
//BODY
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(payStub.YTDNetpay);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.YTDGrossPay);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.YTDDeductions);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.YTDCPP);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.YTDEI);
sb.Append("</td>");
sb.Append("<td>");
sb.Append(payStub.YTDCompanyPensionDeduction);
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</table>");
return(sb.ToString());
}
}
}
