private void SetSelectedUser()
{
if (ddUser.SelectedValue != "")
{
pnlSelectedUser.Visible = true;
DataSet ds = ATMDB.GetDataSet("up_sec_getUser", ddUser.SelectedValue);
ds.Tables[0].TableName = "Centers";
ds.Tables[1].TableName = "Sections";
ds.Tables[2].TableName = "Functions";
dlSections.DataSource = "";
dlSections.DataBind();
dlSections.DataSource = new DataView(ds.Tables[1], "", "DisplayOrder ASC", DataViewRowState.CurrentRows);
dlSections.DataBind();
lbCenters.ClearSelection();
foreach (DataRowView center in ds.Tables["Centers"].DefaultView)
{
WebCommon.SelectListValue(lbCenters, center["SygmaCenterNo"].ToString(), true);
}
}
else
{
pnlSelectedUser.Visible = false;
}
}
protected void ddAddRateType_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet dsRateTypes = ATMDB.GetDataSet("up_p_getPayRatesWithCategories", ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue);
string categoryFilter = string.Format("RateTypeId={0}", ddAddRateType.SelectedValue);
string NotesFilter = string.Format("RateTypeId={0}", ddAddRateType.SelectedValue);
DataView dvNotes = new DataView(dsRateTypes.Tables[0], NotesFilter, "RateTypeId asc", DataViewRowState.CurrentRows);
rfvNotes.Visible = Convert.ToBoolean(dvNotes[0][2]);
if (dsRateTypes.Tables[1].Rows.Count > 0)
{
DataView dvCategories = new DataView(dsRateTypes.Tables[1], categoryFilter, "CategoryId asc", DataViewRowState.CurrentRows);
if (dvCategories.Count > 0)
{
pnlCategory.Visible = true;
ddAddCategory.DataSource = dvCategories;
ddAddCategory.DataBind();
}
else
{
pnlCategory.Visible = false;
}
}
else
{
pnlCategory.Visible = false;
}
}
protected override void LoadATMPage()
{
var ds = ATMDB.GetDataSet("up_p_getFormCriteria", UserName);
var count = ds.Tables[2].Rows.Count;
if (IsPostBack)
{
return;
}
lbSygmaCenterNo.DataSource = ds.Tables[2].DefaultView;
lbSygmaCenterNo.DataBind();
if (count > 1)
{
lbSygmaCenterNo.Items.Insert(0, new ListItem("All", "0"));
lbSygmaCenterNo.ClearSelection();
lbSygmaCenterNo.Height = 15 * (count + 2);
lbSygmaCenterNo.SelectedIndex = 0;
}
else if (count == 1)
{
lbSygmaCenterNo.SelectedIndex = 0;
lbSygmaCenterNo.Height = 45;
}
else
{
lbSygmaCenterNo.Width = 100;
}
}
private void SetPreviewRateAndSchedule()
{
if (ddApsSygmaCenterNo.SelectedValue != "")
{
cbAps.Visible = true;
DataSet dsAps = ATMDB.GetDataSet("up_getApsFlagAndPreviewPay", ddApsSygmaCenterNo.SelectedValue);
if (Convert.ToBoolean(dsAps.Tables[0].Rows[0][0]))
{
cbAps.Checked = true;
txtPrevNetPay.Visible = true;
lblPreview.Visible = true;
pnlApsSchedule.Visible = true;
if (dsAps.Tables[1].Rows.Count > 0 && !Convert.IsDBNull(dsAps.Tables[1].Rows[0][0]))
{
txtPrevNetPay.Text = dsAps.Tables[1].Rows[0][0].ToString();
}
txtPrevNetPayCopy.Text = txtPrevNetPay.Text;
SetAPSchedule();
}
else
{
cbAps.Checked = false;
txtPrevNetPay.Visible = false;
lblPreview.Visible = false;
pnlApsSchedule.Visible = false;
}
}
else
{
txtPrevNetPay.Visible = false;
lblPreview.Visible = false;
cbAps.Visible = false;
pnlApsSchedule.Visible = false;
}
}
protected override void LoadATMPage()
{
isUserSelectedDateRange = false;
DataSet dsIsApprover = ATMDB.GetDataSet("up_user_isApprover", UserName);
isApprover = Convert.ToInt32(dsIsApprover.Tables[0].Rows[0][0].ToString());
if (!IsPostBack)
{
Session["sUserName"] = UserName;
SetSearchCriteria();
RegisterSelectableGridView(gvForms);
SetSelectedActions();
InitializeDateRanges();
}
if (Session["sUserName"] == null)
{
Session["sUserName"] = UserName;
}
gvForms.PageSize = RowCountBar1.PageSize;
DataSet dsDrivers = ATMDB.GetDataSet("up_p_getDrivers");
dtDrivers = dsDrivers.Tables[0];
DataSet dsHelpers = ATMDB.GetDataSet("up_p_getDriverHelpers");
dtHelper = dsHelpers.Tables[0];
AddClientVariable("gUserName", UserName);
}
protected void ddSygmaCenterNo_SelectedIndexChanged(object sender, EventArgs e)
{
var sygmaCenterNo = Convert.ToInt32(ddSygmaCenterNo.SelectedValue);
var dataSet = ATMDB.GetDataSet("up_p_getweekending", sygmaCenterNo);
var dt = new DataTable();
dt.Columns.Add("FiscalWeekending");
dt.Columns.Add("FieldValue");
var count = dataSet.Tables[0].Rows.Count;
if (count != 0)
{
for (var i = 0; i < count; i++)
{
dt.Rows.Add();
dt.Rows[i][0] = Convert.ToDateTime(dataSet.Tables[0].Rows[i][0]).ToShortDateString();
dt.Rows[i][1] = Convert.ToDateTime(dataSet.Tables[0].Rows[i][0]).ToShortDateString();
}
}
ddlWeekending.DataSource = dt;
ddlWeekending.DataBind();
btnSend.Enabled = dt.Rows.Count > 0;
}
private void SetEmployeeDetail()
{
DataSet ds = ATMDB.GetDataSet("up_user_getPayRates", gEmployeeId);
if (ds.Tables[3].Rows.Count > 0)
{
ds.Tables[0].TableName = "PayScales";
ds.Tables[2].TableName = "PayRates";
if (ds.Tables["PayRates"].Rows.Count > 0)
{
rptPayScales.DataSource = ds;
rptRateTypeHeader.DataSource = new DataView(ds.Tables[1], "", "RateTypeDisplayOrder asc", DataViewRowState.CurrentRows);
pnlEmployeeDetail.DataBind();
pnlEmployeeDetail.Visible = true;
}
else
{
lblNoPayScales.Visible = true;
}
DataRow emplRow = ds.Tables[3].Rows[0];
decimal progRate = Convert.ToDecimal(emplRow["ProgressionRate"]);
lblEmployeeName.Text = emplRow["WebDisplay"].ToString();
if (progRate != 1)
{
lblProgRateApplied.Text = string.Format("<span style='font-weight: normal;'>Progression rate of <b>{0:0.####%}</b> applied to values in bold</span>", progRate);
}
}
else
{
pnlNoEmployee.Visible = true;
}
}
protected override void LoadATMPage()
{
if (!IsPostBack)
{
DataSet dsCenter = ATMDB.GetDataSet("up_getCenters ", UserName);
ddSygmaCenterNo.DataSource = dsCenter;
ddSygmaCenterNo.DataBind();
txtWeekendingDate.Text = (DateTime.Now.AddDays(6 - Convert.ToInt32(DateTime.Now.DayOfWeek))).ToShortDateString();
}
}
protected override void LoadATMPage()
{
SetPageVariables();
if (!IsPostBack)
{
LoadCenters();
DataSet dsClassification = ATMDB.GetDataSet("up_p_getCentersAndClassifications");
dtClassifications = dsClassification.Tables[1];
}
}
protected void btnRunNow_Click(object sender, EventArgs e)
{
try
{
DataSet dsForms = ATMDB.GetDataSet("up_p_GuaranteedPay", UserName, ddSygmaCenterNo.SelectedValue, txtWeekendingDate.Text);
Page.ClientScript.RegisterStartupScript(this.GetType(), "Javascript", "javascript:ConfirmationWithIds('" + dsForms.Tables[1].Rows[0][0].ToString() + "');", true);
}
catch (Exception exp)
{
throw new Exception("Error generating Misc Forms", exp);
}
}
protected void ddSygmaCenterNo_SelectedIndexChanged(object sender, EventArgs e)
{
//Refersh Employees list box
DataSet dsEmployees = ATMDB.GetDataSet("up_getEmployees", UserName, ddSygmaCenterNo.SelectedValue);
lbEmployees.DataSource = dsEmployees;
lbEmployees.DataBind();
for (int i = 0; i < lbEmployees.Items.Count; i++)
{
lbEmployees.Items[i].Selected = true;
}
}
private void SetPageNames()
{
//Retrieve the list of all ATM page names
var pageListDs = ATMDB.GetDataSet("up_getAllAtmPageNames");
//Populate the values into lblPageNames
ddPageNames.DataSource = pageListDs.Tables[0];
ddPageNames.DataBind();
ddPageNames.Items.Insert(0, new ListItem("All Pages", "0"));
ddPageNames.ClearSelection();
ddPageNames.Height = 15 * (pageListDs.Tables[0].Rows.Count - 15);
ddPageNames.SelectedIndex = 0;
}
protected override void LoadATMPage()
{
setPageVariables();
if (IsPostBack)
{
return;
}
RowCountBar1.PageSize = 25;
loadCenters();
var dsPayScales = ATMDB.GetDataSet("up_p_getPayScales");
dtPayScales = dsPayScales.Tables[0];
}
public void SetPayScale()
{
DataSet dsPayScale = ATMDB.GetDataSet("up_p_getPayScales");
ddPayScale.DataSource = dsPayScale;
ddPayScale.DataBind();
if (dsPayScale.Tables[0].Rows.Count > 0)
{
DataSet dsRateTypes = ATMDB.GetDataSet("up_p_getPayRatesWithCategories", ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue);
//DataView dvEnabled = new DataView(dsRateTypes.Tables[0], "IsEnabled = 1", "RateTypeId asc", DataViewRowState.CurrentRows);
ddAddRateType.DataSource = dsRateTypes.Tables[0];
ddAddRateType.DataBind();
//string categoryFilter = string.Format("RateTypeId={0}", dsRateTypes.Tables[0].Rows[0][0]);
if (dsRateTypes.Tables[1].Rows.Count > 0)
{
if (dsRateTypes.Tables[0].Rows.Count > 0)
{
string categoryFilter = string.Format("RateTypeId={0}", dsRateTypes.Tables[0].Rows[0][0]);
rfvNotes.Visible = Convert.ToBoolean(dsRateTypes.Tables[0].Rows[0][2]);
//if (dsRateTypes.Tables[0].Rows[0][2].ToString() == "0")
//{
// rfvNotes.Visible = false;
//}
//else
//{
// rfvNotes.Visible = true;
//}
DataView dvCategories = new DataView(dsRateTypes.Tables[1], categoryFilter, "CategoryId asc", DataViewRowState.CurrentRows);
if (dvCategories.Count > 0)
{
pnlCategory.Visible = true;
ddAddCategory.DataSource = dvCategories;
ddAddCategory.DataBind();
}
else
{
pnlCategory.Visible = false;
}
}
else
{
pnlCategory.Visible = false;
}
}
else
{
pnlCategory.Visible = false;
}
}
}
public void SetCenters()
{
DataSet dsCenters = ATMDB.GetDataSet("up_getCenters", UserName);
ddSygmaCenterNo.DataSource = dsCenters;
ddSygmaCenterNo.DataBind();
ddSygmaCenterNo.Items.Insert(0, "Choose...");
ddSygmaCenterNo.SelectedIndex = 0;
if (ddSygmaCenterNo.Items.Count == 2)
{
ddSygmaCenterNo.SelectedIndex = 1;
CenterSelectionIndexChanged();
}
}
protected override void LoadATMPage()
{
if (IsPostBack)
{
return;
}
var dsCenter = ATMDB.GetDataSet("up_p_getFormCriteria", UserName);
ddSygmaCenterNo.DataSource = dsCenter.Tables[2].DefaultView;
ddSygmaCenterNo.DataBind();
if (dsCenter.Tables[2].Rows.Count > 0)
{
var ds = ATMDB.GetDataSet("up_p_getweekending", dsCenter.Tables[2].Rows[0][0].ToString());
var dt = new DataTable();
dt.Columns.Add("FiscalWeekending");
dt.Columns.Add("FieldValue");
var count = ds.Tables[0].Rows.Count;
if (count != 0)
{
for (var i = 0; i < count; i++)
{
dt.Rows.Add();
dt.Rows[i][0] = Convert.ToDateTime(ds.Tables[0].Rows[i][0]).ToShortDateString();
dt.Rows[i][1] = Convert.ToDateTime(ds.Tables[0].Rows[i][1]).ToShortDateString();
}
}
ddlWeekending.DataSource = dt;
ddlWeekending.DataBind();
btnSend.Enabled = dt.Rows.Count > 0;
ds.Clear();
}
if (Session["AdpSuccess"] == null)
{
return;
}
if (Convert.ToBoolean(Session["AdpSuccess"].ToString()))
{
Javascript.Notify("ADP report has been sent to ADP successfully");
}
Session.Remove("AdpSuccess");
}
protected override void LoadATMPage()
{
var ds = ATMDB.GetDataSet("up_p_getFormCriteria", UserName);
var count = ds.Tables[2].Rows.Count;
if (IsPostBack)
{
return;
}
DataView dv = ATMDB.GetDataView("up_getCenters", UserName);
ddSygmaCenterNo.DataSource = dv;
ddSygmaCenterNo.DataBind();
ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", ""));
}
protected void ddSygmaCenterNo_SelectedIndexChanged(object sender, EventArgs e)
{
//Refersh Employees list box
DataSet dsEmployees = ATMDB.GetDataSet("up_getEmployees", UserName, ddSygmaCenterNo.SelectedValue);
lbEmployees.DataSource = dsEmployees;
lbEmployees.DataBind();
for (int i = 0; i < lbEmployees.Items.Count; i++)
{
lbEmployees.Items[i].Selected = true;
}
//refresh rate type drop down
DataSet dsRateTypes = ATMDB.GetDataSet("up_p_getPayRatesWithCategories", ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue);
//DataView dvEnabled = new DataView(dsRateTypes.Tables[0], "IsEnabled = 1", "RateTypeId asc", DataViewRowState.CurrentRows);\
ddAddRateType.DataSource = dsRateTypes.Tables[0];
ddAddRateType.DataBind();
//refresh category dropm down
if (dsRateTypes.Tables[0].Rows.Count > 0)
{
string categoryFilter = string.Format("RateTypeId={0}", dsRateTypes.Tables[0].Rows[0][0]);
rfvNotes.Visible = Convert.ToBoolean(dsRateTypes.Tables[0].Rows[0][2]);
if (dsRateTypes.Tables[1].Rows.Count > 0)
{
DataView dvCategories = new DataView(dsRateTypes.Tables[1], categoryFilter, "CategoryId asc", DataViewRowState.CurrentRows);
if (dvCategories.Count > 0)
{
pnlCategory.Visible = true;
ddAddCategory.DataSource = dvCategories;
ddAddCategory.DataBind();
}
else
{
pnlCategory.Visible = false;
}
}
else
{
pnlCategory.Visible = false;
}
}
else
{
pnlCategory.Visible = false;
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
if (IsValid)
{
try
{
//DataSet dsForms;
string strNotes;
strNotes = txtNotes.Text.Length > 0 ? txtNotes.Text : null;
if (pnlCategory.Visible)
{
gDsForms = ATMDB.GetDataSet("up_p_createMiscFormsWithEmployees", UserName, 2, ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue, ddAddRateType.SelectedValue, txtQuantity.Text, getSelectedEmployees(), RouteNoEdit, dteDepartDate.Text, dteWeekendingDate.Text, ddAddCategory.SelectedValue, strNotes);
}
else
{
gDsForms = ATMDB.GetDataSet("up_p_createMiscFormsWithEmployees", UserName, 2, ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue, ddAddRateType.SelectedValue, txtQuantity.Text, getSelectedEmployees(), RouteNoEdit, dteDepartDate.Text, dteWeekendingDate.Text, null, strNotes);
}
//gDsForms = ATMDB.GetDataSet("up_p_createMiscFormsWithEmployees", UserName, 2, ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue, ddAddRateType.SelectedValue, txtQuantity.Text, getSelectedEmployees(), RouteNoEdit, dteDepartDate.Text, dteWeekendingDate.Text);
gFormIds = gDsForms.Tables[1].Rows[0][0].ToString();
Page.ClientScript.RegisterStartupScript(this.GetType(), "Javascript", "javascript:ConfirmationWithIds('" + gDsForms.Tables[1].Rows[0][0].ToString().Trim() + "');", true);
//if (true)
//{
//}
//foreach (DataRow drForm in gDsForms.Tables[0].Rows)
//{
// i += 1;
// string URL = string.Format("http://localhost:9091/Apps/ATM/Payroll/Forms/AddUpdate.aspx?fid={0}", drForm[0].ToString());
// OpenNewWindow(this, URL, "Form" + i.ToString());
//}
//this.Javascript.Notify("Misc Forms Created Successfully. Form IDs are " + gFormIds);
//Response.Write("<script>alert('Misc Forms Created Successfully. Form IDs are " + gFormIds + "');</script>");
//RedirectToSelf("fid", gFormId.ToString());
//SetFormLoaded();
//SetInitialForm();
//upStatus.Update();
//SetFormInfoView();
}
catch (Exception exp)
{
throw new Exception("Error generating Misc Forms", exp);
}
}
}
public void SetCenters()
{
DataSet dsCenters = ATMDB.GetDataSet("up_getCenters", UserName);
ddSygmaCenterNo.DataSource = dsCenters;
ddSygmaCenterNo.DataBind();
if (dsCenters.Tables[0].Rows.Count > 0)
{
DataSet dsEmployees = ATMDB.GetDataSet("up_getEmployees", UserName, ddSygmaCenterNo.SelectedValue);
lbEmployees.DataSource = dsEmployees;
lbEmployees.DataBind();
for (int i = 0; i < lbEmployees.Items.Count; i++)
{
lbEmployees.Items[i].Selected = true;
}
}
}
protected override void LoadATMPage()
{
var ds = ATMDB.GetDataSet("up_p_getFormCriteria", UserName);
var count = ds.Tables[2].Rows.Count;
if (IsPostBack)
{
return;
}
lbSygmaCenterNo.DataSource = ds.Tables[2].DefaultView;
lbSygmaCenterNo.DataBind();
if (count > 1)
{
lbSygmaCenterNo.Items.Insert(0, new ListItem("All", "0"));
lbSygmaCenterNo.ClearSelection();
lbSygmaCenterNo.Height = 15 * (count + 2);
lbSygmaCenterNo.SelectedIndex = 0;
}
else if (count == 1)
{
lbSygmaCenterNo.SelectedIndex = 0;
lbSygmaCenterNo.Height = 45;
}
else
{
lbSygmaCenterNo.Width = 100;
}
if (!Page.IsPostBack)
{
var today = DateTime.Today;
var lastMonday = today.AddDays(-(int)today.DayOfWeek - 7);
txtStartDate.Text = lastMonday.ToShortDateString();
txtEndDate.Text = lastMonday.AddDays(6).ToShortDateString();
var x = DateRangeCalculator.GetValidDateRanges();
foreach (var item in x)
{
ddlDateRange.Items.Add(new ListItem(item.Key, item.Value.ToString()));
}
ddlDateRange.SelectedIndex = 0;
CalculateDateRanges();
}
}
private void LoadCentersAndClass()
{
DataSet ds = ATMDB.GetDataSet("up_p_getCentersAndClassifications", UserName);
ddHPSygmaCenterNo.DataSource = ds.Tables[0];
ddHPSygmaCenterNo.DataBind();
ddHPSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", ""));
if (ddHPSygmaCenterNo.Items.Count == 2)
{
ddHPSygmaCenterNo.SelectedIndex = 1;
SetHourlyRate();
}
ddClassification.DataSource = ds.Tables[1];
ddClassification.DataBind();
ddClassification.Items.Insert(0, new ListItem("Choose...", ""));
}
protected override void LoadATMPage()
{
if (IsPostBack)
{
return;
}
var ds = ATMDB.GetDataSet("up_p_getFormCriteria", UserName);
var count = ds.Tables[2].Rows.Count;
//Retrieve all pages and populate the ddPageNames
SetPageNames();
//Retrieve Users and populate the ddUsers
lbSygmaCenterNo.DataSource = ds.Tables[2].DefaultView;
lbSygmaCenterNo.DataBind();
if (count > 1)
{
lbSygmaCenterNo.Items.Insert(0, new ListItem("All Centers", "0"));
lbSygmaCenterNo.ClearSelection();
lbSygmaCenterNo.Height = 15 * (count + 2);
lbSygmaCenterNo.SelectedIndex = 0;
}
else if (count == 1)
{
lbSygmaCenterNo.SelectedIndex = 0;
lbSygmaCenterNo.Height = 45;
}
else
{
lbSygmaCenterNo.Width = 100;
}
if (!Page.IsPostBack)
{
ddlEmployeeStatus.Items.Add(new ListItem("Active", "0"));
ddlEmployeeStatus.Items.Add(new ListItem("Inactive", "1"));
ddlEmployeeStatus.Items.Add(new ListItem("Active & Inactive", "2"));
ddlEmployeeStatus.SelectedValue = "0";
}
}
private void SetEmployees()
{
if (ddProgSygmaCenterNo.SelectedIndex > 0)
{
gIsApsEnabledSygmaCenterNo = Convert.ToBoolean(ATMDB.GetScalar("up_p_isApsEnabledCenter", ddProgSygmaCenterNo.SelectedValue));
DataSet dsClassification = ATMDB.GetDataSet("up_p_getCentersAndClassifications");
dtClassifications = dsClassification.Tables[1];
DataView dv = ATMDB.GetDataView("up_getEmployees", UserName, ddProgSygmaCenterNo.SelectedValue);
AddSort(dv);
AddNameFilter(dv);
gvEmployees.DataSource = dv;
gvEmployees.DataBind();
pnlProgression.Visible = true;
lblEmployeeCount.Text = dv.Count.ToString();
}
else
{
pnlProgression.Visible = false;
}
}
/// <summary>
/// Method for emailing the ADP report
/// </summary>
private void sendEmail()
{
try
{
var from = AppSettings.GetAppSetting("adp", "emails", "from");
var dsEmail = ATMDB.GetDataSet("up_p_getAdpToEmail", ddSygmaCenterNo.SelectedValue);
var toEmail = dsEmail.Tables[0].Rows[0][0].ToString();
var subject = "ADP Report - Center" + ddSygmaCenterNo.SelectedValue;
var bccEmails = AppSettings.GetAppSetting("ADP", "emails", "bcc");
var body = new StringBuilder();
body.AppendFormat("Attached is the Sygma ADP Report {0}", Environment.NewLine);
body.AppendFormat("Center: {0} ({1}) {2}", ddSygmaCenterNo.SelectedItem, ddSygmaCenterNo.SelectedValue,
Environment.NewLine);
body.AppendFormat("Weekending Date: {0} {1}", ddlWeekending.SelectedItem, Environment.NewLine);
Email.AddEmails(_email.To, toEmail);
_email.From = new MailAddress(from);
if (bccEmails != string.Empty)
{
Email.AddEmails(_email.Bcc, bccEmails);
}
_email.Priority = MailPriority.High;
_email.Subject = subject;
_email.IsBodyHtml = false;
_email.Body = body.ToString();
buildCSVs();
Email.Send(_email);
ATMDB.GetDataSet("up_p_addAdpLog", Convert.ToInt32(ddSygmaCenterNo.SelectedValue),
Convert.ToDateTime(ddlWeekending.SelectedItem.ToString()), UserName);
Session["AdpSuccess"] = true;
Javascript.Notify("ADP report has been sent to ADP successfully");
}
catch (Exception exp)
{
throw new Exception("Error Sending ADP Report", exp);
}
}
private void SetEmployeesPayroll()
{
if (Session["eprEmployeeIds"] != null && Session["eprCenterNo"] != null && Session["eprFromDate"] != null && Session["eprToDate"] != null && Session["eprRangeBy"] != null && Session["eprGroupByWeekend"] != null)
{
lblInvalidInput.Visible = false;
SygmaCenterNo = Convert.ToInt32(Session["eprCenterNo"]);
EmployeeIds = Session["eprEmployeeIds"].ToString();
RangeBy = Session["eprRangeBy"].ToString();
FromDate = Session["eprFromDate"].ToString();
ToDate = Session["eprToDate"].ToString();
isGroupByWeekending = Convert.ToBoolean(Session["eprGroupByWeekend"]);
isWeekendingRange = (RangeBy == "Week Ending") ? 1 : 0;
//dsEmployeesPayment = ATMDB.GetDataSet("up_p_EmployeesPaymentReport", 30, "538,2798,525,1593", "2014-08-09");
DataSet dsConfig = ATMDB.GetDataSet("up_p_getReportConfig", 11);
string storedproc = dsConfig.Tables[0].Rows[0][0].ToString();
dsEmployeesPayment = ATMDB.GetDataSet(storedproc, SygmaCenterNo, EmployeeIds, FromDate, ToDate, isWeekendingRange);
if (dsEmployeesPayment.Tables[0].Rows.Count > 0)
{
lblNoRecords.Visible = false;
DataSetHelper dsh = new DataSetHelper(dsEmployeesPayment);
if (isGroupByWeekending)
{
dsh.AddDistinctTable("Employees", 0, "WebDisplay", "EmployeeId", "WeekendingDate", "HireDate", "EffectiveHireDate", "ProgressionRate", "PayBandName");
dsh.AddDistinctTable("Routes", 0, "EmployeeId", "RouteNo", "DepartDate", "WeekendingDate");
}
else
{
dsh.AddDistinctTable("Employees", 0, "WebDisplay", "EmployeeId", "HireDate", "EffectiveHireDate", "ProgressionRate", "PayBandName");
dsh.AddDistinctTable("Routes", 0, "EmployeeId", "RouteNo", "DepartDate");
}
rptEmployees.DataSource = dsEmployeesPayment.Tables["Employees"];
rptEmployees.DataBind();
}
}
else
{
lblInvalidInput.Visible = true;
lblNoRecords.Visible = false;
}
}
private void SetEmployeesGridConfiguration()
{
DataSet dsSelectedColumns = ATMDB.GetDataSet("up_p_getProfileCustom", UserName, "MANAGEEMPLOYEES");
if ((dsSelectedColumns.Tables[0].Rows != null) && (dsSelectedColumns.Tables[0].Rows.Count > 0))
{
DataTable dtSelectedCols = JsonConvert.DeserializeObject <DataSet>(dsSelectedColumns.Tables[0].Rows[0]["Value"].ToString()).Tables[0];
// Start Grid column reordering
List <string> columnOrder = CreateColumnOrder(dtSelectedCols);
for (int columnOrderCounter = columnOrder.Count - 1; columnOrderCounter >= 0; columnOrderCounter--)
{
for (int columnCounter = 0; columnCounter <= gvEmployees.Columns.Count - 1; columnCounter++)
{
if (gvEmployees.Columns[columnCounter].HeaderText == columnOrder[columnOrderCounter])
{
var gridColumn = gvEmployees.Columns[columnCounter];
gvEmployees.Columns.RemoveAt(columnCounter);
gvEmployees.Columns.Insert(0, gridColumn);
}
}
}
// Stop Grid column reordering
// Start Grid column hiding
for (int columnCounter = 0; columnCounter <= gvEmployees.Columns.Count - 1; columnCounter++)
{
DataRow selectedDataTableRow = dtSelectedCols.Select("ColumnIdentifier='" + gvEmployees.Columns[columnCounter].HeaderText + "'").FirstOrDefault();
if (selectedDataTableRow == null)
{
gvEmployees.Columns[columnCounter].HeaderStyle.CssClass = "hiddencol";
gvEmployees.Columns[columnCounter].ItemStyle.CssClass = "hiddencol";
}
}
// End Grid column hiding
}
}
protected void CenterSelectionIndexChanged()
{
ClearAllDetails();
lblMessage.Text = "";
lblInvalidDate.Visible = false;
if (ddSygmaCenterNo.SelectedIndex > 0)
{
btnAdd.Enabled = true;
txtWeekendingDate.Enabled = true;
DataSet dsVehicles = ATMDB.GetDataSet("up_p_getVehiclesByCenter", ddSygmaCenterNo.SelectedValue);
DataSet dsTrailers = ATMDB.GetDataSet("up_p_getTrailersByCenter", ddSygmaCenterNo.SelectedValue);
lbVehicles.DataSource = dsVehicles.Tables[0];
lbVehicles.DataBind();
lbTrailers.DataSource = dsTrailers.Tables[0];
lbTrailers.DataBind();
}
else
{
txtWeekendingDate.Enabled = false;
btnAdd.Enabled = false;
}
upFormInfo.Update();
}
private void SetVehicles()
{
if (ddProgSygmaCenterNo.SelectedIndex > 0)
{
DataView dvVehicles = ATMDB.GetDataView("up_getVehicles", UserName, ddProgSygmaCenterNo.SelectedValue);
DataView dvTrailers = ATMDB.GetDataView("up_getTrailers", UserName, ddProgSygmaCenterNo.SelectedValue);
DataTable dtVehicles = dvVehicles.ToTable();
DataTable dtTrailers = dvTrailers.ToTable();
dtVehicles.Merge(dtTrailers);
dtVehicles.AcceptChanges();
DataView dvVehicleTrailer = new DataView(dtVehicles);
DataSet dsTypeMakeStatusObject = ATMDB.GetDataSet("up_getVehicle_Type_Make_Status_ObjectType");
dtVehicleType = dsTypeMakeStatusObject.Tables[0];
dtVehicleMake = dsTypeMakeStatusObject.Tables[1];
dtVehicleStatus = dsTypeMakeStatusObject.Tables[2];
dtVehicleObjectType = dsTypeMakeStatusObject.Tables[3];
DataView dvSygmaCenter = ATMDB.GetDataView("up_getCenters");
dtSygmaCenter = dvSygmaCenter.ToTable();
LoadYear();
LoadReplacedYear();
AddSort(dvVehicleTrailer);
AddNameFilter(dvVehicleTrailer);
AddNameFilter(dvVehicles);
AddNameFilter(dvTrailers);
gvVT.PageSize = (VehicleTrailerRowCountBar1.PageSize > 0) ? VehicleTrailerRowCountBar1.PageSize : 50;
gvVT.DataSource = dvVehicleTrailer;
gvVT.DataBind();
pnlProgression.Visible = true;
VehicleTrailerRowCountBar1.VehiclesCount = dvVehicles.Count;
VehicleTrailerRowCountBar1.TrailersCount = dvTrailers.Count;
VehicleTrailerRowCountBar1.ItemCount = dvVehicles.Count + dvTrailers.Count;
}
else
{
pnlProgression.Visible = false;
}
}
/// <summary>
/// Build the excel adp report and send the temporary stored path of the adp report
/// </summary>
/// <returns> adp report path in temporary folder </returns>
private void buildCSVs()
{
try
{
var centerNo = Convert.ToInt32(ddSygmaCenterNo.SelectedValue);
var weekend = Convert.ToDateTime(ddlWeekending.SelectedItem.ToString());
var ds = ATMDB.GetDataSet("up_p_sendToAdp", centerNo, weekend, UserName,
AppSettings.GetAppSetting("adpmainreport", "ratetype", "required"),
AppSettings.GetAppSetting("adpbonusreport", "ratetype", "required"),
AppSettings.GetAppSetting("adpexpensereport", "ratetype", "required"),
AppSettings.GetAppSetting("adpptoreport", "ratetype", "required"));
var tableCount = ds.Tables.Count;
for (var i = 0; i < tableCount; i++)
{
const int TABLE_INDEX_ADP_REPORT = 0;
const int TABLE_INDEX_BONUS_REPORT_B = 1;
const int TABLE_INDEX_BONUS_REPORT_C = 2;
const int TABLE_INDEX_EXPENSE_REPORT = 3;
string baseFileName;
switch (i)
{
case TABLE_INDEX_ADP_REPORT:
baseFileName = "ADP_Main";
break;
case TABLE_INDEX_BONUS_REPORT_B:
baseFileName = "ADP_Bonus_Tax_B";
break;
case TABLE_INDEX_BONUS_REPORT_C:
baseFileName = "ADP_Bonus_Tax_C";
break;
case TABLE_INDEX_EXPENSE_REPORT:
baseFileName = "ADP_Expense";
break;
default:
baseFileName = "ADP_Pto";
break;
}
var dataTable = ds.Tables[i];
var columnCount = dataTable.Columns.Count;
var hasEarnings = false;
//write header
for (var c = 0; c < columnCount; c++)
{
if (dataTable.Columns[c].ColumnName.StartsWith("EarningCode"))
{
dataTable.Columns[c].Caption = "Earnings 3 Code";
hasEarnings = true;
}
else if (dataTable.Columns[c].ColumnName.StartsWith("EarningAmount"))
{
dataTable.Columns[c].Caption = "Earnings 3 Amount";
hasEarnings = true;
}
else if (dataTable.Columns[c].ColumnName.StartsWith("ExpenseCode"))
{
dataTable.Columns[c].Caption = "Adjust Ded Code";
hasEarnings = true;
}
else if (dataTable.Columns[c].ColumnName.StartsWith("ExpenseAmount"))
{
dataTable.Columns[c].Caption = "Adjust Ded Amount";
hasEarnings = true;
}
else if (dataTable.Columns[c].ColumnName.StartsWith("PayNumber"))
{
dataTable.Columns[c].Caption = "Pay #";
}
else if (dataTable.Columns[c].ColumnName.StartsWith("TaxFrequency"))
{
dataTable.Columns[c].Caption = "Tax Frequency";
}
else
{
dataTable.Columns[c].Caption = dataTable.Columns[c].ColumnName;
}
}
//write data
var fullFileName = getExcelFileFullName(baseFileName);
using (var writer = new StreamWriter(fullFileName))
Rfc4180Writer.WriteDataTable(dataTable, writer, true);
if (hasEarnings)
{
_email.Attachments.Add(new Attachment(fullFileName));
}
}
}
catch (Exception exp)
{
throw new Exception("Error creating ADP Report Excel", exp);
}
}