protected void btnMultipleUpdateOut_Click(object sender, EventArgs e) { try { Business obj = new Business(); string EmpID = hdnMultipleEmpID.Value.ToString().Trim(); DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(Convert.ToDateTime(Session["TodayDate"].ToString())); DateTime EndDate = GeneralFunction.GetLastDayOfWeekDate(Convert.ToDateTime(Session["TodayDate"].ToString())); string empname = Session["EmpName"].ToString().Trim(); 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; int LocationID = Convert.ToInt32(ddlLocation.SelectedItem.Value); int len = Convert.ToInt32(hdnMultipleLength.Value); if (len == 0) { string signInnotes = ""; string signinTime = ""; int loguserId = Convert.ToInt32(hdnMultipleEditLogUserID.Value); if (txtMultipleSignIn.Text != "") { if (loguserId != 0) { signInnotes = "Sign in time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; signinTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + txtMultipleSignIn.Text; } else { signinTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + txtMultipleSignIn.Text; signInnotes = "Sign in time added by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n to " + signinTime; } string Signoutnotes = "Sign out time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; string signOutTime = "01/01/1900"; if (txtMultipleSignOut.Text != "") { signOutTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + txtMultipleSignOut.Text; } bool bnew = obj.UpdateSignInSignOut(EmpID, loguserId, signinTime, signOutTime, signInnotes, Signoutnotes); } else { bool bnew = obj.UpdateSignInSignOutDelete(loguserId); } } else { // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "GetMultiple();", true); string multiplesignIns = hdnMultipleSignIns.Value; string[] multipleSet = multiplesignIns.Split('*'); for (int i = 0; i < multipleSet.Length - 1; i++) { string[] singleSet = multipleSet[i].Split('-'); int loguserID = Convert.ToInt32(singleSet[0].ToString()); string signIn = singleSet[1].ToString(); string signOut = singleSet[2].ToString(); string signInTime = "01/01/1900"; string signInnotes = ""; string Signoutnotes = ""; if (signIn != "N/A" && signIn != "") { signInTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + signIn; signInnotes = "Sign in time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; string signOutTime = "01/01/1900"; if (signOut != "N/A") { signOutTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + signOut; Signoutnotes = "Sign out time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; } bool bnew = obj.UpdateSignInSignOut(EmpID, loguserID, signInTime, signOutTime, signInnotes, Signoutnotes); } else { bool bnew = obj.UpdateSignInSignOutDelete(loguserID); } } } // GetReportAdmin(StartDate, EndDate, LocationID); Page.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true); mdlMultipleEditEditPopUp.Hide(); } catch (Exception ex) { } }
protected void btnMultipleUpdateOut_Click(object sender, EventArgs e) { try { Business obj = new Business(); string EmpID = hdnMultipleEmpID.Value.ToString().Trim(); int offset = Convert.ToInt32(hdnMultipleOffset.Value.Trim()); DateTime StartDate = GeneralFunction.GetFirstDayOfWeekDate(Convert.ToDateTime(Session["TodayDate"].ToString())); DateTime EndDate = GeneralFunction.GetLastDayOfWeekDate(Convert.ToDateTime(Session["TodayDate"].ToString())); string empname = Session["EmpName"].ToString().Trim(); 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; int LocationID = Convert.ToInt32(ddlLocation.SelectedItem.Value); int len = Convert.ToInt32(hdnMultipleLength.Value); if (len == 0) { string signInnotes = ""; string signinTime = ""; int loguserId = Convert.ToInt32(hdnMultipleEditLogUserID.Value); if (txtMultipleSignIn.Text != "") { if (loguserId != 0) { signInnotes = "Sign in time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; signinTime = Convert.ToDateTime(txtMultipleSignIn.Text).AddHours(-offset).ToString().Trim(); // signinTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + txtMultipleSignIn.Text; } else { signinTime = Convert.ToDateTime(txtMultipleSignIn.Text).AddHours(-offset).ToString().Trim(); //signinTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + txtMultipleSignIn.Text; signInnotes = "Sign in time added by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n to " + txtMultipleSignIn.Text; } string Signoutnotes = "Sign out time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; string signOutTime = "01/01/1900"; if (txtMultipleSignOut.Text != "") { // signOutTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + txtMultipleSignOut.Text; signOutTime = Convert.ToDateTime(txtMultipleSignOut.Text).AddHours(-offset).ToString(); } bool bnew = obj.UpdateSignInSignOut(EmpID, loguserId, signinTime, signOutTime, signInnotes, Signoutnotes); } else { bool bnew = obj.UpdateSignInSignOutDelete(loguserId); } } else { string multiplesignIns = hdnMultipleSignIns.Value; string[] multipleSet = multiplesignIns.Split('*'); for (int i = 0; i < multipleSet.Length - 1; i++) { string[] singleSet = multipleSet[i].Split('-'); int loguserID = Convert.ToInt32(singleSet[0].ToString()); string signIn = singleSet[1].ToString(); string signOut = singleSet[2].ToString(); string signInTime = "01/01/1900"; string signInnotes = ""; string Signoutnotes = ""; if (signIn != "N/A" && signIn != "") { // signInTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + signIn; signInTime = Convert.ToDateTime(signIn).AddHours(-offset).ToString().Trim(); signInnotes = "Sign in time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; string signOutTime = "01/01/1900"; if (signOut != "N/A") { //signOutTime = Convert.ToDateTime(hdnMultipleSignInTime.Value).ToString("MM/dd/yyyy") + " " + signOut; signOutTime = Convert.ToDateTime(signOut).AddHours(-offset).ToString().Trim(); Signoutnotes = "Sign out time changed by " + empname + " at -" + ISTTime.ToString("MM/dd/yyyy hh:mm:ss") + "\n"; } bool bnew = obj.UpdateSignInSignOut(EmpID, loguserID, signInTime, signOutTime, signInnotes, Signoutnotes); } else { bool bnew = obj.UpdateSignInSignOutDelete(loguserID); } } } DataTable ds = GetReportAdmin(StartDate, EndDate, LocationID, Convert.ToInt32(ddlShift.SelectedItem.Value)); if (ds.Rows.Count > 2) { Session["AtnAdminDetails"] = ds; grdAttandence.DataSource = ds; grdAttandence.DataBind(); 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(); } mdlMultipleEditEditPopUp.Hide(); } catch (Exception ex) { } }