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