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