public ActionResult GetData(JqueryDatatableParam param)
{
var employees = _brandMaster.GetBrandMasterDetails(); //This method is returning the IEnumerable employee from database
if (!string.IsNullOrEmpty(param.sSearch))
{
employees = employees.Where(x => x.BrandName.ToLower().Contains(param.sSearch.ToLower())).ToList();
}
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.QueryString["iSortCol_0"]);
var sortDirection = HttpContext.Request.QueryString["sSortDir_0"];
if (sortColumnIndex == 3)
{
employees = sortDirection == "asc" ? employees.OrderBy(c => c.BrandName) : employees.OrderByDescending(c => c.BrandName);
}
else
{
Func <BrandMaster, string> orderingFunction = e => sortColumnIndex == 0 ? e.BrandName : e.BrandName;
employees = sortDirection == "asc" ? employees.OrderBy(orderingFunction) : employees.OrderByDescending(orderingFunction);
}
var displayResult = employees.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = employees.Count();
return(Json(new { param.sEcho, iTotalRecords = totalRecords, iTotalDisplayRecords = totalRecords, aaData = displayResult }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get records for datatable
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
//[HttpPost]
public async Task <ActionResult> GetList(JqueryDatatableParam param)
{
ProductDatatable productDatatable = new ProductDatatable();
try
{
ProductListFilter model = new ProductListFilter
{
Start = param.Start,
Length = param.Length,
Search = param.Search.Value,
SortColumn = Convert.ToString(param.Columns[param.Order[0].Column].Data),
SortOrder = Convert.ToString(param.Order[0].Dir)
};
ResJsonOutput result = await PostDataAsync("/API/Products/GetProductList", model);
if (result.Status.IsSuccess)
{
productDatatable = Utility.ConvertJsonToObject <ProductDatatable>(result.Data);
}
}
catch (Exception ex)
{
throw;
}
return(Json(new
{
draw = param.Draw,
data = productDatatable.Products,
recordsFiltered = productDatatable.TotalRecords,
recordsTotal = productDatatable.TotalDisplayRecord
}));
}
// get JSON data to bind in datatable
public ActionResult GetData(JqueryDatatableParam param)
{
var userId = User.Identity.GetUserId();
var todoList = db.Todo.Where(t => t.UserId == userId).ToList();
if (!string.IsNullOrEmpty(param.sSearch))
{
todoList = todoList.Where(x => x.Id.ToString().ToLower().Contains(param.sSearch.ToLower()) ||
x.TodoTitle.ToLower().Contains(param.sSearch.ToLower()) ||
x.DueDate.ToString("dd'/'MM'/'yyyy").ToLower().Contains(param.sSearch.ToLower())).ToList();
}
var displayResult = todoList.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = todoList.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = displayResult
}, JsonRequestBehavior.AllowGet));
}
public IActionResult GetData(JqueryDatatableParam param)
{
var dataroles = Roles;
if (!string.IsNullOrEmpty(param.sSearch))
{
dataroles.Roles = dataroles.Roles.Where(
x => x.RoleName.ToLower().Contains(param.sSearch.ToLower()) ||
(x.IsEnabled ? "Enable" : "Disable").ToLower().Contains(param.sSearch.ToLower())
).ToList();
}
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]);
var sortDirection = HttpContext.Request.Query["sSortDir_0"];
Func <RoleViewModel, string> orderingFunction = e =>
sortColumnIndex == 2 ? (e.IsEnabled ? "Enable" : "Disable") :
sortColumnIndex == 1 ? e.RoleName : e.RoleID.ToString();
dataroles.Roles = sortDirection == "asc" ? dataroles.Roles.OrderBy(orderingFunction).ToList() : dataroles.Roles.OrderByDescending(orderingFunction).ToList();
var displayResult = dataroles.Roles.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = dataroles.Roles.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
Data = displayResult
}));
}
public async Task <IActionResult> GetDataAsync(JqueryDatatableParam param)
{
var dataUser = (await _repo.GetAll()).data;
if (!string.IsNullOrEmpty(param.sSearch))
{
dataUser.users = dataUser.users.Where(
x => x.UserName.ToLower().Contains(param.sSearch.ToLower()) ||
x.Email.ToLower().Contains(param.sSearch.ToLower()) ||
x.RoleName.ToLower().Contains(param.sSearch.ToLower())
).ToList();
}
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]);
var sortDirection = HttpContext.Request.Query["sSortDir_0"];
Func <UserViewModel, string> orderingFunction = e =>
sortColumnIndex == 3 ? e.RoleName :
sortColumnIndex == 2 ? e.Email :
sortColumnIndex == 1 ? e.UserName : e.UserID.ToString();
dataUser.users = sortDirection == "asc" ? dataUser.users.OrderBy(orderingFunction).ToList() : dataUser.users.OrderByDescending(orderingFunction).ToList();
var displayResult = dataUser.users.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = dataUser.users.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
Data = displayResult
}));
}
public JsonResult GetData(JqueryDatatableParam param, string fromDate, string toDate)
{
var products = ProductsService.Instance.PurchaseSearchByDate(fromDate, toDate);
//Pagination
var displayResult = products.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
List <PurchaseTableViewModel> p = new List <PurchaseTableViewModel>();
PurchaseTableViewModel model = new PurchaseTableViewModel();
foreach (var c in displayResult)
{
model.ProductName = c.Product.ProductName;
model.GenericName = c.Product.GenericName;
model.Qty = c.Qty;
model.TotalAmount = c.TotalAmount;
model.Date = c.Date.ToString("dd/M/yyyy", CultureInfo.InvariantCulture);
p.Add(model);
model = new PurchaseTableViewModel();
}
var totalRecords = products.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = p
}, JsonRequestBehavior.AllowGet));
}
public ActionResult GetData(JqueryDatatableParam param)
{
var products = ProductsService.Instance.GetProducts(); //This method is returning the IEnumerable employee from database
//Searching
if (!string.IsNullOrEmpty(param.sSearch))
{
products = products.Where(x => x.ProductName.ToLower().Contains(param.sSearch.ToLower()) ||
x.GenericName.ToLower().Contains(param.sSearch.ToLower()) ||
x.BatchNo.ToLower().Contains(param.sSearch.ToLower()) ||
x.BarCode.ToLower().Contains(param.sSearch.ToLower()) ||
x.Location.ToLower().Contains(param.sSearch.ToLower()) ||
x.ExpiryDate.ToString("dd'/'MM'/'yyyy").ToLower().Contains(param.sSearch.ToLower())).ToList();
}
//Sorting
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.QueryString["iSortCol_0"]);
var sortDirection = HttpContext.Request.QueryString["sSortDir_0"];
if (sortColumnIndex == 3)
{
products = sortDirection == "asc" ? products.OrderBy(c => c.ProductName).ToList() : products.OrderByDescending(c => c.ProductName).ToList();
}
else if (sortColumnIndex == 4)
{
products = sortDirection == "asc" ? products.OrderBy(c => c.GenericName).ToList() : products.OrderByDescending(c => c.GenericName).ToList();
}
else if (sortColumnIndex == 5)
{
products = sortDirection == "asc" ? products.OrderBy(c => c.PackRetailCost).ToList() : products.OrderByDescending(c => c.PackRetailCost).ToList();
}
else
{
Func <Product, string> orderingFunction = e => sortColumnIndex == 0 ? e.ProductName : sortColumnIndex == 1 ? e.Location : e.Location;
products = sortDirection == "asc" ? products.OrderBy(orderingFunction).ToList() : products.OrderByDescending(orderingFunction).ToList();
}
//Pagination
var displayResult = products.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = products.Count();
//Sending data
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = displayResult
}, JsonRequestBehavior.AllowGet));
}
public ActionResult GetResult(JqueryDatatableParam param)
{
List <CustomColumnClass> listOfData1 = GenerateResult();
List <CustomColumnClass> listOfData2 = new List <CustomColumnClass>();
foreach (CustomColumnClass list in listOfData1)
{
CustomColumnClass ccc1 = new CustomColumnClass();
ccc1.BlogPost = list.BlogPost;
ccc1.Comment = "";
ccc1.User = list.User;
ccc1.Date = list.BlogPostDate.ToString("dd/MM/yyyy");
ccc1.Result = list.Result;
listOfData2.Add(ccc1);
List <BlogPostComment> listOfBPC = db.BlogPostComments.Where(x => x.BlogPostId == list.BlogPostId).ToList();
foreach (BlogPostComment bpc in listOfBPC)
{
CustomColumnClass ccc2 = new CustomColumnClass();
ccc2.BlogPost = "";
ccc2.Comment = bpc.Text;
ccc2.User = bpc.User.UserName;
ccc2.Date = ((DateTime)bpc.Date).ToString("dd/MM/yyyy");
ccc2.Result = "Like (" + bpc.Like + ") Dislike (" + bpc.Dislike + ")";
listOfData2.Add(ccc2);
}
}
//=========== Server Side Pagination ==============
if (!string.IsNullOrEmpty(param.sSearch))
{
listOfData2 = listOfData2.Where(x => (x.BlogPost != null && x.BlogPost.Contains(param.sSearch.ToLower())) ||
(x.Comment != null && x.Comment.ToLower().Contains(param.sSearch.ToLower())) ||
(x.User != null && x.User.ToLower().Contains(param.sSearch.ToLower())) ||
(x.Date != null && x.Date.ToString().ToLower().Contains(param.sSearch.ToLower())) ||
(x.Result != null && x.Result.ToLower().Contains(param.sSearch.ToLower()))).ToList();
}
var displayResult = listOfData2.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var totalRecords = listOfData2.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = displayResult
}, JsonRequestBehavior.AllowGet));
}
public JsonResult AllCustomersSearch(JqueryDatatableParam param)
{
var customer = new Customer();
customer.SearchModel = param;
var Model = _custService.CustomerDataTable(customer);
var result = new
{
iTotalRecords = Model.TotalRecords,
iTotalDisplayRecords = Model.TotalDisplayRecords,
aaData = Model.CustomerList
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult GetEmployeeList(JqueryDatatableParam param)
{
var filteredTests = _context.Employee.ToList();
var displayedTest = filteredTests.Skip(param.iDisplayStart)
.Take(param.iDisplayLength);
var totalRecords = filteredTests.Count;
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = displayedTest
}));
}
public ActionResult ListOfEmployee(JqueryDatatableParam param)
{
int startId = (int)Session["StartId"];
int endId = (int)Session["EndId"];
var employees = EmployeeClass.GetAllEmployee().Where(x => x.Id >= startId && x.Id <= endId);
if (!string.IsNullOrEmpty(param.sSearch))
{
employees = employees.Where(x => x.Id.ToString().Contains(param.sSearch.ToLower()) ||
x.Name.ToLower().Contains(param.sSearch.ToLower()) ||
x.Gender.ToLower().Contains(param.sSearch.ToLower()) ||
x.Salary.ToString().Contains(param.sSearch.ToLower())).ToList();
}
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.QueryString["iSortCol_0"]);
var sortDirection = HttpContext.Request.QueryString["sSortDir_0"];
if (sortColumnIndex == 0)
{
employees = sortDirection == "asc" ? employees.OrderBy(c => c.Id).ToList() : employees.OrderByDescending(c => c.Id).ToList();
}
else if (sortColumnIndex == 1)
{
employees = sortDirection == "asc" ? employees.OrderBy(c => c.Name).ToList() : employees.OrderByDescending(c => c.Name).ToList();
}
else if (sortColumnIndex == 2)
{
employees = sortDirection == "asc" ? employees.OrderBy(c => c.Gender).ToList() : employees.OrderByDescending(c => c.Gender).ToList();
}
else if (sortColumnIndex == 3)
{
employees = sortDirection == "asc" ? employees.OrderBy(c => c.Salary).ToList() : employees.OrderByDescending(c => c.Salary).ToList();
}
var displayResult = employees.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var totalRecords = employees.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = displayResult
}, JsonRequestBehavior.AllowGet));
}
public ActionResult GetProducts(JqueryDatatableParam param)
{
var filterText = !string.IsNullOrEmpty(param.sSearch) ? param.sSearch.ToLower() : null;
var currentPage = Convert.ToInt32(param.sEcho);
var pageSize = param.iDisplayLength;
var sortDirection = Request.QueryString["sSortDir_0"];
var sortColumnIndex = Convert.ToInt32(Request.QueryString["iSortCol_0"]);
var sortColumnName = sortColumnIndex == 0
? "ProductId"
: (sortColumnIndex == 1
? "ProdName"
: (sortColumnIndex == 2
? "CategoryName"
: (sortColumnIndex == 3
? "ProdDescription"
: "")));
currentPage = param.iDisplayStart == 0 ? 1 : (param.iDisplayStart / param.iDisplayLength) + 1;
var productData = productRepository.GetProductInfo(filterText, sortColumnName, sortDirection, currentPage, pageSize);
var resultSet = productData
.Select(x => new String[] {
Convert.ToString(x.ProductId),
x.ProdName,
x.CategoryName,
x.ProdDescription,
Convert.ToString(x.ProdCatId),
Convert.ToString(x.TotalRowCount)
}).ToList();
int TotalRecords = 0;
if (productData != null && productData.Count > 0)
{
TotalRecords = productData[0].TotalRowCount.Value;
}
return(Json(new
{
param.sEcho,
iTotalRecords = TotalRecords,
iTotalDisplayRecords = TotalRecords,
aaData = resultSet
}, JsonRequestBehavior.AllowGet));
}
public ActionResult GetData(JqueryDatatableParam param)
{
var itemMasterViewModels = _itemMasters.GetItemMasterDetails(); //This method is returning the IEnumerable employee from database
if (!string.IsNullOrEmpty(param.sSearch))
{
itemMasterViewModels = itemMasterViewModels.Where(x => x.Brand.ToLower().Contains(param.sSearch.ToLower()) ||
x.Category.ToLower().Contains(param.sSearch.ToLower()) ||
x.HsnCode.ToLower().Contains(param.sSearch.ToLower()) ||
x.Item.ToLower().Contains(param.sSearch.ToLower())
).ToList();
}
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.QueryString["iSortCol_0"]);
var sortDirection = HttpContext.Request.QueryString["sSortDir_0"];
if (sortColumnIndex == 3)
{
itemMasterViewModels = sortDirection == "asc" ? itemMasterViewModels.OrderBy(c => c.HsnCode) : itemMasterViewModels.OrderByDescending(c => c.HsnCode);
}
else if (sortColumnIndex == 4)
{
itemMasterViewModels = sortDirection == "asc" ? itemMasterViewModels.OrderBy(c => c.Brand) : itemMasterViewModels.OrderByDescending(c => c.Brand);
}
else if (sortColumnIndex == 5)
{
itemMasterViewModels = sortDirection == "asc" ? itemMasterViewModels.OrderBy(c => c.Category) : itemMasterViewModels.OrderByDescending(c => c.Category);
}
else if (sortColumnIndex == 6)
{
itemMasterViewModels = sortDirection == "asc" ? itemMasterViewModels.OrderBy(c => c.Item) : itemMasterViewModels.OrderByDescending(c => c.Item);
}
else
{
Func <ItemMasterViewModel, string> orderingFunction = e => sortColumnIndex == 0 ? e.Brand : sortColumnIndex == 1 ? e.Category : e.Category;
itemMasterViewModels = sortDirection == "asc" ? itemMasterViewModels.OrderBy(orderingFunction) : itemMasterViewModels.OrderByDescending(orderingFunction);
}
var displayResult = itemMasterViewModels.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = itemMasterViewModels.Count();
return(Json(new { param.sEcho, iTotalRecords = totalRecords, iTotalDisplayRecords = totalRecords, aaData = displayResult }, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> GetDataAsync(JqueryDatatableParam param)
{
var data = (await _repo.GetAll()).data;
if (!string.IsNullOrEmpty(param.sSearch))
{
data.screens = data.screens.Where(
x => (x.ScreenName ?? string.Empty).ToLower().Contains(param.sSearch.ToLower()) ||
(x.ControllerName ?? string.Empty).ToLower().Contains(param.sSearch.ToLower()) ||
(x.ActionName ?? string.Empty).ToLower().Contains(param.sSearch.ToLower()) ||
(x.IsActive ? "Enable" : "Disable").ToLower().Contains(param.sSearch.ToLower()) ||
(x.IsMenu ? "Menu" : "Screen").ToLower().Contains(param.sSearch.ToLower()) ||
(x.ParentName ?? string.Empty).ToLower().Contains(param.sSearch.ToLower())
).ToList();
}
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]);
var sortDirection = HttpContext.Request.Query["sSortDir_0"];
Func <ScreenViewModel, string> orderingFunction = e =>
sortColumnIndex == 6 ? e.ParentName :
sortColumnIndex == 5 ? (e.IsMenu ? "Menu" : "Screen") :
sortColumnIndex == 4 ? (e.IsActive ? "Enable" : "Disable") :
sortColumnIndex == 3 ? e.ActionName :
sortColumnIndex == 2 ? e.ControllerName :
sortColumnIndex == 1 ? e.ScreenName : e.ScreenID.ToString();
data.screens = sortDirection == "asc" ? data.screens.OrderBy(orderingFunction).ToList() : data.screens.OrderByDescending(orderingFunction).ToList();
var displayResult = data.screens.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = data.screens.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = displayResult.Count,
aaData = displayResult
}));
}
public IActionResult GetData(JqueryDatatableParam param)
{
var Customers = repo.Get().data;
if (!string.IsNullOrEmpty(param.sSearch))
{
Customers = Customers.Where(
x => x.CustomerName.ToLower().Contains(param.sSearch.ToLower()) ||
x.CustomerNumber.ToLower().Contains(param.sSearch.ToLower()) ||
x.CustomerAddress.ToLower().Contains(param.sSearch.ToLower()) ||
x.Phone.ToLower().Contains(param.sSearch.ToLower()) ||
x.Resident.ResidentName.ToLower().Contains(param.sSearch.ToLower())
).ToList();
}
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]);
var sortDirection = HttpContext.Request.Query["sSortDir_0"];
Func <CustomerViewModel, string> orderingFunction = e =>
sortColumnIndex == 5 ? e.Resident.ResidentName:
sortColumnIndex == 4 ? e.Phone :
sortColumnIndex == 3 ? e.CustomerAddress :
sortColumnIndex == 2 ? e.CustomerNumber :
sortColumnIndex == 1 ? e.CustomerName : e.CustomerID.ToString();
Customers = sortDirection == "asc" ? Customers.OrderBy(orderingFunction).ToList() : Customers.OrderByDescending(orderingFunction).ToList();
var displayResult = Customers.Skip(param.iDisplayStart)
.Take(param.iDisplayLength).ToList();
var totalRecords = Customers.Count();
return(Json(new
{
param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
Data = displayResult
}));
}
