protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int userid = Convert.ToInt32(Session["UserID"]);
// string IsAdmin = Session["IsAdmin"].ToString();
if (ddlReportType.SelectedItem.Value == "2")
{
DateTime todayDate = Convert.ToDateTime(Session["TodayBannerDate"]);
// DateTime startOfMonth = new DateTime(todayDate.Year, todayDate.Month, 1);
DateTime startDate = GeneralFunction.GetFirstDayOfWeekDate(todayDate);
DateTime StartDate = startDate.AddDays(1 - startDate.Day);
ViewState["StartMonth"] = StartDate.AddMonths(-6);
ViewState["CurrentMonth"] = StartDate.AddMonths(-6);
hdnMonthlyStartDt.Value = StartDate.AddMonths(-6).ToString();
DateTime endDate = StartDate.AddSeconds(-1);
ViewState["CrntMonthEnd"] = endDate;
DataTable dt = GetMonthlyreport(StartDate.AddMonths(-6), endDate);
btnFreeze.Visible = false;
lblFreeze.Visible = false;
if (dt.Rows.Count > 0)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = dt;
grdMonthlyAttendance.DataBind();
}
}
if (ddlReportType.SelectedItem.Value == "1")
{
DateTime todayDate = Convert.ToDateTime(Session["TodayDate1"]);
// DateTime startOfMonth = new DateTime(todayDate.Year, todayDate.Month, 1);
DateTime startDate = GeneralFunction.GetFirstDayOfWeekDate(todayDate);
DateTime StartDate = startDate.AddDays(-21);
ViewState["TodayDate1"] = StartDate;
ViewState["CurrentWeek"] = StartDate;
hdnWeeklyStartDt.Value = StartDate.ToString();
DateTime endDate = startDate.AddDays(6);
ViewState["CrntWkEnd"] = endDate;
DataTable dt = GetWeeklyReport(StartDate, endDate);
btnFreeze.Visible = false;
lblFreeze.Visible = false;
if (GeneralFunction.GetFirstDayOfWeekDate(endDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
if (dt.Rows.Count > 0)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = dt;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
if (ddlReportType.SelectedItem.Value == "0")
{
DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(TodayDate);
DateTime EndDate = GeneralFunction.GetLastDayOfWeekDate(TodayDate);
if (GeneralFunction.GetFirstDayOfWeekDate(TodayDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
btnFreeze.Visible = true;
lblFreeze.Visible = true;
// DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartOfMonth = StartDate.AddDays(-1);
DateTime FreezeDate = StartOfMonth;
Attendance.BAL.Report obj = new Report();
// int CNT = obj.GetFreezedDate(FreezeDate);
DateTime CNT = obj.GetFreezedDate(FreezeDate, ddlLocation.SelectedItem.Text.ToString().Trim());
lblFreezedate.Text = FreezeDate.ToString("MM/dd/yyyy");
hdnFreeze.Value = FreezeDate.ToString("MM/dd/yyyy");
if (CNT.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "Attendance freezed until " + CNT.ToString("MM/dd/yyyy");
ViewState["FreezeDate"] = CNT.ToString("MM/dd/yyyy");
btnFreeze.CssClass = "btn btn-warning btn-small disabled";
btnFreeze.Enabled = false;
}
else
{
lblFreeze.Visible = false;
btnFreeze.CssClass = "btn btn-warning btn-small enabled";
btnFreeze.Enabled = true;
}
DataTable ds = GetReportAdmin(StartDate, EndDate, Convert.ToInt32(ddlLocation.SelectedValue));
Session["AtnAdminDetails"] = ds;
grdAttandence.DataSource = ds;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
catch (Exception ex)
{
}
}
protected void btnPrevious_Click(object sender, EventArgs e)
{
try
{
if (ddlReportType.SelectedItem.Value == "0")
{
int userid = Convert.ToInt32(Session["UserID"]);
DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime PrevWeek = TodayDate.AddDays(-7);
Session["TodayDate"] = PrevWeek.ToString();
if (GeneralFunction.GetFirstDayOfWeekDate(PrevWeek).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
DateTime PreWeekStart = GeneralFunction.GetFirstDayOfWeekDate(PrevWeek);
DateTime PreWeekEnd = GeneralFunction.GetLastDayOfWeekDate(PrevWeek);
//DataTable ds = GetReport(PreWeekStart, PreWeekEnd, userid);
string Ismanage = Session["IsManage"].ToString();
string IsAdmin = Session["IsAdmin"].ToString();
DataTable ds = new DataTable();
if (Ismanage == "False")
{
ds = GetReportSingle(PreWeekStart, PreWeekEnd, userid);
Session["AtnDetails"] = ds;
if (ds.Rows.Count > 0)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
grdAttendanceSingle.DataSource = ds;
grdAttendanceSingle.DataBind();
lnkUserMangement.ForeColor = System.Drawing.Color.Gray;
lnkUserMangement.Enabled = false;
ddlLocation.Visible = false;
lblGrdLocaton.Visible = false;
lnkPayroll.ForeColor = System.Drawing.Color.Gray;
lnkPayroll.Enabled = false;
// lnkUserMangement.Style["display"] = "none";
}
}
else
{
btnFreeze.Visible = true;
lblFreeze.Visible = true;
// DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartOfMonth = PreWeekStart.AddDays(-1);
DateTime FreezeDate = StartOfMonth;
Attendance.BAL.Report obj = new Report();
// int CNT = obj.GetFreezedDate(FreezeDate);
DateTime CNT = obj.GetFreezedDate(FreezeDate, Session["LocationName"].ToString().Trim());
lblFreezedate.Text = FreezeDate.ToString("MM/dd/yyyy");
hdnFreeze.Value = FreezeDate.ToString("MM/dd/yyyy");
if (CNT.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "Attendance freezed until " + CNT.ToString("MM/dd/yyyy");
ViewState["FreezeDate"] = CNT.ToString("MM/dd/yyyy");
btnFreeze.CssClass = "btn btn-warning btn-small disabled";
btnFreeze.Enabled = false;
}
else
{
lblFreeze.Visible = false;
btnFreeze.CssClass = "btn btn-warning btn-small enabled";
btnFreeze.Enabled = true;
}
ds = GetReport(PreWeekStart, PreWeekEnd, userid);
Session["AtnDetails"] = ds;
grdAttandence.DataSource = ds;
grdAttandence.DataBind();
grdAttendanceSingle.DataSource = null;
grdAttendanceSingle.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
else if (ddlReportType.SelectedItem.Value == "1")
{
btnFreeze.Visible = false;
lblFreeze.Visible = false;
int userid = Convert.ToInt32(Session["UserID"]);
DateTime todayDate = Convert.ToDateTime(ViewState["TodayDate1"]);
ViewState["TodayDate1"] = todayDate.AddDays(-28);
// DateTime startOfMonth = new DateTime(todayDate.Year, todayDate.Month, 1);
DateTime startDate = GeneralFunction.GetFirstDayOfWeekDate(todayDate.AddDays(-28));
DateTime StartDate = startDate;
hdnWeeklyStartDt.Value = StartDate.ToString();
DateTime endDate = todayDate.AddDays(-1);
if (GeneralFunction.GetFirstDayOfWeekDate(startDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
DataTable dt = GetWeeklyReport(StartDate, endDate, userid);
if (dt.Rows.Count > 0)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = dt;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
else if (ddlReportType.SelectedItem.Value == "2")
{
int userid = Convert.ToInt32(Session["UserID"]);
DateTime startDate = Convert.ToDateTime(ViewState["StartMonth"]);
DateTime StartDate = startDate.AddMonths(-6);
hdnMonthlyStartDt.Value = StartDate.ToString();
DateTime endDate = startDate.AddSeconds(-1);
ViewState["StartMonth"] = StartDate;
DataTable dt = GetMonthlyreport(StartDate, endDate, userid);
btnFreeze.Visible = false;
lblFreeze.Visible = false;
if (endDate.ToString("MM/dd/yyyy") == (DateTime.Now.AddDays(1 - DateTime.Now.Day)).AddDays(-1).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
if (dt.Rows.Count > 0)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = dt;
grdMonthlyAttendance.DataBind();
}
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["TodayBannerDate"] != null)
{
comanyname.Text = CommonFiles.ComapnyName;
if (!IsPostBack)
{
string timezone = "";
if (Convert.ToInt32(Session["TimeZoneID"]) == 2)
{
timezone = "Eastern Standard Time";
}
else
{
timezone = "India Standard Time";
}
DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone));
var CurentDatetime = ISTTime;
lblDate2.Text = CurentDatetime.ToString("dddd MMMM dd yyyy, hh:mm:ss tt ");
hdnTodaydt.Value = CurentDatetime.ToString("MM/dd/yyyy");
lblTimeZoneName.Text = Session["TimeZoneName"].ToString().Trim();
lblLocation.Text = Session["LocationName"].ToString();
lblHeadSchedule.Text = Session["ScheduleInOut"].ToString();
getLocations();
ViewState["Location"] = Session["LocationName"].ToString();
ddlLocation.SelectedIndex = ddlLocation.Items.IndexOf(ddlLocation.Items.FindByText(lblLocation.Text.Trim()));
lblEmployyName.Text = Session["EmpName"].ToString().Trim();
Photo.Src = Session["Photo"].ToString().Trim();
Session["TodayDate"] = Session["TodayBannerDate"];
DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
Session["TodayDate1"] = Convert.ToDateTime(Session["TodayDate"]);
if (GeneralFunction.GetFirstDayOfWeekDate(TodayDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(TodayDate);
DateTime EndDate = GeneralFunction.GetLastDayOfWeekDate(TodayDate);
ViewState["CurrentStart"] = StartDate;
ViewState["CurrentEnd"] = EndDate;
int userid = Convert.ToInt32(Session["UserID"]);
string Ismanage = Session["IsManage"].ToString();
string IsAdmin = Session["IsAdmin"].ToString();
btnFreeze.Visible = true;
lblFreeze.Visible = true;
// DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartOfMonth = StartDate.AddDays(-1);
DateTime FreezeDate = StartOfMonth;
lblFreezedate.Text = FreezeDate.ToString("MM/dd/yyyy");
hdnFreeze.Value = FreezeDate.ToString("MM/dd/yyyy");
Attendance.BAL.Report obj = new Report();
//int CNT = obj.GetFreezedDate(FreezeDate);
DateTime CNT = obj.GetFreezedDate(FreezeDate, ddlLocation.SelectedItem.Text.ToString().Trim());
lblFreezedate.Text = FreezeDate.ToString("MM/dd/yyyy");
hdnFreeze.Value = FreezeDate.ToString("MM/dd/yyyy");
if (CNT.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "Attendance freezed until " + CNT.ToString("MM/dd/yyyy");
ViewState["FreezeDate"] = CNT.ToString("MM/dd/yyyy");
btnFreeze.CssClass = "btn btn-warning btn-small disabled";
btnFreeze.Enabled = false;
}
else
{
lblFreeze.Visible = false;
btnFreeze.CssClass = "btn btn-warning btn-small enabled";
btnFreeze.Enabled = true;
}
DataTable ds = new DataTable();
ds = GetReportAdmin(StartDate, EndDate, Convert.ToInt32(ddlLocation.SelectedValue));
lblGrdLocaton.Visible = true;
ddlLocation.Visible = true;
Session["AtnAdminDetails"] = ds;
if (ds.Rows.Count > 0)
{
grdAttandence.DataSource = ds;
grdAttandence.DataBind();
}
}
}
else
{
Response.Redirect("Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["LocationName"] != null)
{
if (!IsPostBack)
{
comanyname.Text = CommonFiles.ComapnyName;
string timezone = "";
if (Convert.ToInt32(Session["TimeZoneID"]) == 2)
{
timezone = "Eastern Standard Time";
}
else
{
timezone = "India Standard Time";
}
DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone));
var CurentDatetime = ISTTime;
lblDate2.Text = CurentDatetime.ToString("dddd MMMM dd yyyy, hh:mm:ss tt ");
lblTimeZoneName.Text = Session["TimeZoneName"].ToString().Trim();
lblHeadSchedule.Text = Session["ScheduleInOut"].ToString();
lblEmployyName.Text = Session["EmpName"].ToString().Trim();
Photo.Src = Session["Photo"].ToString().Trim();
lblLocation.Text = Session["LocationName"].ToString();
DateTime TodayDate = Convert.ToDateTime(Session["TodayBannerDate"]);
DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(TodayDate);
DateTime EndDate = StartDate.AddDays(-14);
ViewState["StartRptDt"] = EndDate;
ViewState["EndRptDt"] = StartDate.AddDays(-1);
txtToDate.Text = StartDate.AddDays(-1).ToString("MM/dd/yyyy");
txtFromDate.Text = EndDate.ToString("MM/dd/yyyy");
int userid = Convert.ToInt32(Session["UserID"]);
Attendance.BAL.Report obj = new Report();
DateTime Count = obj.GetFreezedDate(EndDate, Session["LocationName"].ToString());
if (Count.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "";
}
else
{
lblFreeze.Text = "This is tentative attendance report.Some or part of the attendance not yet freezed";
}
GetReport(EndDate, StartDate.AddDays(-1), userid);
BindListOfNewEmployee();
BindListofChanges();
}
}
else
{
Response.Redirect("Default.aspx");
}
}
protected void btnCurrent_Click(object sender, EventArgs e)
{
try
{
int userid = Convert.ToInt32(Session["UserID"]);
string Ismanage = Session["IsManage"].ToString();
string IsAdmin = Session["IsAdmin"].ToString();
if (ddlReportType.SelectedValue == "0")
{
DateTime StartDate = Convert.ToDateTime(ViewState["CurrentStart"].ToString());
DateTime EndDate = Convert.ToDateTime(ViewState["CurrentEnd"].ToString());
Session["TodayDate"] = StartDate;
if (GeneralFunction.GetFirstDayOfWeekDate(StartDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
DataTable ds = new DataTable();
lblReport.Text = "Report type";
ddlReportType.Visible = true;
lblReport.Visible = true;
btnFreeze.Visible = true;
lblFreeze.Visible = true;
DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartOfMonth = GeneralFunction.GetFirstDayOfWeekDate(TodayDate);
DateTime FreezeDate = StartOfMonth.AddDays(-1);
Attendance.BAL.Report obj = new Report();
// int CNT = obj.GetFreezedDate(FreezeDate);
DateTime CNT = obj.GetFreezedDate(FreezeDate, Session["LocationName"].ToString().Trim(), Convert.ToInt32(ddlShift.SelectedValue));
lblFreezedate.Text = FreezeDate.ToString("MM/dd/yyyy");
hdnFreeze.Value = FreezeDate.ToString("MM/dd/yyyy");
if (CNT.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "Attendance freezed until " + CNT.ToString("MM/dd/yyyy");
ViewState["FreezeDate"] = CNT.ToString("MM/dd/yyyy");
btnFreeze.CssClass = "btn btn-warning btn-small disabled";
btnFreeze.Enabled = false;
}
else
{
lblFreeze.Visible = false;
btnFreeze.CssClass = "btn btn-warning btn-small enabled";
btnFreeze.Enabled = true;
}
ds = GetReport(StartDate, EndDate, userid, Convert.ToInt32(ddlShift.SelectedItem.Value));
if (ds.Rows.Count > 1)
{
Session["AtnDetails"] = ds;
grdAttandence.DataSource = ds;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
}
else
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
}
}
else if (ddlReportType.SelectedValue == "1")
{
ViewState["TodayDate1"] = ViewState["CurrentWeek"];
DateTime startWeek = Convert.ToDateTime(ViewState["CurrentWeek"]);
DateTime EndWeek = Convert.ToDateTime(ViewState["CrntWkEnd"]);
hdnWeeklyStartDt.Value = startWeek.ToString();
if (GeneralFunction.GetFirstDayOfWeekDate(EndWeek).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
lblReport.Text = "Report type";
ddlReportType.Visible = true;
lblReport.Visible = true;
DataTable dt = GetWeeklyReport(startWeek, EndWeek, userid, Convert.ToInt32(ddlShift.SelectedItem.Value));
if (dt.Rows.Count > 1)
{
btnFreeze.Visible = false;
lblFreeze.Visible = false;
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
grdWeeklyAttendance.DataSource = dt;
grdWeeklyAttendance.DataBind();
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
}
else
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
}
}
else if (ddlReportType.SelectedItem.Value == "2")
{
DateTime StartDate = Convert.ToDateTime(ViewState["CurrentMonth"]);
ViewState["StartMonth"] = StartDate;
hdnMonthlyStartDt.Value = StartDate.ToString();
DateTime endDate = Convert.ToDateTime(ViewState["CrntMonthEnd"]);
DataTable dt = GetMonthlyreport(StartDate, endDate, userid, Convert.ToInt32(ddlShift.SelectedItem.Value));
btnFreeze.Visible = false;
lblFreeze.Visible = false;
if (endDate.ToString("MM/dd/yyyy") == (DateTime.Now.AddDays(1 - DateTime.Now.Day)).AddDays(-1).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
if (dt.Rows.Count > 1)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = dt;
grdMonthlyAttendance.DataBind();
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
}
else
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
}
}
}
catch (Exception ex)
{
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
int userid = Convert.ToInt32(Session["UserID"]);
DateTime StartDate = Convert.ToDateTime(txtFromDate.Text);
DateTime EndTime = Convert.ToDateTime(txtToDate.Text);
ViewState["StartRptDt"] = StartDate;
ViewState["EndRptDt"] = EndTime;
Attendance.BAL.Report obj = new Report();
DateTime Count = obj.GetFreezedDate(EndTime, Session["LocationName"].ToString());
if (Count.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "";
}
else
{
lblFreeze.Text = "This is tentative attendance report.Some or part of the attendance not yet freezed";
}
GetReport(StartDate, EndTime, userid);
BindListOfNewEmployee();
BindListofChanges();
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IsAdmin"] != null && Session["UserID"] != null)
{
if (!IsPostBack)
{
comanyname.Text = CommonFiles.ComapnyName;
string timezone = "";
if (Convert.ToInt32(Session["TimeZoneID"]) == 2)
{
timezone = "Eastern Standard Time";
}
else
{
timezone = "India Standard Time";
}
DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone));
var CurentDatetime = ISTTime;
lblDate2.Text = CurentDatetime.ToString("dddd MMMM dd yyyy, hh:mm:ss tt ");
lblTimeZoneName.Text = Session["TimeZoneName"].ToString().Trim();
lblHeadSchedule.Text = Session["ScheduleInOut"].ToString();
lblEmployyName.Text = Session["EmpName"].ToString().Trim();
Photo.Src = Session["Photo"].ToString().Trim();
lblLocation.Text = Session["LocationName"].ToString();
lblShiftName.Text = "-" + Session["ShiftName"].ToString();
DateTime TodayDate = Convert.ToDateTime(Session["TodayBannerDate"]);
int userid = Convert.ToInt32(Session["UserID"]);
getLocations();
ddlLocation.SelectedIndex = (ddlLocation.Items.IndexOf(ddlLocation.Items.FindByText(Session["LocationName"].ToString())));
ddlLocation.SelectedIndex = ddlLocation.Items.IndexOf(ddlLocation.Items.FindByText(lblLocation.Text.Trim()));
GetShifts(ddlLocation.SelectedItem.Text.ToString());
ddlShift.SelectedIndex = ddlShift.Items.IndexOf(ddlShift.Items.FindByValue(Session["ShiftID"].ToString()));
//if (lblLocation.Text.Trim() == "USMP" || lblLocation.Text.Trim() == "USWB")
//{
// lnkLeavemangement.Enabled = false;
// lnkLeavemangement.Style["Color"] = "Gray";
//}
//else
//{
// lnkLeavemangement.Enabled = true;
//}
if (Session["IsAdmin"].ToString() == "True")
{
if (ddlLocation.SelectedItem.Text.Trim() == "INBH" || ddlLocation.SelectedItem.Text.Trim() == "INDG")
{
DateTime CurrentDate = Convert.ToDateTime(ISTTime.ToString("MM/dd/yyyy"));
CurrentDate = CurrentDate.AddMonths(-1);
DateTime MonthStart = CurrentDate.AddDays(1 - CurrentDate.Day);
DateTime MonthEnd = MonthStart.AddMonths(1).AddSeconds(-1);
txtToDate.Text = MonthEnd.ToString("MM/dd/yyyy");
txtFromDate.Text = MonthStart.ToString("MM/dd/yyyy");
ViewState["StartRptDt"] = MonthStart;
ViewState["EndRptDt"] = MonthEnd;
Attendance.BAL.Report obj = new Report();
DateTime Count = obj.GetFreezedDate(MonthEnd, ddlLocation.SelectedItem.Text.Trim(),Convert.ToInt32(ddlShift.SelectedValue));
if (Count.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "";
}
else
{
lblFreeze.Text = "This is tentative attendance report.Some or part of the attendance not yet freezed";
}
//bool final = obj.GetFinalPayrollDate(MonthStart,Convert.ToInt32(ddlLocation.SelectedItem.Value),Convert.ToInt32(ddlShift.SelectedValue));
//if (final)
//{
// btnFinal.CssClass = "btn btn-small btn-warning disabled";
// btnSave.CssClass = "btn btn-small btn-warning disabled";
// btnFinal.Enabled = false;
// btnSave.Enabled = false;
// hdnFreeze.Value = "true"; ;
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "delEditLabelCss();", true);
//}
//else
//{
// btnFinal.CssClass = "btn btn-small btn-warning";
// btnSave.CssClass = "btn btn-small btn-warning";
// btnFinal.Enabled = true;
// btnSave.Enabled = true;
// hdnFreeze.Value = "false";
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "addEditLabelCss();", true);
//}
DataTable dt = GetReportIndia(MonthStart, MonthEnd, 0, ddlLocation.SelectedItem.Text.Trim(), Convert.ToInt32(ddlShift.SelectedValue));
lblWeekPayrollReport.Text = "( " + MonthStart.ToString("MM/dd/yyyy") + " - " + MonthEnd.ToString("MM/dd/yyyy") + " )";
GetEditHistory(MonthStart, MonthEnd);
if (dt.Rows.Count > 0)
{
lblTotal.Text = "Employee record count: " + dt.Rows.Count.ToString().Trim();
lblReportDate.Text = "Report generated at <b>" + Convert.ToDateTime(lblDate2.Text).ToString("MM/dd/yyyy hh:mm:ss tt") + "</b> by <b>" + Session["EmpName"].ToString().Trim() + "</b>";
grdPayRollIndia.DataSource = dt;
grdPayRollIndia.DataBind();
Session["Indiapayroll"] = (DataTable)grdPayRollIndia.DataSource;
grdPayRoll.DataSource = null;
grdPayRoll.DataBind();
btnPrint.Visible = true;
lblGrdNodata.Text = "";
dvNodata.Style["display"] = "none";
}
else
{
lblTotal.Text = "";
lblReportDate.Text = "";
lblGrdNodata.Text = "No data found";
dvNodata.Style["display"] = "block";
grdPayRollIndia.DataSource = null;
grdPayRollIndia.DataBind();
grdPayRoll.DataSource = null;
grdPayRoll.DataBind();
}
}
else
{
DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(TodayDate);
DateTime EndDate = StartDate.AddDays(-14);
Attendance.BAL.Report obj = new Report();
DateTime Count = obj.GetFreezedDate(EndDate, ddlLocation.SelectedItem.Text.Trim(), Convert.ToInt32(ddlShift.SelectedValue));
if (Count.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "";
}
else
{
lblFreeze.Text = "This is tentative attendance report.Some or part of the attendance not yet freezed";
}
txtToDate.Text = StartDate.AddDays(-1).ToString("MM/dd/yyyy");
txtFromDate.Text = EndDate.ToString("MM/dd/yyyy");
ViewState["StartRptDt"] = EndDate;
ViewState["EndRptDt"] = StartDate.AddDays(-1);
GetReport(EndDate, StartDate.AddDays(-1), 0, ddlLocation.SelectedItem.Text.Trim(),Convert.ToInt32(ddlShift.SelectedValue));
btnPrint.Visible = false;
rppayslip.DataSource = null;
rppayslip.DataBind();
}
lblGrdLocaton.Visible = true;
ddlLocation.Visible = true;
}
else
{
if (ddlLocation.SelectedItem.Text.Trim() == "INBH" || ddlLocation.SelectedItem.Text.Trim() == "INDG")
{
DateTime CurrentDate = Convert.ToDateTime(ISTTime.ToString("MM/dd/yyyy"));
CurrentDate = CurrentDate.AddMonths(-1);
DateTime MonthStart = CurrentDate.AddDays(1 - CurrentDate.Day);
DateTime MonthEnd = MonthStart.AddMonths(1).AddSeconds(-1);
txtToDate.Text = MonthEnd.ToString("MM/dd/yyyy");
txtFromDate.Text = MonthStart.ToString("MM/dd/yyyy");
ViewState["StartRptDt"] = MonthStart;
ViewState["EndRptDt"] = MonthEnd;
Attendance.BAL.Report obj = new Report();
DateTime Count = obj.GetFreezedDate(MonthEnd, Session["LocationName"].ToString(), Convert.ToInt32(ddlShift.SelectedValue));
if (Count.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "";
}
else
{
lblFreeze.Text = "This is tentative attendance report.Some or part of the attendance not yet freezed";
}
//bool final = obj.GetFinalPayrollDate(MonthStart, Convert.ToInt32(ddlLocation.SelectedItem.Value), Convert.ToInt32(ddlShift.SelectedValue));
//if (final)
//{
// btnFinal.CssClass = "btn btn-small btn-warning disabled";
// btnSave.CssClass = "btn btn-small btn-warning disabled";
// btnFinal.Enabled = false;
// btnSave.Enabled = false;
// hdnFreeze.Value = "true"; ;
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "delEditLabelCss();", true);
//}
//else
//{
// btnFinal.CssClass = "btn btn-small btn-warning";
// btnSave.CssClass = "btn btn-small btn-warning";
// btnFinal.Enabled = true;
// btnSave.Enabled = true;
// hdnFreeze.Value = "false";
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "addEditLabelCss();", true);
//}
DataTable dt = GetReportIndia(MonthStart, MonthEnd,0, ddlLocation.SelectedItem.Text, Convert.ToInt32(ddlShift.SelectedValue));
lblWeekPayrollReport.Text = "( " + MonthStart.ToString("MM/dd/yyyy") + " - " + MonthEnd.ToString("MM/dd/yyyy") + " )";
GetEditHistory(MonthStart, MonthEnd);
if (dt.Rows.Count > 0)
{
lblTotal.Text = "Employee record count: " + dt.Rows.Count.ToString().Trim();
lblReportDate.Text = "Report generated at <b>" + Convert.ToDateTime(lblDate2.Text).ToString("MM/dd/yyyy hh:mm:ss tt") + "</b> by <b>" + Session["EmpName"].ToString().Trim() + "</b>";
grdPayRollIndia.DataSource = dt;
grdPayRollIndia.DataBind();
Session["Indiapayroll"] = (DataTable)grdPayRollIndia.DataSource;
grdPayRoll.DataSource = null;
grdPayRoll.DataBind();
btnPrint.Visible = true;
lblGrdNodata.Text = "";
dvNodata.Style["display"] = "none";
}
else
{
lblTotal.Text = "";
lblReportDate.Text = "";
lblGrdNodata.Text = "No data found";
dvNodata.Style["display"] = "block";
grdPayRollIndia.DataSource = null;
grdPayRollIndia.DataBind();
grdPayRoll.DataSource = null;
grdPayRoll.DataBind();
}
}
else
{
DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(TodayDate);
DateTime EndDate = StartDate.AddDays(-14);
Attendance.BAL.Report obj = new Report();
DateTime Count = obj.GetFreezedDate(EndDate, Session["LocationName"].ToString(), Convert.ToInt32(ddlShift.SelectedValue));
if (Count.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "";
}
else
{
lblFreeze.Text = "This is tentative attendance report.Some or part of the attendance not yet freezed";
}
txtToDate.Text = StartDate.AddDays(-1).ToString("MM/dd/yyyy");
txtFromDate.Text = EndDate.ToString("MM/dd/yyyy");
ViewState["StartRptDt"] = EndDate;
ViewState["EndRptDt"] = StartDate.AddDays(-1);
GetReport(EndDate, StartDate.AddDays(-1), 0, ddlLocation.SelectedItem.Text.Trim(), Convert.ToInt32(ddlShift.SelectedValue));
btnPrint.Visible = false;
rppayslip.DataSource = null;
rppayslip.DataBind();
}
lblGrdLocaton.Visible = true;
ddlLocation.Enabled = false;
}
BindListOfNewEmployee();
BindListofChanges();
}
}
else
{
Response.Redirect("Default.aspx");
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
int userid = Convert.ToInt32(Session["UserID"]);
DateTime StartDate = Convert.ToDateTime(txtFromDate.Text);
DateTime EndTime = Convert.ToDateTime(txtToDate.Text);
ViewState["StartRptDt"] = StartDate;
ViewState["EndRptDt"] = EndTime;
Attendance.BAL.Report obj = new Report();
DateTime Count = obj.GetFreezedDate(EndTime, ddlLocation.SelectedItem.Text.ToString(), Convert.ToInt32(ddlShift.SelectedValue));
if (Count.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "";
}
else
{
lblFreeze.Text = "This is tentative attendance report.Some or part of the attendance not yet freezed";
}
if (Session["IsAdmin"].ToString() == "True")
{
if (ddlLocation.SelectedItem.Text.Trim() == "INBH" || ddlLocation.SelectedItem.Text.Trim() == "INDG")
{
txtFromDate.Text = StartDate.ToString("MM/dd/yyyy");
txtToDate.Text = EndTime.ToString("MM/dd/yyyy");
//bool final = obj.GetFinalPayrollDate(StartDate, Convert.ToInt32(ddlLocation.SelectedItem.Value), Convert.ToInt32(ddlShift.SelectedValue));
//if (final)
//{
// btnFinal.CssClass = "btn btn-small btn-warning disabled";
// btnSave.CssClass = "btn btn-small btn-warning disabled";
// btnFinal.Enabled = false;
// btnSave.Enabled = false;
// hdnFreeze.Value = "true"; ;
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "delEditLabelCss();", true);
//}
//else
//{
// btnFinal.CssClass = "btn btn-small btn-warning";
// btnSave.CssClass = "btn btn-small btn-warning";
// btnFinal.Enabled = true;
// btnSave.Enabled = true;
// hdnFreeze.Value = "false";
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "addEditLabelCss();", true);
//}
DataTable dt = GetReportIndia(StartDate, EndTime,0,ddlLocation.SelectedItem.Text, Convert.ToInt32(ddlShift.SelectedValue));
lblWeekPayrollReport.Text = "( " + StartDate.ToString("MM/dd/yyyy") + " - " + EndTime.ToString("MM/dd/yyyy") + " )";
GetEditHistory(StartDate, EndTime);
if (dt.Rows.Count > 0)
{
lblTotal.Text = "Employee record count: " + dt.Rows.Count.ToString().Trim();
lblReportDate.Text = "Report generated at <b>" + Convert.ToDateTime(lblDate2.Text).ToString("MM/dd/yyyy hh:mm:ss tt") + "</b> by <b>" + Session["EmpName"].ToString().Trim() + "</b>";
grdPayRollIndia.DataSource = dt;
grdPayRollIndia.DataBind();
Session["Indiapayroll"] = (DataTable)grdPayRollIndia.DataSource;
grdPayRoll.DataSource = null;
grdPayRoll.DataBind();
btnPrint.Visible = true;
lblGrdNodata.Text = "";
dvNodata.Style["display"] = "none";
}
else
{
lblTotal.Text = "";
lblReportDate.Text = "";
lblGrdNodata.Text = "No data found";
dvNodata.Style["display"] = "block";
grdPayRollIndia.DataSource = null;
grdPayRollIndia.DataBind();
grdPayRoll.DataSource = null;
grdPayRoll.DataBind();
}
}
else
{
txtFromDate.Text = StartDate.AddDays(-1).ToString("MM/dd/yyyy");
txtToDate.Text = EndTime.ToString("MM/dd/yyyy");
GetReport( StartDate.AddDays(-1),EndTime,0, ddlLocation.SelectedItem.Text.Trim(), Convert.ToInt32(ddlShift.SelectedValue));
btnPrint.Visible = false;
rppayslip.DataSource = null;
rppayslip.DataBind();
}
lblGrdLocaton.Visible = true;
ddlLocation.Visible = true;
}
else
{
GetReport(StartDate, EndTime, userid, "", Convert.ToInt32(ddlShift.SelectedValue));
lblGrdLocaton.Visible = false;
ddlLocation.Visible = false;
btnPrint.Visible = false;
rppayslip.DataSource = null;
rppayslip.DataBind();
}
// GetReport(StartDate, EndTime, userid,ddlLocation.SelectedItem.Text.Trim());
BindListOfNewEmployee();
BindListofChanges();
}
catch (Exception ex)
{
}
}
protected void ddlShift_SelectedIndexChanged(object sender, EventArgs e)
{
ViewState["Location"] = ddlLocation.SelectedItem.Text.Trim();
try
{
if (ddlReportType.SelectedItem.Value == "0")
{
lblReport.Text = "Report type";
ddlReportType.Visible = true;
lblReport.Visible = true;
lblGrdLocaton.Visible = true;
lblGrdLocaton.Text = "Location";
ddlLocation.Visible = true;
int LocationId = Convert.ToInt32(ddlLocation.SelectedItem.Value.ToString());
DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(TodayDate);
DateTime EndDate = GeneralFunction.GetLastDayOfWeekDate(TodayDate);
btnFreeze.Visible = true;
lblFreeze.Visible = true;
// DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartOfMonth = StartDate.AddDays(-1);
DateTime FreezeDate = StartOfMonth;
Attendance.BAL.Report obj = new Report();
// int CNT = obj.GetFreezedDate(FreezeDate);
DateTime CNT = obj.GetFreezedDate(FreezeDate, ddlLocation.SelectedItem.Text.ToString().Trim(), Convert.ToInt32(ddlShift.SelectedValue));
lblFreezedate.Text = FreezeDate.ToString("MM/dd/yyyy");
hdnFreeze.Value = FreezeDate.ToString("MM/dd/yyyy");
if (CNT.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "Attendance freezed until " + CNT.ToString("MM/dd/yyyy");
ViewState["FreezeDate"] = CNT.ToString("MM/dd/yyyy");
btnFreeze.CssClass = "btn btn-warning btn-small disabled";
btnFreeze.Enabled = false;
}
else
{
lblFreeze.Visible = false;
btnFreeze.CssClass = "btn btn-warning btn-small enabled";
btnFreeze.Enabled = true;
}
if (GeneralFunction.GetFirstDayOfWeekDate(TodayDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
DataTable ds = GetReportAdmin(StartDate, EndDate, LocationId, Convert.ToInt32(ddlShift.SelectedItem.Value));
if (ds.Rows.Count > 2)
{
Session["AtnAdminDetails"] = ds;
grdAttandence.DataSource = ds;
grdAttandence.DataBind();
// System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "addCssAfterBind();", true);
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
lblGrdNodata.Text = "";
dvNodata.Style["display"] = "none";
}
else
{
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
lblGrdNodata.Visible = true;
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
else if (ddlReportType.SelectedItem.Value == "1")
{
lblReport.Text = "Report type";
ddlReportType.Visible = true;
lblReport.Visible = true;
lblGrdLocaton.Visible = true;
lblGrdLocaton.Text = "Location";
ddlLocation.Visible = true;
btnFreeze.Visible = false;
lblFreeze.Visible = false;
int LocationId = Convert.ToInt32(ddlLocation.SelectedItem.Value.ToString());
DateTime todayDate = Convert.ToDateTime(Session["TodayDate1"]);
DateTime startDate = GeneralFunction.GetFirstDayOfWeekDate(todayDate);
DateTime StartDate = startDate.AddDays(-21);
ViewState["TodayDate1"] = StartDate;
ViewState["CurrentWeek"] = StartDate;
hdnWeeklyStartDt.Value = StartDate.ToString();
DateTime endDate = startDate.AddDays(6);
ViewState["CrntWkEnd"] = endDate;
if (GeneralFunction.GetFirstDayOfWeekDate(endDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
DataTable dt = GetWeeklyReport(StartDate, endDate, Convert.ToInt32(ddlShift.SelectedItem.Value));
if (dt.Rows.Count > 1)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = dt;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
}
else
{
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
lblGrdNodata.Visible = true;
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
else if (ddlReportType.SelectedItem.Value == "2")
{
lblReport.Text = "Report type";
ddlReportType.Visible = true;
lblReport.Visible = true;
lblGrdLocaton.Visible = true;
lblGrdLocaton.Text = "Location";
ddlLocation.Visible = true;
btnFreeze.Visible = false;
lblFreeze.Visible = false;
int LocationId = Convert.ToInt32(ddlLocation.SelectedItem.Value.ToString());
DateTime todayDate = Convert.ToDateTime(Session["TodayBannerDate"]);
DateTime startDate = todayDate;
DateTime StartDate = startDate.AddDays(1 - startDate.Day);
ViewState["StartMonth"] = StartDate.AddMonths(-6);
ViewState["CurrentMonth"] = StartDate.AddMonths(-6);
hdnMonthlyStartDt.Value = StartDate.AddMonths(-6).ToString();
DateTime endDate = StartDate.AddSeconds(-1);
ViewState["CrntMonthEnd"] = endDate;
DataTable dt = GetMonthlyreport(StartDate.AddMonths(-6), endDate, Convert.ToInt32(ddlShift.SelectedItem.Value));
btnFreeze.Visible = false;
lblFreeze.Visible = false;
if (endDate.ToString("MM/dd/yyyy") == (DateTime.Now.AddDays(1 - DateTime.Now.Day)).AddDays(-1).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
if (dt.Rows.Count > 1)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = dt;
grdMonthlyAttendance.DataBind();
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
lblGrdNodata.Visible = false;
}
else
{
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
lblGrdNodata.Visible = true;
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
}
catch (Exception ex)
{
}
}
protected void btnPrevious_Click(object sender, EventArgs e)
{
try
{
if (ddlReportType.SelectedItem.Value == "0")
{
int userid = Convert.ToInt32(Session["UserID"]);
DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime PrevWeek = TodayDate.AddDays(-7);
Session["TodayDate"] = PrevWeek.ToString();
if (GeneralFunction.GetFirstDayOfWeekDate(PrevWeek).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
DateTime PreWeekStart = GeneralFunction.GetFirstDayOfWeekDate(PrevWeek);
DateTime PreWeekEnd = GeneralFunction.GetLastDayOfWeekDate(PrevWeek);
//DataTable ds = GetReport(PreWeekStart, PreWeekEnd, userid);
string Ismanage = Session["IsManage"].ToString();
string IsAdmin = Session["IsAdmin"].ToString();
DataTable ds = new DataTable();
btnFreeze.Visible = true;
lblFreeze.Visible = true;
// DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]);
DateTime StartOfMonth = PreWeekStart.AddDays(-1);
DateTime FreezeDate = StartOfMonth;
Attendance.BAL.Report obj = new Report();
// int CNT = obj.GetFreezedDate(FreezeDate);
DateTime CNT = obj.GetFreezedDate(FreezeDate, ddlLocation.SelectedItem.Text.ToString().Trim(), Convert.ToInt32(ddlShift.SelectedValue));
lblFreezedate.Text = FreezeDate.ToString("MM/dd/yyyy");
hdnFreeze.Value = FreezeDate.ToString("MM/dd/yyyy");
if (CNT.ToString("MM/dd/yyyy") != "01/01/1900")
{
lblFreeze.Text = "Attendance freezed until " + CNT.ToString("MM/dd/yyyy");
ViewState["FreezeDate"] = CNT.ToString("MM/dd/yyyy");
btnFreeze.CssClass = "btn btn-warning btn-small disabled";
btnFreeze.Enabled = false;
}
else
{
lblFreeze.Visible = false;
btnFreeze.CssClass = "btn btn-warning btn-small enabled";
btnFreeze.Enabled = true;
}
ds = GetReportAdmin(PreWeekStart, PreWeekEnd, Convert.ToInt32(ddlLocation.SelectedValue), Convert.ToInt32(ddlShift.SelectedValue));
if (ds.Rows.Count > 2)
{
Session["AtnAdminDetails"] = ds;
grdAttandence.DataSource = ds;
grdAttandence.DataBind();
//System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "addCssAfterBind();", true);
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
lblGrdNodata.Text = "";
dvNodata.Style["display"] = "none";
}
else
{
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
lblGrdNodata.Visible = true;
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
else if (ddlReportType.SelectedItem.Value == "1")
{
int userid = Convert.ToInt32(Session["UserID"]);
DateTime todayDate = Convert.ToDateTime(ViewState["TodayDate1"]);
ViewState["TodayDate1"] = todayDate.AddDays(-28);
// DateTime startOfMonth = new DateTime(todayDate.Year, todayDate.Month, 1);
DateTime startDate = GeneralFunction.GetFirstDayOfWeekDate(todayDate.AddDays(-28));
DateTime StartDate = startDate;
hdnWeeklyStartDt.Value = StartDate.ToString();
DateTime endDate = todayDate.AddDays(-1);
if (GeneralFunction.GetFirstDayOfWeekDate(startDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
btnFreeze.Visible = false;
lblFreeze.Visible = false;
DataTable dt = GetWeeklyReport(StartDate, endDate, Convert.ToInt32(ddlShift.SelectedItem.Value));
if (dt.Rows.Count > 1)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = dt;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
}
else
{
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
lblGrdNodata.Visible = true;
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
else if (ddlReportType.SelectedItem.Value == "2")
{
// int userid = Convert.ToInt32(Session["UserID"]);
DateTime startDate = Convert.ToDateTime(ViewState["StartMonth"]);
DateTime StartDate = startDate.AddMonths(-6);
hdnMonthlyStartDt.Value = StartDate.ToString();
DateTime endDate = startDate.AddSeconds(-1);
ViewState["StartMonth"] = StartDate;
DataTable dt = GetMonthlyreport(StartDate, endDate, Convert.ToInt32(ddlShift.SelectedItem.Value));
btnFreeze.Visible = false;
lblFreeze.Visible = false;
if (endDate.ToString("MM/dd/yyyy") == (DateTime.Now.AddDays(1 - DateTime.Now.Day)).AddDays(-1).ToString("MM/dd/yyyy"))
{
btnNext.CssClass = "btn btn-danger btn-small disabled";
btnNext.Enabled = false;
}
else
{
btnNext.CssClass = "btn btn-danger btn-small enabled";
btnNext.Enabled = true;
}
if (dt.Rows.Count > 1)
{
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = dt;
grdMonthlyAttendance.DataBind();
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
lblGrdNodata.Visible = false;
}
else
{
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
lblGrdNodata.Visible = true;
grdAttandence.DataSource = null;
grdAttandence.DataBind();
grdWeeklyAttendance.DataSource = null;
grdWeeklyAttendance.DataBind();
grdMonthlyAttendance.DataSource = null;
grdMonthlyAttendance.DataBind();
}
}
}
catch (Exception ex)
{
}
}