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)
{
}
}