public async Task <IActionResult> GetAnalysisByUnit(string type, string sType, int uaId, int lId)
{
CurrentUser cUser = new CurrentUser(HttpContext, _configuration);
try
{
JobUnitAnalysisViewModel juavm = (JobUnitAnalysisViewModel)await reportFeederRepo.GetUnitAnalysisById(uaId, type, sType, lId);
if (juavm.JobUnitSymptomsListJson != null)
{
juavm.JobUnitSymptomsList = JsonConvert.DeserializeObject <List <JobUnitSymptomsViewModel> >(juavm.JobUnitSymptomsListJson);
}
if (juavm.JobUnitAmplitudeListJson != null)
{
juavm.JobUnitAmplitudeList = JsonConvert.DeserializeObject <List <JobUnitAmplitudeViewModel> >(juavm.JobUnitAmplitudeListJson);
}
await auditLogService.LogActivity(cUser.UserId, cUser.HostIP, cUser.SessionId, "Create Report", "Loaded Analysis (Vibration / Oil) Report Data by selected Unit.");
return(Ok(juavm));
}
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)));
}
}
public async Task <IActionResult> Create([FromBody] JobUnitAnalysisViewModel juavm)
{
try
{
CurrentUser cUser = new CurrentUser(HttpContext, _configuration);
juavm.UserId = cUser.UserId;
//juavm.UnitAnalysisId = 0;
var result = await reportFeederRepo.SaveOrUpdate(juavm);
await auditLogService.LogActivity(cUser.UserId, cUser.HostIP, cUser.SessionId, "Create Report", "Report Created.");
return(Ok(result));
}
catch (CustomException cex)
{
var returnObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError, returnObj));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new EmaintenanceMessage(ex.Message)));
}
}
/** This method is used to Save or Update UnitAnalysis */
public async Task <IEnumerable <dynamic> > SaveOrUpdate(JobUnitAnalysisViewModel juavm)
{
string sql = "dbo.EAppSaveJobUnitAnalysis";
using (var conn = util.MasterCon())
{
try
{
string UnitSymptomsJson = null;
string UnitAmplitudeJson = null;
if (juavm.JobUnitSymptomsList != null && juavm.JobUnitSymptomsList.Count > 0)
{
string Header = "{\"JobUnitSymptomsList\": ";
string Footer = "}";
UnitSymptomsJson = Header + JsonConvert.SerializeObject(juavm.JobUnitSymptomsList) + Footer;
}
if (juavm.JobUnitAmplitudeList != null && juavm.JobUnitAmplitudeList.Count > 0)
{
string Header = "{\"JobUnitAmplitudeList\": ";
string Footer = "}";
UnitAmplitudeJson = Header + JsonConvert.SerializeObject(juavm.JobUnitAmplitudeList) + Footer;
}
DynamicParameters _params = new DynamicParameters();
_params.Add("@Result", null, DbType.String, direction: ParameterDirection.Output, size: 4000);
_params.Add("@ResultText", null, DbType.String, direction: ParameterDirection.Output, size: 4000);
_params.Add("@UnitAnalysisId", juavm.UnitAnalysisId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@JobEquipmentId", juavm.JobEquipmentId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@ServiceId", juavm.ServiceId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@UnitType", juavm.UnitType, DbType.String, direction: ParameterDirection.Input);
_params.Add("@UnitId", juavm.UnitId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@ConditionId", juavm.ConditionId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@ConfidentFactorId", juavm.ConfidentFactorId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@FailureProbFactorId", juavm.FailureProbFactorId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@PriorityId", juavm.PriorityId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@IsWorkNotification", juavm.IsWorkNotification, DbType.String, direction: ParameterDirection.Input);
_params.Add("@IsEC", juavm.IsEC, DbType.String, direction: ParameterDirection.Input);
_params.Add("@NoOfDays", juavm.NoOfDays, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@Recommendation", juavm.Recommendation, DbType.String, direction: ParameterDirection.Input);
_params.Add("@Comment", juavm.Comment, DbType.String, direction: ParameterDirection.Input);
_params.Add("@UnitSymptomsJson", UnitSymptomsJson, DbType.String, direction: ParameterDirection.Input);
_params.Add("@UnitAmplitudeJson", UnitAmplitudeJson, DbType.String, direction: ParameterDirection.Input);
_params.Add("@StatusId", juavm.StatusId, DbType.Int32, direction: ParameterDirection.Input);
_params.Add("@UserId", juavm.UserId, DbType.Int32, direction: ParameterDirection.Input);
var returnValue = await(conn.QueryAsync <dynamic>(sql, _params, commandType: CommandType.StoredProcedure));
string result = _params.Get <string>("Result");
string resultText = _params.Get <string>("ResultText");
if (result == "F")
{
throw new CustomException(resultText, "Error", true, resultText);
}
return(returnValue);
}
catch (CustomException cex)
{
throw new CustomException(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
}
catch (Exception ex)
{
throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex);
}
}
}
