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(); } } } }