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