public static string Register(dynamic user)
{
try
{
using (var db = new MoviesDBEntities())
{
var us = new User();
string id = Convert.ToString(user.userId);
string pass = Convert.ToString(user.password);
us.Id = id;
us.Password = pass;
us.FirstName = Convert.ToString(user.user_fname);
us.LastName = Convert.ToString(user.user_lname);
us.Email = Convert.ToString(user.email);
us.Admin = false;
db.User.Add(us);
db.SaveChanges();
return(us.Id.ToString());
}
}
catch (Exception e)
{
throw e;
}
}
public static string DeleteMovie(int movie)
{
try
{
using (var db = new MoviesDBEntities())
{
var b = db.Movie.Where(i => i.Id == movie).FirstOrDefault();
b.IsArchive = true;
var a = db.MovieActor.Where(i => i.MovieID == movie).ToArray();
foreach (MovieActor ac in a)
{
db.MovieActor.Remove(ac);
}
var ums = db.UserMovie.Where(i => i.MovieID == movie).ToArray();
foreach (UserMovie um in ums)
{
db.UserMovie.Remove(um);
}
db.SaveChanges();
return("ok");
}
}
catch (Exception e)
{
throw e;
}
}
public static string ReturnMovie(int movie, string user)
{
try
{
using (var db = new MoviesDBEntities())
{
var um = db.UserMovie.Where(i => i.MovieID == movie && i.UserID == user).FirstOrDefault();
db.UserMovie.Remove(um);
var m = db.Movie.Where(i => i.Id == movie).FirstOrDefault();
m.FreeQuantity++;
db.SaveChanges();
return("ok");
}
}
catch (Exception e)
{
throw e;
}
}
public static string Login(dynamic user)
{
try
{
using (var db = new MoviesDBEntities())
{
string id = Convert.ToString(user.userId);
string pass = Convert.ToString(user.password);
var b = db.User.Where(i => i.Id == id && i.Password == pass).FirstOrDefault();
if (b == null)
{
throw new AuthenticationException("Invalid identification data.");
}
return(JsonConvert.SerializeObject(b));
}
}
catch (Exception e)
{
throw e;
}
}
public static string RentMovie(string user, int movie)
{
try
{
using (var db = new MoviesDBEntities())
{
var um = new UserMovie();
um.UserID = user;
um.MovieID = movie;
db.UserMovie.Add(um);
var m = db.Movie.Where(i => i.Id == movie).FirstOrDefault();
m.FreeQuantity--;
db.SaveChanges();
return("ok");
}
}
catch (Exception e)
{
throw e;
}
}
public static string UpdateMovie(dynamic obj)
{
try
{
using (var db = new MoviesDBEntities())
{
int id = Convert.ToInt32(obj["Id"]);
var b = id == 0 ? new Movie() : db.Movie.Where(i => i.Id == id).FirstOrDefault();
var isNew = false;
if (id == 0)
{
isNew = true;
}
b.Director = Convert.ToInt32(obj["Director"]);
b.Genre = Convert.ToInt32(obj["Genre"]);
b.Year = Convert.ToInt32(obj["Year"]);
b.Plot = Convert.ToString(obj["Plot"]);
b.Name = Convert.ToString(obj["Name"]);
b.HasPoster = Convert.ToBoolean(obj["HasPoster"]) || Convert.ToBoolean(obj["HasNewPoster"]);
b.FreeQuantity = Convert.ToInt32(obj["FreeQuantity"]);
if (isNew)
{
db.Movie.Add(b);
}
var currActors = db.MovieActor.Where(i => i.MovieID == id).ToArray();
foreach (var x in obj["Actors"])
{
int actorid = Convert.ToInt32(x["Id"]);
var exist = currActors.Where(z => z.ActorID == actorid).FirstOrDefault();
if (exist == null)
{
var newActor = new MovieActor();
newActor.MovieID = id;
newActor.ActorID = actorid;
db.MovieActor.Add(newActor);
}
else
{
currActors = currActors.Where(z => z.ActorID != exist.ActorID).ToArray();
}
}
foreach (MovieActor x in currActors)
{
db.MovieActor.Remove(x);
}
db.SaveChanges();
if ((bool)obj["HasNewPoster"] && isNew)
{
ConvertPosterNameToId(Convert.ToString(obj["PosterTS"]), b.Id.ToString());
}
return(JsonConvert.SerializeObject(new { Id = b.Id, IsNew = isNew }));
}
}
catch (Exception e)
{
throw e;
}
}
