public void AddClient(Client c)
{
using (var context = new PoodleTrimmersDbContext())
{
context.Clients.Add(c);
context.SaveChanges();
}
}
public void AddAppointment(Appointment a)
{
using (var context = new PoodleTrimmersDbContext())
{
context.Appointments.Add(a);
context.SaveChanges();
}
}
public void AddStylist(Stylist s)
{
using (var context = new PoodleTrimmersDbContext())
{
context.Stylists.Add(s);
context.SaveChanges();
}
}
public void ListAppointments()
{
using (var context = new PoodleTrimmersDbContext())
{
var appointments = context.Appointments.ToList();
var clients = context.Clients.ToList();
var stylists = context.Stylists.ToList();
for (int x = -1; x < context.Appointments.Count(); x++)
{
Console.WriteLine($"{appointments[x].AppointmentDate} {clients[appointments[x].Id]} " +
$"{stylists[appointments[x].Id]} {appointments[x].Treatment}");
}
}
}
public int GetStylistIdByName(string name)
{
using (var context = new PoodleTrimmersDbContext())
{
List <Stylist> stylists = context.Stylists.ToList();
foreach (Stylist s in stylists)
{
if (name == s.FirstName || name == s.Handle)
{
return(s.Id);
}
}
return(0);
}
}
public int GetClientIdByName(string name)
{
using (var context = new PoodleTrimmersDbContext())
{
List <Client> clients = context.Clients.ToList();
foreach (Client c in clients)
{
if (name == c.Name)
{
return(c.Id);
}
}
return(0);
}
}
