Example #1
0
        /*
         * [HttpGet]
         * public ActionResult GetFrenteAll()
         * {
         * try
         * {
         * if (!_tokenManager.GenerateToken())
         *  return Json(null, JsonRequestBehavior.AllowGet);
         * _IFrenteApiConsumer.SetAuthHeader(_tokenManager.Token);
         * var result = _IFrenteApiConsumer.SelAll(false).Resource;
         *
         * return Json(result.OrderBy(m => m.).Select(m => new SelectListItem
         * {
         *   Text = CultureHelper.GetTraductionNew(Convert.ToString(m.Clave), "Frente", m.),
         *   Value = Convert.ToString(m.Clave)
         * }).ToArray(), JsonRequestBehavior.AllowGet);
         * }
         * catch (ServiceException ex)
         * {
         * return Json(null, JsonRequestBehavior.AllowGet);
         * }
         * }
         */
        /// <summary>
        /// Get List of Frente from Web API.
        /// </summary>
        /// <param name="draw"></param>
        /// <param name="start"></param>
        /// <param name="length"></param>
        /// <returns>Return List of Frente Entity</returns>
        public ActionResult GetFrenteList(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);
            }
            _IFrenteApiConsumer.SetAuthHeader(_tokenManager.Token);


            NameValueCollection filter = HttpUtility.ParseQueryString(param.filters);

            var configuration = new GridConfiguration()
            {
                OrderByClause = "", WhereClause = ""
            };

            if (filter != null)
            {
                configuration = GridQueryHelper.GetDataTableConfigurationNew(param, new FrentePropertyMapper());
            }

            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(FrenteAdvanceSearchModel))
                {
                    var advanceFilter =
                        (FrenteAdvanceSearchModel)Session["AdvanceSearch"];
                    configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter);
                }
                else
                {
                    Session.Remove("AdvanceSearch");
                }
            }

            FrentePropertyMapper oFrentePropertyMapper = new FrentePropertyMapper();

            if (String.IsNullOrEmpty(order))
            {
                if (sortColumn != -1)
                {
                    configuration.OrderByClause = oFrentePropertyMapper.GetPropertyName(param.columns[sortColumn].name) + " " + sortDirection;
                }
            }

            var pageSize  = iDisplayLength;
            var pageIndex = (iDisplayStart / iDisplayLength) + 1;
            var result    = _IFrenteApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource;

            if (result.Frentes == null)
            {
                result.Frentes = new List <Frente>();
            }

            return(Json(new
            {
                aaData = result.Frentes.Select(m => new FrenteGridModel
                {
                    Clave = m.Clave
                    , Descripcion = m.Descripcion
                }).ToList(),
                iTotalRecords = result.RowCount,
                iTotalDisplayRecords = result.RowCount,
                sEcho = sEcho
            }, JsonRequestBehavior.AllowGet));
        }
Example #2
0
        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;
            }

            _IFrenteApiConsumer.SetAuthHeader(_tokenManager.Token);

            NameValueCollection filter = Request.QueryString;
            var configuration          = new GridConfiguration()
            {
                OrderByClause = "", WhereClause = ""
            };

            if (filter != null)
            {
                configuration = GridQueryHelper.GetDataTableConfiguration(filter, new FrentePropertyMapper());
            }

            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 =
                    (FrenteAdvanceSearchModel)Session["AdvanceSearch"];
                configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter);
            }
            string sortDirection = "asc";

            FrentePropertyMapper oFrentePropertyMapper = new FrentePropertyMapper();

            if (Request.QueryString["sSortDir"] != null)
            {
                sortDirection = Request.QueryString["sSortDir"];
            }
            configuration.OrderByClause = oFrentePropertyMapper.GetPropertyName(iSortCol) + " " + sortDirection;
            pageSize = pageSize == 0 ? int.MaxValue : pageSize;

            var result = _IFrenteApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource;

            if (result.Frentes == null)
            {
                result.Frentes = new List <Frente>();
            }

            var data = result.Frentes.Select(m => new FrenteGridModel
            {
                Clave         = m.Clave
                , Descripcion = m.Descripcion
            }).ToList();

            switch (exportFormatType)
            {
            case ExportFormatType.PDF:
                PdfConverter.ExportToPdf(data.ToDataTable(45057, arrayColumnsVisible), "FrenteList_" + DateTime.Now.ToString());
                break;

            case ExportFormatType.EXCEL:
                ExcelConverter.ExportToExcel(data.ToDataTable(45057, arrayColumnsVisible), "FrenteList_" + DateTime.Now.ToString());
                break;

            case ExportFormatType.CSV:
                CsvConverter.ExportToCSV(data.ToDataTable(45057, arrayColumnsVisible), "FrenteList_" + DateTime.Now.ToString());
                break;
            }
        }
Example #3
0
        //[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);
            }

            _IFrenteApiConsumer.SetAuthHeader(_tokenManager.Token);

            NameValueCollection filter = Request.QueryString;

            var configuration = new GridConfiguration()
            {
                OrderByClause = "", WhereClause = ""
            };

            if (filter != null)
            {
                configuration = GridQueryHelper.GetDataTableConfiguration(filter, new FrentePropertyMapper());
            }


            if (!String.IsNullOrEmpty(where))
            {
                configuration.WhereClause = configuration.WhereClause == "" ? where : "(" + configuration.WhereClause + " AND " + where + ")";
            }
            if (Session["AdvanceSearch"] != null && pageSize != 0)
            {
                var advanceFilter =
                    (FrenteAdvanceSearchModel)Session["AdvanceSearch"];
                configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter);
            }

            string sortDirection = "asc";

            FrentePropertyMapper oFrentePropertyMapper = new FrentePropertyMapper();

            if (Request.QueryString["sSortDir"] != null)
            {
                sortDirection = Request.QueryString["sSortDir"];
            }
            configuration.OrderByClause = oFrentePropertyMapper.GetPropertyName(iSortCol) + " " + sortDirection;

            if (!String.IsNullOrEmpty(order))
            {
                configuration.OrderByClause = order;
            }
            pageSize = pageSize == 0 ? int.MaxValue : pageSize;

            var result = _IFrenteApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource;

            if (result.Frentes == null)
            {
                result.Frentes = new List <Frente>();
            }

            var data = result.Frentes.Select(m => new FrenteGridModel
            {
                Clave         = m.Clave
                , Descripcion = m.Descripcion
            }).ToList();

            return(PartialView("_Print", data));
        }