public byte SetOrderStatus(int id)
{
try
{
using (var db = new LunaContext())
{
//Logg event to file
db.LogFromDB();
var order = db.Orders.FirstOrDefault(i => i.OrderId == id);
{
if (order.Status == 1)
{
order.Status = 0;
db.SaveChanges();
}
else
{
order.Status = 1;
db.SaveChanges();
}
}
}
return(1);
}
catch (Exception e)
{
ErrorLog(e);
return(0);
}
}
public byte SetUserStatus(string email)
{
try
{
using (var db = new LunaContext())
{
//Logg event to file
db.LogFromDB();
var user = db.Users.FirstOrDefault(i => i.Email == email);
{
if (user.AccountStatus == 1)
{
user.AccountStatus = 0;
db.SaveChanges();
}
else
{
user.AccountStatus = 1;
db.SaveChanges();
}
}
}
return(1);
}
catch (Exception e)
{
ErrorLog(e);
return(0);
}
}
public bool VerifyAdmin(Login login)
{
Debug.WriteLine("VERIFY");
try
{
using (var db = new LunaContext())
{
//Logg event to file
db.LogFromDB();
AdminUser adminUser = db.AdminUsers.FirstOrDefault(u => u.Username == login.Username);
if (adminUser != null)
{
byte[] usedPassword = PasswordEncryption.toHash(login.Password, adminUser.Salt);
return(adminUser.Password.SequenceEqual(usedPassword));
}
else
{
return(false);
}
}
} catch (Exception e)
{
ErrorLog(e);
return(false);
}
}
public bool EditMovie(Movie movie)
{
try
{
using (var db = new LunaContext())
{
//Logg event to file
db.LogFromDB();
var MovieInDb = db.Movies.First(m => m.MovieId == movie.MovieId);
MovieInDb.Title = movie.Title;
MovieInDb.Price = movie.Price;
MovieInDb.ReleaseYear = movie.ReleaseYear;
MovieInDb.ContentRating = movie.ContentRating;
MovieInDb.Director = movie.Director;
MovieInDb.Duration = movie.Duration;
MovieInDb.Genre = movie.Genre;
MovieInDb.Storyline = movie.Storyline;
db.SaveChanges();
return(true);
}
} catch (Exception e)
{
ErrorLog(e);
return(false);
}
}
public bool AddMovie(Movie movie)
{
try {
using (var db = new LunaContext())
{
//Logg event to file
db.LogFromDB();
if (movie != null)
{
Movie newMovie = new Movie
{
Title = movie.Title,
Director = movie.Director,
ContentRating = movie.ContentRating,
IsAvailable = 1,
Genre = movie.Genre,
Duration = movie.Duration,
Price = movie.Price,
Storyline = movie.Storyline,
ReleaseYear = movie.ReleaseYear,
Poster = movie.Poster,
Stars = movie.Stars
};
db.Movies.Add(newMovie);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}catch (Exception e)
{
ErrorLog(e);
return(false);
}
}
public bool EditUser(User user)
{
try
{
using (var db = new LunaContext())
{
//Logg event to file
db.LogFromDB();
var UserInDb = db.Users.First(u => u.UserId == user.UserId);
UserInDb.FirstName = user.FirstName;
UserInDb.LastName = user.LastName;
UserInDb.Address = user.Address;
if (db.PostalAddresses.Find(user.PostalAddress.ZipCode) != null)
{
UserInDb.PostalAddress = db.PostalAddresses.FirstOrDefault(z => z.ZipCode == user.PostalAddress.ZipCode);
}
else
{
UserInDb.PostalAddress = new PostalAddress()
{
ZipCode = user.PostalAddress.ZipCode,
PostalArea = user.PostalAddress.PostalArea
};
}
//UserInDb.PostalAddress.PostalArea = user.PostalAddress.PostalArea;
//UserInDb.PostalAddress.ZipCode = user.PostalAddress.ZipCode;
db.SaveChanges();
return(true);
}
} catch (Exception e)
{
ErrorLog(e);
return(false);
}
}