public static void CreateMagazineShipping(UsersSubscription usersSubscription) { using (var context = new MagazineContext()) { List <MagazineShipping> magazines = new List <MagazineShipping>(); foreach (Magazine magazine in context.Magazines.ToList()) { MagazineShipping newMagazineShipping = new MagazineShipping() { UsersSubscription = usersSubscription, Magazine = magazine, DeliverTime = DateTime.Now, IsDelivered = true }; magazines.Add(newMagazineShipping); } do { Console.WriteLine("Если вы получили все журналы нажмите на 1"); string delivered = Console.ReadLine().Trim(); if (delivered == "1") { context.MagazineShippings.AddRange(magazines); context.SaveChanges(); break; } } while (true); } }
public ActionResult DeleteConfirmed(int id) { UsersSubscription usersSubscription = db.UsersSubscriptions.Find(id); db.UsersSubscriptions.Remove(usersSubscription); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,UserId,SubscriptionId,Date,ExpireDate,Remarks")] UsersSubscription usersSubscription) { if (ModelState.IsValid) { db.Entry(usersSubscription).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SubscriptionId = new SelectList(db.Subscriptions, "id", "Name", usersSubscription.SubscriptionId); ViewBag.UserId = new SelectList(db.Users, "id", "Name", usersSubscription.UserId); return(View(usersSubscription)); }
// GET: UserSubscription/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UsersSubscription usersSubscription = db.UsersSubscriptions.Find(id); if (usersSubscription == null) { return(HttpNotFound()); } return(View(usersSubscription)); }
public static UsersSubscription AddSubsription(User user, SubsritionsType subsritionsType) { using (var context = new MagazineContext()) { UsersSubscription newUsersSubscription = new UsersSubscription() { Subscription = context.Subscriptions.Where(sub => sub.SubscriptionsTimeInMonth == (int)subsritionsType).SingleOrDefault(), User = context.Users.Where(searchUser => searchUser.Id == user.Id).SingleOrDefault() }; context.UsersSubscriptions.Add(newUsersSubscription); context.SaveChanges(); return(newUsersSubscription); } }
// GET: UserSubscription/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UsersSubscription usersSubscription = db.UsersSubscriptions.Find(id); if (usersSubscription == null) { return(HttpNotFound()); } ViewBag.SubscriptionId = new SelectList(db.Subscriptions, "id", "Name", usersSubscription.SubscriptionId); ViewBag.UserId = new SelectList(db.Users, "id", "Name", usersSubscription.UserId); return(View(usersSubscription)); }
public ActionResult Create([Bind(Include = "id,UserId,SubscriptionId,Date,ExpireDate,Remarks")] UsersSubscription usersSubscription) { var v = db.Subscriptions.Find(usersSubscription.SubscriptionId); usersSubscription.Date = DateTime.Now; usersSubscription.ExpireDate = DateTime.Now.AddDays(v.DurationDay); if (ModelState.IsValid) { db.UsersSubscriptions.Add(usersSubscription); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SubscriptionId = new SelectList(db.Subscriptions, "id", "Name", usersSubscription.SubscriptionId); ViewBag.UserId = new SelectList(db.Users, "id", "Name", usersSubscription.UserId); return(View(usersSubscription)); }