public async Task <IActionResult> Search([FromBody] AssetSequenceViewModel avm) { try { return(Ok(await AssetSequenceRepo.GetAssetSequenceByParams(avm))); } 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 <IEnumerable <dynamic> > GetAssetSequenceByParams(AssetSequenceViewModel avm) { string sql = "dbo.EAppListAssetSequence"; using (var conn = util.MasterCon()) { try { return(await(conn.QueryAsync <dynamic>(sql, new { avm.LanguageId, avm.Status }, commandType: CommandType.StoredProcedure))); } catch (Exception ex) { throw new CustomException("Unable to Load Data, Please Contact Support!!!", "Error", true, ex); } } }
public async Task <IActionResult> Update([FromBody] AssetSequenceViewModel svm) { try { return(Ok(await AssetSequenceRepo.SaveOrUpdate(svm))); } 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))); } }
public async Task <IActionResult> Create([FromBody] AssetSequenceViewModel avm) { try { CurrentUser cUser = new CurrentUser(HttpContext, _configuration); avm.UserId = cUser.UserId; avm.AssetSequenceId = 0; avm.Active = "Y"; return(Ok(await AssetSequenceRepo.SaveOrUpdate(avm))); } 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))); } }
public async Task <IEnumerable <dynamic> > SaveOrUpdate([FromBody] AssetSequenceViewModel avm) { string sql = "dbo.EAppSaveAssetSequence"; using (var conn = util.MasterCon()) { try { return(await(conn.QueryAsync <dynamic>(sql, new { avm.AssetSequenceId, avm.LanguageId, avm.AssetTypeId, avm.AssetSequenceCode, avm.AssetSequenceName, avm.Descriptions, avm.Active, avm.UserId }, commandType: CommandType.StoredProcedure))); } catch (SqlException sqlException) { if (sqlException.Number == 2601 || sqlException.Number == 2627) { throw new CustomException("Duplicate", "Asset Type Code already Exists.", "Error", true, sqlException); } else { throw new CustomException("Due to some Technical Reason, Unable to Save or Update", "Error", true, sqlException); } } catch (Exception ex) { throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex); } } }