public async Task <JsonResult> GetJobHistory()
{
int count = 0;
QuartzScheduler context = new QuartzScheduler(quartzJobStoreSettings.QuartzConnectionString);
var dataTableData = new DataTableData <QRTZ_JOB_HISTORY>();
var gridData = context.QRTZ_JOB_HISTORY.ToList();//new List<QRTZ_JOB_HISTORY>();
PagingData pgData = new PagingData(Request.QueryString);
Expression <Func <QRTZ_JOB_HISTORY, bool> > where = w => (
w.JOB_NAME.Contains(pgData.Search ?? ""));
/* Expression<Func<Order, bool>> where = w => (
* w.OrderNumber != "");*/
dataTableData.draw = pgData.Draw;
//
count = gridData.Count;
gridData = await GetList(gridData.Where(d => d.JOB_NAME != "").AsQueryable().OrderByDescending(d => d.STARTDATE).ThenBy(d => d.JOB_NAME), pgData, where);
dataTableData.data = gridData;
dataTableData.recordsFiltered = count;
dataTableData.recordsTotal = count;
dataTableData.success = true;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public static object GetCities(DataTableAjaxPostModel model)
{
var cols = new List <string>()
{
"LOWER(TRIM(cm.city_name))", "LOWER(TRIM(sm.state_name))", "LOWER(TRIM(cm.doc_count))"
};
// Initialization.
DataTableData <CityModel> result = new DataTableData <CityModel>();
try
{
// Initialization.
string draw = model.draw.ToString();
int startRec = model.start;
int pageSize = model.length;
var c_order = "";
foreach (var o in model.order)
{
var columnName = cols[o.column];
c_order += string.IsNullOrWhiteSpace(c_order) ? columnName + " " + o.dir : ", " + columnName + " " + o.dir;
}
if (!string.IsNullOrWhiteSpace(c_order))
{
c_order = " order by " + c_order;
}
var c_search = "";
foreach (var s in model.columns)
{
if (!string.IsNullOrWhiteSpace(s.search.value) && s.searchable)
{
var i = model.columns.IndexOf(s);
var columnName = cols[i];
c_search += i == 1 ? " and " + columnName + " like '%" + s.search.value.Trim().ToLower() + "%'" : " and " + columnName + " like '%" + s.search.value + "%'";
}
}
var cities = new CityManager().GetAllCitiesPaginated(startRec, pageSize, c_order, c_search);
var cityList = cities.Data;
foreach (var city in cityList)
{
city.Link = "<a href='javascript:void(0);' style='margin-right:10px' class='edit-city' data-id='" + city.Id + "'>Edit</a><a href='javascript:void(0);' style='margin-left:10px' class='delete-city' data-id='" + city.Id + "'>Delete</a>";
}
int recFilter = cities.Data.Count;
result.draw = Convert.ToInt32(draw);
result.recordsTotal = cities.TotalCount;
result.recordsFiltered = cities.TotalCount;
result.data = cityList;
}
catch (Exception ex)
{
// Info
Console.Write(ex);
}
// Return info.
return(result);
}
private async Task Fetch_ByEntityType()
{
var controller = LocalIocManager.Resolve <DataTableController>();
var configurationStore = LocalIocManager.Resolve <IEntityConfigurationStore>();
var input = new DataTableGetDataInput
{
EntityType = configurationStore.Get(typeof(Person)).TypeShortAlias,
Properties = new List <string>
{
nameof(Person.Id),
nameof(Person.FullName),
nameof(Person.EmailAddress1),
nameof(Person.MobileNumber1),
},
CurrentPage = 1,
PageSize = int.MaxValue,
};
DataTableData data = null;
await WithUnitOfWorkAsync(async() =>
{
data = await controller.GetTableDataAsync <Person, Guid>(input, CancellationToken.None);
});
}
public ActionResult AjaxGetJsonData(int draw, int start, int length)
{
DataTableModels <TestModel> ._data = db.testTable.ToList();
string search = Request.QueryString["search[value]"];
int sortColumn = -1;
string sortDirection = "asc";
if (length == -1)
{
length = DataTableModels <TestModel> ._data.Count;
}
// note: we only sort one column at a time
if (Request.QueryString["order[0][column]"] != null)
{
sortColumn = int.Parse(Request.QueryString["order[0][column]"]);
}
if (Request.QueryString["order[0][dir]"] != null)
{
sortDirection = Request.QueryString["order[0][dir]"];
}
DataTableData <TestModel> dataTableData = new DataTableData <TestModel>();
dataTableData.draw = draw;
dataTableData.recordsTotal = DataTableModels <TestModel> ._data.Count;
int recordsFiltered = 0;
dataTableData.data = DataTableModels <TestModel> .FilterData(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
private async Task <DataTableData> FetchData(string tableId, string expression)
{
var controller = LocalIocManager.Resolve <DataTableController>();
var input = new DataTableGetDataInput
{
Id = tableId,
CurrentPage = 1,
PageSize = int.MaxValue,
Filter = new List <ColumnFilterDto>(),
SelectedFilters = new List <SelectedStoredFilterDto>
{
new SelectedStoredFilterDto
{
Expression = expression, ExpressionType = "jsonlogic", Id = "test", Name = "Test"
}
},
};
DataTableData data = null;
await WithUnitOfWorkAsync(async() =>
{
data = await controller.GetTableDataAsync <Person, Guid>(input, CancellationToken.None);
});
return(data);
}
public ActionResult GetList(string cadena, int draw, int start, int length)
{
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = 0;
int recordsFiltered = 0;
if (cadena == null)
{
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length);
}
else if (cadena != null)
{
try
{
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length).Where(o => o.IdRol == int.Parse(cadena)).ToList();
}
catch
{
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length).Where(o => o.Nombre.ToUpper().Contains(cadena.ToUpper())).ToList();
}
}
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public async Task <string> GetAll(DatatableParametersDto dataItems)
{
string output = "";
string error = "";
DataTableData <PatientProfileDto> dataTableData = new DataTableData <PatientProfileDto>();
try
{
var query = _dbContext.PatientProfiles.Select(x => new PatientProfileDto
{
Requisitions = _mapper.Map <ICollection <Requisition>, ICollection <RequisitionDto> >(x.Requisitions),//MapAddress(x.Address),
PatientId = x.PatientId,
Patient = _mapper.Map <PatientDto>(x.Patient),
Id = x.Id
});
var totalCount = query.Count();
int sortColumn = -1;
string sortDirection = "asc";
if (dataItems.Length <= 0)
{
dataItems.Length = totalCount;
}
if (dataItems.Draw <= 0)
{
dataItems.Draw = 10;
}
if (dataItems.Start <= -1)
{
dataItems.Start = 0;
}
dataTableData.draw = dataItems.Draw;
dataTableData.recordsTotal = totalCount;
// Paging
if (dataItems.Length != totalCount)
{
query = query.Skip(dataItems.Start).Take(dataItems.Length);
}
//Search
// Apply filters
/*if (!string.IsNullOrEmpty(dataItems.Search) || !string.IsNullOrWhiteSpace(dataItems.Search))
* {
* var value = dataItems.Search.Trim();
* query = query.Where(p => p..ToString().Contains(value));
* }*/
var data = await query.ToListAsync();
dataTableData.recordsFiltered = totalCount;
dataTableData.data = data;
output = JsonConvert.SerializeObject(dataTableData, Formatting.Indented);
}
catch (Exception ex)
{
error = ex.Message;
}
return(output);
}
public static object GetBloodBanks(DataTableAjaxPostModel model)
{
var cols = new List <string>()
{
"LOWER(TRIM(bm.blood_bank_name))", "LOWER(TRIM(bm.email_id))", "LOWER(TRIM(bm.contact_no))", "LOWER(TRIM(bm.year_of_opening))", "LOWER(TRIM(bm.timings))", "LOWER(TRIM(cm.city_name))"
};
// Initialization.
DataTableData <BloodBankModel> result = new DataTableData <BloodBankModel>();
try
{
// Initialization.
string draw = model.draw.ToString();
int startRec = model.start;
int pageSize = model.length;
var c_order = "";
foreach (var o in model.order)
{
var columnName = cols[o.column];
c_order += string.IsNullOrWhiteSpace(c_order) ? columnName + " " + o.dir : ", " + columnName + " " + o.dir;
}
if (!string.IsNullOrWhiteSpace(c_order))
{
c_order = " order by " + c_order;
}
var c_search = "";
foreach (var s in model.columns)
{
if (!string.IsNullOrWhiteSpace(s.search.value) && s.searchable)
{
var i = model.columns.IndexOf(s);
var columnName = cols[i];
c_search += i == 1 ? " and " + columnName + " like '%" + s.search.value.Trim().ToLower() + "%'" : " and " + columnName + " like '%" + s.search.value + "%'";
}
}
var bloodBanks = new BloodBankManager().GetAllBloodBanksPaginated(startRec, pageSize, c_order, c_search);
var bloodBankList = bloodBanks.Data;
foreach (var bloodBank in bloodBankList)
{
bloodBank.Link = "<a href='javascript:void(0);' style='margin-right:10px' class='edit-bloodbank' data-id='" + bloodBank.Id + "'>Edit</a><a href='javascript:void(0);' class='add-bloodbank-images' data-id='" + bloodBank.Id + "'>Add Images</a><a href='javascript:void(0);' style='margin-left:10px' class='delete-bb' data-id='" + bloodBank.Id + "'>Delete</a>";
}
int recFilter = bloodBanks.Data.Count;
result.draw = Convert.ToInt32(draw);
result.recordsTotal = bloodBanks.TotalCount;
result.recordsFiltered = bloodBanks.TotalCount;
result.data = bloodBankList;
}
catch (Exception ex)
{
// Info
Console.Write(ex);
}
// Return info.
return(result);
}
public ActionResult GetJsonData(int draw, int start, int length)
{
string search = Request.QueryString[DataTableQueryString.Searching];
string sortColumn = "";
string sortDirection = "asc";
if (Request.QueryString[DataTableQueryString.OrderingColumn] != null)
{
sortColumn = GetServiceSortingColumn(Request.QueryString[DataTableQueryString.OrderingColumn].ToString());
}
if (Request.QueryString[DataTableQueryString.OrderingDir] != null)
{
sortDirection = Request.QueryString[DataTableQueryString.OrderingDir];
}
var dataTableData = new DataTableData
{
draw = draw
};
var recordsFiltered = 0;
var result = LeaveService.Instance.GetLeaveApplicationsForSupervisor(User.Identity.Name, out recordsFiltered, start, length, sortColumn, sortDirection, search);
if (result.IsSuccess)
{
dataTableData.data = result.Data;
}
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public JsonResult GetJsonData(int draw, int start, int length)
{
string search = "", sortColumn = "", sortDirection = "asc";
this.GetDataTablePara(out search, out sortColumn, out sortDirection);
DateTime?startDate;
DateTime?endDate;
this.GetDataTableDateRange(out startDate, out endDate);
var dataTableData = new DataTableData
{
draw = draw
};
var recordsFiltered = 0;
var service = new EmployeeService();
var eventData = service.Search(out recordsFiltered, startDate, endDate, start, length, sortColumn, sortDirection, search.Trim());
dataTableData.data = eventData;
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, new JsonSerializerSettings()));
}
public JsonResult AjaxGetJsonData(int draw, int start, int length, int DueDays, bool ShowExpired, int DocType)
{
string search = Request.Form["search[value]"];
int sortColumn = -1;
string sortDirection = "asc";
string SortColName = "";
if (length == -1)
{
length = TOTAL_ROWS;
}
// note: we only sort one column at a time
if (Request.Form["order[0][column]"] != null)
{
sortColumn = int.Parse(Request.Form["order[0][column]"]);
SortColName = Request.Form["columns[" + sortColumn + "][data]"];
}
if (Request.Form["order[0][dir]"] != null)
{
sortDirection = Request.Form["order[0][dir]"];
}
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
int recordsFiltered = 0;
dataTableData.data = FilterData(ref recordsFiltered, ref TOTAL_ROWS, start, length, search, sortColumn, sortDirection, DueDays, ShowExpired, DocType);
dataTableData.recordsTotal = TOTAL_ROWS;
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
//H
public IActionResult LoadDataTable()
{
DataTableData data = new DataTableData();
var result = data.GetData();
return(Json(result));
}
public async Task <string> GetAll(DatatableParametersDto dataItems)
{
string output = "";
string error = "";
DataTableData <NormalRangeDto> dataTableData = new DataTableData <NormalRangeDto>();
try
{
var query = (from range in _dbContext.NormalRanges
select new NormalRangeDto
{
Description = range.Description,
Id = range.Id
});
var totalCount = query.Count();
int sortColumn = -1;
string sortDirection = "asc";
if (dataItems.Length <= 0)
{
dataItems.Length = totalCount;
}
if (dataItems.Draw <= 0)
{
dataItems.Draw = 10;
}
if (dataItems.Start <= -1)
{
dataItems.Start = 0;
}
dataTableData.draw = dataItems.Draw;
dataTableData.recordsTotal = totalCount;
// Paging
if (dataItems.Length != totalCount)
{
query = query.Skip(dataItems.Start).Take(dataItems.Length);
}
//Search
// Apply filters
if (totalCount > 0 && (!string.IsNullOrEmpty(dataItems.Search) || !string.IsNullOrWhiteSpace(dataItems.Search)))
{
var value = dataItems.Search.Trim();
query = query.Where(p => p.Description.Contains(value));
}
var data = await query.ToListAsync();
dataTableData.recordsFiltered = totalCount;
dataTableData.data = data;
output = JsonConvert.SerializeObject(dataTableData, Formatting.Indented);
}
catch (Exception ex)
{
error = ex.Message;
}
return(output);
}
public async Task <DataTableData> GetData(DataTableGetDataInput input, CancellationToken cancellationToken)
{
var mapper = StaticContext.IocManager.Resolve <IObjectMapper>();
var tableConfig = BackupFilesIndex();
var items = (await GetBackupsList()).Select(x => new { FileName = x }).ToList();
var totalRowsBeforeFilter = items.Count();
// Dynamic filter
if (!string.IsNullOrEmpty(input.QuickSearch))
{
var properties = tableConfig.AuthorizedColumns.Where(x => x.IsVisible).Select(x => x.FilterPropertyName)
.ToArray();
if (properties.Length > 0)
{
items = items.LikeDynamic(properties, input.QuickSearch).ToList();
}
}
var totalRows = items.Count();
var totalPages = (int)Math.Ceiling((double)items.Count() / input.PageSize);
var takeCount = input.PageSize > -1 ? input.PageSize : int.MaxValue;
var skipCount = Math.Max(0, (input.CurrentPage - 1) * takeCount);
var sort = input.Sorting.FirstOrDefault();
if (sort != null)
{
items = items.OrderByDynamic(sort.Id, sort.Desc ? "desc" : "asc").ToList();
}
items = items.Skip(skipCount).Take(takeCount).ToList();
var dataRows = new List <Dictionary <string, object> >();
foreach (var item in items)
{
cancellationToken.ThrowIfCancellationRequested();
dataRows.Add(new Dictionary <string, object>()
{
{ "FileName", item.FileName }
});
}
var result = new DataTableData
{
TotalRowsBeforeFilter = totalRowsBeforeFilter,
TotalRows = totalRows,
TotalPages = totalPages,
//Echo = dataTableParam.sEcho,
Rows = dataRows
};
return(result);
}
// this ajax function is called by the client for each draw of the information on the page (i.e. when paging, ordering, searching, etc.).
public ActionResult AjaxGetJsonData(int draw, int start, int length)
{
System.Diagnostics.Debug.WriteLine(" Draw : " + draw);
var searchLOGIN_ID = Request.QueryString["columns[1][search][value]"];
System.Diagnostics.Debug.WriteLine(" RequestParam1 : " + searchLOGIN_ID);
var searchNAME = Request.QueryString["columns[2][search][value]"];
System.Diagnostics.Debug.WriteLine(" RequestParam2 : " + searchNAME);
var searchDT_EDIT = Request.QueryString["columns[3][search][value]"];
System.Diagnostics.Debug.WriteLine(" RequestParam3 : " + searchDT_EDIT);
//string whichcolumn = Request.QueryString["order[0][column]"];
//System.Diagnostics.Debug.WriteLine(" Sort by what Column : " + whichcolumn);
//string whichdirection = Request.QueryString["order[0][dir]"];
//System.Diagnostics.Debug.WriteLine(" Sort by which Direction : " + whichdirection);
string search = Request.QueryString["search[value]"];
System.Diagnostics.Debug.WriteLine(" search : " + search);
int sortColumn = -1;
string sortDirection = "asc";
if (length == -1)
{
length = TOTAL_ROWS;
}
// note: we only sort one column at a time
if (Request.QueryString["order[0][column]"] != null)
{
sortColumn = int.Parse(Request.QueryString["order[0][column]"]);
}
if (Request.QueryString["order[0][dir]"] != null)
{
sortDirection = Request.QueryString["order[0][dir]"];
}
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = TOTAL_ROWS;
int recordsFiltered = 0;
dataTableData.data = FilterData(ref recordsFiltered, start, length, search, searchLOGIN_ID, searchNAME, searchDT_EDIT, sortColumn, sortDirection);
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult GetList(string data, int draw, int start, int length)
{
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = 0;
int recordsFiltered = 0;
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length);
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult GetList(int plaza, string contrato, string cliente, string direccion, int draw, int start, int length)
{
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = 0;
int recordsFiltered = 0;
dataTableData.data = FiltrarContenido(plaza, contrato, cliente, direccion, ref recordsFiltered, start, length);
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult GetList(string cadena, int draw, int start, int length, int proceso, int?filtro)
{
int total = 0;
List <UniversoEncuestaEntity> lista = new List <UniversoEncuestaEntity>();
if (filtro == 1)
{
total = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Aplicada == true).ToList().Count;
lista = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Aplicada == true).Skip(start).Take(length).ToList();
}
else if (filtro == 2)
{
total = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Aplicada == false).ToList().Count;
lista = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Aplicada == false).Skip(start).Take(length).ToList();
}
else
{
if (cadena != "" && cadena != null)
{
try
{
int contrato = Int32.Parse(cadena);
total = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Contrato == Int32.Parse(cadena)).ToList().Count;
lista = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Contrato == Int32.Parse(cadena)).Skip(start).Take(length).ToList();
}
catch
{
total = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Nombre.ToLower().Contains(cadena.ToLower())).ToList().Count;
lista = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso && o.Nombre.ToLower().Contains(cadena.ToLower())).Skip(start).Take(length).ToList();
}
}
if (cadena == null || cadena == "")
{
total = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso).ToList().Count;
lista = proxy.GetUniversoEncuestaList().Where(o => o.IdProcesoEnc == proceso).Skip(start).Take(length).ToList();
}
}
int recordFiltered = total;
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = 0;
dataTableData.data = lista;
dataTableData.recordsFiltered = recordFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult GetLTLogEventos(object parameters)
{
DataTableData dataTableData = new DataTableData();
var input = JObject.FromObject(JObject.FromObject(parameters)["parameters"]);
dataTableData.draw = (int)input["draw"];
//list = HelperGeneral.PaginadorConsultasLTLogEventos((int)input["start"], (int)input["length"]);
dataTableData.data = this.objDb.PaginadorConsultas((int)input["start"], (int)input["length"], "").ToList();
dataTableData.recordsFiltered = this.objDb.Get().Count();
dataTableData.recordsTotal = dataTableData.recordsFiltered;
return(Json(dataTableData));
}
public JsonResult AjaxGetInvoiceJsonData(int ProductId)
{
string search = Request.Form["search[value]"];
int sortColumn = -1;
string sortDirection = "asc";
DataTableData dataTableData = new DataTableData();
int recordsFiltered = 0;
var fdata = InvoiceFilterData(ref recordsFiltered, ref TOTAL_ROWS, search, sortColumn, sortDirection, ProductId);
dataTableData.recordsTotal = TOTAL_ROWS;
dataTableData.recordsFiltered = recordsFiltered;
return(Json(new { data = fdata, recordsTotal = TOTAL_ROWS, recordsFiltered = recordsFiltered }, JsonRequestBehavior.AllowGet));
}
private async Task ScheduledJob_Executions()
{
var controller = LocalIocManager.Resolve <DataTableController>();
var input = new DataTableGetDataInput
{
Id = "ScheduledJob_Executions_test",
CurrentPage = 1,
PageSize = int.MaxValue,
};
DataTableData data = null;
await WithUnitOfWorkAsync(async() =>
{
data = await controller.GetTableDataAsync <ScheduledJobExecution, Guid>(input, CancellationToken.None);
});
}
private async Task TestConvert()
{
var controller = LocalIocManager.Resolve <DataTableController>();
var input = new DataTableGetDataInput
{
Id = "Areas_Index",
CurrentPage = 1,
PageSize = int.MaxValue,
};
DataTableData data = null;
await WithUnitOfWorkAsync(async() =>
{
data = await controller.GetTableDataAsync <Area, Guid>(input, CancellationToken.None);
});
}
private async Task Fetch_ByTableConfigId()
{
var controller = LocalIocManager.Resolve <DataTableController>();
var input = new DataTableGetDataInput
{
Id = PersonsTableId,
CurrentPage = 1,
PageSize = int.MaxValue,
};
DataTableData data = null;
await WithUnitOfWorkAsync(async() =>
{
data = await controller.GetTableDataAsync <Person, Guid>(input, CancellationToken.None);
});
}
public ActionResult AjaxGetJsonData()
{
DataTableData dataTableData = new DataTableData();
dataTableData.draw = 1;
dataTableData.recordsTotal = 5;
int recordsFiltered = 0;
//dataTableData.data = FilterData(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
//dataTableData.recordsFiltered = recordsFiltered;
DataItem customer1 = new DataItem()
{
Name = "1",
Age = "Sourabh",
DoB = "50000"
};
DataItem customer2 = new DataItem()
{
Name = "2",
Age = "Shaili",
DoB = "60000"
};
DataItem customer3 = new DataItem()
{
Name = "3",
Age = "Saloni",
DoB = "55000"
};
dataTableData.data = new List <DataItem>();
dataTableData.data.Add(customer1); // Here Add Method is used to add the item to the list
dataTableData.data.Add(customer2);
//adding one more customer wheather capacity is 2 only
dataTableData.data.Add(customer3);
//dataTableData.data = new List<DataItem> { Name = "Anjan", Age = "20", DoB = "09/12/2019" };
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
//Nuevas funciones
public ActionResult GetList(string data, int draw, int start, int length)
{
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = 0;
int recordsFiltered = 0;
if (data != "")
{
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length).Where(o => o.Pregunta.Contains(data) || o.IdPregunta.ToString().Contains(data)).OrderByDescending(c => c.IdPregunta).ToList();
}
else
{
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length).OrderByDescending(c => c.IdPregunta).ToList();
}
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxGetJsonDataGrp(int draw, int start, int length)
{
var searchParam = Request.QueryString["columns[1]search[value]"];
System.Diagnostics.Debug.WriteLine(" Search Param : ");
System.Diagnostics.Debug.WriteLine(searchParam);
System.Diagnostics.Debug.WriteLine(" Search : ");
string search = Request["search[value]"];
System.Diagnostics.Debug.WriteLine(search);
int sortColumn = -1;
string sortDirection = "asc";
if (length == -1)
{
length = TOTAL_ROWS;
}
// note: we only sort one column at a time
if (Request.QueryString["order[0][column]"] != null)
{
//sortColumn = int.Parse(Request.QueryString["columns[indexOfColumnToSearch]search[value]"]);
sortColumn = int.Parse(Request["order[0][column]"]);
}
if (Request.QueryString["order[0][dir]"] != null)
{
sortDirection = Request.QueryString["order[0][dir]"];
}
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = TOTAL_ROWS;
int recordsFiltered = 0;
dataTableData.data = FilterDataGrp(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
// this ajax function is called by the client for each draw of the information on the page (i.e. when paging, ordering, searching, etc.).
public ActionResult AjaxGetJsonData(int draw, int start, int length)
{
string search = Request.QueryString["search[value]"];
int sortColumn = -1;
string sortDirection = "asc";
if (length == -1)
{
length = TOTAL_ROWS;
}
// note: we only sort one column at a time
if (Request.QueryString["order[0][column]"] != null)
{
sortColumn = int.Parse(Request.QueryString["order[0][column]"]);
}
if (Request.QueryString["order[0][dir]"] != null)
{
sortDirection = Request.QueryString["order[0][dir]"];
}
using (StreamWriter sr = new StreamWriter(@"D:\test.txt"))
{
sr.WriteLine(Request.QueryString);
sr.Close();
}
string searchData = Request.QueryString["search[value]"];
string dateFromTo = Request.QueryString["search[regex]"];
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = TOTAL_ROWS;
int recordsFiltered = 0;
dataTableData.data = FilterData(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
dataTableData.recordsFiltered = recordsFiltered;
var x = Json(dataTableData, JsonRequestBehavior.AllowGet);
return Json(dataTableData, JsonRequestBehavior.AllowGet);
}
public JsonResult AjaxGetJsonData(int draw, int start, int length, string ProductUid)
{
string search = Request.Form["search[value]"];
int sortColumn = -1;
string sortDirection = "asc";
if (length == -1)
{
length = TOTAL_ROWS;
}
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
int recordsFiltered = 0;
dataTableData.data = FilterData(ref recordsFiltered, ref TOTAL_ROWS, start, length, search, sortColumn, sortDirection, ProductUid);
dataTableData.recordsTotal = TOTAL_ROWS;
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult GetList(string cadena, int draw, int start, int length, int?filtro)
{
List <ProcesoEncuestaEntity> lista = new List <ProcesoEncuestaEntity>();
int total = 0;
if (filtro == 1)
{
lista = proxy.GetProcesoEncuestaList().Where(o => o.StatusEncuesta == "Pendiente").Skip(start).Take(length).OrderByDescending(o => o.IdProcesoEnc).ToList();
total = proxy.GetProcesoEncuestaList().Where(o => o.StatusEncuesta == "Pendiente").Count();
}
else if (filtro == 2)
{
lista = proxy.GetProcesoEncuestaList().Where(o => o.StatusEncuesta == "Terminada").Skip(start).Take(length).OrderByDescending(o => o.IdProcesoEnc).ToList();
total = proxy.GetProcesoEncuestaList().Where(o => o.StatusEncuesta == "Terminada").Count();
}
else
{
if (cadena != "" && cadena != null)
{
lista = proxy.GetProcesoEncuestaList().Where(o => o.NombreProceso.ToLower().Contains(cadena.ToLower()) || o.Encuesta.ToLower().Contains(cadena.ToLower())).Skip(start).Take(length).OrderByDescending(o => o.IdProcesoEnc).ToList();
total = proxy.GetProcesoEncuestaList().Where(o => o.NombreProceso.ToLower().Contains(cadena.ToLower()) || o.Encuesta.ToLower().Contains(cadena.ToLower())).Count();
}
else
{
lista = proxy.GetProcesoEncuestaList().Skip(start).Take(length).OrderByDescending(o => o.IdProcesoEnc).ToList();
total = proxy.GetProcesoEncuestaList().Count();
}
}
int recordFiltered = total;
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = 0;
dataTableData.data = lista;
dataTableData.recordsFiltered = recordFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult GetList(string data, int draw, int start, int length)
{
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
dataTableData.recordsTotal = 0;
int recordsFiltered = 0;
if (data != "")
{
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length).Where(o => o.TituloEncuesta.Contains(data) || o.Descripcion.Contains(data) || o.IdEncuesta.Value.ToString().Contains(data) || o.FechaCreacion.Contains(data)).ToList();
}
else
{
dataTableData.data = FiltrarContenido(ref recordsFiltered, start, length);
}
dataTableData.recordsFiltered = recordsFiltered;
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public async Task <string> GetAll(DatatableParametersDto dataItems)
{
string output = "";
string error = "";
DataTableData <TestDto> dataTableData = new DataTableData <TestDto>();
try
{
var query = _dbContext.Tests.Select(x => new TestDto
{
Name = x.Name,
Comment = x.Comment,
NormalValue = _mapper.Map <NormalRangeDto>(x.NormalValue),//MapAddress(x.Address),
NormalValueId = x.NormalValueId,
TestResult = _mapper.Map <TestResultDto>(x.TestResult),
TestResultId = x.TestResultId,
Id = x.Id
});
var totalCount = query.Count();
int sortColumn = -1;
string sortDirection = "asc";
if (dataItems.Length <= 0)
{
dataItems.Length = totalCount;
}
if (dataItems.Draw <= 0)
{
dataItems.Draw = 10;
}
if (dataItems.Start <= -1)
{
dataItems.Start = 0;
}
dataTableData.draw = dataItems.Draw;
dataTableData.recordsTotal = totalCount;
// Paging
if (dataItems.Length != totalCount)
{
query = query.Skip(dataItems.Start).Take(dataItems.Length);
}
//Search
// Apply filters
if (totalCount > 0 && (!string.IsNullOrEmpty(dataItems.Search) || !string.IsNullOrWhiteSpace(dataItems.Search)))
{
var value = dataItems.Search.Trim();
query = query.Where(p => p.Name.Contains(value));
}
var data = await query.ToListAsync();
dataTableData.recordsFiltered = totalCount;
dataTableData.data = data;
output = JsonConvert.SerializeObject(dataTableData, Formatting.Indented);
}
catch (Exception ex)
{
error = ex.Message;
}
return(output);
}
