public ActionResult Edit([Bind(Include = "Id,UserId,SchedulerId")] UserScheduler userScheduler) { if (ModelState.IsValid) { db.Entry(userScheduler).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SchedulerId = new SelectList(db.Schedulers, "Id", "Id", userScheduler.SchedulerId); ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName", userScheduler.UserId); return(View(userScheduler)); }
// GET: UserScheduler/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserScheduler userScheduler = db.UserSchedulers.Find(id); if (userScheduler == null) { return(HttpNotFound()); } return(View(userScheduler)); }
// GET: UserScheduler/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserScheduler userScheduler = db.UserSchedulers.Find(id); if (userScheduler == null) { return(HttpNotFound()); } ViewBag.SchedulerId = new SelectList(db.Schedulers, "Id", "Id", userScheduler.SchedulerId); ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName", userScheduler.UserId); return(View(userScheduler)); }
public ActionResult Create(int schedulerId) { var userId = User.Identity.GetUserId(); var asdasd = db.UserSchedulers.Where(us => us.UserId == userId && us.SchedulerId == schedulerId).FirstOrDefault(); if (db.UserSchedulers.Where(us => us.UserId == userId && us.SchedulerId == schedulerId).FirstOrDefault() == null) { var userScheduler = new UserScheduler(); userScheduler.UserId = userId; userScheduler.SchedulerId = schedulerId; db.UserSchedulers.Add(userScheduler); db.SaveChanges(); return(Json("success", JsonRequestBehavior.AllowGet)); } else { return(Json("error", JsonRequestBehavior.AllowGet)); } }
protected override void Seed(GymManagement.Data.ApplicationDbContext context) { var packages = new Package[] { new Package { Id = 1, Name = "Dance for health", Price = 200 }, new Package { Id = 2, Name = "Body strength", Price = 200 }, new Package { Id = 3, Name = "Fit for life", Price = 250 }, new Package { Id = 4, Name = "Superstar for him", Price = 550 }, new Package { Id = 5, Name = "Superstar for her", Price = 500 }, new Package { Id = 6, Name = "Step & Tone", Price = 150 }, new Package { Id = 7, Name = "Functional Training", Price = 150 } }; context.Packages.AddOrUpdate(packages); context.SaveChanges(); var courseTypes = new CourseType[] { new CourseType { Id = 1, Name = "Zumba", PackageId = 1 }, new CourseType { Id = 2, Name = "Kangoo Jumps", PackageId = 1 }, new CourseType { Id = 3, Name = "Aerobic", PackageId = 1 }, new CourseType { Id = 4, Name = "Spinning", PackageId = 2 }, new CourseType { Id = 5, Name = "Fitness", PackageId = 2 }, new CourseType { Id = 6, Name = "Body building", PackageId = 2 }, new CourseType { Id = 7, Name = "Cycling", PackageId = 3 }, new CourseType { Id = 8, Name = "Yoga", PackageId = 3 }, new CourseType { Id = 9, Name = "Core strength", PackageId = 3 }, new CourseType { Id = 10, Name = "Tae bo", PackageId = 4 }, new CourseType { Id = 11, Name = "Circuit training", PackageId = 4 }, new CourseType { Id = 12, Name = "Body pump", PackageId = 4 }, new CourseType { Id = 13, Name = "Pilates", PackageId = 5 }, new CourseType { Id = 14, Name = "Stretching", PackageId = 5 }, new CourseType { Id = 15, Name = "Meditation", PackageId = 5 }, new CourseType { Id = 16, Name = "X-treme abs", PackageId = 6 }, new CourseType { Id = 17, Name = "Functional Exercies", PackageId = 7 } }; context.CourseTypes.AddOrUpdate(courseTypes); context.SaveChanges(); var courses = new Course[] { new Course { Id = 1, Name = "Zumba for begginers", Dificulty = CourseDifficulty.Easy, CourseTypeId = 1 }, new Course { Id = 2, Name = "Zumba workout", Dificulty = CourseDifficulty.Medium, CourseTypeId = 1 }, new Course { Id = 3, Name = "Zumba for life", Dificulty = CourseDifficulty.Hard, CourseTypeId = 1 }, new Course { Id = 2, Name = "Kangoo Jumps", Dificulty = CourseDifficulty.Easy, CourseTypeId = 1 }, new Course { Id = 3, Name = "Aerobic", Dificulty = CourseDifficulty.Easy, CourseTypeId = 1 }, new Course { Id = 4, Name = "Spinning", Dificulty = CourseDifficulty.Easy, CourseTypeId = 2 }, new Course { Id = 5, Name = "Fitness", Dificulty = CourseDifficulty.Easy, CourseTypeId = 2 }, new Course { Id = 6, Name = "Body building", Dificulty = CourseDifficulty.Easy, CourseTypeId = 2 }, new Course { Id = 7, Name = "Cycling", Dificulty = CourseDifficulty.Easy, CourseTypeId = 3 }, new Course { Id = 8, Name = "Yoga", Dificulty = CourseDifficulty.Medium, CourseTypeId = 3 }, new Course { Id = 9, Name = "Core strength", Dificulty = CourseDifficulty.Medium, CourseTypeId = 3 }, new Course { Id = 10, Name = "Tae bo", Dificulty = CourseDifficulty.Medium, CourseTypeId = 4 }, new Course { Id = 11, Name = "Circuit training", Dificulty = CourseDifficulty.Medium, CourseTypeId = 4 }, new Course { Id = 12, Name = "Body pump", Dificulty = CourseDifficulty.Medium, CourseTypeId = 4 }, new Course { Id = 13, Name = "Pilates", Dificulty = CourseDifficulty.Medium, CourseTypeId = 5 }, new Course { Id = 14, Name = "Stretching", Dificulty = CourseDifficulty.Hard, CourseTypeId = 5 }, new Course { Id = 15, Name = "Meditation", Dificulty = CourseDifficulty.Hard, CourseTypeId = 5 }, new Course { Id = 16, Name = "X-treme abs", Dificulty = CourseDifficulty.Hard, CourseTypeId = 6 }, new Course { Id = 17, Name = "Functional Exercies", Dificulty = CourseDifficulty.Hard, CourseTypeId = 7 } }; context.Courses.AddOrUpdate(courses); context.SaveChanges(); var addresses = new Address[] { new Address { Id = 1, Name = "Main Building", Street = "Mihail Kogalniceanu", StreetNumber = 1, Latitude = 46.7677898, Longitude = 23.593690700000025 }, new Address { Id = 2, Name = "Second Building", Street = "Strada Dunării", StreetNumber = 22, Latitude = 46.77616219999999, Longitude = 23.628539100000012 }, new Address { Id = 3, Name = "Third Building", Street = "Strada Ciprian Porumbescu", StreetNumber = 20, Latitude = 46.7608188, Longitude = 23.579431099999965 }, }; context.Addresses.AddOrUpdate(addresses); context.SaveChanges(); var rooms = new Room[] { new Room { Id = 1, Name = "A", NumberOfSeats = 20, AddressId = 1 }, new Room { Id = 2, Name = "B", NumberOfSeats = 21, AddressId = 1 }, new Room { Id = 3, Name = "C", NumberOfSeats = 11, AddressId = 1 }, new Room { Id = 4, Name = "D", NumberOfSeats = 9, AddressId = 1 }, new Room { Id = 5, Name = "E", NumberOfSeats = 200, AddressId = 2 }, new Room { Id = 6, Name = "F", NumberOfSeats = 5, AddressId = 2 }, new Room { Id = 7, Name = "G", NumberOfSeats = 10, AddressId = 2 }, new Room { Id = 8, Name = "H", NumberOfSeats = 34, AddressId = 3 }, new Room { Id = 9, Name = "I", NumberOfSeats = 11, AddressId = 3 }, new Room { Id = 10, Name = "J", NumberOfSeats = 5, AddressId = 3 }, }; context.Rooms.AddOrUpdate(rooms); context.SaveChanges(); var schedulers = new Scheduler[] { new Scheduler { Id = 1, DateTime = new DateTime(2018, 1, 15, 8, 0, 0), RoomId = 1, CourseId = 1 }, new Scheduler { Id = 2, DateTime = new DateTime(2018, 1, 15, 12, 0, 0), RoomId = 2, CourseId = 1 }, new Scheduler { Id = 3, DateTime = new DateTime(2018, 1, 15, 18, 0, 0), RoomId = 3, CourseId = 2 }, new Scheduler { Id = 4, DateTime = new DateTime(2018, 1, 15, 16, 0, 0), RoomId = 4, CourseId = 2 }, new Scheduler { Id = 5, DateTime = new DateTime(2018, 1, 16, 18, 0, 0), RoomId = 5, CourseId = 3 }, new Scheduler { Id = 6, DateTime = new DateTime(2018, 1, 16, 16, 0, 0), RoomId = 6, CourseId = 3 }, new Scheduler { Id = 7, DateTime = new DateTime(2018, 1, 17, 10, 0, 0), RoomId = 7, CourseId = 4 }, new Scheduler { Id = 8, DateTime = new DateTime(2018, 1, 10, 10, 0, 0), RoomId = 8, CourseId = 4 }, new Scheduler { Id = 6, DateTime = new DateTime(2018, 1, 18, 12, 0, 0), RoomId = 9, CourseId = 5 }, new Scheduler { Id = 7, DateTime = new DateTime(2018, 1, 25, 16, 0, 0), RoomId = 10, CourseId = 5 }, new Scheduler { Id = 8, DateTime = new DateTime(2018, 1, 19, 14, 0, 0), RoomId = 1, CourseId = 6 }, new Scheduler { Id = 9, DateTime = new DateTime(2018, 1, 19, 18, 0, 0), RoomId = 2, CourseId = 6 }, new Scheduler { Id = 10, DateTime = new DateTime(2018, 1, 20, 16, 0, 0), RoomId = 3, CourseId = 7 }, new Scheduler { Id = 11, DateTime = new DateTime(2018, 1, 20, 8, 0, 0), RoomId = 4, CourseId = 7 }, new Scheduler { Id = 12, DateTime = new DateTime(2018, 1, 21, 18, 0, 0), RoomId = 5, CourseId = 5 }, new Scheduler { Id = 13, DateTime = new DateTime(2018, 1, 22, 18, 0, 0), RoomId = 6, CourseId = 3 }, new Scheduler { Id = 14, DateTime = new DateTime(2018, 1, 14, 8, 0, 0), RoomId = 7, CourseId = 1 }, }; context.Schedulers.AddOrUpdate(schedulers); context.SaveChanges(); var subscriptions = new Subscription[] { new Subscription { Id = 1, PackageId = 1, StartDate = new DateTime(2017, 12, 8, 14, 0, 0), Validity = 30 }, new Subscription { Id = 2, PackageId = 2, StartDate = new DateTime(2017, 12, 8, 14, 0, 0), Validity = 30 }, }; context.Subscriptions.AddOrUpdate(subscriptions); context.SaveChanges(); var UserManager = new UserManager <User>(new UserStore <User>(context)); List <string> ids = new List <string>(); for (int i = 0; i <= 10; i++) { ids.Add(Guid.NewGuid().ToString()); } var users = new User[] { new User { Id = ids[0], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Maria", LastName = "Popescu", PhoneNumber = "0756321456", SubscriptionId = 1, IsAdmin = true }, new User { Id = ids[1], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Alina", LastName = "Toader", PhoneNumber = "0756321456", SubscriptionId = 1 }, new User { Id = ids[2], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Raluca", LastName = "Manea", PhoneNumber = "0756321456", SubscriptionId = 1 }, new User { Id = ids[3], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Bogdan", LastName = "Vorobet", PhoneNumber = "0756321456", SubscriptionId = 1 }, new User { Id = ids[4], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Andrei", LastName = "Vlad", PhoneNumber = "0756321456", SubscriptionId = 1 }, new User { Id = ids[5], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Daniel", LastName = "Neamtu", PhoneNumber = "0756321456", SubscriptionId = 1 }, new User { Id = ids[6], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Claudiu", LastName = "Ursuta", PhoneNumber = "0756321456", SubscriptionId = 1 }, new User { Id = ids[7], Email = "*****@*****.**", UserName = "******", PasswordHash = new PasswordHasher().HashPassword("Test1."), FirstName = "Andrei", LastName = "Caleniuc", PhoneNumber = "0756321456", SubscriptionId = 1 }, }; foreach (var user in users) { UserManager.Create(user); } var usercourses = new UserCourse[] { new UserCourse { Id = 1, CourseId = 1, UserId = ids[0] }, new UserCourse { Id = 2, CourseId = 1, UserId = ids[1] }, new UserCourse { Id = 3, CourseId = 1, UserId = ids[2] }, new UserCourse { Id = 4, CourseId = 2, UserId = ids[3] }, new UserCourse { Id = 5, CourseId = 2, UserId = ids[4] }, new UserCourse { Id = 6, CourseId = 2, UserId = ids[5] }, new UserCourse { Id = 7, CourseId = 3, UserId = ids[0] }, new UserCourse { Id = 8, CourseId = 3, UserId = ids[6] }, new UserCourse { Id = 9, CourseId = 3, UserId = ids[7] }, new UserCourse { Id = 10, CourseId = 3, UserId = ids[5] }, new UserCourse { Id = 11, CourseId = 4, UserId = ids[0] }, new UserCourse { Id = 12, CourseId = 4, UserId = ids[5] }, new UserCourse { Id = 13, CourseId = 5, UserId = ids[0] }, new UserCourse { Id = 14, CourseId = 5, UserId = ids[1] }, new UserCourse { Id = 15, CourseId = 5, UserId = ids[3] }, new UserCourse { Id = 16, CourseId = 5, UserId = ids[7] }, new UserCourse { Id = 17, CourseId = 6, UserId = ids[0] }, new UserCourse { Id = 18, CourseId = 6, UserId = ids[7] }, new UserCourse { Id = 19, CourseId = 7, UserId = ids[0] }, new UserCourse { Id = 20, CourseId = 7, UserId = ids[4] }, new UserCourse { Id = 21, CourseId = 8, UserId = ids[0] }, new UserCourse { Id = 22, CourseId = 8, UserId = ids[4] }, new UserCourse { Id = 23, CourseId = 8, UserId = ids[3] }, new UserCourse { Id = 24, CourseId = 9, UserId = ids[0] }, new UserCourse { Id = 25, CourseId = 9, UserId = ids[2] }, new UserCourse { Id = 26, CourseId = 9, UserId = ids[7] }, new UserCourse { Id = 27, CourseId = 10, UserId = ids[0] }, new UserCourse { Id = 28, CourseId = 10, UserId = ids[6] }, new UserCourse { Id = 29, CourseId = 10, UserId = ids[3] }, new UserCourse { Id = 30, CourseId = 11, UserId = ids[0] }, new UserCourse { Id = 31, CourseId = 11, UserId = ids[1] }, new UserCourse { Id = 32, CourseId = 11, UserId = ids[2] }, new UserCourse { Id = 33, CourseId = 12, UserId = ids[1] }, new UserCourse { Id = 34, CourseId = 12, UserId = ids[2] }, new UserCourse { Id = 35, CourseId = 12, UserId = ids[3] }, new UserCourse { Id = 36, CourseId = 13, UserId = ids[4] }, new UserCourse { Id = 37, CourseId = 13, UserId = ids[5] }, new UserCourse { Id = 38, CourseId = 13, UserId = ids[6] }, new UserCourse { Id = 39, CourseId = 14, UserId = ids[7] }, new UserCourse { Id = 40, CourseId = 14, UserId = ids[6] }, new UserCourse { Id = 41, CourseId = 15, UserId = ids[0] }, new UserCourse { Id = 42, CourseId = 15, UserId = ids[7] }, new UserCourse { Id = 43, CourseId = 16, UserId = ids[3] }, new UserCourse { Id = 44, CourseId = 16, UserId = ids[4] }, }; context.UserCourses.AddOrUpdate(usercourses); context.SaveChanges(); var userschedulers = new UserScheduler[] { new UserScheduler { Id = 1, SchedulerId = 1, UserId = ids[0] }, new UserScheduler { Id = 2, SchedulerId = 2, UserId = ids[0] }, new UserScheduler { Id = 3, SchedulerId = 3, UserId = ids[0] }, new UserScheduler { Id = 4, SchedulerId = 4, UserId = ids[0] }, new UserScheduler { Id = 5, SchedulerId = 5, UserId = ids[0] }, new UserScheduler { Id = 6, SchedulerId = 6, UserId = ids[0] }, new UserScheduler { Id = 7, SchedulerId = 7, UserId = ids[0] }, new UserScheduler { Id = 8, SchedulerId = 8, UserId = ids[0] }, new UserScheduler { Id = 9, SchedulerId = 9, UserId = ids[0] }, new UserScheduler { Id = 10, SchedulerId = 10, UserId = ids[0] }, new UserScheduler { Id = 11, SchedulerId = 11, UserId = ids[0] }, new UserScheduler { Id = 12, SchedulerId = 12, UserId = ids[0] }, new UserScheduler { Id = 13, SchedulerId = 13, UserId = ids[0] }, new UserScheduler { Id = 14, SchedulerId = 14, UserId = ids[0] }, }; context.UserSchedulers.AddOrUpdate(userschedulers); context.SaveChanges(); var feedbacks = new Feedback[] { new Feedback { Id = 1, Date = new DateTime(2018, 1, 3, 14, 56, 0), UserFullName = "Ion Popescu", CourseId = 1, Text = "Excelent!!!" }, new Feedback { Id = 2, Date = new DateTime(2017, 1, 3, 18, 56, 0), UserFullName = "Maria Alexandrescu", CourseId = 1, Text = "Impressive!!!" }, new Feedback { Id = 3, Date = new DateTime(2017, 2, 13, 14, 56, 0), UserFullName = "Andrei Caleniuc", CourseId = 1, Text = "Awful!!!" }, new Feedback { Id = 4, Date = new DateTime(2018, 1, 3, 10, 0, 0), UserFullName = "Alina Toader", CourseId = 2, Text = "Never going anywhere else :O" }, new Feedback { Id = 5, Date = new DateTime(2016, 3, 9, 14, 56, 0), UserFullName = "Raluca Manea", CourseId = 2, Text = "Feeling excelent" }, new Feedback { Id = 6, Date = new DateTime(2017, 11, 3, 14, 56, 0), UserFullName = "Claudiu Ursuta", CourseId = 3, Text = "Amazing!!!!!" }, new Feedback { Id = 7, Date = new DateTime(2017, 12, 23, 14, 56, 0), UserFullName = "Andrei Vlad", CourseId = 4, Text = "I liked it very much" }, new Feedback { Id = 8, Date = new DateTime(2017, 1, 18, 14, 56, 0), UserFullName = "Bogdan Vorobet", CourseId = 5, Text = "Awesome!!I will come back" }, new Feedback { Id = 9, Date = new DateTime(2017, 11, 4, 18, 0, 0), UserFullName = "Daniel Neamtu", CourseId = 6, Text = "Awesome!!I will come back!!!" }, new Feedback { Id = 10, Date = new DateTime(2017, 1, 23, 14, 56, 0), UserFullName = "Alex Pop", CourseId = 7, Text = "Awesome!!I will come back!!!" }, new Feedback { Id = 11, Date = new DateTime(2017, 5, 30, 10, 56, 0), UserFullName = "Maria Pop", CourseId = 8, Text = "Impressive!!!" }, new Feedback { Id = 12, Date = new DateTime(2017, 9, 17, 8, 56, 0), UserFullName = "Ioana Pop", CourseId = 9, Text = "Impressive!!!" }, new Feedback { Id = 13, Date = new DateTime(2017, 8, 9, 20, 56, 0), UserFullName = "Ioana Popescu", CourseId = 10, Text = "Impressive!!!" }, new Feedback { Id = 14, Date = new DateTime(2017, 12, 18, 23, 56, 0), UserFullName = "Alina Popescu", CourseId = 11, Text = "Feeling excelent" }, new Feedback { Id = 15, Date = new DateTime(2017, 11, 3, 4, 56, 0), UserFullName = "Adela Popescu", CourseId = 12, Text = "Feeling excelent" }, new Feedback { Id = 16, Date = new DateTime(2018, 1, 17, 6, 43, 0), UserFullName = "Bogdan Popescu", CourseId = 13, Text = "Never going anywhere else :O" }, new Feedback { Id = 17, Date = new DateTime(2018, 1, 15, 16, 27, 0), UserFullName = "Raluca Popescu", CourseId = 14, Text = "Never going anywhere else :O" }, new Feedback { Id = 18, Date = new DateTime(2017, 11, 3, 4, 56, 0), UserFullName = "Adela Ionescu", CourseId = 15, Text = "Never going anywhere else :O" }, new Feedback { Id = 19, Date = new DateTime(2018, 1, 17, 6, 43, 0), UserFullName = "Mircea Ionescu", CourseId = 16, Text = "Excelent!!!" }, new Feedback { Id = 20, Date = new DateTime(2018, 1, 15, 16, 27, 0), UserFullName = "Alex Ionescu", CourseId = 17, Text = "Excelent!!!" }, new Feedback { Id = 1, Date = new DateTime(2018, 1, 3, 14, 56, 0), UserFullName = "Ion Popescu", UserId = ids[0], Text = "Excelent!!!" }, new Feedback { Id = 2, Date = new DateTime(2017, 1, 3, 18, 56, 0), UserFullName = "Maria Alexandrescu", UserId = ids[0], Text = "Impressive!!!" }, new Feedback { Id = 3, Date = new DateTime(2017, 2, 13, 14, 56, 0), UserFullName = "Alex Ionescu", UserId = ids[1], Text = "Awful!!!" }, new Feedback { Id = 4, Date = new DateTime(2018, 1, 3, 10, 0, 0), UserFullName = "Mircea Ionescu", UserId = ids[1], Text = "Never going anywhere else :O" }, new Feedback { Id = 5, Date = new DateTime(2016, 3, 9, 14, 56, 0), UserFullName = "Adela Ionescu", UserId = ids[1], Text = "Feeling excelent" }, new Feedback { Id = 6, Date = new DateTime(2017, 11, 3, 14, 56, 0), UserFullName = "Bogdan Popescu", UserId = ids[2], Text = "Amazing!!!!!" }, new Feedback { Id = 7, Date = new DateTime(2017, 12, 23, 14, 56, 0), UserFullName = "Bogdan Popescu", UserId = ids[3], Text = "I liked it very much" }, new Feedback { Id = 8, Date = new DateTime(2017, 1, 18, 14, 56, 0), UserFullName = "Ioana Pop", UserId = ids[4], Text = "Awesome!!I will come back" }, new Feedback { Id = 9, Date = new DateTime(2017, 11, 4, 18, 0, 0), UserFullName = "Ioana Pop", UserId = ids[5], Text = "Awesome!!I will come back!!!" }, new Feedback { Id = 10, Date = new DateTime(2017, 1, 23, 14, 56, 0), UserFullName = "Alex Pop", UserId = ids[6], Text = "Awesome!!I will come back!!!" }, new Feedback { Id = 11, Date = new DateTime(2017, 1, 23, 14, 56, 0), UserFullName = "Alex Pop", UserId = ids[7], Text = "Awesome!!I will come back!!!" }, }; context.Feedbacks.AddOrUpdate(feedbacks); context.SaveChanges(); }