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