/* * [HttpGet] * public ActionResult GetIndigenaAll() * { * try * { * if (!_tokenManager.GenerateToken()) * return Json(null, JsonRequestBehavior.AllowGet); * _IIndigenaApiConsumer.SetAuthHeader(_tokenManager.Token); * var result = _IIndigenaApiConsumer.SelAll(false).Resource; * * return Json(result.OrderBy(m => m.).Select(m => new SelectListItem * { * Text = CultureHelper.GetTraductionNew(Convert.ToString(m.Clave), "Indigena", m.), * Value = Convert.ToString(m.Clave) * }).ToArray(), JsonRequestBehavior.AllowGet); * } * catch (ServiceException ex) * { * return Json(null, JsonRequestBehavior.AllowGet); * } * } */ /// <summary> /// Get List of Indigena from Web API. /// </summary> /// <param name="draw"></param> /// <param name="start"></param> /// <param name="length"></param> /// <returns>Return List of Indigena Entity</returns> public ActionResult GetIndigenaList(UrlParametersModel param) { int sEcho = param.sEcho; int iDisplayStart = param.iDisplayStart; int iDisplayLength = param.iDisplayLength; string where = param.where; string order = param.order; where = HttpUtility.UrlEncode(where); int sortColumn = -1; string sortDirection = "asc"; if (iDisplayLength == -1) { //length = TOTAL_ROWS; iDisplayLength = Int32.MaxValue; } // note: we only sort one column at a time if (param.sortColumn != null) { sortColumn = int.Parse(param.sortColumn); } if (param.sortDirection != null) { sortDirection = param.sortDirection; } if (!_tokenManager.GenerateToken()) { return(null); } _IIndigenaApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = HttpUtility.ParseQueryString(param.filters); var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetDataTableConfigurationNew(param, new IndigenaPropertyMapper()); } if (!String.IsNullOrEmpty(where)) { configuration.WhereClause = configuration.WhereClause == "" ? where : "(" + configuration.WhereClause + " AND " + where + ")"; } if (!String.IsNullOrEmpty(order)) { configuration.OrderByClause = order; } //Adding Advance Search if (param.AdvanceSearch != null && param.AdvanceSearch == true && Session["AdvanceSearch"] != null) { if (Session["AdvanceSearch"].GetType() == typeof(IndigenaAdvanceSearchModel)) { var advanceFilter = (IndigenaAdvanceSearchModel)Session["AdvanceSearch"]; configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter); } else { Session.Remove("AdvanceSearch"); } } IndigenaPropertyMapper oIndigenaPropertyMapper = new IndigenaPropertyMapper(); if (String.IsNullOrEmpty(order)) { if (sortColumn != -1) { configuration.OrderByClause = oIndigenaPropertyMapper.GetPropertyName(param.columns[sortColumn].name) + " " + sortDirection; } } var pageSize = iDisplayLength; var pageIndex = (iDisplayStart / iDisplayLength) + 1; var result = _IIndigenaApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Indigenas == null) { result.Indigenas = new List <Indigena>(); } return(Json(new { aaData = result.Indigenas.Select(m => new IndigenaGridModel { Clave = m.Clave , Descripcion = m.Descripcion }).ToList(), iTotalRecords = result.RowCount, iTotalDisplayRecords = result.RowCount, sEcho = sEcho }, JsonRequestBehavior.AllowGet)); }
public void Export(string format, int pageIndex, int pageSize, string iSortCol, string sSortDir, string where, string order, dynamic columnsVisible) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); string[] arrayColumnsVisible = null; where = HttpUtility.UrlEncode(where); if (!_tokenManager.GenerateToken()) { return; } _IIndigenaApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetDataTableConfiguration(filter, new IndigenaPropertyMapper()); } if (!String.IsNullOrEmpty(where)) { configuration.WhereClause = configuration.WhereClause == "" ? where : "(" + configuration.WhereClause + " AND " + where + ")"; } if (!String.IsNullOrEmpty(order)) { configuration.OrderByClause = order; } //Adding Advance Search if (Session["AdvanceSearch"] != null && pageSize != 0) { var advanceFilter = (IndigenaAdvanceSearchModel)Session["AdvanceSearch"]; configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter); } string sortDirection = "asc"; IndigenaPropertyMapper oIndigenaPropertyMapper = new IndigenaPropertyMapper(); if (Request.QueryString["sSortDir"] != null) { sortDirection = Request.QueryString["sSortDir"]; } configuration.OrderByClause = oIndigenaPropertyMapper.GetPropertyName(iSortCol) + " " + sortDirection; pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IIndigenaApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Indigenas == null) { result.Indigenas = new List <Indigena>(); } var data = result.Indigenas.Select(m => new IndigenaGridModel { Clave = m.Clave , Descripcion = m.Descripcion }).ToList(); switch (exportFormatType) { case ExportFormatType.PDF: PdfConverter.ExportToPdf(data.ToDataTable(44976, arrayColumnsVisible), "IndigenaList_" + DateTime.Now.ToString()); break; case ExportFormatType.EXCEL: ExcelConverter.ExportToExcel(data.ToDataTable(44976, arrayColumnsVisible), "IndigenaList_" + DateTime.Now.ToString()); break; case ExportFormatType.CSV: CsvConverter.ExportToCSV(data.ToDataTable(44976, arrayColumnsVisible), "IndigenaList_" + DateTime.Now.ToString()); break; } }
//[ObjectAuth(ObjectId = ModuleObjectId.EMPLEADOS_OBJECT, PermissionType = PermissionTypes.Export)] public ActionResult Print(string format, int pageIndex, int pageSize, string iSortCol, string sSortDir, string where, string order) { var exportFormatType = (ExportFormatType)Enum.Parse( typeof(ExportFormatType), format, true); where = HttpUtility.UrlEncode(where); if (!_tokenManager.GenerateToken()) { return(null); } _IIndigenaApiConsumer.SetAuthHeader(_tokenManager.Token); NameValueCollection filter = Request.QueryString; var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" }; if (filter != null) { configuration = GridQueryHelper.GetDataTableConfiguration(filter, new IndigenaPropertyMapper()); } if (!String.IsNullOrEmpty(where)) { configuration.WhereClause = configuration.WhereClause == "" ? where : "(" + configuration.WhereClause + " AND " + where + ")"; } if (Session["AdvanceSearch"] != null && pageSize != 0) { var advanceFilter = (IndigenaAdvanceSearchModel)Session["AdvanceSearch"]; configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter); } string sortDirection = "asc"; IndigenaPropertyMapper oIndigenaPropertyMapper = new IndigenaPropertyMapper(); if (Request.QueryString["sSortDir"] != null) { sortDirection = Request.QueryString["sSortDir"]; } configuration.OrderByClause = oIndigenaPropertyMapper.GetPropertyName(iSortCol) + " " + sortDirection; if (!String.IsNullOrEmpty(order)) { configuration.OrderByClause = order; } pageSize = pageSize == 0 ? int.MaxValue : pageSize; var result = _IIndigenaApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource; if (result.Indigenas == null) { result.Indigenas = new List <Indigena>(); } var data = result.Indigenas.Select(m => new IndigenaGridModel { Clave = m.Clave , Descripcion = m.Descripcion }).ToList(); return(PartialView("_Print", data)); }