public async Task <int> SaveOrUpdate(LeverageViewModel levm) { string sql = "dbo.EAppSaveLeverageServiceDetail"; using (var conn = util.MasterCon()) { try { foreach (LeverageServices ls in levm.LeverageServices) { await(conn.QueryAsync <dynamic>(sql, new { ls.LeverageServiceId, levm.JobEquipmentId, ls.OpportunityTypeId, ls.Descriptions, levm.LSQuoteReference, levm.LSQuoteAmount, levm.LSQuoteStatusId, levm.LSFileName, levm.LSLogicalName, levm.LSPhysicalPath, levm.LSQuoteComment, ls.Active, levm.UserId }, commandType: CommandType.StoredProcedure)); } } catch (Exception ex) { throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex); } return(levm.JobEquipmentId); } }
public async Task <IActionResult> Create([FromBody] LeverageViewModel levm) { try { CurrentUser cUser = new CurrentUser(HttpContext, _configuration); levm.UserId = cUser.UserId; return(Ok(await leverageRepo.SaveOrUpdate(levm))); } 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))); } }