/// <summary>
/// Get inventory from specific movie
/// </summary>
/// <param name="idMovie">ID Movie</param>
/// <returns>Result object</returns>
public DBResults <Inventory> GetInventoriesByIdMovie(int idMovie)
{
DBResults <Inventory> dbResult = new DBResults <Inventory>();
try
{
using (SevenDaysContext db = new SevenDaysContext(Configuration))
{
var inventories = db.Inventory.Where(i => i.IdMovie == idMovie).ToList();
if (inventories == null)
{
dbResult.Message = "No inventory for movie";
}
else
{
dbResult.Success = true;
dbResult.Items = inventories;
}
}
}
catch (Exception ex)
{
dbResult.Message = Common.GetMessageError(ex);
}
return(dbResult);
}
/// <summary>
/// Get purchases from specific user
/// </summary>
/// <param name="idUser">ID User</param>
/// <returns>Result object</returns>
public DBResults <Sale> GetSalesByIdUser(int idUser)
{
DBResults <Sale> dbResult = new DBResults <Sale>();
try
{
using (SevenDaysContext db = new SevenDaysContext(Configuration))
{
var sales = db.Sale.Where(i => i.IdUser == idUser).ToList();
if (sales == null)
{
dbResult.Message = "No sales for user";
}
else
{
dbResult.Success = true;
dbResult.Items = sales;
}
}
}
catch (Exception ex)
{
dbResult.Message = Common.GetMessageError(ex);
}
return(dbResult);
}
/// <summary>
/// Get All movies
/// </summary>
/// <returns>Result object</returns>
public DBResults <Movie> GetMovies()
{
DBResults <Movie> dbResult = new DBResults <Movie>();
try
{
using (SevenDaysContext db = new SevenDaysContext(Configuration))
{
var movie = db.Movie.Where(m => m.IsAvailable == true).OrderBy(m => m.Title).ToList();
dbResult.Success = true;
dbResult.Items = movie;
}
}
catch (Exception ex)
{
dbResult.Message = Common.GetMessageError(ex);
}
return(dbResult);
}
