public JsonResult GetDeliveredOrder(string sidx, string sord, int page, int rows) //Gets the todo Lists.
{
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
List <OrderViewModel> vmorder = new List <OrderViewModel>();
var productList = _productBusiness.GetListWT();
var orderList = _orderBusiness.GetListWT(c => c.OrderStatus == "Delivered");
vmorder = (from c in orderList
select new OrderViewModel
{
OrderId = c.OrderId,
OrderCode = c.OrderCode,
OrderDate = c.OrderDate,
OrderStatus = c.OrderStatus,
OrderedItems = GetOrderedItems(c.OrderId, productList),
CustomerName = c.FirstName + " " + c.LastName,
//FullAddress = c.Address + ", " + c.Pincode + " " + c.City
}).OrderByDescending(col => col.OrderDate).ToList();
var records = vmorder.AsQueryable();
int totalRecords = records.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (!string.IsNullOrEmpty(sidx) && !string.IsNullOrEmpty(sord))
{
if (sord.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sidx);
}
else
{
records = SortHelper.OrderByDescending(records, sidx);
}
}
//applying paging
records = records.Skip(pageIndex * pageSize).Take(pageSize);
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = records
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public List <ProviderModel> GetProvider(int?page, int?limit, string sortBy, string direction, string searchString, out int total)
{
var providerList = db.Proveedor.ToList();
var productList = Factory.Factory.CreateListProductdb();
var listProvider = Factory.Factory.ListProviderModels();
//Edit Product Selected
foreach (var item in providerList)
{
var pc = db.IdProveedorProducto.Where(x => x.IdProveedor == item.IdProveedor).ToList();
foreach (var itemproduct in pc)
{
var product = db.Product.Where(x => x.IdProducto == itemproduct.IdProducto).First();
productList.Add(product);
}
var map = MapperObject.CreateProveedorProductModel(item, productList);
listProvider.Add(map);
}
if (!string.IsNullOrWhiteSpace(searchString))
{
listProvider = listProvider.Where(p => (p.RazonSocial.ToUpper().StartsWith(searchString.ToUpper()) || p.RazonSocial.ToUpper().EndsWith(searchString.ToUpper())) ||
(p.Codigo.ToUpper().StartsWith(searchString.ToUpper()) || p.Codigo.ToUpper().EndsWith(searchString.ToUpper()))).ToList();
}
total = listProvider.Count();
var clienteQueryable = listProvider.AsQueryable();
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
clienteQueryable = SortHelper.OrderBy(clienteQueryable, sortBy);
}
else
{
clienteQueryable = SortHelper.OrderByDescending(clienteQueryable, sortBy);
}
}
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
clienteQueryable = clienteQueryable.Skip(start).Take(limit.Value);
}
return(listProvider);
}
public List <MenuViewModel> GetAllMenusForGrid(int?page, int?limit, string sortBy, string direction, string searchString, out int total)
{
var result = _menuRepository.GetAllMenus().ToViewModelList();
total = result.Count();
var records = result;
records = from m in records
join p in records on m.ParentId equals p.Id into inners
from od in inners.DefaultIfEmpty()
select new MenuViewModel
{
Id = m.Id,
Name = m.Name,
DisplayName = m.DisplayName,
ParentId = m.ParentId,
ParentName = (od == null?String.Empty:od.Name),
LinkUrl = m.LinkUrl,
ImageUrl = m.ImageUrl,
IsActive = m.IsActive,
CreatedBy = m.CreatedBy,
CreatedDate = m.CreatedDate,
ModifiedBy = m.ModifiedBy,
ModifiedDate = m.ModifiedDate,
DisplayOrder = m.DisplayOrder
};
if (!string.IsNullOrWhiteSpace(searchString))
{
records = records.Where(p => p.Name.Contains(searchString) || p.DisplayName.Contains(searchString));
}
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sortBy);
}
else
{
records = SortHelper.OrderByDescending(records, sortBy);
}
}
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = records.Skip(start).Take(limit.Value);
}
//var result= records.ToList();
return(records.ToList());
}
public JsonResult GetCategory(string sidx, string sord, int page, int rows, string colName, string colValue) //Gets the todo Lists.
{
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
var categoryList = _categoryBusiness.GetListWT();
var subcategoryList = _subcategoryBusiness.GetListWT();
var records = (from p in subcategoryList
join c in categoryList on p.CategoryId equals c.CategoryId
select new SubCategoryViewModel
{
TokenKey = p.TokenKey,
SubCategoryName = p.SubCategoryName,
CategoryName = c.CategoryName
}).AsQueryable();
//applying filter
if (!string.IsNullOrEmpty(colName) && !string.IsNullOrEmpty(colValue))
{
records = records.Where(c => c.GetType().GetProperty(colName).GetValue(c, null).ToString().ToLower().Contains(colValue.ToLower()));
}
int totalRecords = records.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (!string.IsNullOrEmpty(sidx) && !string.IsNullOrEmpty(sord))
{
if (sord.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sidx);
}
else
{
records = SortHelper.OrderByDescending(records, sidx);
}
}
//applying paging
records = records.Skip(pageIndex * pageSize).Take(pageSize);
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = records
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public static (long, int, Op) FindMin(long[,] optimumOperation, int i)
{
bool IsDiv3 = i % 3 == 0, IsDiv2 = i % 2 == 0;
List <(long, int, Op)> SortHelper = new List <(long, int, Op)>();
if (IsDiv2)
{
SortHelper.Add((optimumOperation[0, i / 2], i / 2, Op.Div2));
}
if (IsDiv3)
{
SortHelper.Add((optimumOperation[0, i / 3], i / 3, Op.Div3));
}
SortHelper.Add((optimumOperation[0, i - 1], i - 1, Op.Sub1));
return(SortHelper
.OrderBy(x => x.Item1)
.ThenByDescending(x => x.Item3)
.First());
}
public bool IsValid()
{
SortHelper[] sorter = new SortHelper[26];
foreach (char c in Name)
{
int index = c - 'a';
sorter[c - 'a'].c = c;
++sorter[c - 'a'].count;
}
var postSort = sorter.OrderBy(s => s.c).OrderByDescending(s => s.count);
for (int i = 0; i < Checksum.Length; ++i)
{
if (Checksum[i] != postSort.ElementAt(i).c)
{
return(false);
}
}
return(true);
}
public List <ProjectStudent> GetReportsJsonData(int?page, int?limit, string sortBy, string direction, out int total, string projectName = null, string projectType = null, bool?isApproved = null, bool?isClosed = null)
{
var records = _context.ProjectStudents.Include(p => p.Creator).Include(p => p.Updater).Where(p => p.Project.ProjectType == "Bachelor")
.Select(p => new ProjectStudent()
{
Id = p.Id,
ProjectName = p.Project.Name,
StudentName = p.ApplicationUser.FirstName + " " + p.ApplicationUser.LastName,
Professor = (string.IsNullOrEmpty(p.Creator.FirstName) || string.IsNullOrEmpty(p.Creator.LastName)) ? p.Creator.UserName : (p.Creator.FirstName + " " + p.Creator.LastName),
ProjectType = p.Project.ProjectType,
ProjectBranch = p.Project.ProjectSubType
})
.AsQueryable();
if (!string.IsNullOrEmpty(projectName))
{
records = records.Where(r => r.ProjectName.ToLower().Contains(projectName.Trim().ToLower()));
}
total = records.Count();
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sortBy);
}
else
{
records = SortHelper.OrderByDescending(records, sortBy);
}
}
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = records.Skip(start).Take(limit.Value);
}
return(records.ToList());
}
public ListModel <ParameterGroupModel> List(FilterModel filterModel)
{
var startDate = filterModel.StartDate.ResetTimeToStartOfDay();
var endDate = filterModel.EndDate.ResetTimeToEndOfDay();
Expression <Func <ParameterGroup, bool> > expression;
if (filterModel.Status != -1)
{
var status = filterModel.Status.ToString().ToBoolean();
if (filterModel.Searched != null)
{
if (status)
{
expression = c => c.IsApproved && c.Name.Contains(filterModel.Searched);
}
else
{
expression = c => c.IsApproved == false && c.Name.Contains(filterModel.Searched);
}
}
else
{
if (status)
{
expression = c => c.IsApproved;
}
else
{
expression = c => c.IsApproved == false;
}
}
}
else
{
if (filterModel.Searched != null)
{
expression = c => c.Name.Contains(filterModel.Searched);
}
else
{
expression = c => c.Id != Guid.Empty;
}
}
expression = expression.And(e => e.CreationTime >= startDate && e.CreationTime <= endDate);
var model = filterModel.CreateMapped <FilterModel, ListModel <ParameterGroupModel> >();
if (model.Paging == null)
{
model.Paging = new Paging
{
PageSize = filterModel.PageSize,
PageNumber = filterModel.PageNumber
};
}
var sortHelper = new SortHelper <ParameterGroupModel>();
var query = _repositoryParameterGroup
.Join(x => x.Creator.Person)
.Join(x => x.LastModifier.Person)
.Where(expression);
sortHelper.OrderBy(x => x.DisplayOrder);
model.Paging.TotalItemCount = query.Count();
var items = model.Paging.PageSize > 0 ? query.Skip((model.Paging.PageNumber - 1) * model.Paging.PageSize).Take(model.Paging.PageSize) : query;
var modelItems = new HashSet <ParameterGroupModel>();
foreach (var item in items)
{
var modelItem = item.CreateMapped <ParameterGroup, ParameterGroupModel>();
modelItem.Creator = new IdCodeName(item.Creator.Id, item.Creator.Username, item.Creator.Person.DisplayName);
modelItem.LastModifier = new IdCodeName(item.LastModifier.Id, item.LastModifier.Username, item.LastModifier.Person.DisplayName);
modelItems.Add(modelItem);
}
model.Items = modelItems.ToList();
var pageSizeDescription = _serviceMain.ApplicationSettings.PageSizeList;
var pageSizes = pageSizeDescription.Split(',').Select(s => new KeyValuePair <int, string>(s.ToInt(), s)).ToList();
pageSizes.Insert(0, new KeyValuePair <int, string>(-1, "[" + Dictionary.All + "]"));
model.Paging.PageSizes = pageSizes;
model.Paging.PageCount = (int)Math.Ceiling((float)model.Paging.TotalItemCount / model.Paging.PageSize);
if (model.Paging.TotalItemCount > model.Items.Count)
{
model.Paging.HasNextPage = true;
}
// ilk sayfa ise
if (model.Paging.PageNumber == 1)
{
if (model.Paging.TotalItemCount > 0)
{
model.Paging.IsFirstPage = true;
}
// tek sayfa ise
if (model.Paging.PageCount == 1)
{
model.Paging.IsLastPage = true;
}
}
// son sayfa ise
else if (model.Paging.PageNumber == model.Paging.PageCount)
{
model.Paging.HasNextPage = false;
// tek sayfa değilse
if (model.Paging.PageCount > 1)
{
model.Paging.IsLastPage = true;
model.Paging.HasPreviousPage = true;
}
}
// ara sayfa ise
else
{
model.Paging.HasNextPage = true;
model.Paging.HasPreviousPage = true;
}
if (model.Paging.TotalItemCount > model.Items.Count && model.Items.Count <= 0)
{
model.Message = Messages.DangerRecordNotFoundInPage;
}
if (model.Paging.TotalItemCount == 0)
{
model.Message = Messages.DangerRecordNotFound;
}
return(model);
}
private ListModel <CategoryModel> List(DateTime startDate, DateTime endDate, int pageNumber, int pageSize, int status, string searched, Guid languageId, ListModel <CategoryModel> model)
{
var resetedStartDate = startDate.ResetTimeToStartOfDay();
var resetedEndDate = endDate.ResetTimeToEndOfDay();
var language = languageId != Guid.Empty ? _repositoryLanguage.Get(x => x.Id == languageId) : _defaultLanguage;
Expression <Func <Category, bool> > expression;
if (model.Paging == null)
{
model.Paging = new Paging
{
PageSize = pageSize,
PageNumber = pageNumber
};
}
if (status != -1)
{
var bStatus = status.ToString().ToBoolean();
if (searched != null)
{
if (bStatus)
{
expression = c => c.CategoryLanguageLines.Any(x => x.Name.Contains(searched) && x.IsApproved);
}
else
{
expression = c => c.CategoryLanguageLines.Any(x => x.Name.Contains(searched) && x.IsApproved == false);
}
}
else
{
if (bStatus)
{
expression = c => c.CategoryLanguageLines.Any(x => x.IsApproved);
}
else
{
expression = c => c.CategoryLanguageLines.Any(x => x.IsApproved == false);
}
}
}
else
{
if (searched != null)
{
expression = c => c.CategoryLanguageLines.Any(x => x.Name.Contains(searched));
}
else
{
expression = c => c.Id != Guid.Empty;
}
}
expression = expression.And(e => e.CreationTime >= resetedStartDate && e.CreationTime <= resetedEndDate);
var sortHelper = new SortHelper <CategoryModel>();
var query = _repositoryCategory
.Join(x => x.Creator.Person)
.Join(x => x.LastModifier.Person)
.Join(z => z.CategoryLanguageLines)
.ThenJoin(x => x.Language)
.Where(expression);
sortHelper.OrderBy(x => x.DisplayOrder);
model.Paging.TotalItemCount = query.Count();
var items = model.Paging.PageSize > 0 ? query.Skip((model.Paging.PageNumber - 1) * model.Paging.PageSize).Take(model.Paging.PageSize) : query;
var modelItems = new HashSet <CategoryModel>();
foreach (var item in items)
{
CategoryModel modelItem;
if (item.CategoryLanguageLines == null)
{
modelItem = new CategoryModel();
}
else
{
var itemLine = item.CategoryLanguageLines.FirstOrDefault(x => x.Language.Id == language.Id);
modelItem = itemLine != null?itemLine.CreateMapped <CategoryLanguageLine, CategoryModel>() : new CategoryModel();
}
modelItem.Creator = new IdCodeName(item.Creator.Id, item.Creator.Username, item.Creator.Person.DisplayName);
modelItem.LastModifier = new IdCodeName(item.LastModifier.Id, item.LastModifier.Username, item.LastModifier.Person.DisplayName);
modelItem.Language = new IdCodeName(language.Id, language.Code, language.Name);
modelItem.CategoryId = item.Id;
modelItems.Add(modelItem);
}
model.Items = modelItems.ToList();
var pageSizeDescription = _serviceMain.ApplicationSettings.PageSizeList;
var pageSizes = pageSizeDescription.Split(',').Select(s => new KeyValuePair <int, string>(s.ToInt(), s)).ToList();
pageSizes.Insert(0, new KeyValuePair <int, string>(-1, "[" + Dictionary.All + "]"));
model.Paging.PageSizes = pageSizes;
model.Paging.PageCount = (int)Math.Ceiling((float)model.Paging.TotalItemCount / model.Paging.PageSize);
if (model.Paging.TotalItemCount > model.Items.Count)
{
model.Paging.HasNextPage = true;
}
// ilk sayfa ise
if (model.Paging.PageNumber == 1)
{
if (model.Paging.TotalItemCount > 0)
{
model.Paging.IsFirstPage = true;
}
// tek sayfa ise
if (model.Paging.PageCount == 1)
{
model.Paging.IsLastPage = true;
}
}
// son sayfa ise
else if (model.Paging.PageNumber == model.Paging.PageCount)
{
model.Paging.HasNextPage = false;
// tek sayfa değilse
if (model.Paging.PageCount > 1)
{
model.Paging.IsLastPage = true;
model.Paging.HasPreviousPage = true;
}
}
// ara sayfa ise
else
{
model.Paging.HasNextPage = true;
model.Paging.HasPreviousPage = true;
}
if (model.Paging.TotalItemCount > model.Items.Count && model.Items.Count <= 0)
{
model.Message = Messages.DangerRecordNotFoundInPage;
}
if (model.Paging.TotalItemCount == 0)
{
model.Message = Messages.DangerRecordNotFound;
}
return(model);
}
public ListModel <LanguageModel> List(FilterModel filterModel)
{
var startDate = filterModel.StartDate.ResetTimeToStartOfDay();
var endDate = filterModel.EndDate.ResetTimeToEndOfDay();
Expression <Func <Language, bool> > expression;
if (filterModel.Status != -1)
{
var status = filterModel.Status.ToString().ToBoolean();
if (filterModel.Searched != null)
{
if (status)
{
expression = c => c.IsApproved && c.Name.Contains(filterModel.Searched);
}
else
{
expression = c => c.IsApproved == false && c.Name.Contains(filterModel.Searched);
}
}
else
{
if (status)
{
expression = c => c.IsApproved;
}
else
{
expression = c => c.IsApproved == false;
}
}
}
else
{
if (filterModel.Searched != null)
{
expression = c => c.Name.Contains(filterModel.Searched);
}
else
{
expression = c => c.Id != Guid.Empty;
}
}
expression = expression.And(e => e.CreationTime >= startDate && e.CreationTime <= endDate);
var listModel = filterModel.CreateMapped <FilterModel, ListModel <LanguageModel> >();
listModel.Paging ??= new Paging
{
PageSize = filterModel.PageSize,
PageNumber = filterModel.PageNumber
};
var sortHelper = new SortHelper <Language>();
sortHelper.OrderBy(x => x.DisplayOrder);
var query = (IOrderedQueryable <Language>)_repositoryLanguage
.Get().Where(expression);
query = sortHelper.GenerateOrderedQuery(query);
listModel.Paging.TotalItemCount = query.Count();
var items = listModel.Paging.PageSize > 0 ? query.Skip((listModel.Paging.PageNumber - 1) * listModel.Paging.PageSize).Take(listModel.Paging.PageSize) : query;
var modelItems = new HashSet <LanguageModel>();
foreach (var item in items)
{
var modelItem = item.CreateMapped <Language, LanguageModel>();
modelItems.Add(modelItem);
}
listModel.Items = modelItems.ToList();
var pageSizeDescription = _serviceMain.ApplicationSettings.PageSizeList;
var pageSizes = pageSizeDescription.Split(',').Select(s => new KeyValuePair <int, string>(s.ToInt(), s)).ToList();
pageSizes.Insert(0, new KeyValuePair <int, string>(-1, "[" + Dictionary.All + "]"));
listModel.Paging.PageSizes = pageSizes;
listModel.Paging.PageCount = (int)Math.Ceiling((float)listModel.Paging.TotalItemCount / listModel.Paging.PageSize);
if (listModel.Paging.TotalItemCount > listModel.Items.Count)
{
listModel.Paging.HasNextPage = true;
}
if (listModel.Paging.PageNumber == 1)
{
if (listModel.Paging.TotalItemCount > 0)
{
listModel.Paging.IsFirstPage = true;
}
if (listModel.Paging.PageCount == 1)
{
listModel.Paging.IsLastPage = true;
}
}
else if (listModel.Paging.PageNumber == listModel.Paging.PageCount)
{
listModel.Paging.HasNextPage = false;
if (listModel.Paging.PageCount > 1)
{
listModel.Paging.IsLastPage = true;
listModel.Paging.HasPreviousPage = true;
}
}
else
{
listModel.Paging.HasNextPage = true;
listModel.Paging.HasPreviousPage = true;
}
if (listModel.Paging.TotalItemCount > listModel.Items.Count && listModel.Items.Count <= 0)
{
listModel.Message = Messages.DangerRecordNotFoundInPage;
}
if (listModel.Paging.TotalItemCount == 0)
{
listModel.Message = Messages.DangerRecordNotFound;
}
return(listModel);
}
public List <Project> GetJsonData(int?page, int?limit, string sortBy, string direction, out int total, string projectName = null, string projectType = null,
string projectSubType = null, string Professor = null)
{
var isBac = _context.ApplicationUsers.Where(p => p.Id == UserIdentity.Id).Select(p => p.IsBachelorStudent).SingleOrDefault();
var records = _context.Projects.Include(p => p.Creator).Include(p => p.Updater)
.Select(p => new Project()
{
Id = p.Id,
Name = p.Name,
IsApproved = p.IsApproved,
IsClosed = p.IsClosed,
ApprovalSummary = p.IsApproved.Value ? "Yes" : "No",
CloserSummary = p.IsClosed?"Yes":"No",
MaxApprovedStudents = p.MaxApprovedStudents,
ProjectType = p.ProjectType,
ProjectSubType = p.ProjectSubType,
CreatedBy = (string.IsNullOrEmpty(p.Creator.FirstName) || string.IsNullOrEmpty(p.Creator.LastName)) ? p.Creator.UserName : (p.Creator.FirstName + " " + p.Creator.LastName)
}).Where(p => p.IsApproved.Value && !p.IsClosed && !_context.ProjectStudents.Select(c => c.ApplicationUserId).Contains(UserIdentity.Id) && isBac == true)
.AsQueryable();
if (!string.IsNullOrEmpty(projectName))
{
records = records.Where(r => r.Name.ToLower().Contains(projectName.Trim().ToLower()));
}
if (!string.IsNullOrEmpty(projectType) && projectType != "Select")
{
records = records.Where(r => r.ProjectType.ToLower().Contains(projectType.Trim().ToLower()));
}
if (!string.IsNullOrEmpty(projectSubType) && projectSubType != "Select")
{
records = records.Where(r => r.ProjectSubType.ToLower().Contains(projectSubType.Trim().ToLower()));
}
if (!string.IsNullOrEmpty(Professor))
{
records = records.Where(r => r.CreatedBy.ToLower().Contains(Professor.Trim().ToLower()));
}
total = records.Count();
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sortBy);
}
else
{
records = SortHelper.OrderByDescending(records, sortBy);
}
}
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = records.Skip(start).Take(limit.Value);
}
return(records.ToList());
}
private ListModel <UserModel> List(DateTime startDate, DateTime endDate, int pageNumber, int pageSize, int status, string searched, ICollection <Guid> parentIds, ListModel <UserModel> model)
{
var resetedStartDate = startDate.ResetTimeToStartOfDay();
var resetedEndDate = endDate.ResetTimeToEndOfDay();
Expression <Func <User, bool> > expression;
model.Paging ??= new Paging
{
PageSize = pageSize,
PageNumber = pageNumber
};
if (status != -1)
{
var bStatus = status.ToString().ToBoolean();
if (searched != null)
{
if (bStatus)
{
expression = c => c.IsApproved && c.Username.Contains(searched);
}
else
{
expression = c => c.IsApproved == false && c.Username.Contains(searched);
}
}
else
{
if (bStatus)
{
expression = c => c.IsApproved;
}
else
{
expression = c => c.IsApproved == false;
}
}
}
else
{
if (searched != null)
{
expression = c => c.Username.Contains(searched);
}
else
{
expression = c => c.Id != Guid.Empty;
}
}
expression = expression.And(e => e.CreationTime >= resetedStartDate && e.CreationTime <= resetedEndDate);
if (parentIds != null)
{
if (parentIds.Count > 0)
{
expression = expression.And(e => e.RoleUserLines.Any(x => parentIds.Contains(x.Role.Id)));
}
}
var identityUserMinRoleLevel = _serviceMain.IdentityUserMinRoleLevel;
expression = expression.And(x => x.RoleUserLines.All(t => t.Role.Level > identityUserMinRoleLevel));
var sortHelper = new SortHelper <User>();
sortHelper.OrderBy(x => x.DisplayOrder);
var query = (IOrderedQueryable <User>)_repositoryUser
.Join(x => x.Person)
.Join(x => x.Creator.Person)
.Join(x => x.LastModifier.Person)
.Join(x => x.RoleUserLines)
.ThenJoin(x => x.Role)
.Where(expression);
query = sortHelper.GenerateOrderedQuery(query);
model.Paging.TotalItemCount = query.Count();
var items = model.Paging.PageSize > 0 ? query.Skip((model.Paging.PageNumber - 1) * model.Paging.PageSize).Take(model.Paging.PageSize) : query;
var modelItems = new HashSet <UserModel>();
foreach (var item in items)
{
var modelItem = item.CreateMapped <User, UserModel>();
modelItem.Creator = new IdName(item.Creator.Id, item.Creator.Person.DisplayName);
modelItem.LastModifier = new IdName(item.LastModifier.Id, item.LastModifier.Person.DisplayName);
modelItem.IdentityCode = item.Person.IdentityCode;
modelItem.FirstName = item.Person.FirstName;
modelItem.LastName = item.Person.LastName;
modelItem.Roles = item.RoleUserLines.Select(t => t.Role).Select(role => new IdCodeNameSelected(role.Id, role.Code, role.Name, true)).ToList();
modelItems.Add(modelItem);
}
model.Items = modelItems.ToList();
var pageSizeDescription = _serviceMain.ApplicationSettings.PageSizeList;
var pageSizes = pageSizeDescription.Split(',').Select(s => new KeyValuePair <int, string>(s.ToInt(), s)).ToList();
pageSizes.Insert(0, new KeyValuePair <int, string>(-1, "[" + Dictionary.All + "]"));
model.Paging.PageSizes = pageSizes;
model.Paging.PageCount = (int)Math.Ceiling((float)model.Paging.TotalItemCount / model.Paging.PageSize);
if (model.Paging.TotalItemCount > model.Items.Count)
{
model.Paging.HasNextPage = true;
}
if (model.Paging.PageNumber == 1)
{
if (model.Paging.TotalItemCount > 0)
{
model.Paging.IsFirstPage = true;
}
if (model.Paging.PageCount == 1)
{
model.Paging.IsLastPage = true;
}
}
else if (model.Paging.PageNumber == model.Paging.PageCount)
{
model.Paging.HasNextPage = false;
if (model.Paging.PageCount > 1)
{
model.Paging.IsLastPage = true;
model.Paging.HasPreviousPage = true;
}
}
else
{
model.Paging.HasNextPage = true;
model.Paging.HasPreviousPage = true;
}
if (model.Paging.TotalItemCount > model.Items.Count && model.Items.Count <= 0)
{
model.Message = Messages.DangerRecordNotFoundInPage;
}
if (model.Paging.TotalItemCount == 0)
{
model.Message = Messages.DangerRecordNotFound;
}
return(model);
}
public List <ItemType> GetJsonData(int?page, int?limit, string sortBy, string direction, out int total, string name)
{
var results = new List <ItemType>();
results.Add(new ItemType()
{
ItemTypeId = 1, ItemTypeName = "Type1", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 2, ItemTypeName = "Type2", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 3, ItemTypeName = "Type3", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 4, ItemTypeName = "Type4", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 5, ItemTypeName = "Type5", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 6, ItemTypeName = "Type6", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 7, ItemTypeName = "Type7", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 8, ItemTypeName = "Type8", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 9, ItemTypeName = "Type9", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 10, ItemTypeName = "Type10", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 11, ItemTypeName = "Type11", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 12, ItemTypeName = "Type12", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 13, ItemTypeName = "Type13", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 14, ItemTypeName = "Type14", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 15, ItemTypeName = "Type15", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 16, ItemTypeName = "Type16", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 17, ItemTypeName = "Type17", ItemTypeDescription = "Type1"
});
results.Add(new ItemType()
{
ItemTypeId = 18, ItemTypeName = "Type18", ItemTypeDescription = "Type1"
});
var records = results.ToArray().AsQueryable();
if (!string.IsNullOrEmpty(name))
{
records = records.Where(r => r.ItemTypeName.ToLower().Contains(name.Trim().ToLower()));
}
total = records.Count();
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sortBy);
}
else
{
records = SortHelper.OrderByDescending(records, sortBy);
}
}
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = records.Skip(start).Take(limit.Value);
}
return(records.ToList());
}
public JsonResult GetNewOrder(string sidx, string sord, int page, int rows, string colName, string colValue) //Gets the todo Lists.
{
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
List <SaleRecordViewModel> vmorder = new List <SaleRecordViewModel>();
var productList = _productBusiness.GetListWT();
var orderList = _orderBusiness.GetListWT();
vmorder = (from c in orderList
select new SaleRecordViewModel
{
OrderId = c.OrderId,
OrderStatus = c.OrderStatus,
OrderCode = c.OrderCode,
OrderDate = c.OrderDate,
Vat = Convert.ToDouble(GetVATOrderedItems(c.OrderId, productList)),
Sat = Convert.ToDouble(GetSATOrderedItems(c.OrderId, productList)),
// TotalPrice = 2000,
TotalPrice = Convert.ToDouble(GetOrderedItems(c.OrderId, productList)),
CustomerName = c.FirstName + " " + c.LastName,
Discount = Convert.ToDouble(GetDiscountedOrderedItems(c.OrderId, productList)),
TaxTotalPrice = Convert.ToDouble(GetTotal(c.OrderId, productList))
}).OrderByDescending(col => col.OrderDate).Where(u => u.OrderStatus == "Delivered").ToList();
var records = vmorder.AsQueryable();
int totalRecords = records.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (!string.IsNullOrEmpty(sidx) && !string.IsNullOrEmpty(sord))
{
if (sord.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sidx);
}
else
{
records = SortHelper.OrderByDescending(records, sidx);
}
}
if (!string.IsNullOrEmpty(colName) && !string.IsNullOrEmpty(colValue))
{
records = records.Where(c => c.GetType().GetProperty(colName).GetValue(c, null).ToString().ToLower().Contains(colValue.ToLower()));
}
//applying filter
// int totalRecords = records.Count();
// var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
//applying paging
records = records.Skip(pageIndex * pageSize).Take(pageSize);
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = records
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public List <ApplicationUser> GetNotAllocatedStudentsJsonData(int?page, int?limit, string sortBy, string direction, out int total)
{
var approvedStudents = _context.ProjectStudents
.Include(p => p.ApplicationUser)
.Select(p => new ApplicationUser()
{
FirstName = p.ApplicationUser.FirstName,
LastName = p.ApplicationUser.LastName,
Email = p.ApplicationUser.Email,
PhoneNumber = p.ApplicationUser.PhoneNumber,
UserName = p.ApplicationUser.UserName
});
//var notApprovedStudents1 = _context.ProjectStudentChoices
// .Include(p => p.Project)
// .Include(p => p.ApplicationUser)
// .Where(p => p.IsApproved && p.Project.IsClosed)
// .Select(p => new ApplicationUser()
// {
// FirstName = p.ApplicationUser.FirstName,
// LastName = p.ApplicationUser.LastName,
// Email = p.ApplicationUser.Email,
// PhoneNumber = p.ApplicationUser.PhoneNumber,
// UserName = p.ApplicationUser.UserName
// });
var notApprovedStudents = _context.ApplicationUsers
.Where(p => !_context.ProjectStudentChoices.Where(a => a.IsApproved && a.Project.IsClosed).Select(c => c.ApplicationUserId).Contains(p.Id) &&
_context.UserRoles.Where(c => c.RoleId == "1f8cd529-9587-48a9-8efe-f9a1ec3b6268").Select(c => c.UserId).Contains(p.Id)).Select(p => new ApplicationUser()
{
FirstName = p.FirstName,
LastName = p.LastName,
Email = p.Email,
PhoneNumber = p.PhoneNumber,
UserName = p.UserName
});
var records = notApprovedStudents.Except(approvedStudents);
total = records.Count();
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
records = SortHelper.OrderBy(records, sortBy);
}
else
{
records = SortHelper.OrderByDescending(records, sortBy);
}
}
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = records.Skip(start).Take(limit.Value);
}
return(records.ToList());
}
