public ActionResult CancelLeave(ViewApplyLeave _CancelLeave)
{
string Message = string.Empty;
CommonMessages MessagesObj = new CommonMessages();
_CancelLeave.BusinessId = BusinessId;
_CancelLeave.UserId = UserId;
if (_CancelLeave.LeaveStatusId == 2)
{
msg = "Approved";
}
if (_CancelLeave.LeaveStatusId == 3)
{
msg = "Availed";
}
if (_CancelLeave.LeaveStatusId == 4)
{
msg = "Revoke";
}
MessagesObj = LMSBAL.CancelLeave(_CancelLeave);
if (MessagesObj.Result > 0)
{
Message = "Leave " + msg + " Successfully";
}
else
{
Message = MessagesObj.Message;
}
return(Json(Message, JsonRequestBehavior.AllowGet));
}
public ActionResult CancelLeave(int UserEmployeeId, int EmployeeLeaveId, int LeaveStatusId, string LeaveType, string FromDate, string ToDate, string EffectiveLeave)
{
ViewApplyLeave _CancelLeave = new ViewApplyLeave
{
UserEmployeeId = UserEmployeeId,
EmployeeLeaveId = EmployeeLeaveId,
BusinessId = BusinessId,
LeaveStatusId = LeaveStatusId
//EmployeeName = EmployeeName
};
ViewBag.LeaveStatusId = LeaveStatusId;
ViewBag.LeaveType = LeaveType;
ViewBag.FromDate = FromDate;
ViewBag.ToDate = ToDate;
ViewBag.EffectiveLeave = EffectiveLeave;
if (LeaveStatusId == 2)
{
ViewBag.msg = "Approved";
}
else if (LeaveStatusId == 4)
{
ViewBag.msg = "Revoked";
}
else if (LeaveStatusId == 3)
{
ViewBag.msg = "Availed";
}
else
{
ViewBag.msg = "Cancel";
}
return(PartialView(_CancelLeave));
}
public static List <ViewApplyLeave> Get_EmpLeaveDetailsList(ViewApplyLeave Data, int RoleId, int UserEmplyeeId)
{
List <ViewApplyLeave> GetEmpVacations = new List <ViewApplyLeave>();
//Data.Year = 2018;
using (DBSqlCommand cmd = new DBSqlCommand(CommandType.StoredProcedure))
{
try
{
cmd.AddParameters(Data.Year, CommonConstants.Year, SqlDbType.Int);
//cmd.AddParameters(Data.UserEmployeeId, CommonConstants.UserEmployeeId, SqlDbType.Int);
if (RoleId == 6)
{
cmd.AddParameters(UserEmplyeeId, CommonConstants.UserEmployeeId, SqlDbType.Int);
}
else
{
cmd.AddParameters(Data.UserEmployeeId, CommonConstants.UserEmployeeId, SqlDbType.Int);
}
cmd.AddParameters(Data.BusinessId, CommonConstants.BusinessID, SqlDbType.Int);
IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.GetEmployeeLeaveDeatails);
while (ireader.Read())
{
var EmpLeave = new ViewApplyLeave
{
EmployeeLeaveId = ireader.GetInt32(CommonColumns.EmployeeLeaveId),
UserEmployeeId = ireader.GetInt64(CommonColumns.UserEmployeeId),
BusinessId = ireader.GetInt32(CommonColumns.BusinessID),
EmployeeName = ireader.GetString(CommonColumns.EmployeeName),
LeaveStartDate = ireader.GetDateTime(CommonColumns.LeaveStartDate).ToShortDateString(),
LeaveEndDate = ireader.GetDateTime(CommonColumns.LeaveEndDate).ToShortDateString(),
NoOfLeaveDays = ireader.GetInt32(CommonColumns.NoOfLeaveDays),
LeaveType = ireader.GetString(CommonColumns.LeaveType),
LeaveReason = ireader.GetString(CommonColumns.LeaveReason),
Description = ireader.GetString(CommonColumns.Description),
//FileStatus = ireader.GetString(CommonColumns.FileStatus),
LeaveStatus = ireader.GetString(CommonColumns.LeaveStatus),
LeaveStatusId = ireader.GetInt32(CommonColumns.LeaveStatusId),
};
GetEmpVacations.Add(EmpLeave);
}
}
catch (Exception ex)
{
throw new ArgumentException("Exception in Get_EmpLeaveDetailsList. Exception :" + ex.Message);
}
}
return(GetEmpVacations);
}
public ActionResult GetEmployeeLeaveDetails(int EmployeeID, int LeaveYearID)
{
ViewApplyLeave _EmpLeave = new ViewApplyLeave
{
BusinessId = BusinessId,
UserId = UserId,
UserEmployeeId = EmployeeID,
Year = LeaveYearID
};
ViewBag.RoleId = RoleId;
var UserEmplyeeId = UserSessionEmployeeId;
var EmpLeaveDetails = LMSBAL.Get_EmpLeaveDetailsList(_EmpLeave, RoleId, UserEmplyeeId);
ViewBag.EmployeeLeaveData = EmpLeaveDetails;
return(PartialView(EmpLeaveDetails));
}
public static CommonMessages CancelLeave(ViewApplyLeave _CancelLeave)
{
using (DBSqlCommand cmd = new DBSqlCommand(CommandType.StoredProcedure))
{
CommonMessages MessagesObj = new CommonMessages();
try
{
cmd.AddParameters(_CancelLeave.BusinessId, CommonConstants.BusinessID, SqlDbType.Int);
cmd.AddParameters(_CancelLeave.EmployeeLeaveId, CommonConstants.EmployeeLeaveId, SqlDbType.Int);
cmd.AddParameters(_CancelLeave.UserEmployeeId, CommonConstants.UserEmployeeId, SqlDbType.BigInt);
cmd.AddParameters(_CancelLeave.LeaveStatusId, CommonConstants.LeaveStatusId, SqlDbType.BigInt);
IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.usp_UpdateLeaveStatus);
while (ireader.Read())
{
var EmpDet = new CommonMessages
{
Message = ireader.GetString(CommonColumns.ErrorMessage),
Result = ireader.GetInt32(CommonColumns.Result),
ErrorSeverity = ireader.GetString(CommonColumns.ErrorSeverity),
ErrorState = ireader.GetString(CommonColumns.ErrorState)
};
MessagesObj = EmpDet;
}
return(MessagesObj);
}
catch (Exception ex)
{
MessagesObj.Result = 0;
MessagesObj.Message = ex.Message;
MessagesObj.ErrorSeverity = ex.Message;
MessagesObj.ErrorState = ex.Message;
return(MessagesObj);
}
}
}
public static List <ViewApplyLeave> Get_EmpLeaveDetails(ViewApplyLeave _EmpLeave)
{
List <ViewApplyLeave> GetEmpVacations = new List <ViewApplyLeave>();
return(GetEmpVacations);
}
