public async Task <JsonResult> IndexJson(ListFilterViewModels request)
{
var helper = new TransactionTypeDataTableSearchHelper();
var result = await helper.SearchFunction(request);
var resultList = (IEnumerable <TransactionTypesViewModel>)result.filteredList;
var data = resultList.Select(x => new
{
Actions = "<div class='btn-group' style='display:flex;'>" +
"<a class='btn btn-primary' href='#'><i class='fa fa-gear fa-fw'></i> Action</a>" +
"<a class='btn btn-primary dropdown-toggle' data-toggle='dropdown' href='#'>" +
"<span class='fa fa-caret-down' title='Toggle dropdown menu'></span>" +
"</a>" +
"<ul class='dropdown-menu' role='menu'>" +
(x.IsActive ? "<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Edit") + "' onclick='btnClicked($(this))'><a>Edit</a></li>" : "") +
"<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Details") + "' onclick='btnClicked($(this))'><a>Details</a></li>" +
(x.IsActive ? "<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Delete") + "' onclick='btnClicked($(this))'><a>Delete</a></li>" :
"<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Enable") + "' onclick='btnClicked($(this))'><a>Enable</a></li>") +
"</ul>" +
"</div>",
Code = x.Code,
TransType = x.TransType,
IsActive = x.IsActive
});
return(Json(new
{
draw = request.draw,
recordsTotal = result.totalResultCount,
recordsFiltered = result.filteredResultCount,
data = data
}));
}
public async Task <dynamic> SearchFunction(ListFilterViewModels request)
{
var list = new List <VendorViewModel>().AsEnumerable();
var filteredList = new List <VendorViewModel>().AsEnumerable();
int filteredResultCount = 0;
int totalResultCount = 0;
var searchBy = request.search.value?.ToLower() ?? "" ?? "";
var take = request.length;
var skip = request.start;
var orderBy = "Id";
var orderDir = true;
if (request.order != null)
{
orderDir = request.order[0].dir.ToLower().Equals("asc");
orderBy = request.columns[request.order[0].column].data;
orderBy = (orderBy.Equals("actions", StringComparison.OrdinalIgnoreCase) ? "Id" : orderBy) + (orderDir ? "" : " desc");
}
var url = $"api/Vendor/GetList/{request.IsActive}/{_customerId}";
var response = await HttpClientHelper.ApiCall(url, Method.GET);
if (response.IsSuccessful)
{
var result = response.Content;
list = JsonConvert.DeserializeObject <List <dynamic> >(result).Select(x => new VendorViewModel
{
Id = x.Id,
IsActive = x.IsActive,
CustomerId = x.CustomerId,
VendorCode = x.VendorCode != null ? x.VendorCode : "",
VendorName = x.VendorName != null ? x.VendorName : "",
ContactPerson = x.ContactPerson != null ? x.ContactPerson : "",
Telephone = x.Telephone != null ? x.Telephone : "",
MobileNo = x.MobileNo != null ? x.MobileNo : "",
EmailAddress = x.EmailAddress != null ? x.EmailAddress : "",
Website = x.Website != null ? x.Website : "",
Address1 = x.Address1 != null ? x.Address1 : "",
Address2 = x.Address2 != null ? x.Address2 : "",
});
filteredList = list.Where(x => x.VendorCode.ToLower().Contains(searchBy) ||
x.VendorName.ToLower().Contains(searchBy) ||
x.ContactPerson.ToLower().Contains(searchBy) ||
x.Telephone.ToLower().Contains(searchBy) ||
x.MobileNo.ToLower().Contains(searchBy) ||
x.EmailAddress.ToLower().Contains(searchBy) ||
x.Website.ToLower().Contains(searchBy) ||
x.Address1.ToLower().Contains(searchBy) ||
x.Address2.ToLower().Contains(searchBy)).OrderBy(orderBy, StringComparison.OrdinalIgnoreCase);
}
totalResultCount = list.Count();
filteredResultCount = filteredList.Count();
filteredList = filteredList.Skip(skip).Take(take);
return(new { filteredList, filteredResultCount, totalResultCount });
}
public async Task <dynamic> SearchFunction(ListFilterViewModels request)
{
var list = new List <CustomerViewModel>().AsEnumerable();
var filteredList = new List <CustomerViewModel>().AsEnumerable();
int filteredResultCount = 0;
int totalResultCount = 0;
var searchBy = request.search.value?.ToLower() ?? "" ?? "";
var take = request.length;
var skip = request.start;
var orderBy = "Id";
var orderDir = true;
if (request.order != null)
{
orderDir = request.order[0].dir.ToLower().Equals("asc");
orderBy = request.columns[request.order[0].column].data;
orderBy = (orderBy.Equals("actions", StringComparison.OrdinalIgnoreCase) ? "Id" : orderBy) + (orderDir ? "" : " desc");
}
var url = $"api/Customer/GetList/{request.IsActive}/{_customerId}";
var response = await HttpClientHelper.ApiCall(url, Method.GET);
if (response.IsSuccessful)
{
var result = response.Content;
list = JsonConvert.DeserializeObject <List <dynamic> >(result).Select(x => new CustomerViewModel
{
Id = x.Id,
IsActive = x.IsActive,
Domain = x.Domain ?? "",
CompanyName = x.CompanyName ?? "",
EmailAddress = x.EmailAddress ?? "",
FirstName = x.FirstName ?? "",
MiddleName = x.MiddleName != null ? x.MiddleName : "",
LastName = x.LastName ?? "",
ContactNo = x.ContactNo != null ? x.ContactNo : ""
});
filteredList = list.Where(x => x.Domain.ToLower().Contains(searchBy) ||
x.CompanyName.ToLower().Contains(searchBy) ||
x.EmailAddress.ToLower().Contains(searchBy) ||
x.ContactNo.ToLower().Contains(searchBy) ||
x.FirstName.ToLower().Contains(searchBy) ||
x.MiddleName.ToLower().Contains(searchBy) ||
x.LastName.ToLower().Contains(searchBy)).OrderBy(orderBy, StringComparison.OrdinalIgnoreCase);
//(x.FirstName + (!string.IsNullOrEmpty(x.MiddleName) ? " " + x.MiddleName[0] + ". " : " ") + x.LastName)
//.Contains(searchBy)).OrderBy(orderBy, StringComparison.OrdinalIgnoreCase);
}
totalResultCount = list.Count();
filteredResultCount = filteredList.Count();
filteredList = filteredList.Skip(skip).Take(take);
return(new { filteredList, filteredResultCount, totalResultCount });
}
public async Task <dynamic> SearchFunction(ListFilterViewModels request)
{
var list = new List <ItemViewModel>().AsEnumerable();
var filteredList = new List <ItemViewModel>().AsEnumerable();
int filteredResultCount = 0;
int totalResultCount = 0;
var searchBy = request.search.value?.ToLower() ?? "" ?? "";
var take = request.length;
var skip = request.start;
var orderBy = "Id";
var orderDir = true;
if (request.order != null)
{
orderDir = request.order[0].dir.ToLower().Equals("asc");
orderBy = request.columns[request.order[0].column].data;
orderBy = (orderBy.Equals("actions", StringComparison.OrdinalIgnoreCase) ? "Id" : orderBy) + (orderDir ? "" : " desc");
}
var url = $"api/Item/GetList/{request.IsActive}/{_customerId}";
var response = await HttpClientHelper.ApiCall(url, Method.GET);
if (response.IsSuccessful)
{
var result = response.Content;
list = JsonConvert.DeserializeObject <List <dynamic> >(result).Select(x => new ItemViewModel
{
Id = x.Id,
//CustomerId = x.CustomerId,
CustomerId = x.CustomerId,
ProductId = x.ProductId,
BrandId = x.BrandId,
ItemCode = x.ItemCode,
Description = x.Description,
ProductCode = x.Product != null ? x.Product.ProductCode : "",
ProductDesc = x.Product != null ? x.Product.Description : "",
BrandCode = x.Brand != null ? x.Brand.Code : "",
BrandName = x.Brand != null ? x.Brand.Name : "",
IsActive = x.IsActive
});
filteredList = list.Where(x => x.ProductDesc.ToLower().Contains(searchBy) ||
x.BrandName.ToLower().Contains(searchBy) ||
x.ItemCode.ToLower().Contains(searchBy) ||
x.Description.ToLower().Contains(searchBy)).OrderBy(orderBy, StringComparison.OrdinalIgnoreCase);
}
totalResultCount = list.Count();
filteredResultCount = filteredList.Count();
filteredList = filteredList.Skip(skip).Take(take);
return(new { filteredList, filteredResultCount, totalResultCount });
}
public async Task <JsonResult> IndexJson(ListFilterViewModels request)
{
var helper = new CustomerClientDataTableSearchHelper();
var result = await helper.SearchFunction(request);
var resultList = (IEnumerable <CustomerClientViewModel>)result.filteredList;
var data = resultList.Select(x => new
{
Actions = "<div class='btn-group' style='display:flex;'>" +
"<a class='btn btn-primary' href='#'><i class='fa fa-gear fa-fw'></i> Action</a>" +
"<a class='btn btn-primary dropdown-toggle' data-toggle='dropdown' href='#'>" +
"<span class='fa fa-caret-down' title='Toggle dropdown menu'></span>" +
"</a>" +
"<ul class='dropdown-menu' role='menu'>" +
(x.IsActive ? "<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Edit") + "' onclick='btnClicked($(this))'><a>Edit</a></li>" : "") +
"<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Details") + "' onclick='btnClicked($(this))'><a>Details</a></li>" +
(x.IsActive ? "<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Delete") + "' onclick='btnClicked($(this))'><a>Delete</a></li>" :
"<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Enable") + "' onclick='btnClicked($(this))'><a>Enable</a></li>") +
"</ul>" +
"</div>",
CustomerCode = x.CustomerCode,
Description = x.Name,
ContactPerson = x.ContactPerson,
Telephone = x.Telephone,
MobileNo = x.MobileNo,
EmailAddress = x.EmailAddress,
Website = x.Website,
Address1 = x.Address1,
Address2 = x.Address2,
IsActve = x.IsActive
});
return(Json(new
{
draw = request.draw,
recordsTotal = result.totalResultCount,
recordsFiltered = result.filteredResultCount,
data = data
}));
}
public async Task <JsonResult> IndexJson(ListFilterViewModels request)
{
var helper = new CustomerDataTableSearchHelper();
var result = await helper.SearchFunction(request);
var resultList = (IEnumerable <CustomerViewModel>)result.filteredList;
var data = resultList.Select(x => new
{
Actions = "<div class='btn-group' style='display:flex;'>" +
"<a class='btn btn-primary' href='#'><i class='fa fa-gear fa-fw'></i> Action</a>" +
"<a class='btn btn-primary dropdown-toggle' data-toggle='dropdown' href='#'>" +
"<span class='fa fa-caret-down' title='Toggle dropdown menu'></span>" +
"</a>" +
"<ul class='dropdown-menu' role='menu'>" +
(x.IsActive ? "<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Edit") + "' onclick='btnClicked($(this))'><a>Edit</a></li>" : "") +
"<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Details") + "' onclick='btnClicked($(this))'><a>Details</a></li>" +
(x.IsActive ? "<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Delete") + "' onclick='btnClicked($(this))'><a>Disable</a></li>" :
"<li class='crud' data-id='" + x.Id + "' data-request-url='" + Url.Action("Enable") + "' onclick='btnClicked($(this))'><a>Enable</a></li>") +
"</ul>" +
"</div>",
FullName = x.FirstName + (!string.IsNullOrEmpty(x.MiddleName) ? " " + x.MiddleName[0] + ". " : " ") + x.LastName,
EmailAddress = x.EmailAddress,
Domain = x.Domain,
CompanyName = x.CompanyName,
ContactNo = x.ContactNo,
IsActive = x.IsActive
});
return(Json(new
{
draw = request.draw,
recordsTotal = result.totalResultCount,
recordsFiltered = result.filteredResultCount,
data = data
}));
}