public static async Task <bool> insertUserAsync(string uName, string uEmail, string uPass)
{
moviesProjectContext context = new moviesProjectContext();
bool flag = true;
try
{
//query = "INSERT INTO `users` (`userEmail`, `userName` , `userPassword`) VALUES('" + uEmail + "', '" + uName + "', '" + uPass + "')";
await context.Users.AddAsync(new User()
{
UserEmail = uEmail,
UserName = uName,
UserPassword = uPass,
IsAdmin = false
});
await context.SaveChangesAsync();
}
catch (Exception e)
{
flag = false;
}
return(flag);
}
public static async Task <bool> insertRatingAsync(int movieId, string userEmail, string commentContent, bool like)
{
bool flag = true;
try
{
//String query = "REPLACE INTO ratings VALUES (0," + movieId + ",'" + userEmail+"','"+commentContent+"',"+like+")";
moviesProjectContext context = new moviesProjectContext();
if (await context.Ratings.AsQueryable().AnyAsync(x => x.UserEmail == userEmail && x.MovieId == movieId))
{
var item = await context.Ratings.AsQueryable().SingleAsync(x => x.UserEmail == userEmail && x.MovieId == movieId);
item.Like = like;
item.CommentContent = commentContent;
}
else
{
await context.Ratings.AddAsync(new Rating()
{
UserEmail = userEmail,
MovieId = movieId,
CommentContent = commentContent,
Like = like
});
}
await context.SaveChangesAsync();
}
catch (Exception ex)
{
flag = false;
}
return(flag);
}
public static async Task <bool> removeFromWLAsync(string uEmail, int MovieId)
{
moviesProjectContext context = new moviesProjectContext();
try
{
List <Movie> MovieList = new List <Movie>();
// query = "DELETE FROM `watchlist` WHERE userEmail='" + uEmail + "' AND movieId=" + MovieId + "";
var itemToRemove = await context.Watchlists.AsQueryable().SingleOrDefaultAsync(x => x.MovieId == MovieId && x.UserEmail.ToUpper() == uEmail.ToUpper()); //returns a single item.
if (itemToRemove != null)
{
context.Watchlists.Remove(itemToRemove);
await context.SaveChangesAsync();
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static async Task <bool> insertInWLAsync(string uEmail, int MovieId)
{
moviesProjectContext context = new moviesProjectContext();
try
{
//query = "INSERT INTO `watchlist` (`userEmail`, `movieId` ) VALUES('" + uEmail + "', " + MovieId + ")";
await context.Watchlists.AddAsync(new Watchlist()
{
UserEmail = uEmail,
MovieId = MovieId
});
await context.SaveChangesAsync();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static async Task <bool> ChangePass(string uEmail, string uPass, string newPass)
{
moviesProjectContext context = new moviesProjectContext();
bool flag = false;
try
{
if (await context.Users.AsQueryable().AnyAsync(x => x.UserEmail == uEmail && x.UserPassword == uPass))
{
var item = await context.Users.AsQueryable().SingleAsync(x => x.UserEmail == uEmail && x.UserPassword == uPass);
item.UserPassword = newPass;
flag = true;
}
await context.SaveChangesAsync();
}
catch (Exception e)
{
flag = false;
}
return(flag);
}
public static async Task <bool> deleteRatingAsync(int movieId, string userEmail)
{
moviesProjectContext context = new moviesProjectContext();
bool flag = true;
try
{
//String query = "DELETE FROM RATINGS WHERE movieId = '" + movieId + "' AND userEmail = '"+userEmail+"'";
var itemToRemove = await context.Ratings.AsQueryable().SingleOrDefaultAsync(x => x.MovieId == movieId && x.UserEmail == userEmail); //returns a single item.
if (itemToRemove != null)
{
context.Ratings.Remove(itemToRemove);
await context.SaveChangesAsync();
}
}
catch (Exception e)
{
flag = false;
}
return(flag);
}
