public List <Album> GettAllAlbums()
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Albums.Include("User").Include("Photos").Include("Comments").ToList());
}
}
public Comment GetCommentByID(Guid id)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Comments.Include("User").Include("Photo").Include("Album").FirstOrDefault(x => x.Id == id));
}
}
public Photo GetPhotoFromDbById(Guid id)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Photos.Include("User").Include("Album").Include("Comments").FirstOrDefault(x => x.Id == id));
}
}
public Photo GetLastAddedPhoto()
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Photos.Include("User").Include("Album").Include("Comments").OrderByDescending(x => x.Date).FirstOrDefault());
}
}
public List <Photo> GetPhotoFromDbByUserId(Guid userID)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Photos.Include("User").Include("Album").Include("Comments").Where(x => x.UserID == userID).ToList());
}
}
public List <Photo> GetAllPhotosFromDb()
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Photos.Include("User").Include("Album").Include("Comments").ToList());
}
}
public List <Album> GettAllAlbumsByUserID(Guid userID)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Albums.Include("User").Include("Photos").Include("Comments").Where(x => x.User.Id == userID).ToList());
}
}
internal static bool LoginUser(string email, string password)
{
using (var dbCtx = new MVCLabbEntities())
{
foreach (var user in dbCtx.tbl_User)
{
if (email == user.Email && UserHelper.GenerateSHA256Hash(password, user.Salt) == user.Password)
{
var identity = new ClaimsIdentity(new[] {
new Claim(ClaimTypes.Name, user.Name),
new Claim(ClaimTypes.Email, user.Email),
new Claim(ClaimTypes.NameIdentifier, user.Id.ToString()),
new Claim(ClaimTypes.Role, user.Admin ? "Admin" : "User")
},
"ApplicationCookie");
var ctx = HttpContext.Current.Request.GetOwinContext();
var authManager = ctx.Authentication;
authManager.SignIn(identity);
return(true);
}
}
}
return(false);
}
public List <Comment> GetAllComentsByPhotoID(string id)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Comments.Include("User").Include("Photo").Include("Album").Where(x => x.PhotoID.ToString() == id).ToList());
}
}
public User GetUser(string id)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Users.Include("Photos").Include("Albums").Include("Comments").FirstOrDefault(x => x.Id.ToString() == id));
}
}
public List <Photo> GetAllPhotoesInAlbumByID(string id)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Photos.Include("User").Include("Album").Include("Comments").Where(x => x.AlbumID.ToString() == id).ToList());
}
}
public Album GetAlbumByID(Guid id)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Albums.Include("User").Include("Photos").Include("Comments").FirstOrDefault(x => x.Id == id));
}
}
public List <Comment> GetAllComments()
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Comments.Include("User").Include("Photo").ToList());
}
}
public List <User> GetAllUsers()
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Users.Include("Photos").Include("Albums").Include("Comments").ToList());
}
}
public List <Album> GetSearchAlbumsFromDB(string search)
{
using (var ctx = new MVCLabbEntities())
{
return(ctx.Albums.Include("User").Include("Photos").Include("Comments").Where(x =>
x.Name.Contains(search) || x.Description.Contains(search) || x.User.Name.Contains(search)).ToList());
}
}
public void AddComment(Comment comment)
{
using (var ctx = new MVCLabbEntities())
{
comment.Id = Guid.NewGuid();
ctx.Comments.Add(comment);
ctx.SaveChanges();
}
}
public void AddAlbum(Album album)
{
using (var ctx = new MVCLabbEntities())
{
album.Id = Guid.NewGuid();
ctx.Albums.Add(album);
ctx.SaveChanges();
}
}
public void DeletePhotoFromDB(Photo model)
{
using (var ctx = new MVCLabbEntities())
{
var photoToDelete = ctx.Photos.FirstOrDefault(x => x.Id == model.Id);
ctx.Photos.Remove(photoToDelete);
ctx.SaveChanges();
}
}
public void AddPhotoToDB(Photo photoToDB)
{
photoToDB.AlbumID = photoToDB.AlbumID == Guid.Empty ? null : photoToDB.AlbumID;
using (var ctx = new MVCLabbEntities())
{
ctx.Photos.Add(photoToDB);
ctx.SaveChanges();
}
}
public void DeleteAlbum(Album album)
{
using (var ctx = new MVCLabbEntities())
{
var albumDB = ctx.Albums.FirstOrDefault(x => x.Id == album.Id);
ctx.Albums.Remove(albumDB);
ctx.SaveChanges();
}
}
public void DeleteComment(Comment comment)
{
using (var ctx = new MVCLabbEntities())
{
var commentDB = ctx.Comments.FirstOrDefault(x => x.Id == comment.Id);
ctx.Comments.Remove(commentDB);
ctx.SaveChanges();
}
}
public void AddUser(User user)
{
user.Salt = CreateSalt(10);
user.Password = GenerateSHA256Hash(user.Password, user.Salt);
using (var ctx = new MVCLabbEntities())
{
ctx.Users.Add(user);
ctx.SaveChanges();
}
}
public void UdaptePhoto(Photo photo)
{
photo.AlbumID = photo.AlbumID == Guid.Empty ? null : photo.AlbumID;
using (var ctx = new MVCLabbEntities())
{
var photoFromDb = ctx.Photos.FirstOrDefault(x => x.Id == photo.Id);
photoFromDb.Name = photo.Name;
photoFromDb.Description = photo.Description;
photoFromDb.AlbumID = photo.AlbumID;
ctx.SaveChanges();
}
}
public void UpdateAlbum(Album album)
{
using (var ctx = new MVCLabbEntities())
{
var albumDB = ctx.Albums.FirstOrDefault(x => x.Id == album.Id);
albumDB.Name = album.Name;
albumDB.Description = album.Description;
ctx.SaveChanges();
}
}
public User ValidateLogin(string email, string password)
{
using (var dbCtx = new MVCLabbEntities())
{
foreach (var user in dbCtx.Users)
{
if (email == user.Email && GenerateSHA256Hash(password, user.Salt) == user.Password)
{
return(user);
}
}
}
return(null);
}
public void UpdateUser(User user)
{
using (var ctx = new MVCLabbEntities())
{
User userFromDB = ctx.Users.Where(x => x.Id == user.Id).FirstOrDefault();
userFromDB.Name = user.Name;
userFromDB.Country = user.Country;
userFromDB.Email = user.Email;
if (userFromDB.Password != user.Password)
{
var salt = CreateSalt(10);
var password = GenerateSHA256Hash(user.Password, salt);
userFromDB.Salt = salt;
userFromDB.Password = password;
}
ctx.SaveChanges();
}
}