public ActionResult Create([Bind(Include = "TopicID,TopicName,TopicClousureDate,TopicFinalClousureDate,TopicPostDate")] Topic topic) { if (ModelState.IsValid) { db.Topics.Add(topic); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(topic)); }
public ActionResult Create([Bind(Include = "CommentId,Comment,CommentOn,CommentBy,MagazineID")] ArticlesComment articlesComment) { if (ModelState.IsValid) { db.ArticlesComments.Add(articlesComment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MagazineID = new SelectList(db.Magazines, "MagazineID", "MagazineName", articlesComment.MagazineID); return(View(articlesComment)); }
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 static void RegistrationMenu() { Console.WriteLine("===========\n" + "РЕГИСТРАЦИЯ\n" + "==========="); Person newPerson = new Person() { Name = SetInformation.SetName(), Surname = SetInformation.SetSurname(), Address = SetInformation.SetAddress(), PhoneNumber = SetInformation.SetPhoneNumber() }; User newUser = new User() { Login = SetInformation.SetLogin(), Password = SetInformation.SetPassword(), Person = newPerson }; using (var context = new MagazineContext()) { if (!context.People.Contains(newPerson)) { if (!context.Users.Contains(newUser)) { context.Users.Add(newUser); context.SaveChanges(); Console.WriteLine("Зарегистрированно"); } } } }
public string Buy(Purchase purchase) { purchase.Date = DateTime.Now; // добавляем информацию о покупке в базу данных db.Purchases.Add(purchase); // сохраняем в бд все изменения db.SaveChanges(); Buy1(); return(purchase.Person + ", thanks for purchase!"); }
public ActionResult Create(Magazine magazine, string receiver) { if (ModelState.IsValid) { List <FileDetail> fileDetails = new List <FileDetail>(); for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); FileDetail fileDetail = new FileDetail() { FileName = fileName, Extension = Path.GetExtension(fileName), Id = Guid.NewGuid() }; fileDetails.Add(fileDetail); var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), fileDetail.Id + fileDetail.Extension); file.SaveAs(path); } } ViewBag.TopicID = new SelectList(db.Topics, "TopicID", "TopicName", magazine.TopicID); magazine.FileDetails = fileDetails; db.Magazines.Add(magazine); db.SaveChanges(); string subject = "Your student has submitted their post submission for your Topic"; string body = "Hi Marketing Coordinator, " + "Your student has submitted their post submission for your Topic: " + magazine.TopicName + " Student's name: " + User.Identity.Name + " Submit Date: " + DateTime.Now; WebMail.Send(receiver, subject, body); return(RedirectToAction("Index")); } return(View(magazine)); }
public static void DeleteSubsription(User user) { using (var context = new MagazineContext()) { var userSub = context.UsersSubscriptions.Where(userSubscription => userSubscription.User.Id == user.Id).SingleOrDefault(); if (userSub != null) { context.UsersSubscriptions.Remove(userSub); context.SaveChanges(); return; } throw new ArgumentNullException("Нет такого пользователя с такой подпиской"); } }
public static void CreateMagazine() { Magazine newMagazine = new Magazine() { Name = SetInformation.SetName(), Theme = SetInformation.SetTheme(), DateOfIssue = DateTime.Now }; using (var context = new MagazineContext()) { context.Magazines.Add(newMagazine); context.SaveChanges(); } }
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); } }
public async Task DeleteTeacherAsync(string id) { try { magazineContext.Teacher.Remove(magazineContext.Teacher.SingleOrDefault(t => t.Id == id)); magazineContext.SaveChanges(); string msg = String.Format("Преподаватель был удален!"); Response.StatusCode = StatusCodes.Status200OK; await Response.WriteAsync(JsonConvert.SerializeObject(new { success = msg }, new JsonSerializerSettings { Formatting = Formatting.Indented })); } catch (Exception e) { ModelState.AddModelError("error", e.Message); await Response.BadRequestHelper(ModelState.Values); } }
public ActionResult Registr(Customer cust) { cust.idcustomer = Guid.NewGuid(); db.customer.Add(cust); db.SaveChanges(); var myResult = db.customer.Where(c => c.name == cust.name).Select(c => new { c.name, c.product }).Distinct(); ViewBag.name = cust.name; ViewBag.product = cust.product; ViewBag.pop = true; List <string> dict = new List <string>(); foreach (var x in myResult) { string result = x.name + " придбав підписку " + x.product; dict.Add(result); } ViewBag.data = dict; ViewBag.count = dict.Count(); return(View()); }
public ActionResult AddOrder(Order order) { db.Orders.Add(order); db.SaveChanges(); return(View("../Perfect")); }
public ActionResult AddProduct(Product product) { db.Products.Add(product); db.SaveChanges(); return(View("Index")); }
public ActionResult AddUser(User user) { db.Users.Add(user); db.SaveChanges(); return(View("../Perfect")); }
public void SaveChanges() { _context.SaveChanges(); }
public void Delete(T entity) { _entities.Remove(entity); _context.SaveChanges(); }