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