[HttpPost] // возвращаем товар public ActionResult Insert(HistorySaleView entity) { try { double sales = data.SqlQuery <double>("select SaleCost from ProductSales where Id = @id", new { id = entity.Id }).FirstOrDefault(); if (sales != 0) { if (entity.SaleCost > sales) { return(Ok("-1")); } } else { return(Ok("-1")); } int usrid = 0; if (User.FindFirstValue("UserId") != null) { usrid = Convert.ToInt32(User.FindFirstValue("UserId")); } int result = data.SqlExecuteProc("SP_AddProductReturn", new { Id = 0, Amount = entity.Amount, Comments = entity.Comments, ProductSaleId = entity.Id, UserId = usrid, RegDT = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("Central Asia Standard Time")) }); if (result > 0) { return(Ok("1")); } else { return(Ok("-1")); } } catch (Exception e) { return(Ok(e.Message)); } }
public async Task <ActionResult <bool> > PostHistorySaleView(HistorySaleView entity) { try { if (!ModelState.IsValid) { BadRequest(); } var p = new DynamicParameters(); p.Add("@ProductSaleId", entity.Id); p.Add("@Amount", entity.Amount); p.Add("@RegDT", entity.RegDt); p.Add("@UserID", int.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value)); p.Add("@Comments", entity.Comments); int result = await _dappercontext.ExecuteAsync("SP_AddProductReturn", p, CommandType : System.Data.CommandType.StoredProcedure); } catch (Exception ex) { return(Ok(ex.Message)); } return(true); }