public void Delete(int id) { var sql = "DELETE FROM public.notes WHERE id = @Id"; var parameters = new { Id = id }; _postgreSQL.Execute(sql, parameters); }
public void Update(int id, string newPassword) { var sql = "UPDATE public.user SET password = @newPassword WHERE id = @Id"; var parameters = new { Id = id, NewPassword = newPassword }; _postgreSQL.Execute(sql, parameters); }
public IActionResult Update(FirmaDto firmaDto) { try { string sql = @" UPDATE Firma SET Unvan = @Unvan, Telefon = @Telefon, Mail = @Mail, Adres = @Adres, VergiNo = @VergiNo WHERE FirmaID = @FirmaID "; object param = new { FirmaID = firmaDto.FirmaID, Unvan = firmaDto.Unvan, Telefon = firmaDto.Telefon, Mail = firmaDto.Mail, Adres = firmaDto.Adres, VergiNo = firmaDto.VergiNo }; _dapperFirmaService.Execute(sql, param); return(Ok()); } catch (Exception ex) { return(NotFound(ex.Message)); } }
public IActionResult Update(KiralamaDto kiralamaDto) { try { string sql = @" UPDATE Kiralama SET AliciID = @AliciID, ArabaID = @ArabaID, BaslangicTarihi = @BaslangicTarihi, BitisTarihi = @BitisTarihi, TeslimTarihi = @TeslimTarihi WHERE KiralamaID = @KiralamaID "; object param = new { KiralamaID = kiralamaDto.KiralamaID, AliciID = kiralamaDto.AliciID, ArabaID = kiralamaDto.ArabaID, BaslangicTarihi = kiralamaDto.BaslangicTarihi, BitisTarihi = kiralamaDto.BitisTarihi, TeslimTarihi = kiralamaDto.TeslimTarihi }; _dapperKiralamaService.Execute(sql, param); return(Ok()); } catch (Exception ex) { return(NotFound(ex.Message)); } }
public void UpdateUserImagePath(Int64 userId, string imagePath) { var _param = new DynamicParameters(); _param.Add("@ouser_id", userId, DbType.Int64); _param.Add("@oprofile_photo", imagePath, DbType.String); _dapperService.Execute("API_UpdateProfilePicture", _param, CommandType.StoredProcedure); }
public async Task <int> Delete(int ItemId) { var result = await Task.FromResult(_dapper.Execute($"delete from Item where ItemId = {ItemId}", null, commandType: CommandType.Text)); return(result); }
public async Task <int> Delete(int monsterId) { var result = await Task.FromResult(_dapper.Execute($"delete from Monster where MonsterId = {monsterId}", null, commandType: CommandType.Text)); return(result); }
public Task <int> Delete(int id) { var deleteTeam = Task.FromResult(_dapperService.Execute($"Delete [Teams] where TeamID = {id}", null, commandType: CommandType.Text)); return(deleteTeam); }
public async Task <int> Delete(int Id) { var result = await Task.FromResult(_dapper.Execute($"Delete [Player] Where PlayerId = {Id}", null, commandType: CommandType.Text)); return(result); }