public ActionResult EditNews(int id, Ogloszenia ogloszenie) { if (ModelState.IsValid) { var news = db.Ogloszenia.AsNoTracking().Where(u => u.id_ogloszenia == id).FirstOrDefault(); ogloszenie.data_dodania = news.data_dodania; db.Entry(ogloszenie).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("News")); } return(View()); }
public ActionResult CreateNews(FormCollection formCollection) { Ogloszenia ogloszenie = new Ogloszenia(); ogloszenie.tytul = formCollection["tytul"]; DateTime dataDodania = DateTime.Now; ogloszenie.data_dodania = dataDodania; ogloszenie.data_waznosci = Convert.ToDateTime(formCollection["dataWaznosci"]); ogloszenie.id_statusu = 1; ogloszenie.tresc = formCollection["tresc"]; db.Ogloszenia.Add(ogloszenie); db.SaveChanges(); return(RedirectToAction("News")); }
public ActionResult SendNotice(FormCollection formCollection) { if (ModelState.IsValid) { int personID = Convert.ToInt32(Session["personID"]); var teacher = db.Nauczyciele.Where(n => n.id_osoby == personID).FirstOrDefault(); int classID = db.Klasy.Where(k => k.id_wychowawcy == teacher.id_nauczyciela).FirstOrDefault().id_klasy; var students = db.Uczniowie.Where(u => u.id_klasy == classID).ToList(); var parents = students.Select(s => s.Rodzic.Osoba.email).ToList(); try { var senderEmail = new MailAddress("*****@*****.**", teacher.Osoba.FullName); var password = "******"; var subject = formCollection["tytul"]; var message = formCollection["tresc"]; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(senderEmail.Address, password) }; foreach (var parent in parents) { var receiverEmail = new MailAddress(parent); using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = subject, Body = message }) { smtp.Send(mess); } } } catch (Exception) { ViewBag.Error = "Wystąpił błąd z wysłaniem wiadomości e-mail. Spróbuj ponownie."; return(View()); } Ogloszenia ogloszenie = new Ogloszenia(); ogloszenie.tytul = formCollection["tytul"]; ogloszenie.data_dodania = DateTime.Now; ogloszenie.data_waznosci = Convert.ToDateTime(formCollection["dataWaznosci"]); ogloszenie.id_statusu = 1; ogloszenie.tresc = formCollection["tresc"]; ogloszenie.id_klasy = classID; db.Ogloszenia.Add(ogloszenie); db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }