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