internal int UpdateAttReasonIndividual(HRM_AttendanceReason_Individual objAttendanceReasonIndividual, int Id) { try { HRM_AttendanceReason_Individual objAttReasonInd = _context.HRM_AttendanceReason_Individual.First(x => x.Ind_ReasonId == Id); objAttReasonInd.EmpId = objAttendanceReasonIndividual.EmpId; objAttReasonInd.EID = objAttendanceReasonIndividual.EID; objAttReasonInd.Bio_MatrixId = objAttendanceReasonIndividual.Bio_MatrixId; objAttReasonInd.RegionId = objAttendanceReasonIndividual.RegionId; objAttReasonInd.OfficeId = objAttendanceReasonIndividual.OfficeId; objAttReasonInd.DepartmentId = objAttendanceReasonIndividual.DepartmentId; objAttReasonInd.ShiftCode = objAttendanceReasonIndividual.ShiftCode; objAttReasonInd.ShiftName = objAttendanceReasonIndividual.ShiftName; objAttReasonInd.ReasonDate = objAttendanceReasonIndividual.ReasonDate; objAttReasonInd.InTime = objAttendanceReasonIndividual.InTime; objAttReasonInd.OutTime = objAttendanceReasonIndividual.OutTime; objAttReasonInd.ReasonTypeId = objAttendanceReasonIndividual.ReasonTypeId; objAttReasonInd.ReasonType = objAttendanceReasonIndividual.ReasonType; objAttReasonInd.Remarks = objAttendanceReasonIndividual.Remarks; objAttReasonInd.Edit_User = objAttendanceReasonIndividual.Edit_User; objAttReasonInd.Edit_Date = objAttendanceReasonIndividual.Edit_Date; objAttReasonInd.OCode = objAttendanceReasonIndividual.OCode; objAttReasonInd.Shift_TotalHour = objAttendanceReasonIndividual.Shift_TotalHour; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
//-------Insert HRM_AttendanceReason_Individual------------------------------------ public int InsertAttendanceReasonIndividual(HRM_AttendanceReason_Individual objAttendanceReasonIndividual) { try { _context.HRM_AttendanceReason_Individual.AddObject(objAttendanceReasonIndividual); _context.SaveChanges(); return(1); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
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); } }
protected void btnSaveByDepartment_Click(object sender, EventArgs e) { try { HRM_TimeScheduleByReligion objattendanceReason = new HRM_TimeScheduleByReligion(); objattendanceReason.RegionId = Convert.ToInt32(ddlRegion.SelectedValue); objattendanceReason.OfficeId = Convert.ToInt32(ddlOffice.SelectedValue); objattendanceReason.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue); //objattendanceReason.Religion = ddlReligion.Text; objattendanceReason.Date = Convert.ToDateTime(txtDate.Text); objattendanceReason.ReasonType = ddlReasonType.Text; objattendanceReason.Remarks = ddlReasonType.SelectedItem.Text + " : " + txtRemarks.Text; TimeSpan in_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtStartTime.Hour, txtStartTime.Minute, txtStartTime.Second)); objattendanceReason.InTime = in_time; TimeSpan out_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtEndTime.Hour, txtEndTime.Minute, txtEndTime.Second)); objattendanceReason.OutTime = out_time; objattendanceReason.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; objattendanceReason.Edit_Date = DateTime.Now; objattendanceReason.OCode = ((SessionUser)Session["SessionUser"]).OCode; if (in_time > out_time) { //lblMessage.Text = "<font color='red'>Out Time can't be less than In Time</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Out Time can't be less than In Time')", true); return; } int Count = (from shift in _context.HRM_TimeScheduleByReligion where shift.RegionId == objattendanceReason.RegionId && shift.OfficeId == objattendanceReason.OfficeId && shift.DepartmentId == objattendanceReason.DepartmentId && shift.Date == objattendanceReason.Date select shift.ReligionSechedule_Id).Count(); if (Count != 0) { // lblMessage.Text = "Data Already Exists!"; //lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exists!')", true); return; } objAttendanceReasonBll.InsertTimeScheduleByReligion(objattendanceReason); HRM_AttendanceReason_Individual attendanceReasonInd = new HRM_AttendanceReason_Individual(); attendanceReasonInd.RegionId = Convert.ToInt32(ddlRegion.SelectedValue); attendanceReasonInd.OfficeId = Convert.ToInt32(ddlOffice.SelectedValue); attendanceReasonInd.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue); attendanceReasonInd.ReasonDate = Convert.ToDateTime(txtDate.Text); attendanceReasonInd.ReasonTypeId = Convert.ToInt32(ddlReasonType.SelectedValue); attendanceReasonInd.ReasonType = ddlReasonType.SelectedItem.Text; attendanceReasonInd.Remarks = ddlReasonType.SelectedItem.Text + " : " + txtRemarks.Text; attendanceReasonInd.InTime = in_time; attendanceReasonInd.OutTime = out_time; attendanceReasonInd.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; attendanceReasonInd.Edit_Date = DateTime.Now; attendanceReasonInd.OCode = ((SessionUser)Session["SessionUser"]).OCode; if (in_time > out_time) { //lblMessage.Text = "<font color='red'>Out Time can't be less than In Time</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Out Time can't be less than In Time')", true); return; } var result = objAttendanceReasonBll.InsertAtt_ReasonIndByDepartment(Convert.ToInt32(ddlRegion.SelectedValue), Convert.ToInt32(ddlOffice.SelectedValue), Convert.ToInt32(ddlDepartment.SelectedValue), Convert.ToDateTime(txtDate.Text), in_time, out_time, Convert.ToInt32(ddlReasonType.SelectedValue), ddlReasonType.SelectedItem.Text, ddlReasonType.SelectedItem.Text + " : " + txtRemarks.Text, ((SessionUser)Session["SessionUser"]).UserId, DateTime.Now, ((SessionUser)Session["SessionUser"]).OCode); if (result == 1) { // lblMessage.Text = "Data Added successfully!"; //lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Added successfully!')", true); reset(); BindGridAttendance(); } else { //lblMessage.Text = "Data Adding failure!"; //lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Adding failure!')", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string at_status = ""; HRM_AttendanceReason_Individual objattendanceReasonIndividual = new HRM_AttendanceReason_Individual(); objattendanceReasonIndividual.EmpId = Convert.ToInt64(lblHiddenId.Text); objattendanceReasonIndividual.EID = txtEid_AT.Text; objattendanceReasonIndividual.Bio_MatrixId = lblBioId.Text; objattendanceReasonIndividual.RegionId = Convert.ToInt32(lblRegionId.Text); objattendanceReasonIndividual.OfficeId = Convert.ToInt32(lblOfficeId.Text); objattendanceReasonIndividual.DepartmentId = Convert.ToInt32(lblDeparmentId.Text); objattendanceReasonIndividual.ShiftCode = txtShiftCode.Text; objattendanceReasonIndividual.ShiftName = txtShift.Text; objattendanceReasonIndividual.ReasonDate = Convert.ToDateTime(txtDate.Text); objattendanceReasonIndividual.ReasonTypeId = Convert.ToInt32(ddlReasonType.SelectedValue); objattendanceReasonIndividual.ReasonType = ddlReasonType.SelectedItem.Text; objattendanceReasonIndividual.Remarks = "General : " + txtRemarks.Text; //objattendanceReasonIndividual.InTime = (txtStartTime.Hour + ":" + txtStartTime.Minute + ":" + txtStartTime.Second + " " + txtStartTime.AmPm); //objattendanceReasonIndividual.OutTime = (txtEndTime.Hour + ":" + txtEndTime.Minute + ":" + txtEndTime.Second + " " + txtEndTime.AmPm); TimeSpan in_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtStartTime.Hour, txtStartTime.Minute, txtStartTime.Second)); objattendanceReasonIndividual.InTime = in_time; TimeSpan out_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtEndTime.Hour, txtEndTime.Minute, txtEndTime.Second)); objattendanceReasonIndividual.OutTime = out_time; if (rdbPresent.Checked == true) { at_status = "P"; } if (rdbLate.Checked == true) { at_status = "L"; } //if (rdbOverLate.Checked == true) //{ // at_status = "OL"; //} if (rdbAbsent.Checked == true) { at_status = "A"; } objattendanceReasonIndividual.Status = at_status; objattendanceReasonIndividual.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; objattendanceReasonIndividual.Edit_Date = DateTime.Now; objattendanceReasonIndividual.OCode = ((SessionUser)Session["SessionUser"]).OCode; //if (in_time > out_time) //{ // lblMessage.Text = "<font color='red'>Out Time can't be less than In Time</font>"; // return; //} if (BtnSave.Text == "Save") { int result = objAttendanceReasonBll.InsertAttendanceReasonIndividual(objattendanceReasonIndividual); if (result == 1) { //lblMessage.Text = "Record Added successfully!"; //lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Added successfully!')", true); reset(); BindGridAttendance(); } else { //lblMessage.Text = "Record Adding Failure!"; //lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Adding Failure!')", true); } } else { int attReasonIndId = Convert.ToInt16(hiddenId.Value); int result = objAttendanceReasonBll.UpdateAttReasonIndividual(objattendanceReasonIndividual, attReasonIndId); //HRM_ATTENDANCE aHRM_ATTENDANCE = objAtt_BLL.GetAllAttendanceData(Convert.ToDateTime(txtDate.Text), txtEid_AT.Text); if (result == 1) { //lblMessage.Text = "Record Updated Successfully"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Updated Successfully')", true); reset(); BindGridAttendance(); } else { // lblMessage.Text = "Record Updating Failure!"; //lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Updating Failure!')", true); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
public int UpdateAttReasonIndividual(HRM_AttendanceReason_Individual objAttendanceReasonInd, int id) { return(objCtx_DAL.UpdateAttReasonIndividual(objAttendanceReasonInd, id)); }
//-------Insert HRM_AttendanceReason_Individual------------------------------------ public int InsertAttendanceReasonIndividual(HRM_AttendanceReason_Individual objAttendanceReasonIndividual) { return(objCtx_DAL.InsertAttendanceReasonIndividual(objAttendanceReasonIndividual)); }