protected void grdAttendanceSingle_RowDataBound(object sender, GridViewRowEventArgs e) { try { Report obj = new Report(); if (e.Row.RowType == DataControlRowType.DataRow) { var dt = new List<Attendance.Entities.MultipleLogininfo>(); string s = string.Empty; string sTable = string.Empty; Label lblDay = (Label)e.Row.FindControl("lblDay"); if (lblDay.Text.ToString() != "<b>Total Hours</b>" && lblDay.Text.ToString()!="") { string[] Day1 = lblDay.Text.ToString().Split('('); string TodayDt = Day1[1].Substring(0, Day1[1].Length - 2); Label lblScIn = (Label)e.Row.FindControl("lblScIn"); lblScIn.Text = lblScIn.Text.ToString().Trim() == "-" ? "" : lblScIn.Text.ToString(); if (lblScIn.Text.Trim() == "-") { lblScIn.Text = ""; } Label lblSignIn = (Label)e.Row.FindControl("lblSignIn"); lblSignIn.Text = lblSignIn.Text == "" ? "" : lblSignIn.Text == "H" ? "H" : lblSignIn.Text == "L" ? "L" : lblSignIn.Text == "S" ? "S" : Convert.ToDateTime(lblSignIn.Text).ToString("hh:mm tt"); HiddenField hdnSignInFlag = (HiddenField)e.Row.FindControl("hdnSignInFlag"); if (hdnSignInFlag.Value == "True") { e.Row.Cells[2].CssClass += "atnEdit "; } HiddenField hdnSignOutFlag = (HiddenField)e.Row.FindControl("hdnSignOutFlag"); if (hdnSignOutFlag.Value == "True") { e.Row.Cells[2].CssClass += "atnEdit "; } Label lblSignOut = (Label)e.Row.FindControl("lblSignOut"); lblSignIn.Text = lblSignIn.Text == "" ? "" : lblSignIn.Text == "H" ? "H" : lblSignIn.Text == "L" ? "L" : lblSignIn.Text == "S" ? "S" : (lblSignIn.Text + " - " + (lblSignOut.Text == "" ? "" : lblSignOut.Text == "N/A" ? "N/A" : lblSignOut.Text == "L" ? "" : lblSignOut.Text == "H" ? "" : lblSignOut.Text == "S" ? "" : Convert.ToDateTime(lblSignOut.Text).ToString("hh:mm tt"))); HiddenField hdnSigninNotes = (HiddenField)e.Row.FindControl("hdnSigninNotes"); HiddenField hdnMultiple = (HiddenField)e.Row.FindControl("hdnMultiple"); if (hdnMultiple.Value == "True") { lblSignIn.CssClass += "SinglemultipleLogin "; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(TodayDt), lblID.Text); s = CreateMultipleTable(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnSigninNotes.Value), s); s = ""; if (sTable != "") { lblSignIn.Attributes.Add("rel", "tooltip"); lblSignIn.Attributes.Add("title", sTable); e.Row.Cells[2].CssClass += "greenTag "; } Label lblMonHours = (Label)e.Row.FindControl("lblMonHours"); lblMonHours.Text = lblMonHours.Text == "N/A" ? "" : lblMonHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblMonHours.Text))); if (lblMonHours.Text.Trim() == "-") { lblMonHours.Text = ""; } HiddenField hdnLvStatus = (HiddenField)e.Row.FindControl("hdnLvStatus"); e.Row.Cells[2].CssClass += GeneralFunction.GetColor(lblSignIn.Text.Trim(), hdnLvStatus.Value.Trim()); } } } catch (Exception ex) { } }
protected void grdAttandence_RowDataBound(object sender, GridViewRowEventArgs e) { try { Report obj = new Report(); if (e.Row.RowType == DataControlRowType.DataRow) { string s = string.Empty; string sTable = string.Empty; string sMonMultiple = "0"; string sTueMultiple = "0"; string sWedMultiple = "0"; string sThuMultiple = "0"; string sFriMultiple = "0"; string sSatMultiple = "0"; string sSunMultiple = "0"; var dt = new List<Attendance.Entities.MultipleLogininfo>(); Label lblStartDate = (Label)e.Row.FindControl("lblStartDate"); Label lblTermDate = (Label)e.Row.FindControl("lblTermDate"); Label lblPName = (Label)e.Row.FindControl("lblPName"); Label lblName = (Label)e.Row.FindControl("lblName"); string tip = CreateNameTable(lblPName.Text.Trim(), Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy"), Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy")); lblName.Attributes.Add("class", "tooltip2"); lblName.Attributes.Add("title", tip); Label lblMonScIn = (Label)e.Row.FindControl("lblMonScIn"); Label lblTueScIn = (Label)e.Row.FindControl("lblTueScIn"); Label lblWedScIn = (Label)e.Row.FindControl("lblWedScIn"); Label lblThuScIn = (Label)e.Row.FindControl("lblThuScIn"); Label lblFriScIn = (Label)e.Row.FindControl("lblFriScIn"); Label lblSatScIn = (Label)e.Row.FindControl("lblSatScIn"); Label lblSunScIn = (Label)e.Row.FindControl("lblSunScIn"); Label lblMonScOut = (Label)e.Row.FindControl("lblMonScOut"); Label lblTueScOut = (Label)e.Row.FindControl("lblTueScOut"); Label lblWedScOut = (Label)e.Row.FindControl("lblWedScOut"); Label lblThuScOut = (Label)e.Row.FindControl("lblThuScOut"); Label lblFriScOut = (Label)e.Row.FindControl("lblFriScOut"); Label lblSatScOut = (Label)e.Row.FindControl("lblSatScOut"); Label lblSunScOut = (Label)e.Row.FindControl("lblSunScOut"); HiddenField hdnSunLunch = (HiddenField)e.Row.FindControl("hdnSunLunch"); HiddenField hdnMonLunch = (HiddenField)e.Row.FindControl("hdnMonLunch"); HiddenField hdnTueLunch = (HiddenField)e.Row.FindControl("hdnTueLunch"); HiddenField hdnWedLunch = (HiddenField)e.Row.FindControl("hdnWedLunch"); HiddenField hdnThuLunch = (HiddenField)e.Row.FindControl("hdnThuLunch"); HiddenField hdnFriLunch = (HiddenField)e.Row.FindControl("hdnFriLunch"); HiddenField hdnSatLunch = (HiddenField)e.Row.FindControl("hdnSatLunch"); string lunchTip1 = CreateLunchTable(hdnSunLunch.Value.Trim()); lblSunScIn.Attributes.Add("class", "tooltip2"); lblSunScIn.Attributes.Add("title", lunchTip1); lblSunScOut.Attributes.Add("class", "tooltip2"); lblSunScOut.Attributes.Add("title", lunchTip1); lunchTip1 = CreateLunchTable(hdnMonLunch.Value.Trim()); lblMonScIn.Attributes.Add("class", "tooltip2"); lblMonScIn.Attributes.Add("title", lunchTip1); lblMonScOut.Attributes.Add("class", "tooltip2"); lblMonScOut.Attributes.Add("title", lunchTip1); lunchTip1 = CreateLunchTable(hdnTueLunch.Value.Trim()); lblTueScIn.Attributes.Add("class", "tooltip2"); lblTueScIn.Attributes.Add("title", lunchTip1); lblTueScOut.Attributes.Add("class", "tooltip2"); lblTueScOut.Attributes.Add("title", lunchTip1); lunchTip1 = CreateLunchTable(hdnWedLunch.Value.Trim()); lblWedScIn.Attributes.Add("class", "tooltip2"); lblWedScIn.Attributes.Add("title", lunchTip1); lblWedScOut.Attributes.Add("class", "tooltip2"); lblWedScOut.Attributes.Add("title", lunchTip1); lunchTip1 = CreateLunchTable(hdnSatLunch.Value.Trim()); lblSatScIn.Attributes.Add("class", "tooltip2"); lblSatScIn.Attributes.Add("title", lunchTip1); lblSatScOut.Attributes.Add("class", "tooltip2"); lblSatScOut.Attributes.Add("title", lunchTip1); lunchTip1 = CreateLunchTable(hdnThuLunch.Value.Trim()); lblThuScIn.Attributes.Add("class", "tooltip2"); lblThuScIn.Attributes.Add("title", lunchTip1); lblThuScOut.Attributes.Add("class", "tooltip2"); lblThuScOut.Attributes.Add("title", lunchTip1); lunchTip1 = CreateLunchTable(hdnFriLunch.Value.Trim()); lblFriScIn.Attributes.Add("class", "tooltip2"); lblFriScIn.Attributes.Add("title", lunchTip1); lblFriScOut.Attributes.Add("class", "tooltip2"); lblFriScOut.Attributes.Add("title", lunchTip1); Label lblID = (Label)e.Row.FindControl("lblID"); string empid = lblID.Text.Trim(); if ((Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["MonDate"]) < Convert.ToDateTime(lblStartDate.Text))) { lblMonScIn.Text = ""; lblMonScOut.Text = ""; } if (Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["TueDate"]) < Convert.ToDateTime(lblStartDate.Text)) { lblTueScIn.Text = ""; lblTueScOut.Text = ""; } if (Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["WedDate"]) < Convert.ToDateTime(lblStartDate.Text)) { lblWedScIn.Text = ""; lblWedScOut.Text = ""; } if (Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["ThuDate"]) < Convert.ToDateTime(lblStartDate.Text)) { lblThuScIn.Text = ""; lblThuScOut.Text = ""; } if (Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["FriDate"]) < Convert.ToDateTime(lblStartDate.Text)) { lblFriScIn.Text = ""; lblFriScOut.Text = ""; } if (Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["SatDate"]) < Convert.ToDateTime(lblStartDate.Text)) { lblSatScIn.Text = ""; lblSatScOut.Text = ""; } if (Convert.ToDateTime(lblStartDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["SunDate"]) < Convert.ToDateTime(lblStartDate.Text)) { lblSunScIn.Text = ""; lblSunScOut.Text = ""; } if ((Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["MonDate"]) > Convert.ToDateTime(lblTermDate.Text))) { lblMonScIn.Text = ""; lblMonScOut.Text = ""; } if (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["TueDate"]) > Convert.ToDateTime(lblTermDate.Text)) { lblTueScIn.Text = ""; lblTueScOut.Text = ""; } if (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["WedDate"]) > Convert.ToDateTime(lblTermDate.Text)) { lblWedScIn.Text = ""; lblWedScOut.Text = ""; } if (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["ThuDate"]) > Convert.ToDateTime(lblTermDate.Text)) { lblThuScIn.Text = ""; lblThuScOut.Text = ""; } if (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["FriDate"]) > Convert.ToDateTime(lblTermDate.Text)) { lblFriScIn.Text = ""; lblFriScOut.Text = ""; } if (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["SatDate"]) > Convert.ToDateTime(lblTermDate.Text)) { lblSatScIn.Text = ""; lblSatScOut.Text = ""; } if (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") != "01/01/1900" && Convert.ToDateTime(ViewState["SunDate"]) > Convert.ToDateTime(lblTermDate.Text)) { lblSunScIn.Text = ""; lblSunScOut.Text = ""; } LinkButton lblMonIn = (LinkButton)e.Row.FindControl("lblMonIn"); lblMonIn.Text = lblMonIn.Text == "" ? "" : Convert.ToDateTime(lblMonIn.Text).ToString("hh:mm tt"); lblMonIn.Attributes.Add("date", Convert.ToDateTime(ViewState["MonDate"]).ToString("MM/dd/yyyy")); if (lblMonIn.Text == "") { if ((Convert.ToDateTime(ViewState["MonDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["MonDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["MonDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["MonDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblMonIn.Text = "N/A"; } } } HiddenField hdnMonSignInFlag = (HiddenField)e.Row.FindControl("hdnMonSignInFlag"); if (hdnMonSignInFlag.Value == "True") { e.Row.Cells[3].BackColor = System.Drawing.Color.Moccasin; lblMonIn.CssClass.Replace("greenTag", ""); //lblMonIn.ForeColor = System.Drawing.Color.Moccasin ; } HiddenField hdnMonSigninNotes = (HiddenField)e.Row.FindControl("hdnMonSigninNotes"); HiddenField hdnMonMultiple = (HiddenField)e.Row.FindControl("hdnMonMultiple"); if (hdnMonMultiple.Value == "True") { lblMonIn.CssClass = "multipleLogin"; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(ViewState["MonDate"]), empid); s = CreateMultipleTable(dt); sMonMultiple = CreateMultipleString(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnMonSigninNotes.Value), s); s = ""; if (sTable != "") { lblMonIn.Attributes.Add("rel", "tooltip"); lblMonIn.Attributes.Add("title", sTable); e.Row.Cells[3].CssClass = "greenTag"; } lblMonIn.Attributes.Add("sMultiple", sMonMultiple); lblMonIn.Attributes.Add("date", Convert.ToDateTime(ViewState["MonDate"]).ToString("MM/dd/yyyy")); LinkButton lblMonOut = (LinkButton)e.Row.FindControl("lblMonOut"); lblMonIn.Text = lblMonIn.Text == "" ? "" : lblMonIn.Text + (lblMonOut.Text == "" ? "" : lblMonOut.Text == "N/A" ? " - N/A" : " - " + Convert.ToDateTime(lblMonOut.Text).ToString("hh:mm tt")); if (lblMonOut.Text == "") { if ((Convert.ToDateTime(ViewState["MonDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["MonDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["MonDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["MonDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblMonIn.Text = lblMonIn.Text == "" ? "" : lblMonIn.Text + " - N/A"; } } } HiddenField hdnMonFreeze = (HiddenField)e.Row.FindControl("hdnMonFreeze"); if (hdnMonFreeze.Value == "True") { lblMonIn.Enabled = false; lblMonIn.ForeColor = System.Drawing.Color.Black; lblMonOut.Enabled = false; lblMonOut.ForeColor = System.Drawing.Color.Black; } LinkButton lblTueIn = (LinkButton)e.Row.FindControl("lblTueIn"); lblTueIn.Text = lblTueIn.Text == "" ? "" : Convert.ToDateTime(lblTueIn.Text).ToString("hh:mm tt"); if (lblTueIn.Text == "") { if ((Convert.ToDateTime(ViewState["TueDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["TueDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["TueDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["TueDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblTueIn.Text = "N/A"; } } } HiddenField hdnTueSignInFlag = (HiddenField)e.Row.FindControl("hdnTueSignInFlag"); if (hdnTueSignInFlag.Value == "True") { e.Row.Cells[6].BackColor = System.Drawing.Color.Moccasin; //lblTueIn.ForeColor = System.Drawing.Color.Moccasin ; lblTueIn.CssClass.Replace("greenTag", ""); } HiddenField hdnTueSigninNotes = (HiddenField)e.Row.FindControl("hdnTueSigninNotes"); HiddenField hdnTueMultiple = (HiddenField)e.Row.FindControl("hdnTueMultiple"); if (hdnTueMultiple.Value == "True") { lblTueIn.CssClass = "multipleLogin"; // lblMonIn.CssClass = "multipleLogin"; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(ViewState["TueDate"]), empid); s = CreateMultipleTable(dt); sTueMultiple = CreateMultipleString(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnTueSigninNotes.Value), s); s = ""; if (sTable != "") { lblTueIn.Attributes.Add("rel", "tooltip"); lblTueIn.Attributes.Add("title", sTable); e.Row.Cells[6].CssClass = "greenTag"; } lblTueIn.Attributes.Add("sMultiple", sTueMultiple); lblTueIn.Attributes.Add("Date", Convert.ToDateTime(ViewState["TueDate"].ToString()).ToString("MM/dd/yyyy")); LinkButton lblTueOut = (LinkButton)e.Row.FindControl("lblTueOut"); lblTueIn.Text = lblTueIn.Text == "" ? "" : lblTueIn.Text + (lblTueOut.Text == "" ? "" : lblTueOut.Text == "N/A" ? " - N/A" : " - " + Convert.ToDateTime(lblTueOut.Text).ToString("hh:mm tt")); if (lblTueOut.Text == "") { if ((Convert.ToDateTime(ViewState["TueDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["TueDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["TueDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["TueDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblTueIn.Text = lblTueIn.Text == "" ? "" : lblTueIn.Text + " - N/A"; } } } HiddenField hdnTueFreeze = (HiddenField)e.Row.FindControl("hdnTueFreeze"); if (hdnTueFreeze.Value == "True") { lblTueIn.Enabled = false; lblTueIn.ForeColor = System.Drawing.Color.Black; lblTueOut.Enabled = false; lblTueOut.ForeColor = System.Drawing.Color.Black; } LinkButton lblWedIn = (LinkButton)e.Row.FindControl("lblWedIn"); lblWedIn.Text = lblWedIn.Text == "" ? "" : Convert.ToDateTime(lblWedIn.Text).ToString("hh:mm tt"); if (lblWedIn.Text == "") { if ((Convert.ToDateTime(ViewState["WedDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["WedDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["WedDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["WedDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblWedIn.Text = "N/A"; } } } HiddenField hdnWedSignInFlag = (HiddenField)e.Row.FindControl("hdnWedSignInFlag"); if (hdnWedSignInFlag.Value == "True") { e.Row.Cells[9].BackColor = System.Drawing.Color.Moccasin; lblWedIn.CssClass.Replace("greenTag", ""); // lblWedIn.ForeColor = System.Drawing.Color.Moccasin ; } HiddenField hdnWedSignInNotes = (HiddenField)e.Row.FindControl("hdnWedSignInNotes"); HiddenField hdnWedMultiple = (HiddenField)e.Row.FindControl("hdnWedMultiple"); if (hdnWedMultiple.Value == "True") { lblWedIn.CssClass = "multipleLogin"; // lblMonIn.CssClass = "multipleLogin"; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(ViewState["WedDate"]), empid); s = CreateMultipleTable(dt); sWedMultiple = CreateMultipleString(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnWedSignInNotes.Value), s); s = ""; if (sTable != "") { lblWedIn.Attributes.Add("rel", "tooltip"); lblWedIn.Attributes.Add("title", sTable); e.Row.Cells[9].CssClass = "greenTag"; } lblWedIn.Attributes.Add("sMultiple", sWedMultiple); lblWedIn.Attributes.Add("Date", Convert.ToDateTime(ViewState["WedDate"].ToString()).ToString("MM/dd/yyyy")); LinkButton lblWedOut = (LinkButton)e.Row.FindControl("lblWedOut"); lblWedIn.Text = lblWedIn.Text == "" ? "" : lblWedIn.Text + (lblWedOut.Text == "" ? "" : lblWedOut.Text == "N/A" ? " - N/A" : " - " + Convert.ToDateTime(lblWedOut.Text).ToString("hh:mm tt")); if (lblWedOut.Text == "") { if ((Convert.ToDateTime(ViewState["WedDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["WedDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["WedDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["WedDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblWedIn.Text = lblWedIn.Text == "" ? "" : lblWedIn.Text + " - N/A"; } } } HiddenField hdnWedFreeze = (HiddenField)e.Row.FindControl("hdnWedFreeze"); if (hdnWedFreeze.Value == "True") { lblWedIn.Enabled = false; lblWedIn.ForeColor = System.Drawing.Color.Black; lblWedOut.Enabled = false; lblWedOut.ForeColor = System.Drawing.Color.Black; } LinkButton lblThuIn = (LinkButton)e.Row.FindControl("lblThuIn"); lblThuIn.Text = lblThuIn.Text == "" ? "" : Convert.ToDateTime(lblThuIn.Text).ToString("hh:mm tt"); if (lblThuIn.Text == "") { if ((Convert.ToDateTime(ViewState["ThuDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["ThuDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["ThuDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["ThuDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblThuIn.Text = "N/A"; } } } HiddenField hdnThuSignInFlag = (HiddenField)e.Row.FindControl("hdnThuSignInFlag"); if (hdnThuSignInFlag.Value == "True") { e.Row.Cells[12].BackColor = System.Drawing.Color.Moccasin; lblThuIn.Attributes["class"] = ""; //lblThuIn.ForeColor = System.Drawing.Color.Moccasin ; } HiddenField hdnThuSignInNotes = (HiddenField)e.Row.FindControl("hdnThuSignInNotes"); HiddenField hdnThuMultiple = (HiddenField)e.Row.FindControl("hdnThuMultiple"); if (hdnThuMultiple.Value == "True") { lblThuIn.CssClass = "multipleLogin"; // lblMonIn.CssClass = "multipleLogin"; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(ViewState["ThuDate"]), empid); s = CreateMultipleTable(dt); sThuMultiple = CreateMultipleString(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnThuSignInNotes.Value), s); s = ""; if (sTable != "") { lblThuIn.Attributes.Add("rel", "tooltip"); lblThuIn.Attributes.Add("title", sTable); e.Row.Cells[12].CssClass = "greenTag"; } lblThuIn.Attributes.Add("sMultiple", sThuMultiple); lblThuIn.Attributes.Add("Date", Convert.ToDateTime(ViewState["ThuDate"].ToString()).ToString("MM/dd/yyyy")); LinkButton lblThuOut = (LinkButton)e.Row.FindControl("lblThuOut"); lblThuIn.Text = lblThuIn.Text == "" ? "" : lblThuIn.Text + (lblThuOut.Text == "" ? "" : lblThuOut.Text == "N/A" ? " - N/A" : " - " + Convert.ToDateTime(lblThuOut.Text).ToString("hh:mm tt")); if (lblThuOut.Text == "") { if ((Convert.ToDateTime(ViewState["ThuDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["ThuDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["ThuDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["ThuDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblThuIn.Text = lblThuIn.Text == "" ? "" : lblThuIn.Text + " - N/A"; } } } HiddenField hdnThuFreeze = (HiddenField)e.Row.FindControl("hdnThuFreeze"); if (hdnThuFreeze.Value == "True") { lblThuIn.Enabled = false; lblThuIn.ForeColor = System.Drawing.Color.Black; lblThuOut.Enabled = false; lblThuOut.ForeColor = System.Drawing.Color.Black; } LinkButton lblFriIn = (LinkButton)e.Row.FindControl("lblFriIn"); lblFriIn.Text = lblFriIn.Text == "" ? "" : Convert.ToDateTime(lblFriIn.Text).ToString("hh:mm"); if (lblFriIn.Text == "") { if ((Convert.ToDateTime(ViewState["FriDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["FriDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FriDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["FriDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblFriIn.Text = "N/A"; } } } HiddenField hdnFriSignInFlag = (HiddenField)e.Row.FindControl("hdnFriSignInFlag"); if (hdnFriSignInFlag.Value == "True") { e.Row.Cells[15].BackColor = System.Drawing.Color.Moccasin; lblFriIn.CssClass.Replace("greenTag", ""); } HiddenField hdnFriSignInNotes = (HiddenField)e.Row.FindControl("hdnFriSignInNotes"); HiddenField hdnFriMultiple = (HiddenField)e.Row.FindControl("hdnFriMultiple"); if (hdnFriMultiple.Value == "True") { lblFriIn.CssClass = "multipleLogin"; // lblMonIn.CssClass = "multipleLogin"; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(ViewState["FriDate"]), empid); s = CreateMultipleTable(dt); sFriMultiple = CreateMultipleString(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnFriSignInNotes.Value), s); s = ""; if (sTable != "") { lblFriIn.Attributes.Add("rel", "tooltip"); lblFriIn.Attributes.Add("title", sTable); e.Row.Cells[15].CssClass = "greenTag"; } lblFriIn.Attributes.Add("sMultiple", sFriMultiple); lblFriIn.Attributes.Add("Date", Convert.ToDateTime(ViewState["FriDate"].ToString()).ToString("MM/dd/yyyy")); LinkButton lblFriOut = (LinkButton)e.Row.FindControl("lblFriOut"); lblFriIn.Text = lblFriIn.Text == "" ? "" : lblFriIn.Text + (lblFriOut.Text == "" ? "" : lblFriOut.Text == "N/A" ? " - N/A" : " - " + Convert.ToDateTime(lblFriOut.Text).ToString("hh:mm tt")); if (lblFriOut.Text == "") { if ((Convert.ToDateTime(ViewState["FriDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["FriDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FriDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["FriDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblFriIn.Text = lblFriIn.Text == "" ? "" : lblFriIn.Text + " - N/A"; } } } HiddenField hdnFriFreeze = (HiddenField)e.Row.FindControl("hdnFriFreeze"); if (hdnFriFreeze.Value == "True") { lblFriIn.Enabled = false; lblFriIn.ForeColor = System.Drawing.Color.Black; lblFriOut.Enabled = false; lblFriOut.ForeColor = System.Drawing.Color.Black; } LinkButton lblSatIn = (LinkButton)e.Row.FindControl("lblSatIn"); lblSatIn.Text = lblSatIn.Text == "" ? "" : Convert.ToDateTime(lblSatIn.Text).ToString("hh:mm tt"); HiddenField hdnSatSignInFlag = (HiddenField)e.Row.FindControl("hdnSatSignInFlag"); if (lblSatIn.Text == "") { if ((Convert.ToDateTime(ViewState["SatDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["SatDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["SatDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["SatDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblSatIn.Text = "N/A"; } } } if (hdnSatSignInFlag.Value == "True") { e.Row.Cells[18].BackColor = System.Drawing.Color.Moccasin; lblSatIn.CssClass.Replace("greenTag", ""); } HiddenField hdnSatSignInNotes = (HiddenField)e.Row.FindControl("hdnSatSignInNotes"); //lblSatIn.ForeColor = System.Drawing.Color.Moccasin ; HiddenField hdnSatMultiple = (HiddenField)e.Row.FindControl("hdnSatMultiple"); if (hdnSatMultiple.Value == "True") { lblSatIn.CssClass = "multipleLogin"; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(ViewState["SatDate"]), empid); s = CreateMultipleTable(dt); sSatMultiple = CreateMultipleString(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnSatSignInNotes.Value), s); s = ""; if (sTable != "") { lblSatIn.Attributes.Add("rel", "tooltip"); lblSatIn.Attributes.Add("title", sTable); e.Row.Cells[18].CssClass = "greenTag"; } lblSatIn.Attributes.Add("sMultiple", sSatMultiple); lblSatIn.Attributes.Add("Date", Convert.ToDateTime(ViewState["SatDate"].ToString()).ToString("MM/dd/yyyy")); LinkButton lblSatOut = (LinkButton)e.Row.FindControl("lblSatOut"); lblSatIn.Text = lblSatIn.Text == "" ? "" : lblSatIn.Text + (lblSatOut.Text == "" ? "" : lblSatOut.Text == "N/A" ? " - N/A" : " - " + Convert.ToDateTime(lblSatOut.Text).ToString("hh:mm tt")); if (lblSatOut.Text == "") { if ((Convert.ToDateTime(ViewState["SatDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["SatDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["SatDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["SatDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblSatIn.Text = lblSatIn.Text == "" ? "" : lblSatIn.Text + " - N/A"; } } } HiddenField hdnSatFreeze = (HiddenField)e.Row.FindControl("hdnSatFreeze"); if (hdnSatFreeze.Value == "True") { lblSatIn.Enabled = false; lblSatIn.ForeColor = System.Drawing.Color.Black; lblSatOut.Enabled = false; lblSatOut.ForeColor = System.Drawing.Color.Black; } LinkButton lblSunIn = (LinkButton)e.Row.FindControl("lblSunIn"); lblSunIn.Text = lblSunIn.Text == "" ? "" : Convert.ToDateTime(lblSunIn.Text).ToString("hh:mm tt"); if (lblSunIn.Text == "") { if ((Convert.ToDateTime(ViewState["SunDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["SunDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["SunDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["SunDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblSunIn.Text = "N/A"; } } } HiddenField hdnSunSignInFlag = (HiddenField)e.Row.FindControl("hdnSunSignInFlag"); HiddenField hdnSunSignInNotes = (HiddenField)e.Row.FindControl("hdnSunSignInNotes"); if (hdnSunSignInNotes.Value.Trim() == "True") { e.Row.Cells[21].BackColor = System.Drawing.Color.Moccasin; lblSunIn.Attributes["class"] = ""; // lblSunIn.ForeColor = System.Drawing.Color.Moccasin ; } HiddenField hdnSunMultiple = (HiddenField)e.Row.FindControl("hdnSunMultiple"); if (hdnSunMultiple.Value == "True") { lblSunIn.CssClass = "multipleLogin"; // lblMonIn.CssClass = "multipleLogin"; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(ViewState["SunDate"]), empid); s = CreateMultipleTable(dt); sSunMultiple = CreateMultipleString(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (hdnSunSignInNotes.Value), s); s = ""; if (sTable != "") { lblSunIn.Attributes.Add("rel", "tooltip"); lblSunIn.Attributes.Add("title", sTable); e.Row.Cells[21].CssClass = "greenTag"; } lblSunIn.Attributes.Add("sMultiple", sSunMultiple); lblSunIn.Attributes.Add("Date", Convert.ToDateTime(ViewState["SunDate"].ToString()).ToString("MM/dd/yyyy")); LinkButton lblSunOut = (LinkButton)e.Row.FindControl("lblSunOut"); lblSunIn.Text = lblSunIn.Text == "" ? "" : lblSunIn.Text + (lblSunOut.Text == "" ? "" : lblSunOut.Text == "N/A" ? " - N/A" : " - " + Convert.ToDateTime(lblSunOut.Text).ToString("hh:mm tt")); if (lblSunOut.Text == "") { if ((Convert.ToDateTime(ViewState["SunDate"]) >= Convert.ToDateTime(lblStartDate.Text)) && (Convert.ToDateTime(lblTermDate.Text).ToString("MM/dd/yyyy") == "01/01/1900" || Convert.ToDateTime(ViewState["SunDate"]) <= Convert.ToDateTime(lblTermDate.Text))) { if ((Convert.ToDateTime(Convert.ToDateTime(Session["TodayBannerDate"]).ToString("MM/dd/yyyy"))) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["SunDate"])).ToString("MM/dd/yyyy")) && (Convert.ToDateTime((Convert.ToDateTime(ViewState["SunDate"])).ToString("MM/dd/yyyy")) >= Convert.ToDateTime((Convert.ToDateTime(ViewState["FreezeDate"])).ToString("MM/dd/yyyy")))) { lblSunIn.Text = lblSunIn.Text == "" ? "" : lblSunIn.Text + " - N/A"; } } } HiddenField hdnSunFreeze = (HiddenField)e.Row.FindControl("hdnSunFreeze"); if (hdnSunFreeze.Value == "True") { lblSunIn.Enabled = false; lblSunIn.ForeColor = System.Drawing.Color.Black; lblSunOut.Enabled = false; lblSunOut.ForeColor = System.Drawing.Color.Black; } Label lblMonHours = (Label)e.Row.FindControl("lblMonHours"); lblMonHours.Text = lblMonHours.Text == "N/A" ? "" : lblMonHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblMonHours.Text))); Label lblTueHours = (Label)e.Row.FindControl("lblTueHours"); lblTueHours.Text = lblTueHours.Text == "N/A" ? "" : lblTueHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblTueHours.Text))); Label lblWedHours = (Label)e.Row.FindControl("lblWedHours"); lblWedHours.Text = lblWedHours.Text == "N/A" ? "" : lblWedHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblWedHours.Text))); Label lblThuHours = (Label)e.Row.FindControl("lblThuHours"); lblThuHours.Text = lblThuHours.Text == "N/A" ? "" : lblThuHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblThuHours.Text))); Label lblFriHours = (Label)e.Row.FindControl("lblFriHours"); lblFriHours.Text = lblFriHours.Text == "N/A" ? "" : lblFriHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblFriHours.Text))); Label lblSatHours = (Label)e.Row.FindControl("lblSatHours"); lblSatHours.Text = lblSatHours.Text == "N/A" ? "" : lblSatHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblSatHours.Text))); Label lblSunHours = (Label)e.Row.FindControl("lblSunHours"); lblSunHours.Text = lblSunHours.Text == "N/A" ? "" : lblSunHours.Text == "" ? "" : GeneralFunction.CalDoubleToTime((Convert.ToDouble(lblSunHours.Text))); Label lblTotalHours = (Label)e.Row.FindControl("lblTotalHours"); lblTotalHours.Text = lblTotalHours.Text == "0" ? "" : GeneralFunction.CalDoubleToTime(Convert.ToDouble(lblTotalHours.Text)); } } catch (Exception ex) { } }
private void fillCell(Label lbl,Label lblSignIn,Label lblHrs,DataTable dtfilt, int cellNum, GridViewRowEventArgs e) { Report obj = new Report(); string sTable = ""; string s = ""; var dt = new List<Attendance.Entities.MultipleLogininfo>(); try { if (lbl.Text != "") { if (dtfilt.Rows[0]["SignIn"].ToString() != "") { if (dtfilt.Rows[0]["SignIn"].ToString() == "S" || dtfilt.Rows[0]["SignIn"].ToString() == "H" || dtfilt.Rows[0]["SignIn"].ToString() == "L") { lblSignIn.Text = dtfilt.Rows[0]["SignIn"].ToString(); e.Row.Cells[cellNum].CssClass += GeneralFunction.GetColor(lblSignIn.Text, dtfilt.Rows[0]["LvStatus"].ToString().Trim()); } else { if (dtfilt.Rows[0]["Multiple"].ToString() == "True") { lbl.CssClass += "SinglemultipleLogin "; dt = obj.GetMultipleDetailsByEmpID(Convert.ToDateTime(lbl.Text), lblID.Text); s = CreateMultipleTable(dt); dt = null; } sTable = CreateSignInTable(lblName.Text, (dtfilt.Rows[0]["LoginNotes"].ToString()), s); s = ""; if (sTable != "") { lbl.Attributes.Add("rel", "tooltip"); lbl.Attributes.Add("title", sTable); e.Row.Cells[cellNum].CssClass += "greenTag "; } if (dtfilt.Rows[0]["LoginFlag"].ToString() == "True" || dtfilt.Rows[0]["LogoutFlag"].ToString() == "True") { e.Row.Cells[cellNum].CssClass += "atnEdit "; } lblSignIn.Text = Convert.ToDateTime(dtfilt.Rows[0]["SignIn"].ToString()).ToString("hh:mm tt") + " - " + (dtfilt.Rows[0]["SignOut"].ToString() == "N/A" ? "N/A" : Convert.ToDateTime(dtfilt.Rows[0]["SignOut"].ToString()).ToString("hh:mm tt")); lblHrs.Text = (dtfilt.Rows[0]["Hrs"].ToString() == "0" ? "" : dtfilt.Rows[0]["Hrs"].ToString() == "N/A" ? "" : dtfilt.Rows[0]["Hrs"].ToString() == "NULL" ? "" : "Hrs : " + GeneralFunction.CalDoubleToTime(Convert.ToDouble(dtfilt.Rows[0]["Hrs"].ToString()))); } } lbl.Text = Convert.ToDateTime(lbl.Text).ToString("dd"); } } catch (Exception ex) { } }