private List <NoteCategory> mapStringCategoriesToNoteCategory(NotesDbContext context, List <string> stringCategories, Note note) { List <NoteCategory> noteCategories = new List <NoteCategory> (); foreach (string stringCategory in stringCategories) { var category = context.Categories.FirstOrDefault(it => it.Title == stringCategory); if (category == null) { category = new Category { Title = stringCategory }; context.Categories.Add(category); } noteCategories.Add(new NoteCategory { Note = note, Category = category }); } return(noteCategories); }
public User ById(int id) { using (var db = new NotesDbContext()) { return(db.Users.FirstOrDefault(u => u.Id == id)); } }
public IEnumerable <Note> GetNotes(int id) { using (var db = new NotesDbContext()) { return(db.Notes.Where(n => n.OwnerId == id).ToList()); } }
public IActionResult Profile(int id) { if (!this.User.IsAuthenticated) { return(RedirectToAction("/users/login")); } //this.Model["error"] = string.Empty; this.Model["username"] = this.User.Name; this.Model["userid"] = id.ToString(); using (var db = new NotesDbContext()) { var notes = db .Notes .Where(n => n.UserId == id) .ToList(); this.Model["notes"] = string.Join( string.Empty, notes.Select(u => $"<li>{u.Title}: {u.Content}</li>")); } return(View()); }
public SqliteDataProvider() { using (NotesDbContext notescontext = new NotesDbContext()) { notescontext.Database.Migrate(); } }
public bool Exist(string username) { using (var ctx = new NotesDbContext()) { return(ctx.Users.Any(u => u.Username == username)); } }
public IActionResult <AllUsernamesViewModel> All() { // Get users from db List <UsernameViewModel> usernames = null; using (var context = new NotesDbContext()) { usernames = context .Users .Select(u => new UsernameViewModel { UserId = u.Id, Username = u.Username }) .ToList(); } // Create view model var allUsernamesViewModel = new AllUsernamesViewModel { UsernamesWithIds = usernames }; return(View(allUsernamesViewModel)); }
public IActionResult Profile() { int id = int.Parse(this.Request.UrlParameters["id"]); User user = null; using (var context = new NotesDbContext()) { user = context.Users.FirstOrDefault(u => u.Id == id); if (user == null) { this.ViewModel["username"] = "******"; this.ViewModel["message"] = ""; return(View()); } this.ViewModel["username"] = user.Username.ToString(); this.ViewModel["message"] = ""; this.ViewModel["userId"] = user.Id.ToString(); var notes = context.Notes.Where(n => n.OwnerId == user.Id).ToArray(); this.ViewModel["notes"] = notes.Any() ? string.Join(string.Empty, notes .Select(u => $"<li><a href=\"/users/note?id={u.Id}\">{u.Title}</a> - {u.Content}</li>")) : $"<p>No notes for this user !</p>"; } return(View()); }
public IActionResult Login(LoginUserBindingModel loginUserBindingModel) { if (loginUserBindingModel.Username == "" || loginUserBindingModel.Password == "") { this.ViewModel["message"] = "Empty input fields !"; return(View()); } using (var context = new NotesDbContext()) { var foundUser = context .Users .FirstOrDefault(u => u.Username == loginUserBindingModel.Username && u.Password == PasswordUtilities.GenerateHash256(loginUserBindingModel.Password)); if (foundUser == null) { this.ViewModel["message"] = "Invalid Username or password !"; return(View()); } //we add it to the session storage context.SaveChanges(); this.SignIn(foundUser.Username); } return(Redirect("/home/index")); }
public HomePageDataController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public IActionResult Profile(int id) { using (var context = new NotesDbContext()) { var user = context.Users .FirstOrDefault(u => u.Id == id); this.Model["notes"] = string.Join(Environment.NewLine, user.Notes.Select(n => $"<li>{n.Title}</li>")); } //var viewModel = new UserProfileViewModel //{ // UserId = user.Id, // Username = user.Username, // Notes = user.Notes // .Select(n => // new NoteViewModel // { // Title = n.Title, // Content = n.Content // }) //}; return(this.View()); }
public MyAccessController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public void Initialize() { using (var db = new NotesDbContext()) { db.Database.Migrate(); } }
public EnterAndDisplayController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public IActionResult Register(RegisterBindingModel model) { if (!this.IsValidModel(model)) { return(this.View()); } using (var db = new NotesDbContext()) { if (db.Users.Any(u => u.Username == model.Username)) { throw new ArgumentException("Username already taken!"); } var user = new User() { Username = model.Username, Password = model.Password }; db.Add(user); db.SaveChanges(); } return(this.View()); }
public IActionResult All() { // Authenticate user if (!this.User.IsAuthenticated) { return(Redirect(LoginPath)); } using (var context = new NotesDbContext()) { // Get users from db var users = context .Users .Select(u => new { Id = u.Id, Username = u.Username }) .ToList(); // Get users view data this.ViewModel["users"] = users.Any() ? string.Join(string.Empty, users.Select(u => $"<li><a href=\"/users/profile?id={u.Id}\">{u.Username}</a></li>")) : string.Empty; } return(View()); }
public IActionResult Profile(int id) { string username = null; using (var db = new NotesDbContext()) { var user = db.Users .Where(u => u.Id == id) .Select(u => new { u.Username, Notes = u.Notes.ToList() }) .SingleOrDefault(); if (user == null) { throw new ArgumentException("User doesn't exist!"); } this.Model["username"] = user.Username; this.Model["userid"] = id.ToString(); var notes = user.Notes.ToList(); this.Model["users"] = notes.Any() ? string.Join(string.Empty, notes.Select(n => $@"<li>{n.Title} - {n.Content}</li>")) : string.Empty; return(this.View()); } }
public IActionResult Profile(AddNoteBindingModel model) { // Validate model if (!this.IsValidModel(model)) { return(View()); } using (var context = new NotesDbContext()) { // Check if user exists var foundUser = context.Users.Any(u => u.Id == model.UserId); if (!foundUser) { return(Redirect(UsersAllPath)); } // Add note to db var note = new Note { Title = model.Title, Content = model.Content, OwnerId = model.UserId }; context.Notes.Add(note); context.SaveChanges(); } return(Profile(model.UserId)); }
public SequencerController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public IActionResult Register(RegisterUserBindingModel model) { // Validate model if (!this.IsValidModel(model)) { return(View()); } // Add user to db using (var context = new NotesDbContext()) { var user = new User { Username = model.Username, Password = model.Password }; context.Users.Add(user); context.SaveChanges(); } // SignIn user this.SignIn(model.Username); return(Redirect(HomePath)); }
public IActionResult <UserProfileViewModel> Profile(int id) { // Get data from db UserProfileViewModel userViewModel = null; using (var context = new NotesDbContext()) { userViewModel = context .Users .Where(u => u.Id == id) .Select(u => new UserProfileViewModel { UserId = u.Id, Username = u.Username, Notes = u.Notes .Select(n => new NoteViewModel { Title = n.Title, Content = n.Content }) .ToList() }) .FirstOrDefault(); } return(View(userViewModel)); }
public IActionResult Login(LoginUserBindingModel model) { // Validate model if (!this.IsValidModel(model)) { return(View()); } // Validate user credentials using (var context = new NotesDbContext()) { var foundUser = context.Users .Any(u => u.Username == model.Username && u.Password == model.Password); if (!foundUser) { return(Redirect(LoginPath)); } } // SignIn user this.SignIn(model.Username); return(Redirect(HomePath)); }
public IActionResult All() { if (!this.User.IsAuthenticated) { return(RedirectToAction("/users/login")); } var users = new Dictionary <int, string>(); using (var db = new NotesDbContext()) { users = db .Users .ToDictionary(u => u.Id, u => u.Username); } this.Model["users"] = string.Empty; if (users.Any()) { this.Model["users"] = string.Join( string.Empty, users.Select(u => $"<li><a href=\"/users/profile?id={u.Key}\">{u.Value}</a></li>")); } return(View()); }
public SubscriptionController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public NoteIndexController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public NoteFileAdminStdController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public ApiLoginController(UserManager <IdentityUser> userManager, SignInManager <IdentityUser> signInManager, NotesDbContext context) { _userManager = userManager; _signInManager = signInManager; _context = context; }
public SQLFilesController( UserManager <IdentityUser> userManager, SignInManager <IdentityUser> signInManager, NotesDbContext sqlcontext) : base(userManager, signInManager, sqlcontext) { _sqlcontext = sqlcontext; }
public ForwardController(NotesDbContext db, UserManager <IdentityUser> userManager ) { _db = db; _userManager = userManager; }
public string Render() { StringBuilder sb = new StringBuilder(); sb.AppendLine("<a href=\"/home/index\">Back Home</a>"); sb.AppendLine("<h3> All Users </h3>"); sb.AppendLine("<ul>"); using (var context = new NotesDbContext()) { var users = context.Users.ToList(); foreach (var username in Model.Usernames) { int userId = users .FirstOrDefault(u => u.Username == username) .Id; sb.AppendLine($"<li><a href=\"/users/profile?id={userId}\">{username}</a></li>"); } } sb.AppendLine("</ul>"); return(sb.ToString()); }
public void TestMethod1() { using (var conn = new SqlCeConnection(CONNECTION_STRING)) { var dbContext = new NotesDbContext(conn.ConnectionString); var target = new NotesManagerService(new EfUnitOfWork(dbContext)); target.Save(new Note() {Title = "Test"}); var notes = target.GetNotes().ToList(); Assert.AreEqual(1, notes.Count()); } }