public BookmarkItemView(BookmarksDBEntities DB, Bookmark bookmark, User viewer)
{
Id = bookmark.Id;
Name = bookmark.Name;
Url = bookmark.Url;
if (bookmark.CategoryId != 0)
{
Category category = DB.Categories.Find(bookmark.CategoryId);
if (category != null)
{
Category = category.Name;
}
}
else
{
Category = "";
}
AllowEdit = (viewer.Admin) || (bookmark.UserId == viewer.Id);
if (bookmark.UserId == viewer.Id)
{
OwnerShip = (bookmark.Shared ? "Shared" : "Private");
OwnerEmail = "";
}
else
{
User ownerUser = DB.Users.Find(bookmark.UserId);
if (ownerUser != null)
{
OwnerShip = ownerUser.GetFullName();
OwnerEmail = ownerUser.Email;
}
}
}
public static List <BookmarkItemView> BookmarkList(this BookmarksDBEntities DB, User viewer, string SortBy, bool ascendant)
{
List <BookmarkItemView> bookmarkItems = new List <BookmarkItemView>();
foreach (Bookmark bookmark in DB.Bookmarks)
{
if ((viewer.Admin) || (viewer.Id == bookmark.UserId) || (bookmark.Shared))
{
bookmarkItems.Add(new BookmarkItemView(DB, bookmark, viewer));
}
}
switch (SortBy)
{
case "Name":
if (ascendant)
{
bookmarkItems = bookmarkItems.OrderBy(b => b.Name).ToList();
}
else
{
bookmarkItems = bookmarkItems.OrderByDescending(b => b.Name).ToList();
}
break;
case "Url":
if (ascendant)
{
bookmarkItems = bookmarkItems.OrderBy(b => b.Url).ToList();
}
else
{
bookmarkItems = bookmarkItems.OrderByDescending(b => b.Url).ToList();
}
break;
case "OwnerShip":
if (ascendant)
{
bookmarkItems = bookmarkItems.OrderBy(b => b.OwnerShip).ToList();
}
else
{
bookmarkItems = bookmarkItems.OrderByDescending(b => b.OwnerShip).ToList();
}
break;
case "Category":
if (ascendant)
{
bookmarkItems = bookmarkItems.OrderBy(b => b.Category).ToList();
}
else
{
bookmarkItems = bookmarkItems.OrderByDescending(b => b.Category).ToList();
}
break;
}
return(bookmarkItems);
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Users CRUD queries
public static User Add(this BookmarksDBEntities DB, User user)
{
if (user != null)
{
User new_User = DB.Users.Add(user);
DB.SaveChanges();
return(new_User);
}
return(null);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Categories CRUD queries
public static Category Add(this BookmarksDBEntities DB, Category category)
{
if (category != null)
{
Category new_Category = DB.Categories.Add(category);
DB.SaveChanges();
return(new_Category);
}
return(null);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Bookmarks CRUD queries
public static Bookmark Add(this BookmarksDBEntities DB, Bookmark bookmark)
{
if (bookmark != null)
{
Bookmark new_Bookmark = DB.Bookmarks.Add(bookmark);
DB.SaveChanges();
return(new_Bookmark);
}
return(null);
}
public static List <User> SortedUsers(this BookmarksDBEntities DB, string sortBy, bool ascendant)
{
List <User> users = DB.Users.ToList();
if (users.Count > 1)
{
switch (sortBy)
{
case "Name":
if (ascendant)
{
users = users.OrderBy(b => b.FirstName).ThenBy(b => b.LastName).ToList();
}
else
{
users = users.OrderByDescending(b => b.FirstName).ThenByDescending(b => b.LastName).ToList();
}
break;
case "CreationDate":
if (ascendant)
{
users = users.OrderBy(b => b.CreationDate).ToList();
}
else
{
users = users.OrderByDescending(b => b.CreationDate).ToList();
}
break;
case "BirthDate":
if (ascendant)
{
users = users.OrderBy(b => b.BirthDate).ToList();
}
else
{
users = users.OrderByDescending(b => b.BirthDate).ToList();
}
break;
case "Sex":
if (ascendant)
{
users = users.OrderBy(b => b.Sex).ToList();
}
else
{
users = users.OrderByDescending(b => b.Sex).ToList();
}
break;
}
}
return(users);
}
public static bool CategoryExist(this BookmarksDBEntities DB, string name)
{
foreach (Category category in DB.Categories)
{
if (category.Name == name)
{
return(true);
}
}
return(false);
}
public static void Delete(this BookmarksDBEntities DB, Bookmark bookmark)
{
if (bookmark != null)
{
Bookmark bookmarkToDelete = DB.Bookmarks.Find(bookmark.Id);
if (bookmarkToDelete != null)
{
DB.Entry(bookmarkToDelete).State = System.Data.Entity.EntityState.Deleted;
DB.SaveChanges();
}
}
}
public static User Update(this BookmarksDBEntities DB, User user)
{
if (user != null)
{
User userToUpdate = DB.Users.Find(user.Id);
if (userToUpdate != null)
{
userToUpdate.Update(user);
DB.Entry(userToUpdate).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
return(DB.Users.Find(userToUpdate.Id));
}
}
return(null);
}
public static Category Update(this BookmarksDBEntities DB, Category category)
{
if (category != null)
{
Category categoryToUpdate = DB.Categories.Find(category.Id);
if (categoryToUpdate != null)
{
categoryToUpdate.Update(category);
DB.Entry(categoryToUpdate).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
return(DB.Categories.Find(categoryToUpdate.Id));
}
}
return(null);
}
public static Bookmark Update(this BookmarksDBEntities DB, Bookmark bookmark)
{
if (bookmark != null)
{
Bookmark bookmarkToUpdate = DB.Bookmarks.Find(bookmark.Id);
if (bookmarkToUpdate != null)
{
bookmarkToUpdate.Update(bookmark);
DB.Entry(bookmarkToUpdate).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
return(DB.Bookmarks.Find(bookmarkToUpdate.Id));
}
}
return(null);
}
public static void Delete(this BookmarksDBEntities DB, User user)
{
if (user != null)
{
User userToDelete = DB.Users.Find(user.Id);
if (userToDelete != null)
{
foreach (Bookmark bookmark in DB.Bookmarks.Where(b => b.UserId == user.Id))
{
DB.Entry(bookmark).State = System.Data.Entity.EntityState.Deleted;
}
DB.Entry(userToDelete).State = System.Data.Entity.EntityState.Deleted;
DB.SaveChanges();
}
}
}
public static void Delete(this BookmarksDBEntities DB, Category category)
{
if (category != null)
{
Category categoryToDelete = DB.Categories.Find(category.Id);
if (categoryToDelete != null)
{
foreach (Bookmark bookmark in DB.Bookmarks.Where(b => b.CategoryId == categoryToDelete.Id))
{
bookmark.CategoryId = 0;
DB.Entry(bookmark).State = System.Data.Entity.EntityState.Modified;
}
DB.Entry(categoryToDelete).State = System.Data.Entity.EntityState.Deleted;
DB.SaveChanges();
}
}
}
public static User FindByUserName(this BookmarksDBEntities DB, string userName)
{
return(DB.Users.Where(u => u.UserName == userName).FirstOrDefault());
}