public async Task <IActionResult> OnGetAsync() { var user = await _userManager.GetUserAsync(User); if (user == null) { return(NotFound($"Unable to load user with ID '{_userManager.GetUserId(User)}'.")); } var userName = await _userManager.GetUserNameAsync(user); Username = userName; using (_dbContext = new BillardAppIdentityDbContext(_dbinit.setupOptions().Options)) { var equipment = from eq in _dbContext.BillardAppUserEquipment where eq.Owner.Equals(Username) select eq; //Photo = "~/images/[email protected]/r360Edge-1-300x300.jpg"; ListInputModel = new List <InputModel> (); foreach (BillardAppUserEquipment item in equipment) { ImagePathMaker pathMaker = new ImagePathMaker(item.Photo); // input.Name = item.Name; // input.Description = item.Description; // input.Website = string.IsNullOrEmpty (item.Website) == false ? (item.Website.Contains ("www.") == true ? item.Website : "None") : "None"; // input.Price = item.Price; // input.imagePath = pathMaker.validatePath (); ListInputModel.Add(new InputModel { id = item.id, Name = item.Name, Description = item.Description, Website = string.IsNullOrEmpty(item.Website) == false ? (item.Website.Contains("www.") == true ? item.Website : "<br/>") : "<br/>", Price = item.Price, imagePath = pathMaker.validatePath() }); } InputModel Input = new InputModel { id = 0, Name = "None", Description = "None", Price = "0", Website = "None", imagePath = "None", Upload = null }; } return(Page()); }
public JsonResult OnGetEquipmentEdit(int itemId) { BillardAppDatabaseInitializer _dbinit = new BillardAppDatabaseInitializer(); BillardAppIdentityDbContext _dbContext = new BillardAppIdentityDbContext(_dbinit.setupOptions().Options); var equipment = from eq in _dbContext.BillardAppUserEquipment where eq.id.Equals(itemId) select eq; ImagePathMaker pathMaker = new ImagePathMaker(equipment.First().Photo); Input.id = equipment.First().id; Input.Name = equipment.First().Name; Input.Description = equipment.First().Description; Input.Price = equipment.First().Price; Input.Website = string.IsNullOrEmpty(equipment.First().Website) == false ? (equipment.First().Website.Contains("www.") == true ? equipment.First().Website : "None") : "None"; Input.imagePath = pathMaker.validatePath(); return(new JsonResult(Input)); }
public IActionResult OnGet(string returnUrl = null) { BillardAppDatabaseInitializer _dbinit = new BillardAppDatabaseInitializer(); BillardAppIdentityDbContext _dbContext = new BillardAppIdentityDbContext(_dbinit.setupOptions().Options); if (Id == 0) { _billiardClubs = from e in _dbContext.BilliardClubs where e.Owner == _userManager.GetUserName(User) select e; return(Page()); } else { if (_userManager.GetUserName(User) != _dbContext.BilliardClubs.SingleOrDefault(e => e.id == Id).Owner) { returnUrl = returnUrl ?? Url.Content("~/ViewBilliardClub/0"); StatusMessage = "This billiard club is not yours!!"; return(LocalRedirect(returnUrl)); } _billiardClub = _dbContext.BilliardClubs.SingleOrDefault(e => e.id == Id); _notifications = from e in _dbContext.BilliardClubNotifications where e.ForBilliardCLub == _billiardClub.id select e; _notificationCount = _notifications.Count(); ImagePathMaker pathMaker = new ImagePathMaker(_billiardClub.Photo); _billiardClub.Photo = pathMaker.validatePath(); Input = new InputModel { Name = _billiardClub.Name, Description = _billiardClub.Description, Origin = _billiardClub.Origin, Website = _billiardClub.Website, Address = _billiardClub.Address, Latitude = _billiardClub.Latitude, Longitude = _billiardClub.Longitude }; var Members = from e in _dbContext.BilliardClubUsersReference join user in _dbContext.Users on e.BilliardAppUserId equals user.Id where e.BilliardClubId == Id select new { e.BilliardAppUserId, e.BilliardClubId, e.Approved, user.Name, user.LastName, user.UserName }; _members = new List <MembersModel> (); foreach (var item in Members) { _members.Add(new MembersModel { BilliardAppUserId = item.BilliardAppUserId, BilliardClubId = item.BilliardClubId, Approved = item.Approved, Name = item.Name, LastName = item.LastName, UserName = item.UserName }); } var billiardEvents = from e in _dbContext.BilliardEvents where e.forBilliardClub == Id select e; foreach (var item in billiardEvents) { _billiardEvents.Add(new BilliardEvents { EventStartDate = item.EventStartDate, Description = item.Description, Name = item.Name, NumberOfPlayers = item.NumberOfPlayers, Address = item.Address, Latitude = item.Latitude, Longitude = item.Longitude, Owner = item.Owner, Photo = item.Photo, ParticipationFee = item.ParticipationFee, Approved = item.Approved, forBilliardClub = item.forBilliardClub, CreatedDate = item.CreatedDate, id = item.id }); } return(Page()); } }