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