private void buttonSend_Click(object sender, EventArgs e)
{
int ReservationID = 0;
List <string> MailList = new List <string>();
List <string> Time = new List <string>();
List <int> RoomID = new List <int>();
foreach (DataGridViewRow item in dataGridViewParticipants.SelectedRows)
{
string MailAdress = item.Cells[1].Value.ToString();
ReservationID = (int)comboBoxReservationID.SelectedItem;
Time = Db.Reservations.Where(x => x.ReservationID == ReservationID).Select(x => x.StartTime).ToList();
RoomID = Db.Reservations.Where(x => x.ReservationID == ReservationID).Select(x => x.MeetingRoomID).ToList();
MailList.Add(MailAdress);
}
MailProcedure.SendMail(MailList, RoomID[0], Time[0]);
}
public static void Control()
{
ReservationsEntities3 Db = new ReservationsEntities3();
List <int> ReservationIDList = Db.Reservations.Select(x => x.ReservationID).ToList();
List <string> MailList = new List <string>();
List <int> RoomID = new List <int>();
List <string> Time = new List <string>();
foreach (var item in ReservationIDList)
{
if (DateTime.Today.Date.AddDays(1) == Convert.ToDateTime(Db.Reservations.Where(x => x.ReservationID == item).Select(x => x.Date.Value)))
{
MailList = Db.Participants.Where(x => x.ReservationID == item).Select(x => x.MailAdress).ToList();
Time = Db.Reservations.Where(x => x.ReservationID == item).Select(x => x.StartTime).ToList();
RoomID = Db.Reservations.Where(x => x.ReservationID == item).Select(x => x.MeetingRoomID).ToList();
MailProcedure.SendMail(MailList, RoomID[0], Time[0]);
}
}
}
