public int DeleteAppointment(int appointmentId)
{
int i = 0;
using (SqlCommand command = new SqlCommand())
{
i = ExecuteNonQuery(AppointmentStrings.DeleteAppointment(appointmentId));
}
return(i);
}
public List <Appointment> GetAppointmentsByEnd(DateTime endDate)
{
DataTable dt = new DataTable();
List <Appointment> arrAppointments = new List <Appointment>();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(AppointmentStrings.GetAppointmentsByEnd(endDate));
}
foreach (DataRow ms in dt.Rows)
{
arrAppointments.Add(Appointment.ToObject(ms));
}
return(arrAppointments);
}
public Appointment UpdateAppointment(Appointment tmpAppointment)
{
bool avaliable;
bool hours;
bool days;
avaliable = CheckIfAppointmentAvaliable(tmpAppointment.appointmentDate, tmpAppointment.startTime, tmpAppointment.endTime, tmpAppointment.appointmentId);
if (avaliable)
{
//hours = CheckAppointmentTime(tmpAppointment);
//if (hours)
//{
// days = CheckAppointmentDay(tmpAppointment);
// if (days)
// {
DataTable dt = new DataTable();
Appointment appointment = new Appointment();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(AppointmentStrings.UpdateAppointment(tmpAppointment));
}
foreach (DataRow ms in dt.Rows)
{
appointment = Appointment.ToObject(ms);
}
return(appointment);
}
// else
// {
// throw new DayNotAvaliableException("The Day Is Not Avaliable");
// }
// }
// else
// {
// throw new DurationNotAvaliableException("The Duration Is Not Avaliable");
// }
//}
else
{
throw new DateNotAvaliableException("The Time Is Not Avaliable");
}
}
public Appointment GetOneAppointment(int appointmentId)
{
if (appointmentId < 0)
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
Appointment appointment = new Appointment();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(AppointmentStrings.GetOneAppointment(appointmentId));
}
foreach (DataRow ms in dt.Rows)
{
appointment = Appointment.ToObject(ms);
}
return(appointment);
}