public async Task <IEnumerable <dynamic> > GetListEquipmentHealth([FromBody] ListEMaintEquipmentHealthViewModel lehvm)
        {
            string sql = "dbo.OAppDBEquipmentListByCondition";

            using (var conn = util.MasterCon())
            {
                try
                {
                    return(await(conn.QueryAsync <dynamic>(sql, new
                    {
                        lehvm.UserId,
                        lehvm.CountryId,
                        lehvm.ClientSiteId,
                        lehvm.PlantAreaId,
                        lehvm.ConditionId
                    }, commandType: CommandType.StoredProcedure)));
                }
                catch (Exception ex)
                {
                    throw new CustomException("Unable to Load Data, Please Contact Support!!!", "Error", true, ex);
                }
            }
        }
Example #2
0
        //[SKFAuthorize("PRG12:P1")]
        public async Task <IActionResult> GetListEquipmentHealth([FromBody] ListEMaintEquipmentHealthViewModel lehvm)
        {
            CurrentUser cUser = new CurrentUser(HttpContext, _configuration);

            try
            {
                lehvm.UserId = cUser.UserId;
                //lehvm.ClientSiteId
                var result = await observerDashboardRepo.GetListEquipmentHealth(lehvm);

                await auditLogService.LogActivity(cUser.UserId, cUser.HostIP, cUser.SessionId, "Area", "Area list Loaded.");

                return(Ok(result));
            }
            catch (CustomException cex)
            {
                var responseObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
                return(StatusCode(StatusCodes.Status500InternalServerError, responseObj));
            }
            catch (Exception ex)
            {
                return(Ok(new EmaintenanceMessage(ex.Message)));
            }
        }