public async Task <ActionResult <ResponseMessage <int> > > CloseOrder([FromBody] ProductSales[] entity)
{
if (entity == null)
{
return(BadRequest());
}
int executed = 0;
foreach (var item in entity)
{
var n = new
{
ProductId = item.ProductId,
Amount = item.Amount,
SaleCost = item.SaleCost,
IsOptCost = item.IsOptCost,
CustomerId = item.CustomerId,
RegDT = item.RegDt,
UserID = int.Parse(User.FindFirstValue(ClaimTypes.NameIdentifier)),
Comments = item.Comments,
IncomeCost = item.IncomeCost,
OrderNumber = await GetLastOrderNumber(),
IsBank = item.IsBank
};
executed += await _dappercontext.ExecuteAsync("SP_AddProductSale", n, CommandType : System.Data.CommandType.StoredProcedure);
}
return(new ResponseMessage <int>()
{
entity = executed, IsSuccessCode = true
});
}
public async Task <ActionResult <ReturnView> > DeleteUnits(int id)
{
try
{
await _dappercontext.ExecuteAsync("SP_DeleteProductReturn", new { Id = id }, CommandType : System.Data.CommandType.StoredProcedure);
}
catch (Exception ex)
{
return(BadRequest());
}
return(new ReturnView());
}
public async Task <ActionResult <ProductIncoms> > DeleteProductIncoms(int id)
{
var productIncoms = await _context.ProductIncoms.FindAsync(id);
if (productIncoms == null)
{
return(NotFound());
}
await _dappercontext.ExecuteAsync("SP_DeleteProductIncome", new { Id = id }, CommandType : System.Data.CommandType.StoredProcedure);
return(productIncoms);
}
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);
}
//public async Task<bool> AddRefreshToken(Sys_RefreshToken token)
//{
// var existingToken = _sysctx.Sys_RefreshToken.SingleOrDefault(r => r.Subject == token.Subject);
// if (existingToken != null)
// {
// var result = await RemoveRefreshToken(existingToken.Id);
// }
// _sysctx.Sys_RefreshToken.Add(token);
// return await _sysctx.SaveChangesAsync() > 0;
//}
public async Task <bool> RemoveRefreshToken(string refreshTokenId)
{
// var refreshToken = _sysctx.Sys_RefreshToken.SingleOrDefault(r=>r.Id==refreshTokenId);
var refreshToken = DapperContext.QueryNormal(string.Format("select * from Sys_RefreshToken where Id={0}", refreshTokenId));
if (refreshToken.total > 0)
{
return(await DapperContext.ExecuteAsync(string.Format("delete from Sys_RefreshToken where Id={0}", refreshTokenId)) > 0);
// _sysctx.Sys_RefreshToken.Remove(refreshToken);
//return await _sysctx.SaveChangesAsync() > 0;
}
return(false);
}
