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