public ActionResult _Index1(StaffMemberSearch staffMemberSearch, int?page)
{
List <UserModel> UserModelList = Services.UserService.GetAll();
ViewBag.UserId = new SelectList(UserModelList, "Id", "FullName");
List <StaffStatusModel> StaffStatusModelList = Services.StaffStatusService.GetAll();
ViewBag.StaffStatusId = new SelectList(StaffStatusModelList, "Id", "StatusName");
int TotalCount = 0;
var pageSize = 10;
var pageNumber = page ?? 1;
int CurrentPage = pageNumber;
var endPage = CurrentPage + 4;
int PagesToShow = 10;
ViewBag.PageSize = pageSize;
var StaffMemberModelList = Services.StaffMemberService.GetSearchData(staffMemberSearch, page, out TotalCount);
ViewBag.TotalCount = TotalCount;
var result = Helper.CommonFunction.GetPages(TotalCount, pageSize, CurrentPage, PagesToShow);
int totalPages = (TotalCount / pageSize) + (TotalCount % pageSize == 0 ? 0 : 1);
ViewBag.result = result;
ViewBag.totalPages = totalPages;
ViewBag.CurrentPage = CurrentPage;
var pageCount = result.Count();
ViewBag.pageCount = pageCount;
ViewBag.endPage = endPage;
return(View(StaffMemberModelList));
}
public List <StaffMemberModel> GetSearchData(StaffMemberSearch staffMemberSearch, int?page, out int TotalCount)
{
int pageNumber = (page ?? 1);
var body = JsonConvert.SerializeObject(staffMemberSearch);
var result = ServerResponse.Invoke <ServiceResult <List <StaffMemberModel> > >("api/staffMember/getSearchData", body, "Post");
TotalCount = result.TotalCount;
if (result.data != null)
{
var model = result.data.ToList();
return(model);
}
else
{
}
return(result.data.ToList());
}
public ServiceResult <List <StaffMember> > GetSearchData(StaffMemberSearch staffSearch)
{
var pageSize = 10;
var CurrentPage = 1;
ServiceResult <List <StaffMember> > model = new ServiceResult <List <StaffMember> >();
var source = db.StaffMembers.Where(x => x.IsActive == true).Include(x => x.User)
.Include(x => x.User.Branch)
.Include(x => x.StaffStatu)
.Include(x => x.User);
if (staffSearch != null)
{
if (staffSearch.IsActive != false)
{
source = db.StaffMembers.Where(x => x.IsActive == true).OrderByDescending(x => x.Id);
}
if (!string.IsNullOrEmpty(staffSearch.UserName))
{
source = source.Where(m => m.User.FirstName.ToLower().Equals(staffSearch.UserName.ToLower()));
}
if (staffSearch.StaffStatusId > 0)
{
source = source.Where(x => x.StaffStatusId == staffSearch.StaffStatusId);
}
}
int count = source.Count();
var items = source.OrderByDescending(m => m.Id).Skip(((staffSearch.Page ?? 1) - 1) * pageSize).Take(pageSize).ToList();
model.data = items.Select(x => new StaffMember
{
Id = x.Id,
UserId = x.UserId,
User = db.Users.Where(m => m.Id == x.UserId).Include(m => m.Branch).Include(m => m.Role).FirstOrDefault(),
StaffStatusId = x.StaffStatusId,
StaffStatu = db.StaffStatus.Where(m => m.Id == x.StaffStatusId).FirstOrDefault(),
IsActive = x.IsActive,
JoiningDate = x.JoiningDate,
IsFingurPrintAccess = x.IsFingurPrintAccess,
ProfilePic = x.ProfilePic
}).ToList().RemoveReferences();
model.TotalCount = count;
return(model);;
}
