/// <summary> /// Get the details for FE except my pending /// </summary> /// <param name="dashBoardParameter">object</param> /// <param name="loginUserId">string</param> /// <returns>object</returns> public DashboardModel GetDashBoardDetailsForFEExceptMyPending(DashBoardParameter dashBoardParameter, string loginUserId) { DashboardModel oDashBoardModel = new DashboardModel(); try { using (var connection = Connection()) { var result = connection.QueryMultiple("Rpt_DashboardDetailNew", new { DType = dashBoardParameter.DType, Month = dashBoardParameter.Month, Year = dashBoardParameter.Year, DateFrm = dashBoardParameter.DateFrm, DateTo = dashBoardParameter.DateTo, Desig = dashBoardParameter.Desig, UId = loginUserId }, commandType: CommandType.StoredProcedure); oDashBoardModel.PendingDetailsForFE = result.Read<PendingDetailsForFE>().ToList(); } } catch (Exception ex) { //SaveErrorMessageInFile(oErrorMessage = new ErrorMessage { UserId = loginUserId, ModuleName = "DashBoard", MethodName = "GetDashBoardDetailsForFE", Exception = ex.Message }); logger.Error(ex.Message); } return oDashBoardModel; }
public List<SMPDashboardDetail> GetSMPDataDashboardDetails(DashBoardParameter dashBoardParameter, string loginUserId) { List<SMPDashboardDetail> sMPDashboardDetail = new List<SMPDashboardDetail>(); try { using (var connection = Connection()) { var result = connection.QueryMultiple("Rpt_SMPDashboardDetail", new { DType = dashBoardParameter.DType, Month = dashBoardParameter.Month, Year = dashBoardParameter.Year, DateFrm = dashBoardParameter.DateFrm, StatusType = dashBoardParameter.StatusType, DateTo = dashBoardParameter.DateTo, UId = loginUserId }, commandType: CommandType.StoredProcedure); sMPDashboardDetail = result.Read<SMPDashboardDetail>().ToList(); } } catch (Exception ex) { logger.Error(ex.Message); } return sMPDashboardDetail; }
public JsonResult GetDashBoardDetailsForFSR(DashBoardParameter dashBoardParameter) { var result = oDashBoardManager.GetDashBoardDetailsForFSR(dashBoardParameter, CookieManager.GetCookie(CookieManager.CookieName).logindetail.EmpID); result.DsgId = CookieManager.GetCookie(CookieManager.CookieName).logindetail.DsgId; return(Json(new { result }, JsonRequestBehavior.AllowGet)); }
public List<DashBoard> GetSMPDataDashboard(DashBoardParameter dashBoardParameter, string loginUserId) { List<DashBoard> dashboard = new List<DashBoard>(); try { using (var connection = Connection()) { var result = connection.QueryMultiple("Rpt_SMPDataDashboard", new { Month = dashBoardParameter.Month, Year = dashBoardParameter.Year, Type = dashBoardParameter.StatusType, UId = loginUserId }, commandType: CommandType.StoredProcedure); dashboard = result.Read<DashBoard>().ToList(); } } catch (Exception ex) { logger.Error(ex.Message); } return dashboard; }
/// <summary> /// Get the Dashboard details for FE. /// </summary> /// <param name="dashBoardParameter">object</param> /// <param name="loginUserId">string</param> /// <returns>object</returns> public DashboardModel GetPendingDetailsForVersionUpdt(DashBoardParameter dashBoardParameter, string loginUserId) { DashboardModel oDashBoardModel = new DashboardModel(); try { using (var connection = Connection()) { var result = connection.QueryMultiple("Rpt_versionupdatedashboard", new { Month = dashBoardParameter.Month, Year = dashBoardParameter.Year, UId = loginUserId }, commandType: CommandType.StoredProcedure); // oDashBoardModel.MessageInfo = result.Read<Message>().FirstOrDefault(); oDashBoardModel.DashBoardData = result.Read<DashBoard>().ToList(); } } catch (Exception ex) { //SaveErrorMessageInFile(oErrorMessage = new ErrorMessage { UserId = loginUserId, ModuleName = "DashBoard", MethodName = "GetDashBoardDetailsForFE", Exception = ex.Message }); logger.Error(ex.Message); } return oDashBoardModel; }
public JsonResult GetSMPDataDashboardDetails(DashBoardParameter dashBoardParameter) { var result = oDashBoardManager.GetSMPDataDashboardDetails(dashBoardParameter, CookieManager.GetCookie(CookieManager.CookieName).logindetail.EmpID); return(Json(new { result }, JsonRequestBehavior.AllowGet)); }