public ActionResult Update(PostViewModel postViewModel) { if (postViewModel.Id != 0) { var existingPost = this.BlogSystemDbContext.Posts.FirstOrDefault(p => p.Id == postViewModel.Id); existingPost.Name = postViewModel.Name; existingPost.Content = postViewModel.Content; existingPost.DateCreated = DateTime.Now; existingPost.User = UserManager.FindById(User.Identity.GetUserId()); } else { var newPost = new Models.Post() { Name = postViewModel.Name, Content = postViewModel.Content, DateCreated = DateTime.Now, User = UserManager.FindById(User.Identity.GetUserId()) }; this.BlogSystemDbContext.Posts.Add(newPost); } BlogSystemDbContext.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion<BlogSystemDbContext, Configuration>()); var data = new BlogSystemDbContext(); var post = new Post { Title = "Hi 3 dsadasdasdasdasdasd", PostedOn = DateTime.Now, }; data.Posts.Add(post); data.SaveChanges(); var posts = data.Posts.AsQueryable(); if (true) { posts = posts.Where(p => p.Title == "gosho"); } if (true) { posts = posts.Where(p => p.Subtitle == "pesho"); } var result = posts.ToList(); }
public ActionResult Index() { BlogSystemDbContext context = new BlogSystemDbContext(); var count = context.Users.Count(); //return Content(count.ToString()); return(View(count)); }
public static void Main() { var db = new BlogSystemDbContext(); var user = new User() { Id = 1 }; db.Users.Attach(user); db.SaveChanges(); // data.Users.Add(new User // { // Username = "******", // Gender = Gender.Male, // RegistrationDate = DateTime.Now, // FullName = "Vladimir Georgiev", // Birthday = new DateTime(1876, 11, 12), // ContactInfo = new UserContactInfo // { // Tweeter = "@VGeorgiew", // Facebook = "VladiGeorgiev", // PhoneNumber = "0888888888", // Skype = "SkypeProfile" // } // }); // // data.SaveChanges(); // // var user = data.Users.All().FirstOrDefault(x => x.FullName == "Vladimir Georgiev"); // user.FullName = "VG"; // // data.SaveChanges(); // // data.Users.Delete(user); // data.SaveChanges(); }
public static void Main(string[] args) { using (var db = new BlogSystemDbContext()) { db.Users.Add(new User { Username = "******", Gender = Gender.Male, RegistrationDate = DateTime.Now, FullName = "Ivan Ivanov", Birthday = new DateTime(1998, 12, 10), ContactInfo = new UserContactInfo { Twitter = "@csyntax", Facebook = "IvanIvanov", PhoneNumber = "0888888888", Skype = "ivanivanov982" } }); db.SaveChanges(); } }
public static void Main() { var db = new BlogSystemDbContext(); var user = new User() {Id = 1}; db.Users.Attach(user); db.SaveChanges(); // data.Users.Add(new User // { // Username = "******", // Gender = Gender.Male, // RegistrationDate = DateTime.Now, // FullName = "Vladimir Georgiev", // Birthday = new DateTime(1876, 11, 12), // ContactInfo = new UserContactInfo // { // Tweeter = "@VGeorgiew", // Facebook = "VladiGeorgiev", // PhoneNumber = "0888888888", // Skype = "SkypeProfile" // } // }); // // data.SaveChanges(); // // var user = data.Users.All().FirstOrDefault(x => x.FullName == "Vladimir Georgiev"); // user.FullName = "VG"; // // data.SaveChanges(); // // data.Users.Delete(user); // data.SaveChanges(); }
public BaseController(BlogSystemDbContext context) { this.Context = context; }
public GenericRepository(BlogSystemDbContext context) { this.context = context; this.set = context.Set <T>(); }
public RootController() { this.BlogSystemDbContext = new BlogSystemDbContext(); this.UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(this.BlogSystemDbContext)); }
public UsersRepository(BlogSystemDbContext context) : base(context) { }