//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();
}
