/// <summary>
/// Retorna desde la base de datos los datos del usuario que recibe
/// </summary>
/// <param name="username"></param>
/// <returns>usuario</returns>
public async Task <ApplicationUser> GetUserByName(string username)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
return(await Db.ApplicationUser.Where(x => x.UserName == username).FirstOrDefaultAsync());
}
}
/// <summary>
/// AQctuaqliza un producto
/// </summary>
/// <param name="model"></param>
public async void UpdateProduct(ProductsModel model)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
Db.Entry(model).State = EntityState.Modified;
await Db.SaveChangesAsync();
}
}
/// <summary>
/// Actualiza los datos del usuario
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public async Task Updateuser(ApplicationUser user)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
Db.Entry(user).State = EntityState.Modified;
await Db.SaveChangesAsync();
}
}
/// <summary>
/// Permite almacenar la reserva
/// </summary>
/// <param name="reserve"></param>
/// <returns></returns>
public async Task SaveReserveAync(ReserveProductModel reserve)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
await Db.AddAsync(reserve);
await Db.SaveChangesAsync();
}
}
/// <summary>
/// Almacena en base datos el historico de login de los usuarios
/// </summary>
/// <param name="sedeUsuario"></param>
/// <returns></returns>
public async Task SaveLogLogin(LoginLogModel sedeUsuario)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
await Db.AddAsync(sedeUsuario);
await Db.SaveChangesAsync();
}
}
/// <summary>
/// This method permit update a register products from database
/// </summary>
/// <param name="modelProduct"></param>
/// <returns></returns>
public IObservable <ProductsModel> UpdateProduct(ProductsModel modelProduct)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
Db.Entry(modelProduct).State = EntityState.Modified;
Db.SaveChanges();
return(Observable.Return(modelProduct));
}
}
/// <summary>
/// This method gets all products from database
/// </summary>
/// <returns></returns>
public IObservable <List <ProductsModel> > GetProducts()
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var products = from p in Db.ProductsModel
select p;
return(Observable.Return(products.ToList()));
}
}
/// <summary>
/// This method save the product into the database
/// </summary>
/// <param name="reserve"></param>
/// <returns></returns>
public IObservable <ProductsModel> SetProduct(ProductsModel reserve)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
Db.Add(reserve);
Db.SaveChanges();
return(Observable.Return(reserve));
}
}
/// <summary>
/// This method gets the product by Id
/// </summary>
/// <param name="idProduct"></param>
/// <returns></returns>
public IObservable <ProductsModel> GetProductById(int idProduct)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var product = from p in Db.ProductsModel
where p.idProduct == idProduct
select p;
return(Observable.Return(product.FirstOrDefault()));
}
}
/// <summary>
/// Consulta los productos por id
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <ProductsModel> GetProductsById(ProductsViewModel model)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var products = from u in Db.ProductsModel
where u.idProduct == model.ProductoId
select u;
return(await products.FirstOrDefaultAsync());
}
}
/// <summary>
/// Obtiene el listado historico del log de registro
/// </summary>
/// <returns></returns>
public async Task <List <LogLoginViewModel> > GetHistorical()
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var historical = from u in Db.LoginLogModel
join p in Db.ApplicationUser on u.userName equals p.UserName
select new LogLoginViewModel {
userName = p.NombreCompleto,
dateLogin = u.dateLogin
};
return(await historical.ToListAsync());
}
}
/// <summary>
/// Obtiene las reservas de la aplicación
/// </summary>
/// <returns></returns>
public async Task <List <ReserveViewModel> > GetReserve()
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var reserve = from u in Db.ReserveProductModel
join p in Db.ApplicationUser on u.idUser equals p.Id
join pp in Db.ProductsModel on u.idProducto equals pp.idProduct
select new ReserveViewModel {
UserName = p.NombreCompleto,
Description = pp.Descripcion
};
return(await reserve.ToListAsync());
}
}
/// <summary>
/// Permite obtener el listado de productos
/// </summary>
/// <returns></returns>
public async Task <List <ProductsViewModel> > GetProducts()
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var products = from u in Db.ProductsModel
select new ProductsViewModel {
ProductoId = u.idProduct,
Descripcion = u.Descripcion,
amount = u.amount,
avalaible = u.avalaible
};
return(await products.ToListAsync());
}
}
/// <summary>
/// Permite obtener los usuarios de la aplicación
/// </summary>
/// <returns></returns>
public async Task <List <ApplicationUserViewModel> > GetUsers()
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var users = from u in Db.ApplicationUser
join ur in Db.UserRoles on u.Id equals ur.UserId
join r in Db.Roles on ur.RoleId equals r.Id
select new ApplicationUserViewModel
{
UserName = u.UserName,
CompletName = u.CompletName,
Age = u.Age,
Nationality = u.Nationality,
Rol = r.Name,
Balance = u.Balance
};
return(await users.Distinct().ToListAsync());
}
}
/// <summary>
/// Permite obtener los usuarios de la aplicación
/// </summary>
/// <returns></returns>
public async Task <List <ApplicationUserViewModel> > GetUsers()
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
var users = from u in Db.ApplicationUser
join ur in Db.UserRoles on u.Id equals ur.UserId
join r in Db.Roles on ur.RoleId equals r.Id
where u.Eliminado == false
select new ApplicationUserViewModel
{
UserName = u.UserName,
NombreCompleto = u.NombreCompleto,
Edad = u.Edad,
Genero = u.Genero,
Nacionalidad = u.Nacionalidad,
Rol = r.Name
};
return(await users.Distinct().ToListAsync());
}
}
