private DataTable totalizeBiWeeklyResults(DataTable dt) { //Validate if Columns type are decimal, if not, will be switched PMCommon.FormatColumnTypes(dt); dt.Columns.Add("Id", typeof(string)); dt = dt.AsEnumerable() .Where(x => x.Field <string>("Trainer") != "") //Remove white rows .GroupBy(x => x.Field <string>("Id")) .Select ( n => new { CheckDate = "", Trainer = "Total", Manager = "", Role = "", Salary = n.Sum(z => z.Field <decimal?>("Salary") == null ? 0 : z.Field <decimal?>("Salary")), Override = n.Sum(z => z.Field <decimal?>("Override") == null ? 0 : z.Field <decimal?>("Override")), Commission = n.Sum(z => z.Field <decimal?>("Commission") == null ? 0 : z.Field <decimal?>("Commission")), OverPay = n.Sum(z => z.Field <decimal?>("Over Pay") == null ? 0 : z.Field <decimal?>("Over Pay")), UnderPay = n.Sum(z => z.Field <decimal?>("Under Pay") == null ? 0 : z.Field <decimal?>("Under Pay")) } ) .ToList().ToDataTable(); return(dt); }
private DataTable SummaryYearly(int yearDate) { string ParamStartDate = null; string ParamEndDate = null; GetWEYearDates(ref ParamStartDate, ref ParamEndDate, yearDate); DataTable dt = PMCommon.SummaryBiweekly(ParamStartDate, ParamEndDate); dt.Columns.Add("Year-End Balance", typeof(double)); dt.Columns.Add("Quarterly True-Up Bonus", typeof(double)); dt.Columns.Add("Remaining Balance", typeof(double)); for (int i = 0; i < dt.Rows.Count; i++) { if (i < dt.Rows.Count - 1) { dt.Rows[i][0] = yearDate; dt.Rows[i]["Year-End Balance"] = (dt.Rows[i]["Over Pay"].ToString() == "" ? 0 : double.Parse(dt.Rows[i]["Over Pay"].ToString())) + (dt.Rows[i]["Under Pay"].ToString() == "" ? 0 : double.Parse(dt.Rows[i]["Under Pay"].ToString())); if ((double)dt.Rows[i]["Year-End Balance"] >= 0) { dt.Rows[i]["Quarterly True-Up Bonus"] = dt.Rows[i]["Year-End Balance"]; } else { dt.Rows[i]["Remaining Balance"] = dt.Rows[i]["Year-End Balance"]; } } } dt.Columns.Remove("Salary"); dt.Columns.Remove("Override"); dt.Columns.Remove("Commission"); dt.Columns.Remove("Over Pay"); dt.Columns.Remove("Under Pay"); return(dt); }
private void FillControls() { MessageAlert.Visible = false; if (!IsPostBack) { Session["DDLShow"] = "Open"; Session["DateExistInPayroll"] = false; //Session is only empty at this point if this page is reloaded and is not bringing values from previous page PMCumulativeSummary //Or new CheckDate was created and is attemping to refresh data if (Session["BiweekTable"] == null) { string paramStartDate = "", paramEndDate = ""; List <DataTable> lstResults = PMCommon.GetPMPayrollresults(ref paramStartDate, ref paramEndDate); if (lstResults != null && lstResults.Count > 0) { Session["BiweekTable"] = lstResults; } } if (Session["BiweekTable"] != null) { FirstLoadPaycheckList(UnionAllDatatables((List <DataTable>)Session["BiweekTable"])); LoadDDL(); SetSession_PeriodIsOpenOrClosed(); CheckPeriodResults(ddlCheckPeriod.SelectedItem.Text); FindOpenCheckDates(); } else { Response.Redirect("/"); } } }
private void FillControls() { Session["Trainer"] = null; Session["ddlYear"] = null; Session["StartDate"] = null; Session["EndDate"] = null; Session["BiweekTable"] = null; Session["YearTable"] = null; Session["lstResultTables"] = new List <DataTable>(); string paramStartDate = "", paramEndDate = ""; //List<weekending> lstWE = GetWeekendingList(ref paramStartDate, ref paramEndDate); List <DataTable> LstDT = new List <DataTable>(); Session["BiweekTable"] = PMCommon.GetPMPayrollresults(ref paramStartDate, ref paramEndDate); Session["StartDate"] = paramStartDate; Session["EndDate"] = paramEndDate; BiweeklyGridResults(); LoadDDL(); YearlyGridResults(); }