public void Add(DataAppointment dataAppointment)
{
using (var connection = new SqlConnection(_connectionString))
{
var cmd = connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddAppointment";
cmd.Parameters.AddWithValue(@"DoctorID", dataAppointment.DoctorID);
cmd.Parameters.AddWithValue(@"CabinetNumber", dataAppointment.CabinetNumber);
cmd.Parameters.AddWithValue(@"Day", dataAppointment.Day);
cmd.Parameters.AddWithValue(@"Hour", dataAppointment.Hour);
cmd.Parameters.AddWithValue(@"Minute", dataAppointment.Minute);
cmd.Parameters.AddWithValue(@"PatientID", dataAppointment.PatientID);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public void Add(DataAppointment dataAppointment)
{
_dataAppointment.Add(dataAppointment);
}
private void button1_Click(object sender, EventArgs e)
{
if (!doctor.HaveDoctor(id))
{
MessageBox.Show("неверный id доктора!");
}
else if (!cabinet.HaveCabinet(num))
{
MessageBox.Show("неверный номер кабинета!");
}
else
{
int oneday = 0;
day = -1;
for (int i = 0; i < checkedListBox1.Items.Count; i++)
{
// Отмечен ли элемент?
if (checkedListBox1.GetItemChecked(i))
{
day = i;
++oneday;
}
}
if (oneday != 1)
{
MessageBox.Show("Выберите 1 день!");
}
else if (!dataAppointment.FreeCabinet(num, day))
{
MessageBox.Show("кабинет занят в этот день!");
}
else
{
if (!doctor.HaveDay(id, day))
{
MessageBox.Show("доктор не работает в этот день!");
}
else if (!dataAppointment.FreeDoctor(id, day))
{
MessageBox.Show("доктор имеет кабинет в этот день!");
}
else
{
var doctor1 = doctor.GetByID(id);
foreach (Doctor newdoc in doctor1)
{
Doctor doctor2 = newdoc;
if ((int)doctor2.WorkDays[day] == '1')
{
if (doctor2.WorkHours == 1)
{
int hour = 8;
int minute = 0;
while (hour < 13)
{
DataAppointment data = new DataAppointment(id, num, day, hour, minute, 0);
dataAppointment.Add(data);
if (minute == 30)
{
++hour;
minute = 0;
}
else if (minute == 0)
{
minute = 30;
}
}
}
else if (doctor2.WorkHours == 2)
{
int hour = 14;
int minute = 0;
while (hour < 19)
{
DataAppointment data = new DataAppointment(id, num, day, hour, minute, 0);
dataAppointment.Add(data);
if (minute == 30)
{
++hour;
minute = 0;
}
else if (minute == 0)
{
minute = 30;
}
}
}
}
}
Close();
}
}
}
}
