// GET: Employees
public ActionResult Index(TablePageInfo pageInfo)
{
IEnumerable <Employee> employees = _uow.Employees.FullSearch(pageInfo, out int totalPages);
if (User.Identity.IsAuthenticated)
{
ClaimsIdentity userClaims = ((ClaimsIdentity)User.Identity);
string userId = userClaims.GetUserId();
Claim itemsClaim = userClaims
.Claims
.FirstOrDefault(c => c.Type == "items");
if (itemsClaim != null)
{
pageInfo.items = Convert.ToInt32(itemsClaim.Value);
}
}
return(View(new EmployeeHomeViewModel()
{
employees = employees,
pageInfo = pageInfo,
totalPages = totalPages
}));
}
public IEnumerable <Order> FullSearch(TablePageInfo pageInfo, out int totalPages)
{
var context = Ctx as ERPModel;
SqlParameter outParam = new SqlParameter
{
ParameterName = "totalPages",
Value = 0,
Direction = System.Data.ParameterDirection.Output
};
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@employeeName", pageInfo.search ?? string.Empty),
new SqlParameter("@customerName", ""),
new SqlParameter("@startDate", ""),
new SqlParameter("@endDate", ""),
new SqlParameter("@shipAddress", ""),
new SqlParameter("@orderBy", pageInfo.sortBy),
new SqlParameter("@order", pageInfo.order),
new SqlParameter("@items", pageInfo.items),
new SqlParameter("@page", pageInfo.page),
outParam
};
List <Order> orders = context.Database.SqlQuery <Order>("Exec OrderFullSearch @employeeName , @customerName , @startDate , @endDate, @shipAddress, @orderBy , @order , @items , @page , @totalPages OUTPUT", sqlParameters).ToList();
totalPages = (int)outParam.Value;
return(orders);
}
public PartialViewResult Search(TablePageInfo pageInfo)
{
IEnumerable <Order> orders = _uow.Orders.FullSearch(pageInfo, out int totalPages);
return(PartialView("_OrderTable", new OrderHomeViewModel()
{
orders = orders,
pageInfo = pageInfo,
totalPages = totalPages
}));
}
// GET: Employees
public ActionResult Index(TablePageInfo pageInfo)
{
IEnumerable <Order> orders = _uow.Orders.FullSearch(pageInfo, out int totalPages);
return(View(new OrderHomeViewModel()
{
orders = orders,
pageInfo = pageInfo,
totalPages = totalPages
}));
}
public IEnumerable <Employee> GetByName(TablePageInfo pageInfo, out int totalPages)
{
var context = Ctx as ERPModel;
string search = !string.IsNullOrEmpty(pageInfo.search) ?
pageInfo.search.ToLower() : string.Empty;
IQueryable <Employee> employees = context
.Employees
.Where(e => (e.fName + " " + e.lName)
.ToLower()
.Contains(search));
PropertyDescriptor prop = TypeDescriptor
.GetProperties(typeof(Employee))
.Find(pageInfo.sortBy, true);
//Type proptype1 = typeof(prop.GetType());
switch (pageInfo.order)
{
case "dsc":
//employees = employees.OrderByDescending(e => e.ID);
employees = employees.MyOrderBy("fName");
break;
default:
//employees = employees.OrderBy(e => e.ID);
employees = employees.MyOrderByDescending("fName");
//employees = employees.OrderBy(e => prop.GetValue(e));
break;
}
totalPages = (int)Math.Ceiling((double)employees.Count() / pageInfo.items.Value);
employees = employees
.Skip((pageInfo.page.Value - 1) * pageInfo.items.Value)
.Take(pageInfo.items.Value);
return(employees.ToList());
}
public PartialViewResult Search(TablePageInfo pageInfo)
{
if (User.Identity.IsAuthenticated)
{
ClaimsIdentity userClaims = ((ClaimsIdentity)User.Identity);
string userId = userClaims.GetUserId();
Claim itemsClaim = userClaims
.Claims
.FirstOrDefault(c => c.Type == "items");
//Claim claim = new Claim("items",items.Value.ToString());
//_uow.UserManager.AddClaim(userId, claim);
}
IEnumerable <Employee> employees = _uow.Employees.FullSearch(pageInfo, out int totalPages);
return(PartialView("_EmployeesTable", new EmployeeHomeViewModel()
{
employees = employees.ToArray(),
pageInfo = pageInfo,
totalPages = totalPages
}));
}
public static MvcHtmlString BodiedActionLink(this AjaxHelper ajaxHelper, string linkText, string actionName, string controllerName, TablePageInfo routeValues, AjaxOptions ajaxOptions, object htmlAttributes)
{
var repID = "_";
var lnk = ajaxHelper.ActionLink(repID, actionName, controllerName, routeValues, ajaxOptions, htmlAttributes);
return(MvcHtmlString.Create(lnk.ToString().Replace(repID, linkText)));
}
