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 context = new LunaContext())
{
var user = context.Users.FirstOrDefault(i => i.Email == email);
{
if (user.AccountStatus == 1)
{
user.AccountStatus = 0;
context.SaveChanges();
}
else
{
user.AccountStatus = 1;
context.SaveChanges();
}
}
}
return(1);
}
catch (Exception 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 byte MovieAvailabilty(int id)
{
try
{
using (var context = new LunaContext())
{
var movie = context.Movies.FirstOrDefault(i => i.MovieId == id);
{
if (movie.IsAvailable == 1)
{
movie.IsAvailable = 0;
context.SaveChanges();
}
else
{
movie.IsAvailable = 1;
context.SaveChanges();
}
}
}
return(1);
}
catch (Exception e)
{
ErrorLog(e);
return(0);
}
}
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);
}
}
/// <summary>
/// Oppretter en ordre til en aktuell bruker og oppdaterer databasecontexten.
/// </summary>
/// <param name="movieList">Tar inn en liste av filmer.</param>
/// <param name="userEmail">Tar inn en bruker-epost som fungerer som id og navigasjon.</param>
/// <returns></returns>
public bool createOrder(List <Movie> movieList, string userEmail)
{
using (var context = new LunaContext())
{
try
{
var order = new Order();
var newOrderLines = new List <OrderLine>();
order.User = context.Users.FirstOrDefault(m => m.Email == userEmail);
order.OrderDate = DateTime.Now;
order.OrderLine = newOrderLines;
foreach (var movie in movieList)
{
var newOrderLine = new OrderLine();
newOrderLine.Movie = context.Movies.FirstOrDefault(m => m.MovieId == movie.MovieId);
newOrderLine.Order = order;
order.OrderLine.Add(newOrderLine);
}
context.Orders.Add(order);
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool RemoveUser(string Email)
{
using (var context = new LunaContext())
{
var userToDelete = context.Users.FirstOrDefault(e => e.Email == Email);
if (userToDelete != null)
{
context.Users.Remove(userToDelete);
context.SaveChanges();
return(true);
}
return(false);
}
}
public string UpdateInProgress(long id)
{
var inters = _context.Interventions.Find(id);
if (inters == null)
{
return("Please enter an existing intervention id");
}
if (inters.Status != "Pending")
{
return("Please choose a Pending intervention");
}
else
{
inters.Status = "In Progress";
string StartingDate = DateTime.Now.ToString("yyyy/MM/dd H:mm:ss");
inters.StartingDate = StartingDate;
_context.Interventions.Update(inters);
_context.SaveChanges();
return("The intervention #" + inters.Id + " status has been successufully changed to In Progress at " + inters.StartingDate);
}
}
public ActionResult Update(long id, Elevators elevator)
{
var elv = _context.Elevators.Find(id);
if (elv == null)
{
return(NotFound());
}
elv.Status = elevator.Status;
_context.Elevators.Update(elv);
_context.SaveChanges();
return(NoContent());
}
public ActionResult Update(long id, Columns column)
{
var col = _context.Columns.Find(id);
if (col == null)
{
return(NotFound());
}
col.Status = column.Status;
_context.Columns.Update(col);
_context.SaveChanges();
return(NoContent());
}
public ActionResult Update(long id, Batteries battery)
{
var bat = _context.Batteries.Find(id);
if (bat == null)
{
return(NotFound());
}
bat.Status = battery.Status;
_context.Batteries.Update(bat);
_context.SaveChanges();
return(NoContent());
}
/// <summary>
/// Legger inn en ny bruker i user-tabellen. Postaddressene legges ikke dobbelt
/// slik at vi slipper dobbeltlagring. Et problem nå er at hvis noen lager en postnummer
/// med feil poststed, vil alle andre med samme postnummer få dette poststedet også.
/// Vi har planlagt å bruke Posten sitt API for å fylle databasen vår med postnumre og
/// auto-fylle posted for å unngå dette. Her er det også en try-catch vi må håndtere.
/// </summary>
/// <param name="inUser">Tar inn en bruker</param>
/// <returns>returnerer en bolsk verdi avhengig av om registreringen var velykket eller ikke.</returns>
public bool AddCustomer(UserViewModel inUser)
{
using (var context = new LunaContext())
{
try
{
if (context.Users.FirstOrDefault(u => u.Email == inUser.Email) != null)
{
return(false);
}
var newUser = new User()
{
FirstName = inUser.FirstName,
LastName = inUser.LastName,
Address = inUser.Address,
AccountStatus = 1
};
//Legger inn nytt postnr og poststed hvis det ikke allerede finnes i databasen.
if (context.PostalAddresses.Find(inUser.ZipCode) != null)
{
newUser.PostalAddress = context.PostalAddresses.FirstOrDefault(z => z.ZipCode == inUser.ZipCode);
}
else
{
newUser.PostalAddress = new PostalAddress()
{
ZipCode = inUser.ZipCode,
PostalArea = inUser.PostalArea
};
}
newUser.Email = inUser.Email;
var salt = PasswordEncryption.addSalt();
newUser.Salt = salt;
newUser.Password = PasswordEncryption.toHash(inUser.Password, salt);
context.Users.Add(newUser);
context.SaveChanges();
return(true);
}
catch (Exception error)
{
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);
}
}
public bool RemoveUser(string Email)
{
try
{
using (var context = new LunaContext())
{
var userToDelete = context.Users.FirstOrDefault(e => e.Email == Email);
if (userToDelete != null)
{
var orders = context.Orders.Include("OrderLine").Where(u => u.User.UserId == userToDelete.UserId).ToList();
foreach (var order in orders)
{
var orderlines = context.OrderLines.Where(u => u.Order.OrderId == order.OrderId).ToList();
context.Orders.Remove(order);
foreach (var orderline in orderlines)
{
context.OrderLines.Remove(orderline);
}
}
context.Users.Remove(userToDelete);
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
} catch (Exception e)
{
ErrorLog(e);
return(false);
}
}
