public Configuration() { AutomaticMigrationsEnabled = false; var context = new NewsPortalContext(); Seed(context); }
protected void Button1_Click1(object sender, EventArgs e) { using (var context = new NewsPortalContext()) { var users = context.Users.ToList(); if (users.FirstOrDefault(x => x.Login == TextBox1.Text && x.Password == TextBox2.Text) != null) { Response.Redirect(ResolveUrl("index.aspx")); } } }
protected void Button1_Click(object sender, EventArgs e) { using (var context = new NewsPortalContext()) { var users = context.Users.ToList(); if (TextBox2.Text == TextBox3.Text) { if (users.FirstOrDefault(x => x.Login == TextBox1.Text) == null) { context.Users.Add(new User() { Login = TextBox1.Text, Password = TextBox2.Text, Email = TextBox4.Text }); context.SaveChanges(); Response.Redirect(ResolveUrl("login.aspx")); } } } }
public NewsPortalUnitOfWork(NewsPortalContext context) { _context = context; }
protected override void Seed(NewsPortalContext context) { // Add Users context.Users.AddOrUpdate( new User { Id = 1, Username = "******", Name = "Publisher 1", Password = "******", Role = Role.Publisher }, new User { Id = 2, Username = "******", Name = "Publisher 2", Password = "******", Role = Role.Publisher }, new User { Id = 3, Username = "******", Name = "Publisher 3", Password = "******", Role = Role.Publisher }, new User { Id = 4, Username = "******", Name = "Publisher 4", Password = "******", Role = Role.Publisher }, new User { Id = 5, Username = "******", Name = "Employee 1", Password = "******", Role = Role.Employee, Likes = 10 }, new User { Id = 6, Username = "******", Name = "Employee 2", Password = "******", Role = Role.Employee, Likes = 1 }, new User { Id = 7, Username = "******", Name = "Employee 3", Password = "******", Role = Role.Employee }, new User { Id = 8, Username = "******", Name = "Employee 4", Password = "******", Role = Role.Employee } ); context.SaveChanges(); // Add Users context.Authors.AddOrUpdate( new Author { Id = 1, Name = "Author 1" }, new Author { Id = 2, Name = "Author 2" }, new Author { Id = 3, Name = "Author 3" } ); context.SaveChanges(); User publisher = context.Users.First(u => u.Id == 1); Author author = context.Authors.First(u => u.Id == 1); // Add Articles context.Articles.AddOrUpdate( new Article { Id = 1, Title = "News Article 1", Author = author, Publisher = publisher, Body = "This is a sample body for News Article 1", ArticleType = ArticleType.News, PublishDate = DateTime.Now, Likes = 10 }, new Article { Id = 2, Title = "News Article 2", Author = author, Publisher = publisher, Body = "This is a sample body for News Article 2", ArticleType = ArticleType.News, PublishDate = DateTime.Now }, new Article { Id = 3, Title = "Technology Article 1", Author = author, Publisher = publisher, Body = "This is a sample body for Technology Article 1", ArticleType = ArticleType.Technology, PublishDate = DateTime.Now, Likes = 45 } ); context.SaveChanges(); }
public EfUnitOfWork() { _db = new NewsPortalContext(); }
public void Initilise() { INewsPortalContext context = new NewsPortalContext(); _userRepository = new UserRepository(context); }
public Repository(NewsPortalContext context) { _db = context; }
public NewsPortalGenericRepository(NewsPortalContext context) { _context = context; _dbSet = _context.Set <T>(); }