public IHttpActionResult Index(FormDataCollection form)
{
try
{
string sEcho = form["draw"].ToString(); //pagina
int iDisplayStart = Convert.ToInt32(form["Start"]); //numero de objeto a esconder
int iDisplayLength = Convert.ToInt32(form["Length"]); //tamaño de la grilla
string sSearch = form["search[value]"].ToString().ToLower(); //filtro smart (global)
List <Orden> OrdenesList = new List <Orden>();
var Count = 0;
if (HttpContext.Current.Session != null)
{
try
{
if (!string.IsNullOrEmpty(sSearch))
{
OrdenesList = db.Orden.Include(o => o.actividad.cliente).Include(o => o.usuario).ToList()
.Where(o => o.OrdenId.ToString().Contains(sSearch) ||
(o.OrdenFecha != null && o.OrdenFecha.ToString("d").ToLower().Contains(sSearch)) ||
(o.OrdenFechaDespacho != null && o.OrdenFechaDespacho.ToString("d").ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(o.OrdenEstado.ToString()) && o.OrdenEstado.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(o.ActividadId.ToString()) && o.ActividadId.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(o.actividad.cliente.ClienteRazonSocial.ToString()) && o.actividad.cliente.ClienteRazonSocial.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(o.OrdenNroGuia.ToString()) && o.OrdenNroGuia.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(o.usuario.UsuarioNombre.ToString()) && o.usuario.UsuarioNombre.ToString().ToLower().Contains(sSearch))
).ToList();
}
else
{
OrdenesList = db.Orden.Include(o => o.actividad.cliente).Include(o => o.usuario).ToList();
} //if (!string.IsNullOrEmpty(sSearch))
} //try
catch
{
OrdenesList = new List <Orden>();
} //catch
} //if (HttpContext.Current.Session != null)
Count = OrdenesList.Count;
OrdenesList = OrdenesList.OrderByDescending(o => o.OrdenFecha)
.Skip(iDisplayStart).Take(iDisplayLength).ToList();
var CustomerPaged = new SysDataTablePager();
CustomerPaged.draw = sEcho;
CustomerPaged.recordsTotal = Count;
CustomerPaged.recordsFiltered = Count;
CustomerPaged.data = OrdenesList.Select(o => new { o.OrdenId, o.OrdenFecha, o.OrdenFechaDespacho, o.OrdenEstado, o.ActividadId, o.actividad.cliente.ClienteRazonSocial, o.OrdenNroGuia, o.usuario.UsuarioNombre });
return(Ok(CustomerPaged));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public async Task <Object> GetListadoRipstAsync(int fktoken)
{
NameValueCollection nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
string sEcho = nvc["sEcho"].ToString();
string sSearch = nvc["sSearch"].ToString();
int iDisplayStart = Convert.ToInt32(nvc["iDisplayStart"]);
//this provides display length of table it can be 10,25, 50
int iDisplayLength = Convert.ToInt32(nvc["iDisplayLength"]);
//iSortCol gives your Column numebr of for which sorting is required
int iSortCol = Convert.ToInt32(nvc["iSortCol_0"]);
//provides your sort order (asc/desc)
string sortOrder = nvc["sSortDir_0"].ToString();
var result = new List <VW_Listado_Estado_Rips>();//new List<VW_Listado_Estado_Rips>();
//Search query when sSearch is not empty
if (sSearch != "" && sSearch != null) //If there is search query
{
result = (from VLR in bd.VW_Listado_Estado_Rips
where (VLR.codigo.ToString().Contains(sSearch.ToString()) ||
VLR.tipo_usuario.ToString().ToLower().Contains(sSearch.ToString()) ||
VLR.categoria.ToString().ToLower().Contains(sSearch.ToString()) ||
VLR.periodo_fecha_inicio.Value.ToString().Contains(sSearch.ToString()) ||
VLR.periodo_fecha_fin.Value.ToString().Contains(sSearch.ToString()) ||
VLR.fecha_cargo.Value.ToString().Contains(sSearch.ToString()) ||
VLR.estado_web_validacion.ToString().ToLower().Contains(sSearch.ToString()) ||
VLR.estado_web_preradicacion.ToString().ToLower().Contains(sSearch.ToString()) ||
VLR.estado_servicio_validacion.ToString().ToLower().Contains(sSearch.ToString()) ||
VLR.estado_radicacion.ToString().ToLower().Contains(sSearch.ToString())
)
where VLR.FK_usuario == fktoken
orderby VLR.fecha_cargo ascending
select VLR).ToList();
// Call Funcion de ordenado y proveer sorted Data, then Skip using iDisplayStart
result = SortFunction(iSortCol, sortOrder, result).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
else //Si no hay valores a buscar
{
result = (from VLR in bd.VW_Listado_Estado_Rips
where VLR.FK_usuario == fktoken
orderby VLR.fecha_cargo ascending
select VLR).ToList();
// Call Funcion de ordenado y proveer sorted Data, then Skip using iDisplayStart
result = SortFunction(iSortCol, sortOrder, result).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
//get total value count
var Cantidad = bd.VW_Listado_Estado_Rips.Where(v => v.FK_usuario == fktoken).Count();
//se Creo un modelo para datatable paging and sending data & enter all the required values
var VWListadoPaged = new SysDataTablePager <VW_Listado_Estado_Rips>(result, Cantidad, Cantidad, sEcho);
return(VWListadoPaged);
}
public string GetUser()
{
try
{
NameValueCollection nvc = HttpUtility.ParseQueryString(HttpContext.Current.Request.Url.Query);
var sEcho = nvc["sEcho"];
var iDisplayStart = Convert.ToInt32(nvc["iDisplayStart"]);
var iDisplayLength = Convert.ToInt32(nvc["iDisplayLength"]);
var iSortCol = Convert.ToInt32(nvc["iSortCol_0"]);
var isAsc = nvc["sSortDir_0"] == "asc";
var sSearch = nvc["sSearch"];
var PageIndex = iDisplayStart == 0 ? 1 : (iDisplayStart / iDisplayLength) + 1;
var PageEnd = PageIndex * iDisplayLength;
var PageStart = (PageEnd - iDisplayLength) + 1;
AuthenController ctrl = new AuthenController();
int RecordCount = ctrl.GetCountUser(sSearch);
List <MAS_USERSerializeProperties> coll = ctrl.GetUserWithPaging(sSearch, PageStart, PageEnd);
var ret = coll.Select(p => new
{
Code = p.USER_ID,
NameEng = p.USER_NAME_ENG,
NameLoc = p.USER_NAME_LOC,
PhoneNo = p.PHONE_NO,
Email = p.EMAIL,
CCA = p.CCA,
ServiceKey = p.CCA_SERVICEKEY,
Signature = p.SIGNATURE,
DepartmentName = p.DEPARTMENT_NAME
}).ToList();
var dtPage = new SysDataTablePager();
dtPage.sEcho = sEcho;
dtPage.iTotalRecords = RecordCount;
dtPage.iTotalDisplayRecords = RecordCount;
dtPage.aaData = ret.Select(c => (object)c).ToList();
return(JsonConvert.SerializeObject(dtPage));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult GetData(string sEcho, string sSearch, int iDisplayStart, int iDisplayLength, string iSortCol_0, string sSortDir_0)
{
try
{
//iSortCol gives your Column numebr of for which sorting is required
int iSortCol = Convert.ToInt32(iSortCol_0);
//provides your sort order (asc/desc)
string sortOrder = sSortDir_0;
//get total value count
var Count = _typeOfPaymentRepository.GetAll().Count();
var typesOfPayments = new List <TypeOfPaymentDto>();
//Search query when sSearch is not empty
if (sSearch != "" && sSearch != null) //If there is search query
{
typesOfPayments = Mapper.Map <List <TypeOfPaymentDto> >(_typeOfPaymentRepository.GetAll()
.Where(a => a.Code.ToLower().Contains(sSearch.ToLower()) ||
a.Id.ToString().ToLower().Contains(sSearch.ToLower()) ||
a.Title.ToString().ToLower().Contains(sSearch.ToLower())).ToList());
Count = typesOfPayments.Count();
// Call SortFunction to provide sorted Data, then Skip using iDisplayStart
typesOfPayments = SortFunction(iSortCol, sortOrder, typesOfPayments).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
else
{
//get data from database
typesOfPayments = Mapper.Map <List <TypeOfPaymentDto> >(_typeOfPaymentRepository.GetAll() //speficiy conditions if there is any using .Where(Condition)
.ToList());
// Call SortFunction to provide sorted Data, then Skip using iDisplayStart
typesOfPayments = SortFunction(iSortCol, sortOrder, typesOfPayments).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
var TypeOfPaymentsPaged = new SysDataTablePager <TypeOfPaymentDto>(typesOfPayments, Count, Count, sEcho);
return(Ok(TypeOfPaymentsPaged));
}
catch (Exception ex)
{
logger.Error($"GetData() {DateTime.Now}");
logger.Error(ex);
logger.Error("==============================");
return(InternalServerError());
}
}
public SysDataTablePager Get()
{
NameValueCollection nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
string sEcho = nvc["draw"].ToString(); //pagina
int iDisplayStart = Convert.ToInt32(nvc["Start"]); //numero de objeto a esconder
int iDisplayLength = Convert.ToInt32(nvc["Length"]); //tamaño de la grilla
string sSearch = nvc["search[value]"].ToString().ToLower(); //filtro smart (global)
List <Auditoria> AuditoriaList = null;
var Count = 0;
try
{
if (!string.IsNullOrEmpty(sSearch))
{
AuditoriaList = (from a in db.Auditoria
select a).ToList()
.Where(a => a.AuditoriaId.ToString().Contains(sSearch) ||
(a.AuditoriaFecha != null && a.AuditoriaFecha.ToString("d").ToLower().Contains(sSearch)) ||
(a.AuditoriaHora != null && a.AuditoriaHora.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.usuarioId) && a.usuarioId.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.AuditoriaEvento) && a.AuditoriaEvento.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.AuditoriaDesc) && a.AuditoriaDesc.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.ObjetoId) && a.ObjetoId.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.AuditoriaEquipo) && a.AuditoriaEquipo.ToLower().Contains(sSearch))
).ToList();
}
else
{
AuditoriaList = db.Auditoria.ToList();
}
Count = AuditoriaList.Count;
AuditoriaList = AuditoriaList.OrderByDescending(a => a.AuditoriaId).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
catch
{
AuditoriaList = new List <Auditoria>();
}
var CustomerPaged = new SysDataTablePager();
CustomerPaged.draw = sEcho;
CustomerPaged.recordsTotal = Count;
CustomerPaged.recordsFiltered = Count;
CustomerPaged.data = AuditoriaList;
return(CustomerPaged);
}
public string GetOrganization()
{
try
{
NameValueCollection nvc = HttpUtility.ParseQueryString(HttpContext.Current.Request.Url.Query);
var sEcho = nvc["sEcho"];
var iDisplayStart = Convert.ToInt32(nvc["iDisplayStart"]);
var iDisplayLength = Convert.ToInt32(nvc["iDisplayLength"]);
var iSortCol = Convert.ToInt32(nvc["iSortCol_0"]);
var isAsc = nvc["sSortDir_0"] == "asc";
var sSearch = nvc["sSearch"];
var PageIndex = iDisplayStart == 0 ? 1 : (iDisplayStart / iDisplayLength) + 1;
var PageEnd = PageIndex * iDisplayLength;
var PageStart = (PageEnd - iDisplayLength) + 1;
AuthenController ctrl = new AuthenController();
MAS_ORGSerializeProperties org = ctrl.GetOrgByPrimaryKey(MySession.Current.OrgCode);
int RecordCount = ctrl.GetCountOrg(sSearch, MySession.Current.Schema, org.CENTER_ORG);
List <MAS_ORGSerializeProperties> coll = ctrl.GetOrgWithPaging(sSearch, PageStart, PageEnd, MySession.Current.Schema, org.CENTER_ORG);
var ret = coll.Select(p => new
{
OrgCode = p.ORG_CODE,
OrgNameEng = p.ORG_NAME_ENG,
OrgNameLoc = p.ORG_NAME_LOC,
ShortNameEng = p.SHORT_NAME_ENG,
ShortNameLoc = p.SHORT_NAME_LOC,
Schema = p.SCHEMA,
CenterOrg = p.CENTER_ORG
}).ToList();
var dtPage = new SysDataTablePager();
dtPage.sEcho = sEcho;
dtPage.iTotalRecords = RecordCount;
dtPage.iTotalDisplayRecords = RecordCount;
dtPage.aaData = ret.Select(c => (object)c).ToList();
return(JsonConvert.SerializeObject(dtPage));
}
catch (Exception)
{
throw;
}
}
public string GetGroupUser()
{
try
{
NameValueCollection nvc = HttpUtility.ParseQueryString(HttpContext.Current.Request.Url.Query);
var sEcho = nvc["sEcho"];
var iDisplayStart = Convert.ToInt32(nvc["iDisplayStart"]);
var iDisplayLength = Convert.ToInt32(nvc["iDisplayLength"]);
var iSortCol = Convert.ToInt32(nvc["iSortCol_0"]);
var isAsc = nvc["sSortDir_0"] == "asc";
var sSearch = nvc["sSearch"];
var OrgCode = nvc["OrgCode"];
var GroupCode = nvc["GroupCode"];
var iExisting = nvc["iExisting"];
var PageIndex = iDisplayStart == 0 ? 1 : (iDisplayStart / iDisplayLength) + 1;
var PageEnd = PageIndex * iDisplayLength;
var PageStart = (PageEnd - iDisplayLength) + 1;
AuthenController ctrl = new AuthenController();
int RecordCount = ctrl.GetCountGroupUser(sSearch, OrgCode, GroupCode, iExisting);
List <MAS_USERSerializeProperties> coll = ctrl.GetGroupUserWithPaging(sSearch, OrgCode, GroupCode, iExisting, PageStart, PageEnd);
var ret = coll.Select(p => new
{
Code = p.USER_ID,
NameEng = p.USER_NAME_ENG,
NameLoc = p.USER_NAME_LOC
}).ToList();
var dtPage = new SysDataTablePager();
dtPage.sEcho = sEcho;
dtPage.iTotalRecords = RecordCount;
dtPage.iTotalDisplayRecords = RecordCount;
dtPage.aaData = ret.Select(c => (object)c).ToList();
return(JsonConvert.SerializeObject(dtPage));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult GetData(string sEcho, string sSearch, int iDisplayStart, int iDisplayLength, string iSortCol_0, string sSortDir_0)
{
try
{
//iSortCol gives your Column numebr of for which sorting is required
int iSortCol = Convert.ToInt32(iSortCol_0);
//provides your sort order (asc/desc)
string sortOrder = sSortDir_0;
var SearchItems = new List <SearchDto>();
if (MemoryCacher.GetValue(Constant.SearchList) != null)
{
SearchItems = (List <SearchDto>)MemoryCacher.GetValue(Constant.SearchList);
}
else
{
SearchItems = Mapper.Map <List <SearchDto> >(_searchRepository.Search(sSearch));
MemoryCacher.Add(Constant.SearchList, SearchItems, DateTimeOffset.Now.AddMinutes(Constant.CacheTime));
}
//get total value count
var Count = SearchItems.Count();
// Call SortFunction to provide sorted Data, then Skip using iDisplayStart
SearchItems = SortFunction(iSortCol, sortOrder, SearchItems).Skip(iDisplayStart).Take(iDisplayLength).ToList();
var SearchPaged = new SysDataTablePager <SearchDto>(SearchItems, Count, Count, sEcho);
return(Ok(SearchPaged));
}
catch (Exception ex)
{
logger.Error($"GetData() {DateTime.Now}");
logger.Error(ex);
logger.Error("==============================");
return(InternalServerError());
}
}
public IHttpActionResult GetData(string sEcho, string sSearch, int iDisplayStart, int iDisplayLength, string iSortCol_0, string sSortDir_0)
{
try
{
//iSortCol gives your Column numebr of for which sorting is required
int iSortCol = Convert.ToInt32(iSortCol_0);
//provides your sort order (asc/desc)
string sortOrder = sSortDir_0;
//get total value count
var Count = 0;
var Categories = new List <CategoryGridItemDto>();
//Search query when sSearch is not empty
if (sSearch != "" && sSearch != null) //If there is search query
{
if (MemoryCacher.GetValue(Constant.CategoryList) != null)
{
//Get the list from cache
Categories = (List <CategoryGridItemDto>)MemoryCacher.GetValue(Constant.CategoryList);
}
else
{
Categories = Mapper.Map <List <CategoryGridItemDto> >(_categoryRepository.GetAll().Where(a => a.Title.ToLower().Contains(sSearch.ToLower()) ||
a.Parent.Title.ToLower().Contains(sSearch.ToLower()) ||
a.TypeOfPayment.Title.ToLower().Contains(sSearch.ToLower())
)
.ToList());
MemoryCacher.Add(Constant.CategoryList, Categories, DateTimeOffset.Now.AddMinutes(Constant.CacheTime));
}
Count = Categories.Count();
// Call SortFunction to provide sorted Data, then Skip using iDisplayStart
Categories = SortFunction(iSortCol, sortOrder, Categories).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
else
{
if (MemoryCacher.GetValue(Constant.CategoryList) != null)
{
//Get the list from cache
Categories = (List <CategoryGridItemDto>)MemoryCacher.GetValue(Constant.CategoryList);
}
else
{
//get data from database
Categories = Mapper.Map <List <CategoryGridItemDto> >(_categoryRepository.GetAll().ToList());
MemoryCacher.Add(Constant.CategoryList, Categories, DateTimeOffset.Now.AddMinutes(Constant.CacheTime));
}
Count = Categories.Count();
// Call SortFunction to provide sorted Data, then Skip using iDisplayStart
Categories = SortFunction(iSortCol, sortOrder, Categories).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
var CategoriesPaged = new SysDataTablePager <CategoryGridItemDto>(Categories, Count, Count, sEcho);
return(Ok(CategoriesPaged));
}
catch (Exception ex)
{
logger.Error($"GetData() {DateTime.Now}");
logger.Error(ex);
logger.Error("==============================");
return(InternalServerError());
}
}
public SysDataTablePager filldata(FormDataCollection form)
{
string sEcho = form["draw"].ToString(); //pagina
int iDisplayStart = Convert.ToInt32(form["Start"]); //numero de objeto a esconder
int iDisplayLength = Convert.ToInt32(form["Length"]); //tamaño de la grilla
string sSearch = form["search[value]"].ToString().ToLower(); //filtro smart (global)
var movimientosList = new List <Movimiento>();
var Count = 0;
if (HttpContext.Current.Session != null)
{
try
{
Seguridadcll seguridadcll = (Seguridadcll)HttpContext.Current.Session["seguridad"];
Configuracion config = seguridadcll.Configuracion;
if (!string.IsNullOrEmpty(sSearch))
{
movimientosList = db.Movimiento.Include(m => m.producto)
.Where(m => (m.TipoMovimientoID == config.ConfigTipoMovAjEntrada || m.TipoMovimientoID == config.ConfigTipoMovEntrada) &&
m.MovimientoDisponible > 0 && m.MovimientoEstado == EstadoMovimiento.Abierto)
.ToList()
.Where(m => m.MovimientoId.ToString().Contains(sSearch) ||
(m.MovimientoFechaCrea != null && m.MovimientoFechaCrea.ToString("d").ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(m.ProductoId) && m.ProductoId.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(m.producto.ProductoDesc) && m.producto.ProductoDesc.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(m.MovimientoValor.ToString()) && m.MovimientoValor.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(m.MovimientoCantidad.ToString()) && m.MovimientoCantidad.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(m.MovimientoDisponible.ToString()) && m.MovimientoDisponible.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(m.MovimientoReservado.ToString()) && m.MovimientoReservado.ToString().ToLower().Contains(sSearch))
)
.ToList();
}
else
{
movimientosList = db.Movimiento.Include(m => m.producto)
.Where(m => (m.TipoMovimientoID == config.ConfigTipoMovAjEntrada || m.TipoMovimientoID == config.ConfigTipoMovEntrada) &&
m.MovimientoDisponible > 0 && m.MovimientoEstado == EstadoMovimiento.Abierto).ToList();
}//if (!string.IsNullOrEmpty(sSearch))
}
catch
{
movimientosList = new List <Movimiento>();
}// try
}
else
{
movimientosList = new List <Movimiento>();
}//if (HttpContext.Current.Session != null)
Count = movimientosList.Count;
movimientosList = movimientosList.OrderByDescending(m => m.MovimientoFechaCrea)
.Skip(iDisplayStart).Take(iDisplayLength).ToList();
var CustomerPaged = new SysDataTablePager();
CustomerPaged.draw = sEcho;
CustomerPaged.recordsTotal = Count;
CustomerPaged.recordsFiltered = Count;
CustomerPaged.data = movimientosList.Select(m => new { m.MovimientoId, m.ProductoId, m.producto.ProductoDesc, m.MovimientoFechaCrea, m.MovimientoValor, m.MovimientoCantidad, m.MovimientoDisponible, m.MovimientoReservado, m.MovimientoLinea });
return(CustomerPaged);
}
public SysDataTablePager Get(FormDataCollection form)
{
//NameValueCollection nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
string sEcho = form["draw"].ToString(); //pagina
int iDisplayStart = Convert.ToInt32(form["Start"]); //numero de objeto a esconder
int iDisplayLength = Convert.ToInt32(form["Length"]); //tamaño de la grilla
string sSearch = form["search[value]"].ToString().ToLower(); //filtro smart (global)
dynamic ActividadesList;
var Count = 0;
if (HttpContext.Current.Session != null)
{
Seguridadcll seguridadcll = (Seguridadcll)HttpContext.Current.Session["seguridad"];
var clienteList = seguridadcll.ClienteList.Select(c => c.ClienteID).ToArray();
try
{
if (!string.IsNullOrEmpty(sSearch))
{
ActividadesList = (from a in db.Actividad
join u in db.Usuarios on a.UsuarioIdElabora equals u.UsuarioId
join c in db.Clientes on a.ClienteID equals c.ClienteID
select new { a.ActividadId, a.ActividadFecha, a.ActividadEstado, a.ActividadTitulo, c.ClienteID, a.cliente.ClienteRazonSocial, a.UsuarioIdElabora, u.UsuarioNombre })
.ToList()
.Where(a => clienteList.Contains(a.ClienteID) == true && a.ActividadId.ToString().Contains(sSearch) ||
(a.ActividadFecha != null && a.ActividadFecha.ToString("d").ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.ActividadEstado.ToString()) && a.ActividadEstado.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.ActividadTitulo) && a.ActividadTitulo.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.ClienteRazonSocial) && a.ClienteRazonSocial.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.UsuarioIdElabora) && a.UsuarioIdElabora.ToLower().Contains(sSearch)))
.OrderByDescending(a => a.ActividadId)
.Skip(iDisplayStart).Take(iDisplayLength).ToList();
Count = ((from a in db.Actividad
join u in db.Usuarios on a.UsuarioIdElabora equals u.UsuarioId
join c in db.Clientes on a.ClienteID equals c.ClienteID
select new { a.ActividadId, a.ActividadFecha, a.ActividadEstado, a.ActividadTitulo, c.ClienteID, a.cliente.ClienteRazonSocial, a.UsuarioIdElabora })
.ToList()
.Where(a => clienteList.Contains(a.ClienteID) == true && a.ActividadId.ToString().Contains(sSearch) ||
(a.ActividadFecha != null && a.ActividadFecha.ToString("d").ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.ActividadEstado.ToString()) && a.ActividadEstado.ToString().ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.ActividadTitulo) && a.ActividadTitulo.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.ClienteRazonSocial) && a.ClienteRazonSocial.ToLower().Contains(sSearch)) ||
(!string.IsNullOrEmpty(a.UsuarioIdElabora) && a.UsuarioIdElabora.ToLower().Contains(sSearch)))
.OrderByDescending(a => a.ActividadId)
.ToList()).Count;
}
else
{
ActividadesList = (from a in db.Actividad
join u in db.Usuarios on a.UsuarioIdElabora equals u.UsuarioId
join c in db.Clientes on a.ClienteID equals c.ClienteID
select new { a.ActividadId, a.ActividadFecha, a.ActividadEstado, a.ActividadTitulo, c.ClienteID, a.cliente.ClienteRazonSocial, a.UsuarioIdElabora, u.UsuarioNombre })
.Where(a => clienteList.Contains(a.ClienteID) == true)
.OrderByDescending(a => a.ActividadId)
.Skip(iDisplayStart).Take(iDisplayLength).ToList();
Count = ((from a in db.Actividad
join u in db.Usuarios on a.UsuarioIdElabora equals u.UsuarioId
join c in db.Clientes on a.ClienteID equals c.ClienteID
select new { a.ActividadId, a.ActividadFecha, a.ActividadEstado, a.ActividadTitulo, c.ClienteID, a.cliente.ClienteRazonSocial, a.UsuarioIdElabora })
.Where(a => clienteList.Contains(a.ClienteID) == true)
.OrderByDescending(a => a.ActividadId)
.ToList()).Count;
}//if (!string.IsNullOrEmpty(sSearch))
}
catch// (Exception e)
{
ActividadesList = new List <Actividad>();
}
}
else
{
ActividadesList = new List <Actividad>();
}//if (HttpContext.Current.Session != null)
var CustomerPaged = new SysDataTablePager();
CustomerPaged.draw = sEcho;
CustomerPaged.recordsTotal = Count;
CustomerPaged.recordsFiltered = Count;
CustomerPaged.data = ActividadesList;
return(CustomerPaged);
}
public async Task <Object> GetListadoRipstAsync(long fktoken)
{
NameValueCollection nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
string sEcho = nvc["sEcho"].ToString();
string sSearch = nvc["sSearch"].ToString();
int iDisplayStart = Convert.ToInt32(nvc["iDisplayStart"]);
//this provides display length of table it can be 10,25, 50
int iDisplayLength = Convert.ToInt32(nvc["iDisplayLength"]);
//iSortCol gives your Column numebr of for which sorting is required
int iSortCol = Convert.ToInt32(nvc["iSortCol_0"]);
//provides your sort order (asc/desc)
string sortOrder = nvc["sSortDir_0"].ToString();
var result = new List <VW_Cargador_RIPS>(); //= new IList<VW_Auditoria_RIPS>();//new List<VW_Listado_Estado_Rips>();
var Cantidad = 0;
//Console.WriteLine(Convert.ToDateTime(sSearch).ToString());
//Search query when sSearch is not empty
if (sSearch != "" && sSearch != null) //If there is search query
{
result = (from VLR in bd.VW_Cargador_RIPS
where VLR.web_usuario_id == fktoken
where (
VLR.prerradicado.Value.ToString().Contains(sSearch.ToString()) ||
VLR.radicado.Value.ToString().Contains(sSearch.ToString()) ||
VLR.tipo_usuario_afiliacion.ToString().ToLower().Contains(sSearch.ToString().ToLower()) ||
VLR.categoria.ToString().ToLower().Contains(sSearch.ToString().ToLower()) ||
VLR.estado_general.ToString().ToLower().Contains(sSearch.ToString().ToLower()) ||
EntityFunctions.TruncateTime(VLR.prerradicado_fecha).ToString().Contains(sSearch.ToString()) ||
EntityFunctions.TruncateTime(VLR.periodo_inicio).ToString().Contains(sSearch.ToString()) ||
EntityFunctions.TruncateTime(VLR.periodo_fin).ToString().Contains(sSearch.ToString())
)
//group VLR by new { VLR.periodo_inicio, VLR.extranjero } into grp
//select grp.OrderBy(y => y.preradicado).FirstOrDefault()).ToList();
select VLR).ToList();
//get total value count
Cantidad = result.Count();
// Call Funcion de ordenado y proveer sorted Data, then Skip using iDisplayStart
result = SortFunction(iSortCol, sortOrder, result).Skip(iDisplayStart).Take(iDisplayLength).ToList();
/*orderby VLR.preradicado ascending
* select VLR).ToList();*/
}
else //Si no hay valores a buscar
{
result = (from VLR in bd.VW_Cargador_RIPS
where VLR.web_usuario_id == fktoken
orderby VLR.periodo_inicio descending
select VLR
).ToList();
//get total value count
Cantidad = result.Count();
result = SortFunction(iSortCol, sortOrder, result).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
//se Creo un modelo para datatable paging and sending data & enter all the required values
var VWListadoPaged = new SysDataTablePager <VW_Cargador_RIPS>(result, Cantidad, Cantidad, sEcho);
return(VWListadoPaged);
}
public async Task <Object> GetListadoRipstAsync(long fktoken)
{
NameValueCollection nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
string sEcho = nvc["sEcho"].ToString();
string sSearch = nvc["sSearch"].ToString();
int iDisplayStart = Convert.ToInt32(nvc["iDisplayStart"]);
//this provides display length of table it can be 10,25, 50
int iDisplayLength = Convert.ToInt32(nvc["iDisplayLength"]);
//iSortCol gives your Column numebr of for which sorting is required
int iSortCol = Convert.ToInt32(nvc["iSortCol_0"]);
//provides your sort order (asc/desc)
string sortOrder = nvc["sSortDir_0"].ToString();
var result = new List <Web_Novedad_list>(); //= new IList<VW_Auditoria_RIPS>();//new List<VW_Listado_Estado_Rips>();
var Cantidad = 0;
//Console.WriteLine(Convert.ToDateTime(sSearch).ToString());
//Search query when sSearch is not empty
if (sSearch != "" && sSearch != null) //If there is search query
{
result = (from VLR in db.Web_Novedad
where VLR.FK_web_novedad_web_usuario == fktoken
where (
VLR.numero_registro.ToString().Contains(sSearch.ToString()) ||
VLR.FK_web_novedad_estado_rips.ToString().ToLower().Contains(sSearch.ToString().ToLower()) ||
VLR.periodofechainicio.ToString().Contains(sSearch.ToString()) ||
VLR.periodofechafin.ToString().Contains(sSearch.ToString()) ||
VLR.fecha_modificacion.ToString().Contains(sSearch.ToString())
)
select new Web_Novedad_list
{
numero_registro = VLR.numero_registro,
fechaInicio = VLR.periodofechainicio,
fechaFin = VLR.periodofechafin,
registro_fecha = VLR.fecha_modificacion,
motivo = VLR.motivo_novedad,
tipo_novedad = VLR.Web_Tipo_Novedad.nombre,
estado_general = VLR.Estado_RIPS.nombre,
estado_general_numero = VLR.Estado_RIPS.estado_rips_id,
}).ToList();
//get total value count
Cantidad = result.Count();
// Call Funcion de ordenado y proveer sorted Data, then Skip using iDisplayStart
result = SortFunction(iSortCol, sortOrder, result).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
else //Si no hay valores a buscar
{
result = (from VLR in db.Web_Novedad
where VLR.FK_web_novedad_web_usuario == fktoken
orderby VLR.periodofechainicio descending
select new Web_Novedad_list
{
numero_registro = VLR.numero_registro,
fechaInicio = VLR.periodofechainicio,
fechaFin = VLR.periodofechafin,
motivo = VLR.motivo_novedad,
tipo_novedad = VLR.Web_Tipo_Novedad.nombre,
estado_general = VLR.Estado_RIPS.nombre,
estado_general_numero = VLR.Estado_RIPS.estado_rips_id,
registro_fecha = VLR.fecha_modificacion
}).ToList();
//get total value count
Cantidad = result.Count();
result = SortFunction(iSortCol, sortOrder, result).Skip(iDisplayStart).Take(iDisplayLength).ToList();
}
//se Creo un modelo para datatable paging and sending data & enter all the required values
var VWListadoPaged = new SysDataTablePager <Web_Novedad_list>(result, Cantidad, Cantidad, sEcho);
return(VWListadoPaged);
}
