protected void btn_Confirm_Clcik(object sender, EventArgs e)
{
try
{
Attendance_BLL _attendancebll = new Attendance_BLL();
List <HRM_ATTENDANCE> lstHRM_ATTENDANCE = new List <HRM_ATTENDANCE>();
foreach (GridViewRow gvRow in grdview.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_ATTENDANCE _attendance = new HRM_ATTENDANCE();
if (rowChkBox.Checked == true)
{
Label lblEID = ((Label)gvRow.FindControl("lblEID"));
Label lblWorkingDay = ((Label)gvRow.FindControl("lblWorkingDay"));
Label lblAttendanceDate = ((Label)gvRow.FindControl("lblAttendanceDate"));
TextBox txtbxInTime = ((TextBox)gvRow.FindControl("txtbxIntime"));
TextBox txtbxOutTIme = ((TextBox)gvRow.FindControl("txtbxOuttime"));
_attendance.EID = lblEID.Text;
_attendance.Attendance_Date = Convert.ToDateTime(lblAttendanceDate.Text);
_attendance.In_Time = TimeSpan.Parse(txtbxInTime.Text);
_attendance.Out_Time = TimeSpan.Parse(txtbxOutTIme.Text);
_attendance.Remarks = txtbxremark.Text;
_attendance.Attendance_Process_Status = true;
_attendance.OCode = ((SessionUser)Session["SessionUser"]).OCode;
_attendance.Edit_Date = DateTime.Now;
_attendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
lstHRM_ATTENDANCE.Add(_attendance);
}
}
if (lstHRM_ATTENDANCE.Count > 0)
{
var result = _attendancebll.Update_IndividualAttendance(lstHRM_ATTENDANCE);
if (result != null)
{
ClearUI();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int DeleteAttendanceByLeaveDate(List <HRM_LeaveApply> leaveApplyesDates)
{
DeleteAttendenceByCode(leaveApplyesDates);
foreach (HRM_LeaveApply aitem in leaveApplyesDates)
{
var attendance = _context.HRM_ATTENDANCE.Where(a => a.Attendance_Date == aitem.LeaveDates && a.EID == aitem.Eid).FirstOrDefault();
if (attendance != null)
{
attendance.In_Time = null;
attendance.Out_Time = null;
attendance.InTime = null;
attendance.OutTime = null;
attendance.Late_Time = null;
attendance.Over_Time = null;
attendance.OT_Total = 0;
attendance.Status = _context.HRM_LEAVE_TYPE.FirstOrDefault(a => a.LEV_ID == aitem.LeaveTypeId).LEV_TYPE;
attendance.Update_Status = 1;
attendance.Attendance_Process_Status = false;
attendance.OCode = aitem.OCODE;
attendance.Edit_User = aitem.EDIT_USER;
attendance.Edit_Date = aitem.EDIT_DATE;
attendance.Attendance_Date = aitem.LeaveDates;
attendance.Leave_Code = aitem.LeaveCode;
attendance.Attendance_Day = Convert.ToDateTime(aitem.LeaveDates).DayOfWeek.ToString();
_context.SaveChanges();
}
else
{
HRM_ATTENDANCE _attendance = new HRM_ATTENDANCE();
_attendance.EID = aitem.Eid;
_attendance.ShiftCode = _context.HRM_PersonalInformations.FirstOrDefault(a => a.EID == aitem.Eid).ShiftCode;
_attendance.In_Time = null;
_attendance.Out_Time = null;
_attendance.InTime = null;
_attendance.OutTime = null;
_attendance.Late_Time = null;
_attendance.Over_Time = null;
_attendance.OT_Total = 0;
_attendance.Status = _context.HRM_LEAVE_TYPE.FirstOrDefault(a => a.LEV_ID == aitem.LeaveTypeId).LEV_TYPE;
_attendance.Update_Status = 1;
_attendance.Attendance_Process_Status = false;
_attendance.OCode = aitem.OCODE;
_attendance.Edit_User = aitem.EDIT_USER;
_attendance.Edit_Date = aitem.EDIT_DATE;
_attendance.Attendance_Date = aitem.LeaveDates;
_attendance.Leave_Code = aitem.LeaveCode;
_attendance.Attendance_Day = Convert.ToDateTime(aitem.LeaveDates).DayOfWeek.ToString();
_context.HRM_ATTENDANCE.AddObject(_attendance);
_context.SaveChanges();
}
}
return(1);
}
protected void btnProcess_Click(object sender, EventArgs e)
{
try
{
string OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
HRM_OfficialDay_Individual OfficialDayIndvidual = new HRM_OfficialDay_Individual();
OfficialDayIndvidual.Official_Date = Convert.ToDateTime(txtDate.Text);
OfficialDayIndvidual.Working_Day = ddlday.Text;
OfficialDayIndvidual.OT_Applicable = Convert.ToBoolean(ddlOT.SelectedValue);
OfficialDayIndvidual.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
OfficialDayIndvidual.Edit_Date = DateTime.Now;
OfficialDayIndvidual.OCode = OCODE;
OfficialDayIndvidual.EID = txtEid_TRNS.Text;
var result = objAtt_BLL.GetAllOfficeDayById(OCODE, txtEid_TRNS.Text, Convert.ToDateTime(txtDate.Text));
if (result.Count > 0)
{
objAtt_BLL.UpdateOffialTypeById(OfficialDayIndvidual, Convert.ToDateTime(txtDate.Text), txtEid_TRNS.Text); //update working day
}
else
{
objAtt_BLL.InsertOfficeTypeIndividual(OfficialDayIndvidual);
}
HRM_ATTENDANCE attendanceDay = new HRM_ATTENDANCE();
attendanceDay.Working_Day = ddlday.Text;
var result1 = objAtt_BLL.UpdateAtt_WorkingDayById(OCODE, txtEid_TRNS.Text, txtDate.Text, ddlday.Text);
if (result1 == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true);
//lblMessage.Text = "Data Update successfully!";
//lblMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updating Error!')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnAttSubmit_Click(object sender, EventArgs e)
{
try
{
string at_status = "";
bool ot_status;
HRM_ATTENDANCE objAttendance = new HRM_ATTENDANCE();
objAttendance.EmpId = Convert.ToInt64(lblHiddenId.Text);
objAttendance.EID = txtEid_AT.Text;
objAttendance.ShiftCode = lblShiftCode.Text;
objAttendance.Attendance_Date = Convert.ToDateTime(txtAttDate.Text);
objAttendance.Attendance_Day = Convert.ToDateTime(txtAttDate.Text).DayOfWeek.ToString();
objAttendance.Working_Day = ddlWorkingDay.Text;
objAttendance.OT_Compliance = 0;
objAttendance.Update_Status = 0;
TimeSpan in_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttInTime.Hour, txtAttInTime.Minute, txtAttInTime.Second));
objAttendance.In_Time = in_time;
TimeSpan out_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttOutTime.Hour, txtAttOutTime.Minute, txtAttOutTime.Second));
objAttendance.Out_Time = out_time;
TimeSpan workedTime = Calculations.timeDiff(in_time, out_time);
TimeSpan overTime = TimeSpan.Parse("00:00:00");
TimeSpan originalTime = TimeSpan.Parse("09:00:00");
if (originalTime < in_time)
{
TimeSpan late_time = Calculations.timeDiff(originalTime, in_time);
objAttendance.Late_Time = late_time;
}
else
{
objAttendance.Late_Time = TimeSpan.Parse("00:00:00");
}
if (overTime == TimeSpan.Parse("00:00:00"))
{
ot_status = false;
}
else
{
ot_status = true;
}
objAttendance.Worked_Time = workedTime;
objAttendance.Shift_TotalHour = shifted_TotalHour;
objAttendance.Over_Time = overTime;
objAttendance.OT_Hour = 0;
objAttendance.OT_Minute = 0;
objAttendance.OT_Total = 0;
objAttendance.OT_ExtraAdd = 0;
objAttendance.OT_Deduction = 0;
objAttendance.OT_Status = ot_status;
if (rdbPresent.Checked == true)
{
at_status = "P";
}
if (rdbLate.Checked == true)
{
at_status = "L";
}
if (rdbAbsent.Checked == true)
{
at_status = "A";
}
objAttendance.Status = at_status;
//objAttendance.Remarks = "Manual Attendance:" + txtRemarks_AT.Text;
objAttendance.Remarks = txtRemarks_AT.Text;
//obj.EDIT_USER = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
objAttendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
objAttendance.Edit_Date = DateTime.Now;
objAttendance.OCode = ((SessionUser)Session["SessionUser"]).OCode;
int AttendanceCount = (from att in _context.HRM_ATTENDANCE
where att.EID == objAttendance.EID && att.Attendance_Date == objAttendance.Attendance_Date
select att.ATTE_ID).Count();
if (AttendanceCount == 0)
{
int result = objAtt_BLL.InsertAttendance(objAttendance);
if (result == 1)
{
//lblMessege.Text = "Attendance Recorded successfully!";
//lblMessege.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Attendance Recorded Successfully')", true);
var employeeId = txtEid_AT.Text.ToString();
BindGridEmployeeAttendanceById(employeeId);
reset();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Attendance Recording failure!')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Attendance Already Recorded in this day for this Employee!')", true);
}
}
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
{
UserDAL userDAl = new UserDAL();
Attendance_BLL _attendancebll = new Attendance_BLL();
List <HRM_ATTENDANCE> attendances = new List <HRM_ATTENDANCE>();
if (ckIndividualPunishment.Checked) //individual process
{
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 Attendance Date!')", true);
return;
}
HRM_ATTENDANCE _attendance = new HRM_ATTENDANCE();
_attendance.EID = txtbxEID.Text;
_attendance.Attendance_Date = Convert.ToDateTime(txtDate.Text);
_attendance.Remarks = txtbxremark.Text;
_attendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
_attendance.Edit_Date = DateTime.Now;
_attendance.OCode = ((SessionUser)Session["SessionUser"]).OCode;
attendances.Add(_attendance);
if (attendances.Count > 0)
{
List <HRM_EMPLOYEES_VIEWER> lstEmpAttendnace = _attendancebll.GetEmployeesByEidForAttendance(txtbxEID.Text, Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text)); //check attendance data
if (lstEmpAttendnace.Count > 0)
{
Guid UserID = ((SessionUser)Session["SessionUser"]).UserId;
string PunishedBy = userDAl.getEIDbyUserGuidID(UserID);
int result = _attendancebll.AttendanceAdjustment(attendances, PunishedBy);
if (result == 1)
{
// insert/update leave/holiday attendnace status process by selected eid
aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID(attendances, Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text));
ClearUI();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Attendance Punishment Successfull')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Attendance Data Found!')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true);
}
}
else
{
foreach (GridViewRow gvRow in grdview.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_ATTENDANCE _attendance = new HRM_ATTENDANCE();
if (rowChkBox.Checked == true)
{
Label lblEID = ((Label)gvRow.FindControl("lblEID"));
TextBox txtbx = ((TextBox)gvRow.FindControl("txtbx"));
_attendance.EID = lblEID.Text;
_attendance.Attendance_Date = Convert.ToDateTime(txtDate.Text);
_attendance.Remarks = txtbxremark.Text;
_attendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
_attendance.Edit_Date = DateTime.Now;
_attendance.OCode = ((SessionUser)Session["SessionUser"]).OCode;
attendances.Add(_attendance);
}
}
if (attendances.Count > 0)
{
Guid UserID = ((SessionUser)Session["SessionUser"]).UserId;
string PunishedBy = userDAl.getEIDbyUserGuidID(UserID);
int result = _attendancebll.AttendanceAdjustment(attendances, PunishedBy);
if (result == 1)
{
// insert/update leave/holiday attendnace status process by selected eid
aAttendance_RPT_Bll.Insert_Update_AbsentLeaveStatus_ByDate_EID(attendances, Convert.ToDateTime(txtDate.Text), Convert.ToDateTime(txtDate.Text));
ClearUI();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Attendance Punishment Successfull')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btn_Confirm_Clcik(object sender, EventArgs e)
{
try
{
Attendance_BLL _attendancebll = new Attendance_BLL();
List <HRM_ATTENDANCE> attendances = new List <HRM_ATTENDANCE>();
foreach (GridViewRow gvRow in grdview.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_ATTENDANCE _attendance = new HRM_ATTENDANCE();
if (rowChkBox.Checked == true)
{
Label lblEID = ((Label)gvRow.FindControl("lblEID"));
Label lblWorkingDay = ((Label)gvRow.FindControl("lblWorkingDay"));
TextBox txtbx = ((TextBox)gvRow.FindControl("txtbx"));
if (drpEntryType.SelectedValue == "In-Time")
{
_attendance.In_Time = TimeSpan.Parse(txtbx.Text);
_attendance.Out_Time = TimeSpan.Parse(txtbx.Text);
}
else
{
_attendance.In_Time = TimeSpan.Parse(txtbx.Text);
_attendance.Out_Time = TimeSpan.Parse(txtbx.Text);
}
_attendance.EID = lblEID.Text;
_attendance.Attendance_Date = Convert.ToDateTime(txtDate.Text);
_attendance.Attendance_Day = Convert.ToDateTime(txtDate.Text).DayOfWeek.ToString();
_attendance.Working_Day = lblWorkingDay.Text;
_attendance.Remarks = txtbxremark.Text;
_attendance.Attendance_Process_Status = true;
_attendance.OCode = ((SessionUser)Session["SessionUser"]).OCode;
_attendance.Edit_Date = DateTime.Now;
_attendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
attendances.Add(_attendance);
}
}
if (attendances.Count > 0)
{
string type = drpEntryType.SelectedValue.ToString();
int result = _attendancebll.UpdateAttendance(attendances, type);
if (result == 1)
{
ClearUI();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnAttSubmit_Click(object sender, EventArgs e)
{
try
{
Attendance_BLL _attendancebll = new Attendance_BLL();
List <HRM_ATTENDANCE> attendances = new List <HRM_ATTENDANCE>();
foreach (GridViewRow gvRow in GridViewEMP_AT.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_ATTENDANCE obj = new HRM_ATTENDANCE();
if (rowChkBox.Checked == true)
{
Label lblId = ((Label)gvRow.FindControl("lblId"));
TextBox txtbxExtraOtAdd = ((TextBox)gvRow.FindControl("OTExtraAdd"));
Label lblAttnDate = ((Label)gvRow.FindControl("lblAttnDate"));
//Label lbltotalot = ((Label)gvRow.FindControl("lbltotalot"));
//double totalOT = Convert.ToDouble(lbltotalot.Text);
DateTime otDate = Convert.ToDateTime(lblAttnDate.Text);
obj.ATTE_ID = Convert.ToInt32(lblId.Text);
int AttId = Convert.ToInt32(obj.ATTE_ID);
if (rdExtraOT.Checked)
{
obj.OT_ExtraAdd = Convert.ToInt32(txtbxExtraOtAdd.Text);
// obj.OT_Total = totalOT + Convert.ToDouble(txtbxExtraOtAdd.Text);
}
else if (rdExtraOTDeduct.Checked)
{
obj.OT_Deduction = Convert.ToInt32(txtbxExtraOtAdd.Text);
// obj.OT_Total = totalOT - Convert.ToDouble(txtbxExtraOtAdd.Text);
}
obj.OCode = ((SessionUser)Session["SessionUser"]).OCode;
obj.Edit_Date = DateTime.Now;
obj.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
var result = objAtt_BLL.UpdateAttendanceOT(obj, AttId);
if (result == 1)
{
//ot process
string OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
string userId = Convert.ToString(((SessionUser)Session["SessionUser"]).UserId);
objAtt_BLL.UpdateOT_ByShift_EID(otDate, otDate, hdnEmployeeShiftCode.Value, txtEid_AT.Text);
//ot process log
var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(otDate));
var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(otDate));
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 Update Successfully.')", true);
// load grid
DateTime fromdate = Convert.ToDateTime(txtfromDate.Text);
DateTime toDate = Convert.ToDateTime(txtToDate.Text);
var row = objAtt_BLL.GetAttendanceByEID(txtEid_AT.Text).Where(x => x.Attendance_Date >= fromdate && x.Attendance_Date <= toDate).ToList();
if (row.Count > 0)
{
GridViewEMP_AT.DataSource = row.ToList();
GridViewEMP_AT.DataBind();
}
else
{
GridViewEMP_AT.DataSource = null;
GridViewEMP_AT.DataBind();
}
///
}
}
}
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateAttendanceOT(HRM_ATTENDANCE objAttendance, int attId)
{
return(objCtx_DAL.UpdateAttendanceOT(attId, objAttendance));
}
internal int InsertAtt_MachineProblem(HRM_ATTENDANCE objAttendance)
{
return(objCtx_DAL.InsertAtt_MachineProblem(objAttendance));
}
//-------Insert------------------------------------
public int InsertAttendance(HRM_ATTENDANCE objAtt)
{
return(objCtx_DAL.InsertAttendance(objAtt));
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
HRM_MachineReadableProblem objmachineProblem = new HRM_MachineReadableProblem();
objmachineProblem.RegionId = Convert.ToInt32(lblRegionId.Text);
objmachineProblem.OfficeId = Convert.ToInt32(lblOfficeId.Text);
objmachineProblem.ShiftCode = ddlShiftCode.SelectedValue;
objmachineProblem.ShiftName = ddlShiftCode.SelectedItem.Text;
objmachineProblem.Att_Date = Convert.ToDateTime(txtDate.Text);
objmachineProblem.Att_Day = Convert.ToDateTime(txtDate.Text).DayOfWeek.ToString();
objmachineProblem.Working_Day = ddlWorkingDay.Text;
objmachineProblem.Remarks = txtRemarks.Text;
TimeSpan in_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtStartTime.Hour, txtStartTime.Minute, txtStartTime.Second));
objmachineProblem.InTime = in_time;
TimeSpan out_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtEndTime.Hour, txtEndTime.Minute, txtEndTime.Second));
objmachineProblem.OutTime = out_time;
objmachineProblem.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
objmachineProblem.Edit_Date = DateTime.Now;
objmachineProblem.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;
}
objAttendanceBll.InsertMachineProblem(objmachineProblem);
HRM_ATTENDANCE objAttendance = new HRM_ATTENDANCE();
objAttendance.ShiftCode = ddlShiftCode.SelectedValue;
objAttendance.Attendance_Date = Convert.ToDateTime(txtDate.Text);
objAttendance.Attendance_Day = Convert.ToDateTime(txtDate.Text).DayOfWeek.ToString();
objAttendance.Working_Day = ddlWorkingDay.Text;
objAttendance.Remarks = txtRemarks.Text;
objAttendance.In_Time = in_time;
objAttendance.Out_Time = out_time;
objAttendance.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
objAttendance.Edit_Date = DateTime.Now;
objAttendance.OCode = ((SessionUser)Session["SessionUser"]).OCode;
var result = objAttendanceBll.InsertAtt_MachineProblem(objAttendance);
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();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btn_Confirm_Clcik(object sender, EventArgs e)
{
try
{
UserDAL userDAl = new UserDAL();
Attendance_BLL _attendancebll = new Attendance_BLL();
List <HRM_ATTENDANCE> attendances = new List <HRM_ATTENDANCE>();
//string[] plussign = txtbxOtHour.Text.Split('+');
//string[] Minsign = txtbxOtHour.Text.Split('-');
//string psign = plussign[0].ToString();
//string misign = Minsign[0].ToString();
//string plussign = txtbxOtHour.Text.ToString();
//string[] values = plussign.Split('+');
//string psign = values[1].ToString();
//string Minsign = txtbxOtHour.Text.ToString();
//string[] values1 = Minsign.Split('-');
//string misign = values1[1].ToString();
//string sign = txtbxOtHour.Text.ToString();
string sign = txtbxOtHour.Text.Substring(0, 1);
if (sign == "+" || sign == "-")
{
//CheckBox headerChkBox = ((CheckBox)grdview.HeaderRow.FindControl("headerLevelCheckBox"));
//if (headerChkBox.Checked == true)
//{
// foreach (GridViewRow gvRow in grdview.Rows)
// {
// HRM_ATTENDANCE _attendance = new HRM_ATTENDANCE();
// CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
// Label lblEID = ((Label)gvRow.FindControl("lblEID"));
// TextBox txtbx = ((TextBox)gvRow.FindControl("txtbx"));
// _attendance.EID = lblEID.Text;
// _attendance.Remarks = txtbxremark.Text;
// _attendance.Attendance_Date = Convert.ToDateTime(txtDate.Text);
// attendances.Add(_attendance);
// }
//}
//else
//{
foreach (GridViewRow gvRow in grdview.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_ATTENDANCE _attendance = new HRM_ATTENDANCE();
if (rowChkBox.Checked == true)
{
Label lblEID = ((Label)gvRow.FindControl("lblEID"));
TextBox txtbx = ((TextBox)gvRow.FindControl("txtbx"));
_attendance.EID = lblEID.Text;
_attendance.Attendance_Date = Convert.ToDateTime(txtDate.Text);
_attendance.Remarks = txtbxremark.Text;
attendances.Add(_attendance);
}
}
//}
string OThour = Convert.ToString(txtbxOtHour.Text.Trim());
Guid UserID = ((SessionUser)Session["SessionUser"]).UserId;
string apprvedBy = userDAl.getEIDbyUserGuidID(UserID);
int result = _attendancebll.ManualOTUpdate(attendances, apprvedBy, OThour);
if (result == 1)
{
ClearUI();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully.')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Use + or - Sign Before Number')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnAttSubmit_Click(object sender, EventArgs e)
{
try
{
using (ERPSSLHBEntities _context = new ERPSSLHBEntities())
{
string at_status = "";
//bool ot_status;
HRM_ATTENDANCE obj = new HRM_ATTENDANCE();
//obj.EmpId = Convert.ToInt64(lblHiddenId.Text);
//obj.EID = txtEid_AT.Text;
//obj.ShiftCode = lblShiftCode.Text;
//obj.Attendance_Date = Convert.ToDateTime(txtAttDate.Text);
//obj.Attendance_Day = Convert.ToDateTime(txtAttDate.Text).DayOfWeek.ToString();
//obj.Working_Day = ddlWorkingDay.Text;
//obj.OT_Compliance = 0;
TimeSpan in_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttInTime.Hour, txtAttInTime.Minute, txtAttInTime.Second));
obj.In_Time = in_time;
TimeSpan out_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtAttOutTime.Hour, txtAttOutTime.Minute, txtAttOutTime.Second));
obj.Out_Time = out_time;
//TimeSpan workedTime = Calculations.timeDiff(in_time, out_time);
//TimeSpan overTime = TimeSpan.Parse("00:00:00");
//if (overTime == TimeSpan.Parse("00:00:00"))
//{
// ot_status = false;
//}
//else
//{
// ot_status = true;
//}
//obj.Worked_Time = workedTime;
//obj.Shift_TotalHour = shifted_TotalHour;
//obj.Over_Time = overTime;
//obj.OT_Hour = 0;
//obj.OT_Minute = 0;
//obj.OT_Total = 0;
//obj.OT_Status = ot_status;
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";
}
obj.Status = at_status;
//obj.Remarks = "Manual Attendance : "+txtRemarks_AT.Text;
obj.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
//obj.EDIT_USER = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
obj.Edit_Date = DateTime.Now;
obj.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;
}
int AttId = Convert.ToInt32(hiddenId.Value);
int result = objAtt_BLL.UpdateAttendance(obj, AttId);
if (result == 1)
{
lblMessage.Text = "Data Update successfully";
lblMessage.ForeColor = System.Drawing.Color.Green;
reset();
if (txtEID.Text != "")
{
BindGridAttendanceByEID();
}
else
{
BindGridEmployeeAttendance();
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
