public ActionResult ChangeWedding(WeddingOfferViewModel WeddingOfferViewModel) { using (var db = new OtherDbContext()) { var currentUserId = User.Identity.GetUserId(); var WeddingToChange = new WeddingOfferViewModel { Offer = new List <OfferViewModel>(), Wedding = new WeddingViewModels() }; //Pobranie wesela i przypisanie nowych wartości WeddingToChange.Wedding = db.Weddings.Where(x => x.UserId == currentUserId).FirstOrDefault(); WeddingToChange.Wedding.LocationOfWedding = WeddingOfferViewModel.Wedding.LocationOfWedding; WeddingToChange.Wedding.NumberOfGuests = WeddingOfferViewModel.Wedding.NumberOfGuests; var WeddingOffers = db.Wedding2Offers.Where(x => x.Wedding_Id == WeddingToChange.Wedding.Id).ToList(); foreach (var item in WeddingOffers) { db.Wedding2Offers.Remove(item); } //Przypisanie ID oferty do ID wesela i dodanie do kontekstu DB var selectedOffer = WeddingOfferViewModel.Offer.Where(x => x.IsChecked == true).ToList(); foreach (var item in selectedOffer) { var Wedding2Offer = new Wedding2OfferViewModel { Wedding_Id = WeddingToChange.Wedding.Id, Offer_Id = item.Id }; db.Wedding2Offers.Add(Wedding2Offer); } //Dodanie danych o weselu i zapisanie zmian w bazie danych. db.SaveChanges(); ViewBag.Message = "Pomyslnie zmieniono dane!"; return(RedirectToAction("Index", "Home")); } }
public ActionResult BookDate(WeddingOfferViewModel WeddingOfferViewModel) { var appdb = new ApplicationDbContext(); var currentUserId = User.Identity.GetUserId(); var currentUser = appdb.Users.Where(x => x.Id == currentUserId).FirstOrDefault(); using (var db = new OtherDbContext()) { var NewWedding = new WeddingOfferViewModel { Wedding = new WeddingViewModels { UserId = User.Identity.GetUserId(), Date = WeddingOfferViewModel.Wedding.Date, NumberOfGuests = WeddingOfferViewModel.Wedding.NumberOfGuests, LocationOfWedding = WeddingOfferViewModel.Wedding.LocationOfWedding, IsConfirmed = false } }; //Przypisanie ID oferty do ID wesela i dodanie do kontekstu DB var selectedOffer = WeddingOfferViewModel.Offer.Where(x => x.IsChecked == true).ToList(); foreach (var item in selectedOffer) { var Wedding2Offer = new Wedding2OfferViewModel { Wedding_Id = NewWedding.Wedding.Id, Offer_Id = item.Id }; db.Wedding2Offers.Add(Wedding2Offer); } //Dodanie danych o weselu i zapisanie zmian w bazie danych. db.Weddings.Add(NewWedding.Wedding); db.SaveChanges(); string message = "Uzytkownik " + currentUser.FirstName + " " + currentUser.LastName + " zarezerwowal termin " + NewWedding.Wedding.Date + " . Skontaktuj sie z nim!"; string subject = "Zarezerwowano nowe wesele!"; EmailHelper.SendEmail(message, subject, "*****@*****.**"); return(RedirectToAction("Index", "Home")); } }