Esempio n. 1
0
        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)
            {

            }
        }