public User ReadData_User(string username, string password)
{
using (var context = new MusicDatabaseEntities())
{
try
{
User userFound = ReadData_User(username);
if (password == userFound.Password)
{
return(userFound);
}
string userGuid = userFound.UserGuid.ToString();
string hashedPassword = HashData.Security.HashSHA1(password + userGuid);
if (hashedPassword == userFound.Password)
{
return(userFound);
}
return(null);
}
catch (Exception e)
{
return(null);
}
}
}
public bool SaveData_User(User user)
{
using (var context = new MusicDatabaseEntities())
{
var isUserAlreadySaved = (from u in context.Users
where user.Username == u.Username select u).SingleOrDefault();
if (isUserAlreadySaved != null)
{
return(false);
}
try
{
Guid userGuid = System.Guid.NewGuid();
string hashedPassword = HashData.Security.HashSHA1
(user.Password + userGuid.ToString());
user.Password = hashedPassword;
user.UserGuid = userGuid;
context.Users.Add(user);
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public Rating[] ReadData_Ratings()
{
using (var context = new MusicDatabaseEntities())
{
try
{
var query = (from r in context.Ratings
join a in context.Albums on r.IdAlbum equals a.IdAlbum
join u in context.Users on r.IdUser equals u.IdUser
select r).ToArray();
Rating[] output = new Rating[query.Length];
for (int i = 0; i < query.Length; i++)
{
output[i] = new Rating
{
Album = query[i].Album,
IdAlbum = query[i].IdAlbum,
User = query[i].User,
IdUser = query[i].IdUser,
IdRating = query[i].IdRating,
Rating1 = query[i].Rating1
};
}
return(output);
}
catch (Exception e)
{
return(null);
}
}
}
public bool UpdateData_Album(Album album)
{
using (var context = new MusicDatabaseEntities())
{
var actualRecord = ReadData_Album(album.IdAlbum);
if (string.IsNullOrEmpty(album.ArtistName))
{
album.ArtistName = actualRecord.ArtistName;
}
if (string.IsNullOrEmpty(album.AlbumName))
{
album.AlbumName = actualRecord.AlbumName;
}
try
{
var record = context.Albums.Where(a => a.IdAlbum == album.IdAlbum).FirstOrDefault();
record.AlbumName = album.AlbumName;
record.ArtistName = album.ArtistName;
record.IdAlbum = album.IdAlbum;
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public Rating ToRating()
{
using (var context = new MusicDatabaseEntities())
{
var album = (from a in context.Albums where a.IdAlbum == IdAlbum select a).SingleOrDefault();
var user = (from u in context.Users where u.IdUser == IdUser select u).SingleOrDefault();
Rating output = new Rating {
IdAlbum = album.IdAlbum, IdRating = this.IdRating, IdUser = user.IdUser, Rating1 = Rating
};
return(output);
}
}
public User[] ReadData_Users()
{
using (var context = new MusicDatabaseEntities())
{
try
{
var query = (from u in context.Users select u).ToArray();
return(query);
}
catch (Exception)
{
return(null);
}
}
}
public Album[] ReadData_Albums()
{
Album[] query;
using (var context = new MusicDatabaseEntities())
{
try
{
query = (from a in context.Albums select a).ToArray();
return(query);
}
catch (Exception)
{
return(null);
}
}
}
public bool DeleteData_Rating(int id)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var rating = context.Ratings.Find(id);
context.Entry(rating).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool UpdateData_Rating(int ratingId, int?rating)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var record = context.Ratings.SingleOrDefault(r => r.IdRating == ratingId);
record.Rating1 = rating;
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool UpdateData_Rating(Rating rating)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var record = context.Ratings.SingleOrDefault(r => r.IdAlbum == rating.IdAlbum && r.IdUser == rating.IdUser);
record.Rating1 = rating.Rating1;
record.IdUser = rating.IdUser;
record.IdAlbum = rating.IdAlbum;
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public Album ReadData_Album(int id)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var albumChecked = (from a in context.Albums where a.IdAlbum == id select a).SingleOrDefault();
if (albumChecked == null)
{
return(null);
}
return(albumChecked);
}
catch (Exception)
{
return(null);
}
}
}
public Album ReadData_Album(string artistName, string albumName)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var albumChecked = (from a in context.Albums where a.ArtistName == artistName && a.AlbumName == albumName select a).SingleOrDefault();
if (albumChecked == null)
{
return(null);
}
return(albumChecked);
}
catch (Exception)
{
return(null);
}
}
}
public User ReadData_User(int id)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var checkUser = (from u in context.Users where u.IdUser == id select u).SingleOrDefault();
if (checkUser == null)
{
return(null);
}
return(checkUser);
}
catch (Exception)
{
return(null);
}
}
}
public Rating ReadData_Rating(int id)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var checkRating = (from a in context.Ratings where a.IdRating == id select a).SingleOrDefault();
if (checkRating == null)
{
return(null);
}
else
{
var query = (from r in context.Ratings
join a in context.Albums on r.IdAlbum equals a.IdAlbum
join u in context.Users on r.IdUser equals u.IdUser
where r.IdRating == id
select r).SingleOrDefault();
Rating output = new Rating
{
Album = query.Album,
IdAlbum = query.IdAlbum,
User = query.User,
IdUser = query.IdUser,
IdRating = query.IdRating,
Rating1 = query.Rating1
};
return(output);
}
}
catch (Exception)
{
return(null);
}
}
}
public bool SaveData_Rating(Rating rating)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var checkIfRatingExist = (from c in context.Ratings where c.IdAlbum == rating.IdAlbum && c.IdUser == rating.IdUser select c).SingleOrDefault();
if (checkIfRatingExist == null)
{
context.Ratings.Add(rating);
context.SaveChanges();
return(true);
}
else
{
return(UpdateData_Rating(rating));
}
}
catch (Exception)
{
return(false);
}
}
}
public bool SaveData_Album(string artistName, string albumName)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var isAlbumAlreadySaved = (from a in context.Albums where a.ArtistName == artistName && a.AlbumName == albumName select a).SingleOrDefault();
if (isAlbumAlreadySaved != null)
{
return(false);
}
context.Albums.Add(new Album {
ArtistName = artistName, AlbumName = albumName
});
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool UpdateData_User(User user)
{
using (var context = new MusicDatabaseEntities())
{
try
{
var record = context.Users.Where(u => u.IdUser == user.IdUser).FirstOrDefault();
if (record == null)
{
return(false);
}
if (user.Username != null)
{
record.Username = user.Username;
}
if (user.Rank != null)
{
record.Rank = user.Rank;
}
if (user.Password != null)
{
//actualRecord.Password = user.Password;
Guid userGuid = System.Guid.NewGuid();
string hashedPassword = HashData.Security.HashSHA1
(user.Password + userGuid.ToString());
record.Password = hashedPassword;
record.UserGuid = userGuid;
}
context.SaveChanges();
/*var actualRecord = ReadData_User(user.IdUser);
* if(user.Username == null)
* {
* user.Username = actualRecord.Username;
* }
*
* if (user.Password == null)
* {
* user.Password = actualRecord.Password;
* }
*
* if (user.Rank == null)
* {
* user.Rank = actualRecord.Rank;
* }
*
* var record = context.Users.Where(u => u.IdUser == user.IdUser).FirstOrDefault();
*
* record.IdUser = user.IdUser;
* record.Password = user.Password;
* record.Username = user.Username;
* record.Rank = user.Rank;
* context.SaveChanges();*/
return(true);
}
catch (Exception)
{
return(false);
}
}
}
