public static bool DeleteAppointments(string connectionString, IEnumerable <Appointment> appointments)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
foreach (var customer in appointments.Select(customer => new Appointment()
{
ID = customer.ID
}))
{
context.Appointments.Attach(customer);
context.Appointments.Remove(customer);
}
var result = context.SaveChanges();
return(result > 0);
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return(false);
}
}
public static AppointmentCollection GetAppointments(string connectionString, DateTime appointmentDate)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
var items = context.Appointments.Where(x => x.AppointmentDate == appointmentDate);
return(new AppointmentCollection(items.ToList()));
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return(null);
}
}
public static AppointmentCollection GetAppointments(string connectionString, DateTime appointmentDate)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
var items = context.Appointments.Where(x => x.AppointmentDate == appointmentDate);
return new AppointmentCollection(items.ToList());
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return null;
}
}
public static bool AddAppointment(string connectionString, Appointment appointment)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
context.Appointments.Add(appointment);
var result = context.SaveChanges();
return(result > 0);
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return(false);
}
}
public static bool AddAppointment(string connectionString, Appointment appointment)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
context.Appointments.Add(appointment);
var result = context.SaveChanges();
return result > 0;
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return false;
}
}
public static bool DeleteAppointments(string connectionString, IEnumerable<Appointment> appointments)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
foreach (var customer in appointments.Select(customer => new Appointment() {ID = customer.ID}))
{
context.Appointments.Attach(customer);
context.Appointments.Remove(customer);
}
var result = context.SaveChanges();
return result > 0;
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return false;
}
}
public static bool UpdateAppointments(string connectionString, IEnumerable <Appointment> appointments)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
foreach (var appointment in appointments)
{
context.Appointments.Add(appointment);
var entry = context.Entry(appointment);
entry.State = EntityState.Modified;
}
var result = context.SaveChanges();
return(result > 0);
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return(false);
}
}
public static bool UpdateAppointments(string connectionString, IEnumerable<Appointment> appointments)
{
try
{
using (var context = new AppointmentDBContext(connectionString))
{
foreach (var appointment in appointments)
{
context.Appointments.Add(appointment);
var entry = context.Entry(appointment);
entry.State = EntityState.Modified;
}
var result = context.SaveChanges();
return result > 0;
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return false;
}
}
