public async Task <IHttpActionResult> Get()
{
var context = new DAL.AppDBContext();
var clients = await context.Clients.ToArrayAsync();
return(Ok(clients));
}
static void Main(string[] args)
{
using (var context = new DAL.AppDBContext())
{
var customers = context.Customers.ToList();
foreach (var cust in customers)
{
Console.WriteLine(cust.id + " " + cust.customer + " " + cust.address);
}
}
}
public async Task <IHttpActionResult> Get(int id)
{
var context = new DAL.AppDBContext();
var client = await context.Clients.FindAsync(id);
if (client == null)
{
return(NotFound());
}
return(Ok(client));
}
static void Main(string[] args)
{
using (var context = new DAL.AppDBContext())
{
var customers = context.Customers.ToList();
foreach (var cust in customers)
{
Console.WriteLine(cust.id + " " + cust.customer + " " + cust.address);
}
}
}
public async Task <IHttpActionResult> Post([FromBody] Models.Client client)
{
try
{
var context = new DAL.AppDBContext();
context.Clients.Add(client);
await context.SaveChangesAsync();
return(Ok());
}
catch
{
return(InternalServerError());
}
}
private static void GenerateClientsRecords(DAL.AppDBContext context)
{
if (context.Clients.Count() == 0)
{
for (int i = 1; i <= 100; i++)
{
var client = new Models.Client();
client.FirstName = $"First Name {i}";
client.LastName = $"Last Name {i}";
context.Clients.Add(client);
}
context.SaveChanges();
}
}
