Skip to content

Instantly share code, notes, and snippets.

View emrekizildas's full-sized avatar
🎯
Focusing

Emre Kızıldaş emrekizildas

🎯
Focusing
71 followers · 25 following
View GitHub Profile
@emrekizildas
emrekizildas / DatabaseService.cs
Created March 19, 2019 13:46
services.AddEntityFrameworkNpgsql()
.AddDbContext<DatabaseContext>()
.BuildServiceProvider();
@emrekizildas
emrekizildas / ServiceController.cs
Created March 19, 2019 14:03
private readonly DatabaseContext _db;
public ServiceController(DatabaseContext context)
{
_db = context;
}
@emrekizildas
emrekizildas / GetBook.cs
Last active March 19, 2019 14:40
[HttpGet("{id}")]
public async Task<ActionResult<BookInfoDto>> GetBook(int id)
{
BookInfoDto book = await _db.Books
.Select(x => new BookInfoDto() { BookID = x.BookID, Name = x.Name, AuthorName = x.Author.Name })
.SingleOrDefaultAsync(x => x.BookID == id);
if (book == null)
return NotFound("İstenilen kitap bulunamadı");
return Ok(book);
@emrekizildas
emrekizildas / GetBooks.cs
Created March 19, 2019 14:43
[HttpGet]
public async Task<IActionResult> GetBooks()
{
List<BookInfoDto> books = await _db.Books
.Select(x => new BookInfoDto() { BookID = x.BookID, Name = x.Name, AuthorName = x.Author.Name })
.ToListAsync();
if (books.Count() == 0)
return NotFound();
@emrekizildas
emrekizildas / ServiceController.cs
Created March 19, 2019 16:26
Son hali
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using CoreAPI.DTOs;
using CoreAPI.Models;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
namespace CoreAPI.Controllers
@emrekizildas
emrekizildas / HomeController.cs
Created March 19, 2019 16:52
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
namespace CoreAPI.Controllers
{
[Route("[controller]/[action]")]
public class HomeController : Controller
@emrekizildas
emrekizildas / Index.cshtml
Created March 19, 2019 16:56
<html>
<head>
<title>.NET Core Web API</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
</head>
<body>
</body>
</html>
@emrekizildas
emrekizildas / Index.cshtml
Created March 19, 2019 16:58
<div class="container" style="margin-top:50px;">
<div class="row">
<div class="col-md-4">
<button class="btn btn-success" id="kitaplariGetir">Kitapları Getir</button>
</div>
<div class="col-md-8">
<div id="getBooksArea">
<ul id="getBooks"></ul>
</div>
</div>
@emrekizildas
emrekizildas / getBooks.js
Created March 19, 2019 17:08
$("#kitaplariGetir").click(function(){
$.ajax({
type: 'GET',
url: '/api/Service/GetBooks',
success: function(books){
$("#getBooks").html("");
$.each(books, function(index, value){
$("#getBooks").append("<li>Kitap Adı: <b>"+value.name+" - Yazarı: <b>"+value.authorName+"</b>");
});
}
@emrekizildas
emrekizildas / getAuthors.js
Created March 19, 2019 17:15
$("#yazarlariGetir").click(function(){
$.ajax({
type: 'GET',
url: '/api/Service/GetAuthors',
success: function(books){
$("#getAuthors").html("");
$.each(books, function(index, value){
$("#getAuthors").append("<li>Yazar Adı: <b>"+value.authorName+" - Kitap Sayısı: <b>"+value.totalBook+"</b>");
});
}