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); } }