/// <summary>
/// Get action method to show current bookings of the member
/// </summary>
/// <returns>View containing the bookings</returns>
public virtual ActionResult Booking(int? page)
{
var id = WebHelper.GetIdentityId(User.Identity);
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
var p = page ?? 1;
try
{
var member = mRepo.Get(id);
Member.Validate(member);
var list = member.MemberBookings.Where(mb => !mb.Expired).OrderByDescending(b=>b.CreationDate);
var model = new PagingList<MemberBooking>
{
List = list.Skip((p - 1) * PagedListViewModel.PageSize).Take(PagedListViewModel.PageSize).ToList(),
PagingInfo = new PagingInfo { CurrentPage = p, ItemsPerPage = PagedListViewModel.PageSize, TotalItems = list.Count() }
};
return View(model);
}
catch (Exception ex)
{
_Logger.Error("Booking", ex);
return View(MVC.Shared.Views.Error);
}
}
/// <summary>
/// 获取所有角色分页列表
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public PagingList<RoleDto> GetRoles(GetRolesInput input)
{
var query = _roleRepository.Table;
var source = query.OrderBy(n => n.Id)
.Skip((input.PageIndex - 1) * input.PageSize)
.Take(input.PageSize)
.MapTo<List<RoleDto>>();
var result = new PagingList<RoleDto>(source, input.PageIndex, input.PageSize, query.LongCount());
return result;
}
public PagingList <UserModel> getUsers(IndexModel foIndexModel)
{
SqlParameter[] laParam = new SqlParameter[] {
new SqlParameter("@inTotalRecordFound", SqlDbType.Int, 8, ParameterDirection.Output, false, 0, 0, String.Empty, DataRowVersion.Default, 0)
};
List <UserListDbQueryModel> tblUserlist = moDataContext.tblUserList.FromSqlRaw("getUsersList {0},{1},{2},{3},@inTotalRecordFound OUTPUT",
foIndexModel.PageNumber, foIndexModel.PageSize, foIndexModel.stFilterKeyword, foIndexModel.stSortKeyword, laParam[0]).ToList();
PagingList <UserModel> loUserList = new PagingList <UserModel>(moAutoMapper.Map <List <UserListDbQueryModel>, List <UserModel> >(tblUserlist), foIndexModel.PageNumber, foIndexModel.PageSize, Convert.ToInt32(laParam[0].Value));
return(loUserList);
}
public IActionResult Index(int pageNumber = 1, string sort = "Name")
{
var qry = from sd in _sampleData
where sd.Number > -5
select sd;
var model = PagingList.Create(qry, 10, pageNumber, sort, "Name");
model.PageParameterName = "pageNumber";
model.SortExpressionParameterName = "sort";
return(View(model));
}
public async Task <IActionResult> Index(int page = 1)
{
var query = db.clanak.AsNoTracking().OrderByDescending(c => c.DatumObjave);
var model = await PagingList.CreateAsync(query, 5, page);
//List<ListaClanakaVM> model = db.clanak.Select(c => new ListaClanakaVM
//{
// ID=c.ClanakID,
// Naslov=c.Naslov,
// Slika=c.SlikaPath
//}).ToList();
return(View(model));
}
public IActionResult Index(int page = 1, int row = 10)
{
// var Roles = _roleManager.Roles.Select(r => new RolesViewModel { RoleID = r.Id, RoleName = r.Name ,Description = r.Description }).ToList();
var Roles = _roleManager.GetAllRolesAndUsersCount();
var PagingModel = PagingList.Create(Roles, row, page);
PagingModel.RouteValue = new Microsoft.AspNetCore.Routing.RouteValueDictionary
{
{ "row", row }
};
return(View(PagingModel));
}
public async Task <IActionResult> Index(int pageindex = 1, MessageNote?message = null)
{
var user = await GetCurrentUserAsync();
ViewData["Exist"] =
message == MessageNote.Exist ? "Allocation of Lecture to their Courses Generated;":
message == MessageNote.Add ? "Select One of the Record"
: "";
var model = PagingList.Create(await _mappingService.HistoyofMapping(user.DepartmentID), 5, pageindex);
return(View(model));
}
public async Task <IActionResult> Ekspozitat(int page = 1)
{
string emailUser = User.Identity.Name;
var query = _context.Ekspozitat.AsNoTracking().Where(a => a.uzerEmail == emailUser).OrderByDescending(s => s.Id_Ekspozites);
var model = await PagingList.CreateAsync(query, 3, page);
model.Action = "Ekspozitat";
return(View(model));
}
public async Task <IActionResult> Index(int page = 1, string brandName = "")
{
ViewData["brandName"] = brandName;
var query = from x in _marcaService.FindAllQueryable() select x;
if (!String.IsNullOrEmpty(brandName))
{
query = query.Where(x => x.MarNom.Contains(brandName.ToUpper()));
}
var queryOrder = query.OrderBy(order => order.MarCod);
return(View(await PagingList.CreateAsync(queryOrder, 5, page)));
}
public async Task <IActionResult> PretragaPoProizvodjacu(string naziv, int pageIndex = 1)
{
var proizvodi = ctx.ProizvodVarijacija.Include(x => x.Proizvod).Include(x => x.Slika).Where(x => x.Proizvod.Proizvodjac.Naziv.Equals(naziv)).AsNoTracking().OrderBy(x => x.Id);
var model = await PagingList.CreateAsync(proizvodi, 6, pageIndex);
model.Action = "PretragaPoProizvodjacu";
model.RouteValue = new RouteValueDictionary {
{ "naziv", naziv }
};
return(View("Index", model));
}
public async Task <IActionResult> PretragaPoNazivu(string pretraga, int pageIndex = 1)
{
var proizvodi = ctx.ProizvodVarijacija.Include(x => x.Proizvod).Include(x => x.Slika).Where(x => x.Proizvod.Naziv.Contains(pretraga)).AsNoTracking().OrderBy(x => x.Id);
var model = await PagingList.CreateAsync(proizvodi, 6, pageIndex);
model.Action = "PretragaPoNazivu";
model.RouteValue = new RouteValueDictionary {
{ "pretraga", pretraga }
};
return(View("Index", model));
}
public IActionResult ProductList(string ProductSearch, int page = 1)
{
ViewData["GetDetails"] = ProductSearch;
var query = from x in _unitOfWork.ProductRepository.GetItems() select x;
if (!String.IsNullOrEmpty(ProductSearch))
{
query = query.Where(x => x.Name.Contains(ProductSearch)).ToList();
}
var model = PagingList.Create(query, 5, page);
return(View(query));
}
// GET: TipoProdutos
public async Task <IActionResult> Index(int page = 1)
{
if (Request.Cookies["idDoUser"] == null)
{
return(RedirectToAction("Login", "Jornaleiros"));
}
var query = _context.TipoProdutos.OrderBy(v => v.NomeTipoProduto);
ListaParaCsv = query.ToList();
var model = await PagingList.CreateAsync(query, 5, page);
return(View(model));
}
public IActionResult Index(Guid cateId, Guid categoryId, string type, int page = 1)
{
ViewBag.CateId = cateId;
ViewBag.CategoryId = categoryId;
ViewBag.Type = type;
var pageSize = 10;
var file = _fileService.GetAllFileByType(categoryId, type);
var model = PagingList.Create(file, pageSize, page);
model.RouteValue = new RouteValueDictionary(new { cateId = cateId, categoryId = categoryId, type = type });
model.Action = "Index";
return(View(model));
}
// GET: Intermeios
public async Task <IActionResult> Index(string search, DateTime?minDate, DateTime?maxDate, int page = 1)
{
if (!String.IsNullOrEmpty(search))
{
var result = await _interService.FindByIntermeioAsync(minDate, maxDate, search);
ViewData["Filter"] = search;
ViewData["minDate"] = result.Item2.Value.ToString("yyyy-MM-dd");
ViewData["maxDate"] = result.Item3.Value.ToString("yyyy-MM-dd");
return(View(result.Item1));
}
return(View(await PagingList.CreateAsync(_context.Intermeio.AsNoTracking().OrderByDescending(r => r.Date_base), 20, page)));
}
// GET: Students
public async Task <IActionResult> Index(string sortOrder,
string currentFilter,
string searchString,
int?pageNumber)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["LastName_Sort"] = String.IsNullOrEmpty(sortOrder) ? "LastName_desc" : "";
ViewData["Date_Sort"] = sortOrder == "Date" ? "Date_desc" : "Date";
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var students = from s in _context.Students
select s;
if (!String.IsNullOrEmpty(searchString))
{
students = students.Where(s => s.LastName.Contains(searchString) ||
s.FirstName.Contains(searchString));
}
switch (sortOrder)
{
case "LastName_desc":
students = students.OrderByDescending(s => s.LastName);
break;
case "Date":
students = students.OrderBy(s => s.EnrollmentDate);
break;
case "Date_desc":
students = students.OrderByDescending(s => s.EnrollmentDate);
break;
default:
students = students.OrderBy(s => s.LastName);
break;
}
int pageSize = 5;
return(View(await PagingList <Student> .CreateAsync(students.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
public async Task <PagingList <IndexViewModel.Coach> > GetCoachesPagingListAsync(
string filter = null,
int pageSize = DefaultPageSize,
int page = 1,
string sortExpression = nameof(IndexViewModel.Coach.Name))
{
if (pageSize < DefaultPageSize)
{
pageSize = DefaultPageSize;
}
if (page < 1)
{
page = 1;
}
if (string.IsNullOrWhiteSpace(sortExpression))
{
sortExpression = nameof(IndexViewModel.Coach.Name);
}
var baseCoachesQuery = this.Database.Coaches;
if (!string.IsNullOrWhiteSpace(filter))
{
baseCoachesQuery = baseCoachesQuery.Where(coach => coach.RegisteredUser.FirstName.Contains(filter) || coach.RegisteredUser.LastName.Contains(filter));
}
var coachesQuery = (from coach in baseCoachesQuery
let teams = coach.Teams
.Select(tc => new IndexViewModel.Team
{
Id = tc.TeamId,
Name = tc.Team.Name
})
select new IndexViewModel.Coach
{
Id = coach.Id,
Name = coach.RegisteredUser.FirstName + " " + coach.RegisteredUser.LastName,
Teams = teams
});
var coaches = await PagingList.CreateAsync(
coachesQuery,
pageSize,
page,
sortExpression,
nameof(IndexViewModel.Coach.Name));
return(coaches);
}
public async Task <PagingList <TouristRout> > GetTourisRoutsAsync(TouristRouteRequestParam touristRouteParam, PagingRequestParam pagingRequestParam)
{
IQueryable <TouristRout> resultQueryable = FakeContext.TouristRout
.Include(xt => xt.Pictures);
if (!string.IsNullOrEmpty(touristRouteParam.TitleKeyWord))
{
resultQueryable = resultQueryable.Where(xt => xt.Title.Contains(touristRouteParam.TitleKeyWord));
}
if (touristRouteParam.RatingLogicType != LogicType.Null)
{
switch (touristRouteParam.RatingLogicType)
{
case LogicType.Null:
break;
case LogicType.LessThen:
resultQueryable = resultQueryable.Where(xt => xt.Rating < touristRouteParam.RatingValue);
break;
case LogicType.EqualTo:
resultQueryable = resultQueryable.Where(xt => xt.Rating == touristRouteParam.RatingValue);
break;
case LogicType.LargeThen:
resultQueryable = resultQueryable.Where(xt => xt.Rating > touristRouteParam.RatingValue);
break;
case LogicType.LessAndEqual:
resultQueryable = resultQueryable.Where(xt => xt.Rating <= touristRouteParam.RatingValue);
break;
case LogicType.LargeAndEqual:
resultQueryable = resultQueryable.Where(xt => xt.Rating >= touristRouteParam.RatingValue);
break;
default:
break;
}
}
if (!string.IsNullOrEmpty(pagingRequestParam.OrderBy))
{
//if (pagingRequestParam.OrderBy.ToLowerInvariant()== "OriginalPrice".ToLowerInvariant())
//{
// resultQueryable=resultQueryable.OrderBy(xt => xt.OriginalPrice);
//}
var touristRouteDic = propertyMappingServer.GetPropertyMapping <TouristRoutDTO, TouristRout>();
resultQueryable = resultQueryable.ApplySort(pagingRequestParam.OrderBy, touristRouteDic);
}
return(await PagingList <TouristRout> .CreatePagelistAsync(pagingRequestParam.PageNumber, pagingRequestParam.PageSize, resultQueryable));
}
public async Task <PagingList <ActivitiesViewModel.Activity> > GetActivitiesAsync(
string userId,
string filter = null,
int pageSize = DefaultPageSize,
int page = 1,
string sortExpression = DefaultActivitiesSortExpression)
{
if (pageSize < DefaultPageSize)
{
pageSize = DefaultPageSize;
}
if (page < 1)
{
page = 1;
}
if (string.IsNullOrWhiteSpace(sortExpression))
{
sortExpression = DefaultActivitiesSortExpression;
}
var baseActivitiesQuery = (from registeredUser in this.Database.RegisteredUsers
where registeredUser.AspNetUserId == userId
from rut in registeredUser.Teams
from activity in rut.Team.Calendar
select activity);
if (!string.IsNullOrWhiteSpace(filter))
{
baseActivitiesQuery = baseActivitiesQuery.Where(activity => activity.Name.Contains(filter));
}
var activitiesQuery = (from activity in baseActivitiesQuery
select new ActivitiesViewModel.Activity
{
Id = activity.Id,
Name = activity.Name,
StartDate = activity.StartDate,
EndDate = activity.EndDate
});
var activities = await PagingList.CreateAsync(
activitiesQuery,
pageSize,
page,
sortExpression,
DefaultActivitiesSortExpression);
return(activities);
}
public async Task <IActionResult> Index(int page = 1)
{
LaptopAddEdit model = new LaptopAddEdit();
//LINQ to Query string
//Join on 2 tables
var query = (from l in _context.laptops
join p in _context.products on l.ProductId equals p.ProductId
select new LaptopListViewModel()
{
ProductId = p.ProductId,
Name = p.ProductName,
LaptopId = l.LaptopId,
BatteryType = l.BatteryType,
Bluetooth = l.Bluetooth,
CpuCache = l.CpuCache,
CpuFrequency = l.CpuFrequency,
CpuManufactor = l.CpuManufactor,
CpuSeries = l.CpuSeries,
CpuType = l.CpuType,
Description = l.Description,
GPUManufactor = l.GPUManufactor,
GPUModel = l.GPUModel,
GPUSize = l.GPUSize,
HDMI = l.HDMI,
Modem = l.Modem,
ODD = l.ODD,
OS = l.OS,
OSVersion = l.OSVersion,
RAM = l.RAM,
RAMType = l.RAMType,
ScreenSize = l.ScreenSize,
ScreenTechnology = l.ScreenTechnology,
ScreenType = l.ScreenType,
Size = l.Size,
Speaker = l.Speaker,
Storage = l.Storage,
StorageType = l.StorageType,
USB2 = l.USB2,
USB3 = l.USB3,
VGA = l.VGA,
Webcam = l.Webcam,
Weight = l.Weight,
Wifi = l.Wifi
}).AsNoTracking().OrderBy(p => p.ProductId);
var modelPaging = await PagingList.CreateAsync(query, 10, page);
return(View(modelPaging));
}
public async Task <IActionResult> Index(string filter, string categoryFilter, List <string> Procesor, int page = 1, string sortExpression = "ProductName")
{
var qry = _context.Products.Where(p => p.ProductAvailability > 0).AsNoTracking()
.Include(c => c.Category)
.Include(p => p.PhotoProducts)
.ThenInclude(p => p.Photo)
.Include(p => p.ProductAssortments)
.ThenInclude(a => a.Assortment)
.ThenInclude(p => p.Param)
.AsQueryable();
List <string> k = Procesor;
if (k.Count != 0)
{
//var movies = _db.Movies.Where(p => p.Genres.Intersect(listOfGenres).Any());
//qry = _context.Products.Where(p=>p.ProductAssortments)
}
if (!string.IsNullOrWhiteSpace(filter))
{
if (string.IsNullOrWhiteSpace(categoryFilter))
{
qry = qry.Where(p => p.ProductName.Contains(filter));
}
else
{
qry = qry.Where(p => p.ProductName.Contains(filter)).Where(p => p.Category.CategoryId == Convert.ToInt32(categoryFilter));
}
}
else
{
if (!string.IsNullOrWhiteSpace(categoryFilter))
{
qry = qry.Where(p => p.Category.CategoryId == Convert.ToInt32(categoryFilter));
}
}
var model = await PagingList.CreateAsync(qry, 10, page, sortExpression, "ProductName");
model.RouteValue = new RouteValueDictionary {
{ "filter", filter },
{ "categoryFilter", categoryFilter },
{ "sortExpression", sortExpression }
};
ViewBag.ListOfCategories = _context.Categories.OrderBy(c => c.CategoryName).ToList();
ViewBag.ListOfParams = _context.Params.Include(a => a.Assortments).OrderBy(p => p.ParamName).ToList();
return(View(model));
}
public IActionResult VisitLogs(string sortOrder, int page = 1)
{
// Check valid login:
if (HttpContext.Session.GetString("UserID") != null)
{
// Prepare view variable to sort table columns by visit time:
TempData["VisitTime"] = sortOrder == "VisitTime" ? "visit_time_desc" : "VisitTime";
try
{
// Create a left join query of related entities to get wanted values for the visit log rows:
var visitList = from visitor in _db.VsVisitors
join visit in _db.VsVisits on visitor.Id equals visit.VisitorId into visits
from visitsResult in visits.DefaultIfEmpty()
join adminVisit in _db.VsAdminVisits on visitsResult.Id equals adminVisit.VisitId into adminVisits
from adminVisitResult in adminVisits.DefaultIfEmpty()
join admin in _db.VsAdmins on adminVisitResult.AdminId equals admin.Id into admins
from adminResult in admins.DefaultIfEmpty()
where visitor.IsIgnored != true
select new VisitorStats()
{
VisitID = visitsResult.Id,
IPAddress = visitor.Ipaddress,
VisitTime = visitsResult.VisitTime,
VisitURL = visitsResult.VisitUrl,
RefererURL = visitsResult.RefererUrl,
AdminID = adminVisitResult.AdminId,
AdminFirstname = adminResult.Firstname,
AdminEmail = adminResult.Email
};
visitList = sortOrder switch
{
"visit_time_desc" => visitList.OrderByDescending(v => v.VisitTime),
"VisitTime" => visitList.OrderBy(v => v.VisitTime),
_ => visitList.OrderByDescending(v => v.VisitTime)
};
var model = PagingList.Create(visitList, Convert.ToInt32(_config["Paging:ItemsPerPage"]), page);
model.Action = nameof(VisitLogs);
return(View(model));
}
catch (Exception e)
{
Console.Write(e.Message);
}
return(View());
}
return(RedirectToAction("Login", "Home"));
}
public async Task <PagingList <UserListViewModel> > load(int page)
{
var query = _userManager.Users.AsNoTracking().Select(u => new UserListViewModel
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
PhoneNumber = u.PhoneNumber,
Email = u.Email
}).OrderBy(i => i.Id);
var modelPaging = await PagingList <UserListViewModel> .CreateAsync(query, pagesize, page);
return(modelPaging);
}
public void CollectionConstructorTest()
{
// Arrange
List <string> expected = new List <string>()
{
"foo",
"bar"
};
// Act
PagingList <string> target = new PagingList <string>(expected);
// Assert
}
public IActionResult Index(int page = 1)
{
var query = db.skladista.Select(x => new SkladistaIndexVM
{
SkladisteId = x.SkladisteId,
Adresa = x.Adresa.Ulica + " " + x.Adresa.BrUlice,
Naziv = x.Naziv,
Opis = x.Opis
}).AsNoTracking().OrderBy(x => x.Naziv);
var model = PagingList.Create(query, 5, page);
return(View(nameof(Index), model));
}
public IActionResult Index(int page = 1, int row = 10)
{
var Roles = _roleManager.Roles.Select(r => new RolesViewModel {
RoleID = r.Id, RoleName = r.Name
}).ToList();
var PagingModel = PagingList.Create(Roles, row, page);
PagingModel.RouteValue = new RouteValueDictionary
{
{ "row", row }
};
return(View(PagingModel));
}
public async Task <IActionResult> EditPikturat(int page = 1)
{
string idUser = _userManager.GetUserId(User);
//query me kushtin kolona UD_Useri i piktures te kete id e Uzerit!
var query = _context.Pikturat.AsNoTracking().Where(a => a.ID_Useri == idUser).OrderByDescending(s => s.IdPiktura);
var model = await PagingList.CreateAsync(query, 4, page);
model.Action = "EditPikturat";
return(View(model));
}
public async Task <IActionResult> PurchaseHistory(int?page)
{
var userId = _userManager.GetUserId(User);
var goodsQuery = _context.PurchaseHistory.AsNoTracking()
.Where(P => P.PurchaserId == userId)
.Include(P => P.Goods)
.Include(P => P.ResultItemGoods)
.ThenInclude(RIG => RIG.ItemGoods)
.ThenInclude(IG => IG.Item)
.OrderByDescending(P => P.Date);
var model = await PagingList.CreateAsync(goodsQuery, _appOptionsAccessor.PurchaseHistoryPageSize, page.GetValueOrDefault(1));
return(View(model));
}
public async Task <IActionResult> Index(int page = 1)
{
if (HttpContext.Session.GetInt32("Login") != 1)
{
return(RedirectToAction(nameof(Login)));
}
else
{
var linkAggregator = _context.Links.Include(l => l.Users).Include(l => l.Likes)
.Where(u => u.UserId == HttpContext.Session.GetInt32("UserID"))
.OrderByDescending(o => o.Likes.Where(l => l.LinkID == o.LinkId).Count());
return(View(await PagingList.CreateAsync(linkAggregator, 100, page)));
}
}
public async Task <PagingList <News> > load(int page)
{
var model = _db.news.AsNoTracking().Select(n => new News()
{
NewsId = n.NewsId,
newTitle = n.newTitle,
newsConten = n.newsConten,
newsDate = n.newsDate,
newsImage = n.newsImage
}).OrderBy(n => n.NewsId);
var modelPaging = await PagingList <News> .CreateAsync(model, pagesize, page);
return(modelPaging);
}
protected async Task <PagingList <VM> > PagingListAsyncHandle <M, VM>(int pageIndex, int pageSize, UiMethodEnum sqlType)
where VM : class
{
var result = new PagingList <VM>();
DC.PageIndex = result.PageIndex = pageIndex;
DC.PageSize = result.PageSize = pageSize;
PreExecuteHandle(sqlType);
result.TotalCount = await DC.DS.ExecuteScalarAsync <int>();
result.Data = await DC.DS.ExecuteReaderMultiRowAsync <VM>();
return(result);
}
// GET: Clientes
public async Task <IActionResult> Index(int page = 1)
{
if (Request.Cookies["idDoUser"] == null)
{
return(RedirectToAction("Login", "Jornaleiros"));
}
var query = _context.Clientes.Include(j => j.Status).AsNoTracking().Where(c => c.StatusId == 1).OrderBy(j => j.NomeCliente);
ListaParaCsv.Clear();
ListaParaCsv = query.ToList();
var model = await PagingList.CreateAsync(query, 5, page);
return(View(model));
}
/// <summary>
/// 获取用户分页数据
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public PagingList<UserDto> GetUsers(GetUsersInput input)
{
var query = _userRepository.Table;
if (!string.IsNullOrWhiteSpace(input.NameKeyWords))
query = query.Where(m => m.UserName.Contains(input.NameKeyWords) || m.NickName.Contains(input.NameKeyWords) || m.TrueName.Contains(input.NameKeyWords));
if (!string.IsNullOrWhiteSpace(input.EmailAddress))
query = query.Where(n => n.AccountEmail.Contains(input.EmailAddress));
if (input.IsActive.HasValue)
query = query.Where(n => n.IsActived == input.IsActive.Value);
var source = query.OrderBy(n => n.Id)
.Skip((input.PageIndex - 1) * input.PageSize)
.Take(input.PageSize)
.MapTo<List<UserDto>>();
var result = new PagingList<UserDto>(source, input.PageIndex, input.PageSize,query.LongCount());
return result;
}
public virtual ActionResult ActivatedBO(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
int pageValue = page ?? 1;
var activated = mRepo.GetMany(m => m.MemberMainData.BOStatus == (int)eBOStatus.Done);
var viewModel = new PagingList<Member>()
{
List = activated.Skip((pageValue - 1) * MiscHelpers.Constants.PageSize).Take(MiscHelpers.Constants.PageSize).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = activated.Count()
}
};
return View(viewModel);
}
public virtual ActionResult BusinessCenter(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var lRepo = ModelFactory.GetRepository<ILocalisationRepository>(context);
var pageValue = page ?? 1;
var localisations = lRepo.GetMany(loc => loc.TypeValue == (int)LocalisationType.BuisnessCenter && loc.CountryId == "FR").OrderByDescending(x => x.ID).ToList();
var viewModel = new PagingList<Localisation>()
{
List = localisations.Skip((pageValue - 1) * MiscHelpers.Constants.PageSize).Take(MiscHelpers.Constants.PageSize).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = localisations.Count
}
};
return View(MVC.Admin.Sheet.Views.BusinessCenter, viewModel);
}
/// <summary>
/// Prepares a web page containing a paginated list of the people on home page
/// </summary>
/// <param name="page">The page to display</param>
/// <returns>The action result.</returns>
public virtual ActionResult IndexWelcomePeople(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var wpRepo = ModelFactory.GetRepository<IWelcomePeopleRepository>(context);
int pageValue = page ?? 1;
var welcomPeople = wpRepo.Get((pageValue - 1) * MiscHelpers.Constants.PageSize, MiscHelpers.Constants.PageSize, wp => wp.Id);
var viewModel = new PagingList<WelcomePeople>()
{
List = welcomPeople,
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = wpRepo.GetCount()
}
};
return View(viewModel);
}
/// <summary>
/// Deprecated
/// </summary>
/// <returns>The action result.</returns>
public virtual ActionResult Index(int? page)
{
var viewModel = new PagingList<Localisation>();
return View(viewModel);
}
/// <summary>
/// Get action method to show quotation of the owner
/// </summary>
/// <returns>View containing the quotations</returns>
public virtual ActionResult Quotation(int? page)
{
var id = WebHelper.GetIdentityId(User.Identity);
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
var qRepo = ModelFactory.GetRepository<IQuotationRepository>(context);
var p = page ?? 1;
try
{
var member = mRepo.Get(id);
Member.Validate(member);
var quotations = qRepo.GetMany(q => q.Offer.Localisation.OwnerID == id && q.StatusId == (int)MemberQuotation.Status.Unknown);
var model = new PagingList<MemberQuotation>
{
List = quotations.OrderByDescending(mq => mq.CreationDate).Skip((p - 1) * PagedListViewModel.PageSize).Take(PagedListViewModel.PageSize).ToList(),
PagingInfo = new PagingInfo { CurrentPage = p, ItemsPerPage = PagedListViewModel.PageSize, TotalItems = quotations.Count }
};
return View(model);
}
catch (Exception ex)
{
_Logger.Error("Quotation", ex);
return View(MVC.Shared.Views.Error);
}
}
/// <summary>
/// Get action method to show quotation of the member
/// </summary>
/// <returns>View containing the quotations</returns>
public virtual ActionResult Quotation(int? page)
{
var id = WebHelper.GetIdentityId(User.Identity);
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
var p = page ?? 1;
try
{
var member = mRepo.Get(id);
Member.Validate(member);
var list = member.MemberQuotations.Where(q => q.Unknown || q.CreationDate > DateTime.UtcNow.AddDays(-15)).OrderByDescending(q => q.CreationDate); ;
var model = new PagingList<MemberQuotation>
{
List = list.Skip((p - 1) * PagedListViewModel.PageSize).Take(PagedListViewModel.PageSize).ToList(),
PagingInfo = new PagingInfo { CurrentPage = p, ItemsPerPage = PagedListViewModel.PageSize, TotalItems = list.Count() }
};
return View(model);
}
catch (Exception ex)
{
_Logger.Error("Quotation", ex);
return View(MVC.Shared.Views.Error);
}
}
/// <summary>
/// 获取所有用户分页列表
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public PagingList<Blog> GetBlogs(GetBlogsInput input)
{
var query = _blogRepository.Table;
if (!string.IsNullOrWhiteSpace(input.NameKeyWords))
query = query.Where(m => m.Title.Contains(input.NameKeyWords) || m.Summary.Contains(input.NameKeyWords));
if (input.SortBy.HasValue)
{
switch (input.SortBy.Value)
{
case SortBy.CreatedTime:
query = query.OrderBy(n => n.Id);
break;
case SortBy.CreatedTimeDesc:
query = query.OrderByDescending(n => n.Id);
break;
case SortBy.UpdatedTimeDesc:
query = query.OrderByDescending(n => n.UpdatedTime);
break;
case SortBy.CommentCount:
query = query.OrderByDescending(n => n.CommentCount);
break;
case SortBy.HitCount:
query = query.OrderByDescending(n => n.HitCount);
break;
default:
query = query.OrderByDescending(n => n.IsTop).ThenByDescending(n => n.Id);
break;
}
}
else
{
query = query.OrderByDescending(n => n.IsTop).ThenByDescending(n => n.Id);
}
var source = query
.Include(n => n.Author).Skip((input.PageIndex - 1) * input.PageSize)
.Take(input.PageSize);
var result = new PagingList<Blog>(source, input.PageIndex, input.PageSize, query.LongCount());
return result;
}
/// <summary>
/// Prepares a web page containing a paginated list of localisations
/// </summary>
/// <param name="page">The page to display</param>
/// <returns>The action result.</returns>
public virtual ActionResult Index(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var lRepo = ModelFactory.GetRepository<ILocalisationRepository>(context);
var pageValue = page ?? 1;
var localisations = lRepo.Get((pageValue - 1) * MiscHelpers.Constants.PageSize, MiscHelpers.Constants.PageSize, l => l.ID);
var viewModel = new PagingList<Localisation>()
{
List = localisations,
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = lRepo.GetCount()
}
};
return View(viewModel);
}
public virtual ActionResult MemberWithApi(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
int pageValue = page ?? 1;
var members = mRepo.GetMany(m => !string.IsNullOrEmpty(m.MemberMainData.ApiKey));
var viewModel = new PagingList<Member>()
{
List = members.Skip((pageValue - 1) * MiscHelpers.Constants.PageSize).Take(MiscHelpers.Constants.PageSize).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = members.Count()
}
};
return View(viewModel);
}
public virtual ActionResult AdminList(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
int pageValue = page ?? 1;
var admins = mRepo.GetMembers(MiscHelpers.AdminConstants.AdminRole);
var viewModel = new PagingList<Member>()
{
List = admins.Skip((pageValue - 1) * MiscHelpers.Constants.PageSize).Take(MiscHelpers.Constants.PageSize).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = admins.Count
}
};
return View(MVC.Admin.Member.Views.Admins, viewModel);
}
/// <summary>
/// Get action method to show clients of the owner
/// </summary>
/// <returns>View containing the clients</returns>
public virtual ActionResult List(int? page)
{
var id = WebHelper.GetIdentityId(User.Identity);
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
var p = page ?? 1;
try
{
var member = mRepo.Get(id);
Member.Validate(member);
var clients = new List<Member>();
foreach (var loc in member.Localisations)
{
clients = clients.Concat(loc.LocalisationClients.Select(mc => mc.Member)).ToList();
}
var model = new PagingList<Member>
{
List = clients.Skip((p - 1) * PageSize).Take(PageSize).ToList(),
PagingInfo = new PagingInfo { CurrentPage = p, ItemsPerPage = PageSize, TotalItems = clients.Count() }
};
return View(model);
}
catch (Exception ex)
{
_Logger.Error("List", ex);
return View(MVC.Shared.Views.Error);
}
}
public virtual ActionResult Leaderboard(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
int pageValue = page ?? 1;
var members = mRepo.GetLeaders();
foreach (var member in members)
{
member.Score = mRepo.Get(member.MemberId).ComputeScore();
}
var viewModel = new PagingList<MemberAdminModel>()
{
List = members.OrderByDescending(x => x.Score).Skip((pageValue - 1) * MiscHelpers.Constants.PageSize).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = members.Count
}
};
return View(MVC.Admin.Member.Views.UsersLeaderboard, viewModel);
}
/// <summary>
/// Get action result to show all the localisations of the owner
/// </summary>
/// <returns>View of owner localisations</returns>
public virtual ActionResult Localisations(int? page)
{
var id = WebHelper.GetIdentityId(User.Identity);
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
var p = page ?? 1;
try
{
var member = mRepo.Get(id);
Member.Validate(member);
var localisations = member.Localisations.Where(loc => !Localisation.FreeLocalisationTypes.Contains(loc.TypeValue));
var model = new PagingList<Localisation>
{
List = localisations.Skip((p - 1) * PagedListViewModel.PageSize).Take(PagedListViewModel.PageSize).ToList(),
PagingInfo = new PagingInfo { CurrentPage = p, ItemsPerPage = PagedListViewModel.PageSize, TotalItems = localisations.Count() }
};
return View(model);
}
catch (Exception ex)
{
_Logger.Error("Localisations", ex);
return View(MVC.Shared.Views.Error);
}
}
/// <summary>
/// Prepares a web page containing a paginated list of localisations
/// </summary>
/// <param name="page">The page to display</param>
/// <returns>The action result.</returns>
public virtual ActionResult IndexQuotation(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var qRepo = ModelFactory.GetRepository<IQuotationRepository>(context);
var pageValue = page ?? 1;
var quotations = qRepo.Get((pageValue - 1) * MiscHelpers.Constants.PageSize, MiscHelpers.Constants.PageSize, mb => mb.Id);
var viewModel = new PagingList<MemberQuotation>()
{
List = quotations,
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = qRepo.GetCount()
}
};
return View(viewModel);
}
public virtual ActionResult LastCreate(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var lRepo = ModelFactory.GetRepository<ILocalisationRepository>(context);
var pageValue = page ?? 1;
var modifications = lRepo.GetLatestModifications(100, EditionType.Creation).Skip((pageValue - 1) * MiscHelpers.Constants.PageSize).Take(MiscHelpers.Constants.PageSize).ToList();
var viewModel = new PagingList<MemberEdition>()
{
List = modifications,
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = 100
}
};
return View(MVC.Admin.Moderation.Views.LastCreate, viewModel);
}
/// <summary>
/// Prepares a web page containing a paginated list of localisations
/// </summary>
/// <param name="page">The page to display</param>
/// <returns>The action result.</returns>
public virtual ActionResult IndexRental(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var rRepo = ModelFactory.GetRepository<IRentalRepository>(context);
var pageValue = page ?? 1;
var rentals = rRepo.Get((pageValue - 1) * MiscHelpers.Constants.PageSize, MiscHelpers.Constants.PageSize, r => r.Id);
var viewModel = new PagingList<Rental>()
{
List = rentals,
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = rRepo.GetCount()
}
};
return View(viewModel);
}
public virtual ActionResult IndexOwner(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
int pageValue = page ?? 1;
var owners = mRepo.GetOwners();
var viewModel = new PagingList<Member>()
{
List = owners.Skip((pageValue - 1) * MiscHelpers.Constants.PageSize).Take(MiscHelpers.Constants.PageSize).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = owners.Count()
}
};
return View(viewModel);
}
/// <summary>
/// Get action method to show clients of a localisation
/// </summary>
/// <returns>View containing the clients</returns>
public virtual ActionResult LocalisationList(int id, int? page)
{
var memberId = WebHelper.GetIdentityId(User.Identity);
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
var lRepo = ModelFactory.GetRepository<ILocalisationRepository>(context);
var p = page ?? 1;
try
{
var localisation = lRepo.Get(id);
var clients = localisation.LocalisationClients.Select(mc => mc.Member);
var model = new PagingList<Member>
{
List = clients.Skip((p - 1) * PageSize).Take(PageSize).ToList(),
PagingInfo = new PagingInfo { CurrentPage = p, ItemsPerPage = PageSize, TotalItems = clients.Count() }
};
return View(new LocalisationModel<PagingList<Member>> { InnerModel = model, LocalisationModelId = id });
}
catch (Exception ex)
{
_Logger.Error("LocalisationList", ex);
return View(MVC.Shared.Views.Error);
}
}
/// <summary>
/// Prepares a web page containing a paginated list of members
/// </summary>
/// <param name="page">The page to display</param>
/// <returns>The action result.</returns>
public virtual ActionResult IndexUser(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
int pageValue = page ?? 1;
var members = mRepo.Get((pageValue - 1) * MiscHelpers.Constants.PageSize, MiscHelpers.Constants.PageSize, m => m.MemberId);
var viewModel = new PagingList<MemberAdminModel>()
{
List = _MembershipService.GetAdminMapping(members).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = mRepo.GetCount()
}
};
return View(MVC.Admin.Member.Views.IndexUser, viewModel);
}
/// <summary>
/// Prepares a web page containing a paginated list of the press on home page
/// </summary>
/// <param name="page">The page to display</param>
/// <returns>The action result.</returns>
public virtual ActionResult IndexPress(int? page)
{
var context = ModelFactory.GetUnitOfWork();
var pRepo = ModelFactory.GetRepository<IPressRepository>(context);
int pageValue = page ?? 1;
var press = pRepo.Get((pageValue - 1) * MiscHelpers.Constants.PageSize, MiscHelpers.Constants.PageSize, p => p.ID);
var viewModel = new PagingList<Press>()
{
List = press.OrderByDescending(x => x.Date).ToList(),
PagingInfo = new PagingInfo
{
CurrentPage = pageValue,
ItemsPerPage = MiscHelpers.Constants.PageSize,
TotalItems = pRepo.GetCount()
}
};
return View(viewModel);
}
