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