/// <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()); } }