protected void weeklystd()
{
try
{
lblWkyCustMessage.Visible = false;
lbWkyReasonCodes.Enabled = false;
lbWkyReasonCodes.Height = 73;
DataView dvReasonCode = ATMDB.GetDataView("up_getSelectedReasonCode");
lbWkyReasonCodes.DataSource = dvReasonCode.Table.DefaultView;
lbWkyReasonCodes.DataBind();
foreach (ListItem item in lbWkyReasonCodes.Items)
{
if (item.Value == "18" || item.Value == "40" || item.Value == "41" || item.Value == "60" || item.Value == "61")
{
item.Selected = true;
}
}
}
catch (Exception)
{
log.WriteEntryFormat("Error while loading weekly reason codes");
}
}
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;
}
}
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()
{
if (string.IsNullOrEmpty(Request.QueryString.Get("funcid")))
{
ATMDB.RunNonQuery("up_user_setStartFunction", UserName, Request.QueryString.Get("funcid"));
}
}
private void SetHourlyRate()
{
if (ddHPSygmaCenterNo.SelectedValue != "" && ddClassification.SelectedValue != "")
{
decimal rate = Convert.ToDecimal(ATMDB.GetScalar("up_getHourlyRate", ddHPSygmaCenterNo.SelectedValue, ddClassification.SelectedValue));
if (rate != 0)
{
txtHourlyRate.Enabled = true;
txtHourlyRate.Text = Convert.ToString(rate);
txtPrevHourlyPay.Text = txtHourlyRate.Text;
}
else
{
txtHourlyRate.Enabled = true;
txtHourlyRate.Text = "";
txtPrevHourlyPay.Text = txtHourlyRate.Text;
}
}
else
{
txtHourlyRate.Text = "";
txtPrevHourlyPay.Text = txtHourlyRate.Text;
txtHourlyRate.Enabled = 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);
}
private void LoadCenters()
{
DataView dv = ATMDB.GetDataView("up_getCenters", UserName);
ddSygmaCenterNo.DataSource = dv;
ddSygmaCenterNo.DataBind();
ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", ""));
if (ddSygmaCenterNo.Items.Count == 2)
{
ddSygmaCenterNo.SelectedIndex = 1;
SetPayRateTypes();
}
//ddProgSygmaCenterNo.DataSource = dv;
//ddProgSygmaCenterNo.DataBind();
//ddProgSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", ""));
ddApsSygmaCenterNo.DataSource = dv;
ddApsSygmaCenterNo.DataBind();
ddApsSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", ""));
if (ddApsSygmaCenterNo.Items.Count == 2)
{
ddApsSygmaCenterNo.SelectedIndex = 1;
SetPreviewRateAndSchedule();
}
}
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;
}
protected override void LoadATMPage()
{
if (IsPostBack)
{
return;
}
DataView dv = ATMDB.GetDataView("up_getCenters", UserName);
ddSygmaCenterNo.DataSource = dv;
ddSygmaCenterNo.DataBind();
ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", ""));
ddSygmaCenterNo.Items.Insert(1, new ListItem("All", "0"));
weeklystd();
Quaterlystd();
txtWkyStartDate.Text = (DateTime.Now.AddDays(-Convert.ToInt32(DateTime.Now.DayOfWeek) - 7)).ToShortDateString();
txtWkyEndDate.Text = (DateTime.Now.AddDays(-Convert.ToInt32(DateTime.Now.DayOfWeek) - 1)).ToShortDateString();
DateTime startDate = new DateTime();
DateTime endDate = new DateTime();
string lastQuarter = GetLastQuarterDates(DateTime.Now.Month);
SetLastQuarterDates(out startDate, out endDate, lastQuarter);
txtQtystartDate.Text = Convert.ToDateTime(startDate).ToString("M/dd/yyyy");
txtQtyEndDate.Text = Convert.ToDateTime(endDate).ToString("M/dd/yyyy");
}
protected void Qty_ReasonCode_CheckedChanged(Object sender, EventArgs e)
{
try
{
if (rbQtyStdReasoncodes.Checked)
{
Quaterlystd();
}
if (rbQtyCustReasoncodes.Checked)
{
lblQtyCustMessage.Visible = true;
lbQtyReasonCodes.Enabled = true;
DataView dvReasonCode = ATMDB.GetDataView("up_getReasonCode");
lbQtyReasonCodes.DataSource = dvReasonCode.Table.DefaultView;
lbQtyReasonCodes.DataBind();
lbQtyReasonCodes.Height = 150;
foreach (ListItem item in lbQtyReasonCodes.Items)
{
if (item.Value == "18" || item.Value == "40" || item.Value == "41" || item.Value == "60" || item.Value == "61")
{
item.Selected = true;
}
}
}
}
catch (Exception)
{
log.WriteEntryFormat("Error while loading Quaterly reason codes");
}
}
protected void txtWeekendingDate_TextChanged(object sender, EventArgs e)
{
lblMessage.Text = "";
DateTime date;
if (DateTime.TryParse(txtWeekendingDate.Text, out date))
{
lblInvalidDate.Visible = false;
if (date >= Convert.ToDateTime("01-01-2001") && date <= Convert.ToDateTime("01-01-2099"))
{
DataView dvForms = ATMDB.GetDataView("up_p_getFormsByWeekending", ddSygmaCenterNo.SelectedValue, txtWeekendingDate.Text);
lbRoutes.DataSource = dvForms;
lbRoutes.DataBind();
lbRoutes.Items.Insert(0, "Choose...");
upFormInfo.Update();
}
else
{
txtWeekendingDate.Text = "";
lblInvalidDate.Text = "Invalid Date; Outside available Date Range! ";
lblInvalidDate.Visible = true;
}
}
else
{
lbRoutes.Items.Clear();
if (txtWeekendingDate.Text != "")
{
lblInvalidDate.Text = "Weekending Date is invalid!";
lblInvalidDate.Visible = true;
}
txtWeekendingDate.Text = "";
upFormInfo.Update();
}
}
private void LoadEmployees()
{
DataView dv = ATMDB.GetDataView("up_getNonATMEmployees", ddSygmaCenterNo.SelectedValue);
ddEmployee.DataSource = dv;
ddEmployee.DataBind();
ddEmployee.Items.Insert(0, new ListItem("Choose...", "-1"));
}
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];
}
}
private void LoadCenters()
{
DataView dv = ATMDB.GetDataView("up_getCenters", UserName);
ddSygmaCenterNo.DataSource = dv;
ddSygmaCenterNo.DataBind();
ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "-1"));
ddEmployee.Items.Insert(0, new ListItem("Choose...", "-1"));
}
protected void cuvQuantity_ServerValidate(object source, ServerValidateEventArgs args)
{
if (IsValid)
{
txtQuantity.Text = Convert.ToString(ATMDB.GetScalar("up_p_getValidQuantity", ddAddRateType.SelectedValue, txtQuantity.Text));
args.IsValid = true;
//cuvQuantity.Text = "TEst";
//if (!args.IsValid)
// FireValidationFailedMessage((CustomValidator)source);
}
}
protected void cuvRouteNo_ServerValidate(object source, ServerValidateEventArgs args)
{
if (IsValid)
{
args.IsValid = (bool)ATMDB.GetScalar("up_p_isRouteNoValid", ddSygmaCenterNo.SelectedValue, RouteNoEdit, Convert.ToDateTime(dteWeekendingDate.Text));
//cuvRouteNo.ErrorMessage = "Test";
//cuvRouteNo.Text = "TEst";
//if (!args.IsValid)
// FireValidationFailedMessage((CustomValidator)source);
}
}
protected void ddDepartDay_SelectedIndexChanged(object sender, EventArgs e)
{
DataView dv = ATMDB.GetDataView("up_getRoutes", UserName, ddSygmaCenterNo.SelectedValue);
AddSort(dv);
AddNameFilter(dv);
gvRoutes.PageSize = RowCountBar1.PageSize;
gvRoutes.DataSource = dv;
setRoutes();
gvRoutes.DataBind();
}
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;
}
}
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 override void LoadBasePage()
{
//check that the user has access to the page
if (!Convert.ToBoolean(ATMDB.GetScalar("up_sec_isValidUser", UserName,
Request.AppRelativeCurrentExecutionFilePath)))
{
GotoInvalidUserPage();
}
else
{
LoadATMPage();
}
}
protected override void LoadATMPage()
{
setPageVariables();
if (IsPostBack)
{
return;
}
RowCountBar1.PageSize = 25;
loadCenters();
var dsPayScales = ATMDB.GetDataSet("up_p_getPayScales");
dtPayScales = dsPayScales.Tables[0];
}
private void SetPayRateTypes()
{
if (ddSygmaCenterNo.SelectedValue != "" && ddPayScale.SelectedValue != "")
{
pnlRates.Visible = true;
gvPayRates.DataSource = ATMDB.GetDataView("up_p_getCenterPayScaleRates", ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue);
gvPayRates.DataBind();
}
else
{
pnlRates.Visible = false;
}
}
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;
}
private void LoadCenters()
{
DataView dv = ATMDB.GetDataView("up_getCenters", UserName);
ddProgSygmaCenterNo.DataSource = dv;
ddProgSygmaCenterNo.DataBind();
ddProgSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", ""));
if (ddProgSygmaCenterNo.Items.Count == 2)
{
ddProgSygmaCenterNo.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");
}
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();
}
}
