///OT Proccess /// protected void btnOTProccess_Click(object sender, EventArgs e) { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; List <string> ShiftCodes = objAtt_BLL.GetAllShiftCode(OCODE).ToList(); foreach (string ashiftcode in ShiftCodes) { var result = objAtt_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtOTFrom.Text), Convert.ToDateTime(txtOTTo.Text), ashiftcode); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('OT Proccessed Successfully')", true); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('OT Proccessing Failure!')", true); } } //ot process log DateTime fromdate = Convert.ToDateTime(txtOTFrom.Text.Trim()); DateTime todate = Convert.ToDateTime(txtOTTo.Text.Trim()); Guid USERID = ((SessionUser)Session["SessionUser"]).UserId; var ParamempID1 = new SqlParameter("@Date_From", fromdate); var ParamempID2 = new SqlParameter("@Date_To", todate); var ParamempID3 = new SqlParameter("@Edit_User", USERID); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @Date_From, @Date_To, @Edit_User, @Edit_Date, @OCODE"; _context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); // //txtOTFrom.Text = ""; //txtOTTo.Text = ""; } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void btn_Confirm_Clcik(object sender, EventArgs e) { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; DateTime EDIT_DATE = DateTime.Now; Guid userId = ((SessionUser)Session["SessionUser"]).UserId; DateTime workingDate = Convert.ToDateTime(txtDate.Text); string Attdate = Convert.ToString(txtDate.Text); List <HRM_OfficialDay_Individual> lstHRM_OfficialDay_Individual = new List <HRM_OfficialDay_Individual>(); if (ckIndividualWorkingDay.Checked) // individual working day type change { if (txtbxEID.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Enter E-ID!')", true); return; } if (txtDate.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Working Date!')", true); return; } if (ddlworkingType.SelectedItem.Text == "------ Select One ------") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Working Day!')", true); return; } HRM_OfficialDay_Individual aHRM_OfficialDay_Individual = new HRM_OfficialDay_Individual(); string eid = txtbxEID.Text; string workingDay = ddlworkingType.Text; var getdata = objAtt_BLL.GetAllOfficeDayById(OCODE, eid, Convert.ToDateTime(txtDate.Text)); var getAttendancedata = objAtt_BLL.GetAttendanceByEID_Date(OCODE, eid, Convert.ToDateTime(txtDate.Text)); if (getdata.Count() == 0) //insert { aHRM_OfficialDay_Individual.EID = txtbxEID.Text; aHRM_OfficialDay_Individual.Official_Date = Convert.ToDateTime(txtDate.Text); aHRM_OfficialDay_Individual.Working_Day = workingDay; aHRM_OfficialDay_Individual.OCode = OCODE; aHRM_OfficialDay_Individual.Edit_Date = EDIT_DATE; aHRM_OfficialDay_Individual.Edit_User = userId; lstHRM_OfficialDay_Individual.Add(aHRM_OfficialDay_Individual); _context.HRM_OfficialDay_Individual.AddObject(aHRM_OfficialDay_Individual); _context.SaveChanges(); // insert working day type if (getAttendancedata.Count > 0) { HRM_ATTENDANCE aHRM_ATTENDANCE = new HRM_ATTENDANCE(); DateTime date = Convert.ToDateTime(Attdate); aHRM_ATTENDANCE = _context.HRM_ATTENDANCE.Where(c => c.EID == eid && c.Attendance_Date == date).First(); aHRM_ATTENDANCE.Update_Status = 0; aHRM_ATTENDANCE.OCode = OCODE; aHRM_ATTENDANCE.Edit_Date = EDIT_DATE; aHRM_ATTENDANCE.Edit_User = userId; _context.SaveChanges(); // update attendance update status // update attendnace status by date aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //insert/update leave/holiday attendnace status process by selected eid aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID2(lstHRM_OfficialDay_Individual, Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //ot process List <string> ShiftCodes = objAtt_BLL.GetAllShiftCode(OCODE).ToList(); foreach (string ashiftcode in ShiftCodes) { objAtt_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text), ashiftcode); } //ot process log var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtDate.Text)); var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtDate.Text)); var ParamempID3 = new SqlParameter("@Edit_User", userId); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; _context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); } ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true); grdview.DataSource = null; grdview.DataBind(); } else //update { HRM_OfficialDay_Individual _HRM_OfficialDay_Individual = new HRM_OfficialDay_Individual(); _HRM_OfficialDay_Individual = _context.HRM_OfficialDay_Individual.Where(c => c.EID == eid).First(); _HRM_OfficialDay_Individual.Working_Day = workingDay; _HRM_OfficialDay_Individual.OCode = OCODE; _HRM_OfficialDay_Individual.Edit_Date = EDIT_DATE; _HRM_OfficialDay_Individual.Edit_User = userId; _HRM_OfficialDay_Individual.Official_Date = Convert.ToDateTime(txtDate.Text); lstHRM_OfficialDay_Individual.Add(_HRM_OfficialDay_Individual); int result = objAtt_BLL.UpdateWorkingDay(lstHRM_OfficialDay_Individual); // update working day type if (result == 1) { if (getAttendancedata.Count > 0) { HRM_ATTENDANCE aHRM_ATTENDANCE = new HRM_ATTENDANCE(); DateTime date = Convert.ToDateTime(Attdate); aHRM_ATTENDANCE = _context.HRM_ATTENDANCE.Where(c => c.EID == eid && c.Attendance_Date == date).First(); aHRM_ATTENDANCE.Update_Status = 0; aHRM_ATTENDANCE.OCode = OCODE; aHRM_ATTENDANCE.Edit_Date = EDIT_DATE; aHRM_ATTENDANCE.Edit_User = userId; _context.SaveChanges(); // update attendnace update status // update attendnace status by date aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //insert/update leave/holiday attendnace status process by selected eid aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID2(lstHRM_OfficialDay_Individual, Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //ot process List <string> ShiftCodes = objAtt_BLL.GetAllShiftCode(OCODE).ToList(); foreach (string ashiftcode in ShiftCodes) { objAtt_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text), ashiftcode); } //ot process log var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtDate.Text)); var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtDate.Text)); var ParamempID3 = new SqlParameter("@Edit_User", userId); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; _context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); } grdview.DataSource = null; grdview.DataBind(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processing Faliure!')", true); } } ClearUI(); } else // dept/section/subsection wise working day type change { if (grdview.Rows.Count < 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true); return; } foreach (GridViewRow gvRow in grdview.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); HRM_OfficialDay_Individual aHRM_OfficialDay_Individual = new HRM_OfficialDay_Individual(); Label lblEID = ((Label)gvRow.FindControl("lblEID")); string eid = lblEID.Text.ToString(); DropDownList ddlworking_Day = ((DropDownList)gvRow.FindControl("ddlworking_Day")); string workingDay = ddlworking_Day.Text; var getdata = objAtt_BLL.GetAllOfficeDayById(OCODE, eid, Convert.ToDateTime(txtDate.Text)); //var getAttendancedata = objAtt_BLL.GetAttendanceByEID_Date(OCODE, eid, Convert.ToDateTime(txtDate.Text)); if (rowChkBox.Checked == true) { if (getdata.Count() == 0) //insert { aHRM_OfficialDay_Individual.EID = lblEID.Text; aHRM_OfficialDay_Individual.Official_Date = Convert.ToDateTime(txtDate.Text); aHRM_OfficialDay_Individual.Working_Day = workingDay; aHRM_OfficialDay_Individual.OCode = OCODE; aHRM_OfficialDay_Individual.Edit_Date = EDIT_DATE; aHRM_OfficialDay_Individual.Edit_User = userId; lstHRM_OfficialDay_Individual.Add(aHRM_OfficialDay_Individual); _context.HRM_OfficialDay_Individual.AddObject(aHRM_OfficialDay_Individual); _context.SaveChanges(); //insert //if (getAttendancedata.Count > 0) //{ //foreach (var aHRM_ATTENDANCE in _context.HRM_ATTENDANCE.Where(x => x.EID == eid && x.Attendance_Date == workingDate)) //{ // aHRM_ATTENDANCE.Update_Status = 0; // aHRM_ATTENDANCE.OCode = OCODE; // aHRM_ATTENDANCE.Edit_Date = EDIT_DATE; // aHRM_ATTENDANCE.Edit_User = userId; //} //_context.CommandTimeout = 1000; //_context.SaveChanges(); //HRM_ATTENDANCE aHRM_ATTENDANCE = new HRM_ATTENDANCE(); //DateTime date = Convert.ToDateTime(Attdate); //aHRM_ATTENDANCE = _context.HRM_ATTENDANCE.Where(c => c.EID == eid && c.Attendance_Date == date).First(); //aHRM_ATTENDANCE.Update_Status = 0; //aHRM_ATTENDANCE.OCode = OCODE; //aHRM_ATTENDANCE.Edit_Date = EDIT_DATE; //aHRM_ATTENDANCE.Edit_User = userId; //_context.SaveChanges(); //aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); // update attendnace status by date //insert/update leave/holiday attendnace status process by selected eid //aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID2(lstHRM_OfficialDay_Individual, Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //ot process //List<string> ShiftCodes = objAtt_BLL.GetAllShiftCode(OCODE).ToList(); //foreach (string ashiftcode in ShiftCodes) //{ // objAtt_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text), ashiftcode); //} ////ot process log //var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtDate.Text)); //var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtDate.Text)); //var ParamempID3 = new SqlParameter("@Edit_User", userId); //var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); //var ParamempID5 = new SqlParameter("@OCODE", OCODE); //string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; //_context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); //} ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true); grdview.DataSource = null; grdview.DataBind(); } else //update { foreach (var _HRM_OfficialDay_Individual in _context.HRM_OfficialDay_Individual.Where(x => x.EID == eid && x.Official_Date == workingDate)) { _HRM_OfficialDay_Individual.Working_Day = workingDay; _HRM_OfficialDay_Individual.OCode = OCODE; _HRM_OfficialDay_Individual.Edit_Date = EDIT_DATE; _HRM_OfficialDay_Individual.Edit_User = userId; lstHRM_OfficialDay_Individual.Add(_HRM_OfficialDay_Individual); } _context.SaveChanges(); //if (getAttendancedata.Count > 0) //{ //foreach (var aHRM_ATTENDANCE in _context.HRM_ATTENDANCE.Where(x => x.EID == eid && x.Attendance_Date == workingDate)) //{ // aHRM_ATTENDANCE.Update_Status = 0; // aHRM_ATTENDANCE.OCode = OCODE; // aHRM_ATTENDANCE.Edit_Date = EDIT_DATE; // aHRM_ATTENDANCE.Edit_User = userId; //} // _context.CommandTimeout = 1000; //_context.SaveChanges(); //HRM_ATTENDANCE aHRM_ATTENDANCE = new HRM_ATTENDANCE(); //DateTime date = Convert.ToDateTime(Attdate); //aHRM_ATTENDANCE = _context.HRM_ATTENDANCE.Where(c => c.EID == eid && c.Attendance_Date == date).First(); //aHRM_ATTENDANCE.Update_Status = 0; //aHRM_ATTENDANCE.OCode = OCODE; //aHRM_ATTENDANCE.Edit_Date = EDIT_DATE; //aHRM_ATTENDANCE.Edit_User = userId; //_context.SaveChanges(); // update attendnace status by date //aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //insert/update leave/holiday attendnace status process by selected eid //aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID2(lstHRM_OfficialDay_Individual, Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //ot process //List<string> ShiftCodes = objAtt_BLL.GetAllShiftCode(OCODE).ToList(); //foreach (string ashiftcode in ShiftCodes) //{ // objAtt_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text), ashiftcode); //} ////ot process log //var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtDate.Text)); //var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtDate.Text)); //var ParamempID3 = new SqlParameter("@Edit_User", userId); //var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); //var ParamempID5 = new SqlParameter("@OCODE", OCODE); //string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; //_context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); //} grdview.DataSource = null; grdview.DataBind(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); } } } //_context.SaveChanges(); ClearUI(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void btn_Confirm_Clcik(object sender, EventArgs e) { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; DateTime EDIT_DATE = DateTime.Now; Guid userId = ((SessionUser)Session["SessionUser"]).UserId; Attendance_BLL _attendancebll = new Attendance_BLL(); List <HRM_AttendanceReason_Individual> lstHRM_AttendanceReason_Individual = new List <HRM_AttendanceReason_Individual>(); if (chkIndividualShift.Checked) //individual process { for (int i = 0; i < Convert.ToInt16(hdfTotalDay.Value); i++) { if (txtbxEID.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Enter E-ID!')", true); return; } if (txtFromDate.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Attendance Date!')", true); return; } HRM_AttendanceReason_Individual _attendance = new HRM_AttendanceReason_Individual(); string shiftCode = hdShiftCode.Value; string EID = txtbxEID.Text; DateTime fromdate = Convert.ToDateTime(txtFromDate.Text); var getAttendancedata = aAttendance_BLL.GetAttendanceByEID_Date(OCODE, EID, Convert.ToDateTime(txtFromDate.Text)); List <HRM_AttendanceReason_Individual> a_HRM_AttendanceReason_Individual = aAttendance_BLL.GetHRM_AttendanceReason_Individual(EID, fromdate.AddDays(i)); if (a_HRM_AttendanceReason_Individual.Count == 0) //insert { _attendance.EID = txtbxEID.Text; _attendance.ReasonDate = fromdate.AddDays(i); _attendance.Remarks = txtbxremark.Text; _attendance.Status = "true"; _attendance.ShiftCode = shiftCode; _attendance.OCode = ((SessionUser)Session["SessionUser"]).OCode; _attendance.Edit_Date = DateTime.Now; _attendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; TimeSpan start_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttInTime.Hour, txtAttInTime.Minute, txtAttInTime.Second)); _attendance.InTime = start_time; TimeSpan end_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttOutTime.Hour, txtAttOutTime.Minute, txtAttOutTime.Second)); _attendance.OutTime = end_time; TimeSpan lateAllowed = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtLateAllowed.Hour, txtLateAllowed.Minute, txtLateAllowed.Second)); _attendance.LateAllowed = lateAllowed; TimeSpan totalHour, hour1, hour2; if (start_time > end_time) { hour1 = TimeSpan.Parse("23:59:59"); hour2 = Calculations.timeDiff(start_time, hour1); totalHour = hour2 + end_time; _attendance.Shift_TotalHour = totalHour; } else { totalHour = Calculations.timeDiff(start_time, end_time); _attendance.Shift_TotalHour = totalHour; } lstHRM_AttendanceReason_Individual.Add(_attendance); _context.HRM_AttendanceReason_Individual.AddObject(_attendance); try { _context.SaveChanges(); if (getAttendancedata.Count > 0) { aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); // update attendnace status by date // insert/update leave/holiday attendnace status process by selected eid aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID1(lstHRM_AttendanceReason_Individual, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); //ot process List <string> ShiftCodes = aAttendance_BLL.GetAllShiftCode(OCODE).ToList(); foreach (string ashiftcode in ShiftCodes) { aAttendance_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text), ashiftcode); } //ot process log var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtFromDate.Text)); var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtFromDate.Text)); var ParamempID3 = new SqlParameter("@Edit_User", userId); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; _context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); // } ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true); grdview.DataSource = null; grdview.DataBind(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } //ClearUI(); } else //update { DateTime iDate = fromdate.AddDays(i); foreach (var AttendanceReason in _context.HRM_AttendanceReason_Individual.Where(x => x.EID == EID && x.ReasonDate == iDate)) { //AttendanceReason.ReasonDate = Convert.ToDateTime(txtFromDate.Text); AttendanceReason.Remarks = txtbxremark.Text; AttendanceReason.Status = "true"; AttendanceReason.ShiftCode = shiftCode; AttendanceReason.OCode = ((SessionUser)Session["SessionUser"]).OCode; AttendanceReason.Edit_Date = DateTime.Now; AttendanceReason.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; TimeSpan start_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttInTime.Hour, txtAttInTime.Minute, txtAttInTime.Second)); AttendanceReason.InTime = start_time; TimeSpan end_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttOutTime.Hour, txtAttOutTime.Minute, txtAttOutTime.Second)); AttendanceReason.OutTime = end_time; TimeSpan lateAllowed = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtLateAllowed.Hour, txtLateAllowed.Minute, txtLateAllowed.Second)); _attendance.LateAllowed = lateAllowed; TimeSpan totalHour, hour1, hour2; if (start_time > end_time) { hour1 = TimeSpan.Parse("23:59:59"); hour2 = Calculations.timeDiff(start_time, hour1); totalHour = hour2 + end_time; AttendanceReason.Shift_TotalHour = totalHour; } else { totalHour = Calculations.timeDiff(start_time, end_time); AttendanceReason.Shift_TotalHour = totalHour; } lstHRM_AttendanceReason_Individual.Add(_attendance); } try { _context.SaveChanges(); if (getAttendancedata.Count > 0) { aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); // update attendnace status by date // insert/update leave/holiday attendnace status process by selected eid aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID1(lstHRM_AttendanceReason_Individual, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); //ot process List <string> ShiftCodes = aAttendance_BLL.GetAllShiftCode(OCODE).ToList(); foreach (string ashiftcode in ShiftCodes) { aAttendance_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text), ashiftcode); } //ot process log var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtFromDate.Text)); var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtFromDate.Text)); var ParamempID3 = new SqlParameter("@Edit_User", userId); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; _context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); // } ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true); grdview.DataSource = null; grdview.DataBind(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } } } ClearUI(); } else // dept/section/subsection wise process { if (grdview.Rows.Count < 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true); return; } foreach (GridViewRow gvRow in grdview.Rows) { for (int i = 0; i < Convert.ToInt16(hdfTotalDay.Value); i++) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); HRM_AttendanceReason_Individual _attendance = new HRM_AttendanceReason_Individual(); Label lblEID = ((Label)gvRow.FindControl("lblEID")); Label lblShiftCode = ((Label)gvRow.FindControl("lblShiftCode")); string shiftCode = lblShiftCode.Text; string EID = lblEID.Text; DateTime fromdate = Convert.ToDateTime(txtFromDate.Text); List <HRM_AttendanceReason_Individual> a_HRM_AttendanceReason_Individual = aAttendance_BLL.GetHRM_AttendanceReason_Individual(EID, fromdate.AddDays(i)); //var getAttendancedata = aAttendance_BLL.GetAttendanceByEID_Date(OCODE, EID, fromdate); if (rowChkBox.Checked == true) { if (a_HRM_AttendanceReason_Individual.Count == 0) //insert { _attendance.EID = lblEID.Text; _attendance.ReasonDate = fromdate.AddDays(i); _attendance.Remarks = txtbxremark.Text; _attendance.Status = "true"; _attendance.ShiftCode = shiftCode; _attendance.OCode = ((SessionUser)Session["SessionUser"]).OCode; _attendance.Edit_Date = DateTime.Now; _attendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; TimeSpan start_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttInTime.Hour, txtAttInTime.Minute, txtAttInTime.Second)); _attendance.InTime = start_time; TimeSpan end_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttOutTime.Hour, txtAttOutTime.Minute, txtAttOutTime.Second)); _attendance.OutTime = end_time; TimeSpan lateAllowed = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtLateAllowed.Hour, txtLateAllowed.Minute, txtLateAllowed.Second)); _attendance.LateAllowed = lateAllowed; TimeSpan totalHour, hour1, hour2; if (start_time > end_time) { hour1 = TimeSpan.Parse("23:59:59"); hour2 = Calculations.timeDiff(start_time, hour1); totalHour = hour2 + end_time; _attendance.Shift_TotalHour = totalHour; } else { totalHour = Calculations.timeDiff(start_time, end_time); _attendance.Shift_TotalHour = totalHour; } lstHRM_AttendanceReason_Individual.Add(_attendance); _context.HRM_AttendanceReason_Individual.AddObject(_attendance); //insert try { _context.SaveChanges(); //if (getAttendancedata.Count > 0) //{ //aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); // update attendnace status by date // insert/update leave/holiday attendnace status process by selected eid //aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID1(lstHRM_AttendanceReason_Individual, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); //ot process //List<string> ShiftCodes = aAttendance_BLL.GetAllShiftCode(OCODE).ToList(); //foreach (string ashiftcode in ShiftCodes) //{ // aAttendance_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text), ashiftcode); //} ////ot process log //var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtFromDate.Text)); //var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtFromDate.Text)); //var ParamempID3 = new SqlParameter("@Edit_User", userId); //var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); //var ParamempID5 = new SqlParameter("@OCODE", OCODE); //string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; //_context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); // //} ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true); grdview.DataSource = null; grdview.DataBind(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } } else //update { DateTime iDate = fromdate.AddDays(i); foreach (var AttendanceReason in _context.HRM_AttendanceReason_Individual.Where(x => x.EID == EID && x.ReasonDate == iDate)) { AttendanceReason.Remarks = txtbxremark.Text; AttendanceReason.Status = "true"; AttendanceReason.ShiftCode = shiftCode; AttendanceReason.OCode = ((SessionUser)Session["SessionUser"]).OCode; AttendanceReason.Edit_Date = DateTime.Now; AttendanceReason.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; TimeSpan start_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttInTime.Hour, txtAttInTime.Minute, txtAttInTime.Second)); AttendanceReason.InTime = start_time; TimeSpan end_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttOutTime.Hour, txtAttOutTime.Minute, txtAttOutTime.Second)); AttendanceReason.OutTime = end_time; TimeSpan lateAllowed = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtLateAllowed.Hour, txtLateAllowed.Minute, txtLateAllowed.Second)); _attendance.LateAllowed = lateAllowed; TimeSpan totalHour, hour1, hour2; if (start_time > end_time) { hour1 = TimeSpan.Parse("23:59:59"); hour2 = Calculations.timeDiff(start_time, hour1); totalHour = hour2 + end_time; AttendanceReason.Shift_TotalHour = totalHour; } else { totalHour = Calculations.timeDiff(start_time, end_time); AttendanceReason.Shift_TotalHour = totalHour; } lstHRM_AttendanceReason_Individual.Add(AttendanceReason); } try { _context.SaveChanges(); //update //if (getAttendancedata.Count > 0) //{ //aAttendance_RPT_Bll.UpdateAll_AttStatus_ByDate(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); // update attendnace status by date // insert/update leave/holiday attendnace status process by selected eid //aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID1(lstHRM_AttendanceReason_Individual, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text)); //ot process //List<string> ShiftCodes = aAttendance_BLL.GetAllShiftCode(OCODE).ToList(); //foreach (string ashiftcode in ShiftCodes) //{ // aAttendance_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtFromDate.Text), ashiftcode); //} ////ot process log //var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(txtFromDate.Text)); //var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(txtFromDate.Text)); //var ParamempID3 = new SqlParameter("@Edit_User", userId); //var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); //var ParamempID5 = new SqlParameter("@OCODE", OCODE); //string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; //_context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); // //} ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true); grdview.DataSource = null; grdview.DataBind(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } } } } } ClearUI(); } } catch (Exception ex) { string EID = Convert.ToString(((SessionUser)Session["SessionUser"]).EID); // LogController<ExtraShiftEmployeewise>.SetLog(ex, EID); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }