public async Task <IActionResult> AddBranchAsync([FromBody] MBranch branch) { if (!await productsRepository.IsProductSellerAsync(branch.ProductId, int.Parse(User.Identity.Name))) { return(BadRequest()); } return(Ok(await branchesRepository.AddBranchAsync(branch))); }
public async Task <MBranch> AddBranchAsync(MBranch branch) { const string sql = "INSERT INTO dbo.Branches (Name, Description, ProductId, IsEnabled) " + "OUTPUT INSERTED.Id, INSERTED.Name, INSERTED.Description, INSERTED.IsEnabled, INSERTED.CreateDate " + "VALUES (@Name, @Description, @ProductId, @IsEnabled);"; branch = await connection.QuerySingleAsync <MBranch>(sql, branch); branch.Versions = new List <MVersion>(); return(branch); }
public async Task <IActionResult> PutBranchAsync([FromBody] MBranch branch) { if (!await branchesRepository.IsBranchSellerAsync(branch.Id, int.Parse(User.Identity.Name))) { return(BadRequest()); } await branchesRepository.UpdateBranchAsync(branch); return(Ok()); }
public async Task UpdateBranchAsync(MBranch branch) { const string sql = "UPDATE dbo.Branches SET Name = @Name, Description = @Description, " + "IsEnabled = @IsEnabled WHERE Id = @Id;"; await connection.ExecuteAsync(sql, branch); }