//Get the full name from database public string GetFullName(int userId) { using var db = new DiaryContext(); var query = (from b in db.Users where b.UserId == userId select b).SingleOrDefault(); return(query.FullName); }
public List <UserModel> GetUserFromDb(string userName) { using var db = new DiaryContext(); return((from b in db.Users where b.UserName == userName select b).ToList()); }
//************************************************************************** //entry section //************************************************************************** //retrieve all entrys from database public List <DiaryEntryModel> GetEntrysFromDb(int userId) { using var db = new DiaryContext(); return((from b in db.DiaryEntrys where b.UserId == userId select b).ToList()); }
//Save or Update the Created Entry to Database public void EntryToDb(DiaryEntryModel entry) { using var db = new DiaryContext(); var result = db.DiaryEntrys.SingleOrDefault(e => e.EntryId == entry.EntryId); if (result != null) { db.Entry(result).CurrentValues.SetValues(entry); //update entry to the given ID } else //Save new entry { db.DiaryEntrys.Add(entry); } db.SaveChanges(); }
public void CreateTestUser() { using var db = new DiaryContext(); if (!db.Users.Any())//only create user if no users exist { List <UserModel> lstUser = new List <UserModel>() { new UserModel { UserName = "******", FirstName = "User", LastName = "Example", Password = SecurePasswordHasher.Hash("1") } }; lstUser.Add(new UserModel { UserName = "******", FirstName = "User2", LastName = "Example2", Password = SecurePasswordHasher.Hash("2") }); db.Users.Add(lstUser[0]); db.Users.Add(lstUser[1]); db.SaveChanges(); } }
public void CreateTestEntrys() { using var db = new DiaryContext(); //add some test entrys to the EntryDb for TestUser 1 and 2 if db is empty if (!db.DiaryEntrys.Any()) //only create entries if no entries exist { byte[] img; string testText = "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor " + "invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo " + "dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. " + "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et " + "dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet " + "clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."; using (WebClient webClient = new WebClient()) { img = webClient.DownloadData("https://onaliternote.files.wordpress.com/2016/11/wp-1480230666843.jpg"); } List <DiaryEntryModel> lstTestEntrys = new List <DiaryEntryModel>() { new DiaryEntryModel { UserId = 1, Text = testText, TagBirthday = true, TagFriends = true, ByteImage = img, Date = DateTime.Today }, //create a sencond entry for user 2 new DiaryEntryModel { UserId = 2, Text = "this is user Id 2 and not visible with userId 1.", TagFriends = true, TagBirthday = true, TagFamily = true, ByteImage = img, Date = DateTime.Today.AddDays(-6) } }; //more entrys for (int i = 6; i < 50; i++) { lstTestEntrys.Add(new DiaryEntryModel { UserId = 1, Text = testText, TagFriends = true, TagBirthday = true, TagFamily = true, ByteImage = img, Date = DateTime.Today.AddDays(-i) }); } foreach (var item in lstTestEntrys) { db.DiaryEntrys.Add(item); } db.SaveChanges(); } }
//************************************************************************** //user section //************************************************************************** //Save the user to Database public void UserToDb(UserModel user) { using var db = new DiaryContext(); db.Users.Add(user); db.SaveChanges(); }
//Delete entry from Database public void DeleteEntryInDb(DiaryEntryModel entrys) { using var db = new DiaryContext(); db.Entry(entrys).State = EntityState.Deleted; db.SaveChanges(); }