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()); } } }