internal int CancelLeavesForThirdReportinBoss(List <HRM_LeaveApply> leaveApplyesDates)
{
foreach (HRM_LeaveApply aiem in leaveApplyesDates)
{
HRM_LeaveApply obj = _context.HRM_LeaveApply.FirstOrDefault(a => a.LeaveDates == aiem.LeaveDates && a.LeaveCode == aiem.LeaveCode);
obj.ReportingBoss2ApproveDate = aiem.ReportingBoss2ApproveDate;
obj.ReportingBoss2DisApporveStatus = aiem.ReportingBoss2DisApporveStatus;
obj.IsPandingStatus = aiem.IsPandingStatus;
_context.SaveChanges();
}
return(1);
}
internal int LeaveForDisApproveNotChangeForHRM(HRM_LeaveApply leaveApplyObj)
{
using (var _context = new ERPSSLHBEntities())
{
var ParamempID = new SqlParameter("@LeaveCOde", leaveApplyObj.LeaveCode);
var ParamempID1 = new SqlParameter("@ReprotingBoss1ApporveStatus", leaveApplyObj.ReprotingBossHRmDisApporveStatus);
var ParamempID2 = new SqlParameter("@ReportingBoss1pproveDate", leaveApplyObj.ReportingBossHRMDisApproveDate);
string SP_SQL = "HRM_LeaveDisApproveForForReportinHRM @LeaveCOde,@ReprotingBoss1ApporveStatus,@ReportingBoss1pproveDate";
_context.ExecuteStoreCommand(SP_SQL, ParamempID, ParamempID1, ParamempID2);
return(1);
}
}
internal int UpdateLeaveApplyByLeaveId(HRM_LeaveApply leaveApplyObj, int leaveId)
{
HRM_LeaveApply obj = _context.HRM_LeaveApply.First(x => x.LeaveId == leaveId);
obj.LeaveAppliedDate = leaveApplyObj.LeaveAppliedDate;
obj.LeaveTypeId = leaveApplyObj.LeaveTypeId;
obj.LeaveDates = leaveApplyObj.LeaveDates;
obj.TotalDay = leaveApplyObj.TotalDay;
obj.LeaveResion = leaveApplyObj.LeaveResion;
_context.SaveChanges();
return(1);
}
protected void BtnAprove_Click(object sender, EventArgs e)
{
try
{
List <HRM_LeaveApply> leaveApplyes = new List <HRM_LeaveApply>();
int totalMaternityLeave = GetMaternityLeaveInfo();
TimeSpan difference = Convert.ToDateTime(txtbxLeaveDateTo.Text) - Convert.ToDateTime(txtbxLeaveDateFrom.Text);
var days = difference.TotalDays;
if (days > Convert.ToInt32(totalMaternityLeave))
{
lblMessage.Text = "Please Check Maternity Leave!";
}
else
{
DateTime begin = Convert.ToDateTime(txtbxLeaveDateFrom.Text);
DateTime end = Convert.ToDateTime(txtbxLeaveDateTo.Text);
List <DateTime> dates = new List <DateTime>();
for (DateTime date = begin; date < end; date = date.AddDays(1))
{
HRM_LeaveApply leaveApply = new HRM_LeaveApply();
leaveApply.TotalDay = 1;
leaveApply.ReprotingBossHRmApporveStatus = true;
leaveApply.ReportingBossHRMApproveDate = DateTime.Now;
leaveApply.LeaveDates = date;
leaveApply.LeaveCode = lblLeaveId.Text;
leaveApply.Eid = lblApplicantId.Text;
leaveApply.LeaveTypeId = 6;
leaveApply.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
leaveApply.EDIT_DATE = DateTime.Now;
leaveApply.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
leaveApplyes.Add(leaveApply);
//dates.Add(date);
}
int result = leaveBll.MaternityLeaveAccept(leaveApplyes);
if (result == 1)
{
HRM_MaternityLeave maternityLeave = new HRM_MaternityLeave();
maternityLeave.StatusDate = DateTime.Now;
maternityLeave.EID = lblApplicantId.Text;
maternityLeave.ApproveStatus = true;
int result1 = maternityLeaveBll.ApproveMaternityLeaveLeaveInfo(maternityLeave);
if (result1 == 1)
{
lblMessage.Text = "Approve Successfully!";
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal HRM_LeaveApply GetLeaveInfoById(string leaveId, string OCODE)
{
try
{
int LeaveId = Convert.ToInt32(leaveId);
HRM_LeaveApply obj = _context.HRM_LeaveApply.First(x => x.LeaveId == LeaveId);
return(obj);
}
catch (Exception)
{
throw;
}
}
internal int UpdateLeaveForApproveNotChange(HRM_LeaveApply leaveApplyes)
{
try
{
using (var _context = new ERPSSLHBEntities())
{
var ParamempID = new SqlParameter("@LeaveCOde", leaveApplyes.LeaveCode);
var ParamempID1 = new SqlParameter("@ReprotingBossHRmApporveStatus", leaveApplyes.ReprotingBossHRmApporveStatus);
var ParamempID2 = new SqlParameter("@ReportingBossHRMApproveDate", leaveApplyes.ReportingBossHRMApproveDate);
string SP_SQL = "HRM_LeaveApproveForHRM @LeaveCOde,@ReprotingBossHRmApporveStatus,@ReportingBossHRMApproveDate";
_context.ExecuteStoreCommand(SP_SQL, ParamempID, ParamempID1, ParamempID2);
return(1);
}
}
catch (Exception)
{
throw;
}
}
private int DeleteAttendenceByCode(List <HRM_LeaveApply> leaveApplyesDates)
{
try
{
int status = 0;
HRM_LeaveApply _leaveobj = leaveApplyesDates.FirstOrDefault();
List <HRM_ATTENDANCE> attendences = _context.HRM_ATTENDANCE.Where(x => x.Leave_Code == _leaveobj.LeaveCode).ToList();
foreach (HRM_ATTENDANCE aitem in attendences)
{
_context.HRM_ATTENDANCE.DeleteObject(aitem);
_context.SaveChanges();
status = 1;
}
return(status);
}
catch (Exception)
{
throw;
}
}
protected void btnDisapporve_Click(object sender, EventArgs e)
{
try
{
string leaveCode = hidLeaveCode.Value;
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = leaveCode;
leaveApplyObj.ReportingBoss2DisApporveStatus = true;
leaveApplyObj.ReportingBoss2DisApproveDate = DateTime.Now;
int result = leaveBll.LeaveForDisApproveNotChangeForReportingBoss2(leaveApplyObj);
if (result == 1)
{
lblMessage.Text = "This Leave has Dispproved";
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void BtnLeaveSubmit_Click(object sender, EventArgs e)
{
try
{
List <HRM_LeaveApply> leaveApplyes = new List <HRM_LeaveApply>();
HRM_PersonalInformations personalInfo = employeeSetUpDal.GetReportingBossById(lblApplicantId.Text);
string firstReportingBoss = personalInfo.ReportingBossId;
string secondReportinBoss = personalInfo.SecondReportingBossId;
string thirdReportingBoss = personalInfo.ThirdReportingBossId;
if (drpLeaveType.SelectedItem.ToString() == "--Select--")
{
lblMessage.Text = "Please Select Leave Type!";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
string[] dates = txtLeaveDate.Text.Split(',');
if (dates.Length > 0)
{
for (int i = 0; i < dates.Length; i++)
{
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
//leaveApplyObj.LeaveAppliedDate = DateTime.Now;
//leaveApplyObj.LeaveResion = txtbxLeaveReason.Text;
//leaveApplyObj.LeaveDates = txtLeaveDate.Text;
//leaveApplyObj.LeaveTypeId = Convert.ToInt32(drpLeaveType.SelectedValue);
//leaveApplyObj.TotalDay = Convert.ToInt32(txtbxTotalDay.Text);
//leaveApplyObj.ReportingBossId = hidReportingBossID.Value.ToString();
//if (BtnLeaveSubmit.Text == "Submit")
//{
// leaveApplyObj.Eid = lblApplicantId.Text;
// leaveApplyObj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
// leaveApplyObj.EDIT_DATE = DateTime.Now;
// leaveApplyObj.OCODE =((SessionUser)Session["SessionUser"]).OCode;
// int result = leaveBll.InsertLeaveApply(leaveApplyObj);
// if (result == 1)
// {
// lblMessage.Text = "Data Save Successfully.";
// setAnnulLeave();
// GetLeaveInfoByEmployeeId();
// }
//}
//else
//{
// int leaveId = Convert.ToInt32(hidLeaveId.Value);
// int result = leaveBll.UpdateLeaveApplyByLeaveId(leaveApplyObj, leaveId);
// if (result == 1)
// {
// lblMessage.Text = "Data Update Successfully.";
// setAnnulLeave();
// GetLeaveInfoByEmployeeId();
// clearAllControl();
// }
//}
leaveApplyObj.LeaveCode = lblLeaveId.Text;
leaveApplyObj.ReprotingBoss1 = firstReportingBoss;
leaveApplyObj.ReprotingBoss2 = secondReportinBoss;
leaveApplyObj.ReprotingBossHRM = thirdReportingBoss;
leaveApplyObj.LeaveAppliedDate = DateTime.Now;
leaveApplyObj.LeaveResion = txtbxLeaveReason.Text;
leaveApplyObj.LeaveDates = Convert.ToDateTime(dates[i]);
leaveApplyObj.LeaveTypeId = Convert.ToInt32(drpLeaveType.SelectedValue);
leaveApplyObj.TotalDay = 1;
leaveApplyObj.ReportingBossId = hidReportingBossID.Value.ToString();
leaveApplyObj.ReprotingBossHRmApporveStatus = false;
leaveApplyObj.ReprotingBoss1ApproveStatus = false;
leaveApplyObj.ReportingBoss2ApporveStatus = false;
leaveApplyObj.ReprotingBoss1DisApproveStatus = false;
leaveApplyObj.ReportingBoss2DisApporveStatus = false;
leaveApplyObj.ReprotingBossHRmDisApporveStatus = false;
leaveApplyObj.Eid = lblApplicantId.Text;
leaveApplyObj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
leaveApplyObj.EDIT_DATE = DateTime.Now;
leaveApplyObj.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
leaveApplyes.Add(leaveApplyObj);
}
if (BtnLeaveSubmit.Text == "Submit")
{
int result = leaveBll.InsertLeaveApply(leaveApplyes);
if (result == 1)
{
lblMessage.Text = "Data Save Successfully.";
setAnnulLeave();
GetLeaveInfoByEmployeeId();
}
}
getLeaveCode();
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateLeaveApplyByLeaveId(HRM_LeaveApply leaveApplyObj, int leaveId)
{
return(objCtx_DAL.UpdateLeaveApplyByLeaveId(leaveApplyObj, leaveId));
}
internal int LeaveForDisApproveNotChangeForReportingBoss2(HRM_LeaveApply leaveApplyObj)
{
return(objCtx_DAL.LeaveForDisApproveNotChangeForReportingBoss2(leaveApplyObj));
}
internal int UpdateLeaveForApproveNotChangeForReportingBoss1(HRM_LeaveApply leaveApplyObj)
{
return(objCtx_DAL.UpdateLeaveForApproveNotChangeForReportingBoss1(leaveApplyObj));
}
internal int UpdateLeaveForApproveNotChange(HRM_LeaveApply leaveApplyes)
{
return(objCtx_DAL.UpdateLeaveForApproveNotChange(leaveApplyes));
}
protected void btnUpdate_click(object sender, EventArgs e)
{
try
{
bool status = false;
string CL = "";
string SL = "";
string AL = "";
string ML = "";
string LWP = "";
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
var row = objLeave_BLL.GetAllLeaveType(OCODE).ToList();
if (row.Count > 0)
{
foreach (var item in row)
{
if (item.LEV_TYPE == "AL")
{
AL = item.LEV_DAYS.ToString();
}
else if (item.LEV_TYPE == "CL")
{
CL = item.LEV_DAYS.ToString();
}
else if (item.LEV_TYPE == "SL")
{
SL = item.LEV_DAYS.ToString();
}
else if (item.LEV_TYPE == "ML")
{
ML = item.LEV_DAYS.ToString();
}
}
}
if (txtEid_TRNS.Text == "")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input E-ID')", true);
}
else if (drpLeaveType.SelectedItem.ToString() == "--Select--")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Leave Type')", true);
}
else if (txtbxFromDate.Text == "")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input From Date')", true);
}
else if (txtbxToDate.Text == "")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input To Date')", true);
}
else if (drpLeaveType.SelectedItem.ToString() == "CL")
{
status = true;
Int32 totalActualLeave = TotalLeave();
Int32 totalLeave = totalActualLeave - Convert.ToInt16(hidTotalLeave.Value);
if (totalLeave + Convert.ToInt32(txtbxTotalDay.Text) > Convert.ToInt32(CL))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total CL Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "SL")
{
status = true;
Int32 totalActualLeave = TotalLeave();
Int32 totalLeave = totalActualLeave - Convert.ToInt16(hidTotalLeave.Value);
if (Convert.ToInt32(txtbxTotalDay.Text) + totalLeave > Convert.ToInt32(SL))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total SL Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "AL")
{
Int32 totalActualLeave = TotalLeave();
Int32 totalLeave = totalActualLeave - Convert.ToInt16(hidTotalLeave.Value);
status = true;
if (Convert.ToInt32(txtbxTotalDay.Text) + totalLeave > Convert.ToInt32(AL))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total AL Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "ML")
{
status = true;
Int32 totalActualLeave = TotalLeave();
Int32 totalLeave = totalActualLeave - Convert.ToInt16(hidTotalLeave.Value);
if (totalLeave + Convert.ToInt32(txtbxTotalDay.Text) > Convert.ToInt32(ML))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total ML Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "LWP")
{
status = true;
}
if (status)
{
if (DeleteExistinLeaveDetailsByCodeId())
{
if (txtbxToDate.Text != "")
{
if (!IsExist())
{
//string OCODE1 = ((SessionUser)Session["SessionUser"]).OCode;
DateTime DateTimeFrom = Convert.ToDateTime(txtbxFromDate.Text);
DateTime DateTo = Convert.ToDateTime(txtbxToDate.Text);
List <HRM_LeaveApply> leaveApplyesDates = new List <HRM_LeaveApply>();
for (int i = 0; i < Convert.ToInt16(txtbxTotalDay.Text); i++)
{
//check employee present
List <HRM_ATTENDANCE> lstHRM_ATTENDANCE = aAttendance_BLL.GetAttendanceInfo_DateWise(DateTimeFrom.AddDays(i)).Where(x => x.EID == txtEid_TRNS.Text && x.Status == "P").ToList();
if (lstHRM_ATTENDANCE.Count > 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Employee Already Exist in Attendance!')", true);
return;
}
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = hidLeaveCode.Value.ToString();
leaveApplyObj.LeaveDates = DateTimeFrom.AddDays(i);
leaveApplyObj.LeaveAppliedDate = Convert.ToDateTime(hidAppliedDate.Value);
leaveApplyObj.LeaveToDate = Convert.ToDateTime(txtbxToDate.Text);
leaveApplyObj.Eid = txtEid_TRNS.Text;
leaveApplyObj.LeaveTypeId = Convert.ToInt16(drpLeaveType.SelectedValue.ToString());
leaveApplyObj.LeaveCurrentYear = Convert.ToDateTime(txtbxFromDate.Text).Year;
leaveApplyObj.LeaveResion = txtbxResion.Text.Trim();
leaveApplyObj.ReprotingBossHRM = drpApprovedHR.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss1 = drpdwnApproveSupervisor.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss2 = drpApprovedAdmin.SelectedValue.ToString();
leaveApplyObj.LeaveStatusHRM = true;
leaveApplyObj.ReprotingBoss1ApproveStatus = true;
leaveApplyObj.ReportingBoss2ApporveStatus = true;
leaveApplyObj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
leaveApplyObj.EDIT_DATE = DateTime.Now;
leaveApplyObj.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
leaveApplyesDates.Add(leaveApplyObj);
}
//int checkResult = objLeave_BLL.CheckAttendance(leaveApplyesDates);
//if (checkResult == 0)
//{
int result = objLeave_BLL.InsertLeaveApply(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
string employeeID = Convert.ToString(txtEid_TRNS.Text);
GetLeaveDetailsByEID(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully!')", true);
}
}
//}
//else
//{
// ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Employee Already Exist in Attendance!')", true);
//}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Date Already Exist for Leave !')", true);
}
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnCancel_click(object sender, EventArgs e)
{
try
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
string EID = Convert.ToString(((SessionUser)Session["SessionUser"]).EID);
string LeaveCode = Convert.ToString(hidLeaveCode.Value);
string FirstReportingBossID = objLeave_BLL.GetFirstReportingBossIDByLeaveCode(LeaveCode);
string SecondReportingBossID = objLeave_BLL.GetSecondReportingBossIDByLeaveCode(LeaveCode);
string ThirdReportingBossID = objLeave_BLL.GetThirdReportingBossIDByLeaveCode(LeaveCode);
DateTime DateTimeFrom = Convert.ToDateTime(txtbxFromDate.Text);
DateTime DateTo = Convert.ToDateTime(txtbxToDate.Text);
List <HRM_LeaveApply> leaveApplyesDates = new List <HRM_LeaveApply>();
for (int i = 0; i < Convert.ToInt16(txtbxTotalDay.Text); i++)
{
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = hidLeaveCode.Value.ToString();
leaveApplyObj.OCODE = OCODE;
leaveApplyObj.LeaveDates = DateTimeFrom.AddDays(i);
leaveApplyObj.LeaveAppliedDate = Convert.ToDateTime(hidAppliedDate.Value);
leaveApplyObj.LeaveToDate = Convert.ToDateTime(txtbxToDate.Text);
leaveApplyObj.Eid = hidEid.Value;
leaveApplyObj.LeaveTypeId = Convert.ToInt16(drpLeaveType.SelectedValue.ToString());
leaveApplyObj.LeaveCurrentYear = DateTime.Now.Year;
leaveApplyObj.LeaveResion = txtbxResion.Text.Trim();
leaveApplyObj.ReprotingBossHRM = drpApprovedHR.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss1 = drpdwnApproveSupervisor.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss2 = drpApprovedAdmin.SelectedValue.ToString();
leaveApplyObj.IsPandingStatus = true;
leaveApplyObj.ReprotingBossHRmDisApporveStatus = false;
leaveApplyObj.ReportingBossHRMDisApproveDate = DateTime.Now;
leaveApplyObj.ReprotingBoss1DisApproveStatus = false;
leaveApplyObj.ReprotingBoss1DisApproveDate = DateTime.Now;
leaveApplyObj.ReportingBoss2DisApporveStatus = false;
leaveApplyObj.ReportingBoss2DisApproveDate = DateTime.Now;
leaveApplyesDates.Add(leaveApplyObj);
}
if (FirstReportingBossID == EID)
{
//leaveApplyObj.ReprotingBossHRmDisApporveStatus = false;
//leaveApplyObj.ReportingBossHRMDisApproveDate = DateTime.Now;
int result = objLeave_BLL.CancelLeavesForFirstReportinBoss(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
//string employeeID = Convert.ToString(txtEid_TRNS.Text);
//GetLeaveDetailsByEID(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Level Cancel Successfully!')", true);
}
}
}
else if (SecondReportingBossID == EID)
{
int result = objLeave_BLL.CancelLeavesForSecondReportinBoss(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
//string employeeID = Convert.ToString(txtEid_TRNS.Text);
//GetLeaveDetailsByEID(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Level Cancel Successfully!')", true);
}
}
}
else if (ThirdReportingBossID == EID)
{
int result = objLeave_BLL.CancelLeavesForThirdReportinBoss(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
//string employeeID = Convert.ToString(txtEid_TRNS.Text);
//GetLeaveDetailsByEID(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully!')", true);
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnSave_click(object sender, EventArgs e)
{
try
{
if (drpLeaveType.SelectedItem.ToString() == "--Select--")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Leave Type')", true);
}
else if (txtbxFromDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input From Date')", true);
}
else if (txtbxToDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input To Date')", true);
}
else
{
//if (DeleteExistinLeaveDetailsByCodeId())
//{
if (txtbxToDate.Text != "")
{
//if (!IsExist())
//{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
string EID = Convert.ToString(((SessionUser)Session["SessionUser"]).UserId);
string LeaveCode = Convert.ToString(hidLeaveCode.Value);
string FirstReportingBossID = objLeave_BLL.GetFirstReportingBossIDByLeaveCode(LeaveCode);
string SecondReportingBossID = objLeave_BLL.GetSecondReportingBossIDByLeaveCode(LeaveCode);
string ThirdReportingBossID = objLeave_BLL.GetThirdReportingBossIDByLeaveCode(LeaveCode);
List <HRM_LeaveApply> mainLeavesbyCode = objLeave_BLL.getLeaveApplyesByCode(LeaveCode);
DateTime DateTimeFrom = Convert.ToDateTime(txtbxFromDate.Text);
DateTime DateTo = Convert.ToDateTime(txtbxToDate.Text);
List <HRM_LeaveApply> leaveApplyesDates1 = new List <HRM_LeaveApply>();
for (int i = 0; i < Convert.ToInt16(txtbxTotalDay.Text); i++)
{
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = hidLeaveCode.Value.ToString();
leaveApplyObj.OCODE = OCODE;
leaveApplyObj.LeaveDates = DateTimeFrom.AddDays(i);
leaveApplyObj.LeaveAppliedDate = Convert.ToDateTime(hidAppliedDate.Value);
leaveApplyObj.LeaveToDate = Convert.ToDateTime(txtbxToDate.Text);
leaveApplyObj.Eid = hidEid.Value;
leaveApplyObj.LeaveTypeId = Convert.ToInt16(drpLeaveType.SelectedValue.ToString());
leaveApplyObj.LeaveCurrentYear = DateTime.Now.Year;
leaveApplyObj.LeaveResion = txtbxResion.Text.Trim();
leaveApplyObj.ReprotingBossHRM = drpApprovedHR.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss1 = drpdwnApproveSupervisor.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss2 = drpApprovedAdmin.SelectedValue.ToString();
leaveApplyObj.LeaveStatusHRM = true;
if (FirstReportingBossID == EID)
{
leaveApplyObj.ReprotingBossHRmDisApporveStatus = false;
leaveApplyObj.ReportingBossHRMDisApproveDate = DateTime.Now;
}
else if (SecondReportingBossID == EID)
{
leaveApplyObj.ReprotingBoss1DisApproveStatus = false;
leaveApplyObj.ReprotingBoss1DisApproveDate = DateTime.Now;
}
else if (ThirdReportingBossID == EID)
{
leaveApplyObj.ReportingBoss2DisApporveStatus = false;
leaveApplyObj.ReportingBoss2DisApproveDate = DateTime.Now;
}
leaveApplyesDates1.Add(leaveApplyObj);
}
List <HRM_LeaveApply> leaveApplyesDates = (from post in mainLeavesbyCode
join meta in leaveApplyesDates1
on post.LeaveDates equals meta.LeaveDates
select post
).ToList();
int resultdelete = objLeave_BLL.DeleteLeaveDetailsByLeaveCode(LeaveCode);
if (resultdelete == 1)
{
int result = objLeave_BLL.InsertLeaveApply(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
//string employeeID = Convert.ToString(txtEid_TRNS.Text);
//GetLeaveDetailsByEID(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Leave Approved Successfully')", true);
}
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Date Already Exist for Leave !')", true);
}
//}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnSave_click(object sender, EventArgs e)
{
try
{
bool status = false;
if (txtEid_TRNS.Text == "")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input E-ID!')", true);
}
else if (drpLeaveType.SelectedItem.ToString() == "--Select--")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Leave Type!')", true);
}
else if (txtbxFromDate.Text == "")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input From Date!')", true);
}
else if (txtbxToDate.Text == "")
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input To Date!')", true);
}
else if (drpLeaveType.SelectedItem.ToString() == "CL")
{
status = true;
if (Convert.ToInt32(lblCloE.Text) + Convert.ToInt32(txtbxTotalDay.Text) > Convert.ToInt32(lblCl.Text))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total CL Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "SL")
{
status = true;
if (Convert.ToInt32(lblSLE.Text) + Convert.ToInt32(txtbxTotalDay.Text) > Convert.ToInt32(lblSl.Text))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total SL Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "AL")
{
status = true;
if (Convert.ToInt32(lblALE.Text) + Convert.ToInt32(txtbxTotalDay.Text) > Convert.ToInt32(lblAL.Text))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total AL Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "ML")
{
status = true;
if (Convert.ToInt32(lblMLE.Text) + Convert.ToInt32(txtbxTotalDay.Text) > Convert.ToInt32(lblML.Text))
{
status = false;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Total ML Leave!')", true);
}
}
else if (drpLeaveType.SelectedItem.ToString() == "LWP")
{
status = true;
}
if (status)
{
if (!IsExist())
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
int count = objLeave_BLL.GetLastRowNumber(OCODE);
int total = count + 1;
string Code = "LC" + total;
DateTime DateTimeFrom = Convert.ToDateTime(txtbxFromDate.Text);
DateTime DateTo = Convert.ToDateTime(txtbxToDate.Text);
List <HRM_LeaveApply> leaveApplyesDates = new List <HRM_LeaveApply>();
for (int i = 0; i < Convert.ToInt16(txtbxTotalDay.Text); i++)
{
//check employee present
List <HRM_ATTENDANCE> lstHRM_ATTENDANCE = aAttendance_BLL.GetAttendanceInfo_DateWise(DateTimeFrom.AddDays(i)).Where(x => x.EID == txtEid_TRNS.Text).ToList();
if (lstHRM_ATTENDANCE.Count > 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Employee Already Exist in Attendance!')", true);
return;
}
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = Code;
leaveApplyObj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
leaveApplyObj.EDIT_DATE = DateTime.Now;
leaveApplyObj.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
leaveApplyObj.LeaveDates = DateTimeFrom.AddDays(i);
leaveApplyObj.LeaveAppliedDate = Convert.ToDateTime(txtbxFromDate.Text);
leaveApplyObj.LeaveToDate = Convert.ToDateTime(txtbxToDate.Text);
leaveApplyObj.Eid = txtEid_TRNS.Text;
leaveApplyObj.LeaveTypeId = Convert.ToInt16(drpLeaveType.SelectedValue.ToString());
leaveApplyObj.LeaveCurrentYear = Convert.ToDateTime(txtbxFromDate.Text).Year;
leaveApplyObj.LeaveResion = txtbxResion.Text.Trim();
leaveApplyObj.ReprotingBossHRM = drpApprovedHR.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss1 = drpdwnApproveSupervisor.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss2 = drpApprovedAdmin.SelectedValue.ToString();
leaveApplyObj.LeaveStatusHRM = true;
leaveApplyObj.ReprotingBoss1ApproveStatus = true;
leaveApplyObj.ReportingBoss2ApporveStatus = true;
leaveApplyObj.EDIT_DATE = DateTime.Now;
leaveApplyObj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
leaveApplyesDates.Add(leaveApplyObj);
}
int result = objLeave_BLL.InsertLeaveApply(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
string employeeID = Convert.ToString(txtEid_TRNS.Text);
getLeaveEnjoyedInfoById(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Date Already Exist for Leave!')", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
//private void gethrmemployeeList()
//{
// try
// {
// string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
// List<ReportingBoss> personalInfos = objEmp_BLL.GetPersonalInfoByDepartment(OCODE);
// if (personalInfos.Count > 0)
// {
// //drpdwnApproveSupervisor.DataSource = personalInfos;
// //drpdwnApproveSupervisor.DataTextField = "FulllName";
// //drpdwnApproveSupervisor.DataValueField = "EID";
// //drpdwnApproveSupervisor.DataBind();
// //drpdwnApproveSupervisor.Items.Insert(0, new ListItem("--Select--", "0"));
// //drpApprovedAdmin.DataSource = personalInfos;
// //drpApprovedAdmin.DataTextField = "FulllName";
// //drpApprovedAdmin.DataValueField = "EID";
// //drpApprovedAdmin.DataBind();
// //drpApprovedAdmin.Items.Insert(0, new ListItem("--Select--", "0"));
// drpApprovedHR.DataSource = personalInfos;
// drpApprovedHR.DataTextField = "FulllName";
// drpApprovedHR.DataValueField = "EID";
// drpApprovedHR.DataBind();
// drpApprovedHR.Items.Insert(0, new ListItem("--Select--", "0"));
// }
// }
// catch (Exception)
// {
// throw;
// }
//}
protected void btnSave_click(object sender, EventArgs e)
{
try
{
if (txtEid_TRNS.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input E-ID')", true);
}
else if (drpLeaveType.SelectedItem.ToString() == "--Select--")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Leave Type')", true);
}
else if (txtbxFromDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input From Date')", true);
}
else if (txtbxToDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input To Date')", true);
}
else
{
if (!IsExist())
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
int count = objLeave_BLL.GetLastRowNumber(OCODE);
int total = count + 1;
string Code = " LC" + total;
DateTime DateTimeFrom = Convert.ToDateTime(txtbxFromDate.Text);
DateTime DateTo = Convert.ToDateTime(txtbxToDate.Text);
List <HRM_LeaveApply> leaveApplyesDates = new List <HRM_LeaveApply>();
for (int i = 0; i < Convert.ToInt16(txtbxTotalDay.Text); i++)
{
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = Code;
leaveApplyObj.OCODE = OCODE;
leaveApplyObj.LeaveDates = DateTimeFrom.AddDays(i);
leaveApplyObj.LeaveAppliedDate = Convert.ToDateTime(txtbxFromDate.Text);
leaveApplyObj.LeaveToDate = Convert.ToDateTime(txtbxToDate.Text);
leaveApplyObj.Eid = txtEid_TRNS.Text;
leaveApplyObj.LeaveTypeId = Convert.ToInt16(drpLeaveType.SelectedValue.ToString());
leaveApplyObj.LeaveCurrentYear = DateTime.Now.Year;
leaveApplyObj.LeaveResion = txtbxResion.Text.Trim();
leaveApplyObj.ReprotingBossHRM = drpApprovedHR.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss1 = drpdwnApproveSupervisor.SelectedValue.ToString();
leaveApplyObj.ReprotingBoss2 = drpApprovedAdmin.SelectedValue.ToString();
leaveApplyObj.LeaveStatusHRM = true;
leaveApplyObj.ReprotingBoss1ApproveStatus = true;
leaveApplyObj.ReportingBoss2ApporveStatus = true;
leaveApplyesDates.Add(leaveApplyObj);
}
int result = objLeave_BLL.InsertLeaveApply(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
string employeeID = Convert.ToString(txtEid_TRNS.Text);
getLeaveEnjoyedInfoById(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully!')", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Date Already Exist for Leave !')", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void BtnAprove_Click(object sender, EventArgs e)
{
try
{
LEAVE_BLL leaveBll = new LEAVE_BLL();
// string leaveId = Session["aLeaveID"].ToString();
// leaveApplyObj.ApporveBy = "SBD";
// leaveApplyObj.ApproveDate = DateTime.Now;
//// leaveApplyObj.LeaveDates = txtLeaveDate.Text.ToString();
// leaveApplyObj.TotalDay = Convert.ToInt32(txtbxTotalDay.Text);
// string leaId = Session["aLeaveID"].ToString();
if (txtLeaveDate.Text == "")
{
string leaveCode = hidLeaveCode.Value;
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = leaveCode;
leaveApplyObj.ReprotingBoss1ApproveStatus = true;
leaveApplyObj.ReprotingBoss1ApproveDate = DateTime.Now;
int result = leaveBll.UpdateLeaveForApproveNotChangeForReportingBoss2(leaveApplyObj);
if (result == 1)
{
lblMessage.Text = "This Leave has Approved";
}
}
else
{
List <HRM_LeaveApply> newLeaveApplyList = new List <HRM_LeaveApply>();
string[] dates = txtLeaveDate.Text.Split(',');
if (dates.Length > 0)
{
for (int i = 0; i < dates.Length; i++)
{
string leaveCode = hidLeaveCode.Value;
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
// DateTime ConvertDate = Convert.ToDateTime(dates[i]);
//string formateDate = ConvertDate.ToString("yyyy-MM-dd");
leaveApplyObj.LeaveCode = leaveCode;
leaveApplyObj.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
leaveApplyObj.LeaveDates = Convert.ToDateTime(dates[i]);
leaveApplyObj.ReprotingBossHRmApporveStatus = true;
leaveApplyObj.ReportingBossHRMApproveDate = DateTime.Now.Date;
newLeaveApplyList.Add(leaveApplyObj);
}
}
int result = leaveBll.UpdateLeaveChangeForReportingBoss2(newLeaveApplyList);
if (result == 1)
{
lblMessage.Text = "This Leave has Approved";
}
}
//int result = leaveBll.UpdateLeaveForApprove(leaveApplyObj, leaId);
//if (result == 1)
//{
// lblMessage.Text = "This Leave has Approved";
//}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnSave_click(object sender, EventArgs e)
{
try
{
if (txtEid_TRNS.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input E-ID')", true);
}
else if (drpLeaveType.SelectedItem.ToString() == "--Select--")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Leave Type')", true);
}
else if (txtbxFromDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input From Date')", true);
}
else if (txtbxToDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input To Date')", true);
}
else
{
if (!IsExist())
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
int count = objLeave_BLL.GetLastRowNumber(OCODE);
int total = count + 1;
string Code = " LC" + total;
string thirdReportingBoss = null;
string secondReportingBoss = null;
string hrmreportinBoss = null;
HRM_PersonalInformations _personalinfo = objEmp_BLL.getPersonalInfosByID(txtEid_TRNS.Text);
if (_personalinfo.ReportingBossId != null)
{
hrmreportinBoss = _personalinfo.ReportingBossId.ToString();
}
if (_personalinfo.SecondReportingBossId != null)
{
secondReportingBoss = _personalinfo.SecondReportingBossId.ToString();
}
if (_personalinfo.ThirdReportingBossId != null)
{
thirdReportingBoss = _personalinfo.ThirdReportingBossId.ToString();
}
DateTime DateTimeFrom = Convert.ToDateTime(txtbxFromDate.Text);
DateTime DateTo = Convert.ToDateTime(txtbxToDate.Text);
List <HRM_LeaveApply> leaveApplyesDates = new List <HRM_LeaveApply>();
for (int i = 0; i < Convert.ToInt16(txtbxTotalDay.Text); i++)
{
HRM_LeaveApply leaveApplyObj = new HRM_LeaveApply();
leaveApplyObj.LeaveCode = Code;
leaveApplyObj.OCODE = OCODE;
leaveApplyObj.LeaveDates = DateTimeFrom.AddDays(i);
leaveApplyObj.LeaveAppliedDate = Convert.ToDateTime(txtbxFromDate.Text);
leaveApplyObj.LeaveToDate = Convert.ToDateTime(txtbxToDate.Text);
leaveApplyObj.Eid = txtEid_TRNS.Text;
leaveApplyObj.LeaveTypeId = Convert.ToInt16(drpLeaveType.SelectedValue.ToString());
leaveApplyObj.LeaveCurrentYear = DateTime.Now.Year;
leaveApplyObj.LeaveResion = txtbxResion.Text.Trim();
leaveApplyObj.TotalDay = 1;
leaveApplyObj.IsPandingStatus = false;
leaveApplyObj.LeaveStatusHRM = false;
leaveApplyObj.ReprotingBoss1ApproveStatus = false;
leaveApplyObj.ReportingBoss2ApporveStatus = false;
leaveApplyObj.ReprotingBossHRM = hrmreportinBoss;
leaveApplyObj.ReprotingBoss1 = secondReportingBoss;
leaveApplyObj.ReprotingBoss2 = thirdReportingBoss;
leaveApplyesDates.Add(leaveApplyObj);
}
int result = objLeave_BLL.InsertLeaveApply(leaveApplyesDates);
if (result == 1)
{
int Attendanceresult = objLeave_BLL.DeleteAttendanceByLeaveDate(leaveApplyesDates);
if (Attendanceresult == 1)
{
ClaerAllController();
string employeeID = Convert.ToString(txtEid_TRNS.Text);
getLeaveEnjoyedInfoById(employeeID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully')", true);
}
}
string eid = txtEid_TRNS.Text;
List <LeaveForReport> report = new List <LeaveForReport>();
report = objLeave_BLL.GetEmployeeApplyReport(eid, DateTimeFrom, DateTo);
if (report.Count > 0)
{
Session["rptDs"] = "DataSet1";
Session["rptDt"] = report;
Session["rptFile"] = "/HRM/reports/HRM_Leave_Apply_ById.rdlc";
Session["rptTitle"] = "Leave Apply";
Response.Redirect("Report_Viewer.aspx");
//ReportViewer1.LocalReport.DataSources.Clear();
//ReportDataSource rpts = new ReportDataSource("DataSet1", report);
//ReportViewer1.LocalReport.DataSources.Add(rpts);
//ReportViewer1.LocalReport.ReportPath = "D:/TFS/HOMEBOUND/ERPSSL/HRM/reports/HRM_Leave_Apply_ById.rdlc";
//ReportViewer1.LocalReport.Refresh();
//rpt_Leave_Apply.Reset();
//ReportDataSource rpts = new ReportDataSource("D:/TFS/HOMEBOUND/ERPSSL/HRM/reports/DataSet1", report);
//rpt_Leave_Apply.LocalReport.DataSources.Add(rpts);
//rpt_Leave_Apply.LocalReport.ReportPath = "D:/TFS/HOMEBOUND/ERPSSL/HRM/reports/HRM_Leave_Apply_ById.rdlc";
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('This Date Already Exist for Leave !')", true);
}
}
}
catch (Exception)
{
throw;
}
}
