public async Task <IActionResult> Save(KiralamaDto kiralamaDto)
{
try
{
string sql = @"
INSERT INTO
Kiralama
(AliciID, ArabaID, BaslangicTarihi, BitisTarihi)
VALUES
(@AliciID, @ArabaID, @BaslangicTarihi, @BitisTarihi)
";
object param = new
{
AliciID = kiralamaDto.AliciID,
ArabaID = kiralamaDto.ArabaID,
BaslangicTarihi = kiralamaDto.BaslangicTarihi,
BitisTarihi = kiralamaDto.BitisTarihi
};
await _dapperKiralamaService.ExecuteAsync(sql, param);
return(Ok());
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public async Task <IActionResult> Save(FirmaDto firmaDto)
{
try
{
string sql = @"
INSERT INTO
Firma
(Unvan, Telefon, Mail, Adres, VergiNo)
VALUES
(@Unvan, @Telefon, @Mail, @Adres, @VergiNo)
";
object param = new
{
Unvan = firmaDto.Unvan,
Telefon = firmaDto.Telefon,
Mail = firmaDto.Mail,
Adres = firmaDto.Adres,
VergiNo = firmaDto.VergiNo
};
await _dapperFirmaService.ExecuteAsync(sql, param);
return(Ok());
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <bool> Add(TestModel model)
{
return(await dapper.ExecuteAsync <int>(SQL_Insert, new
{
model.Description
}) > 0);
}