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;
_IPadecimientosApiConsumer.SetAuthHeader(_tokenManager.Token);
NameValueCollection filter = Request.QueryString;
var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" };
if (filter != null)
configuration = GridQueryHelper.GetDataTableConfiguration(filter, new PadecimientosPropertyMapper());
if (!String.IsNullOrEmpty(where))
{
configuration.WhereClause = configuration.WhereClause == "" ? where : "(" + configuration.WhereClause + " AND " + where + ")";
}
if (Session["AdvanceSearch"] != null && pageSize != 0)
{
var advanceFilter =
(PadecimientosAdvanceSearchModel)Session["AdvanceSearch"];
configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter);
}
string sortDirection = "asc";
PadecimientosPropertyMapper oPadecimientosPropertyMapper = new PadecimientosPropertyMapper();
if (Request.QueryString["sSortDir"] != null)
{
sortDirection = Request.QueryString["sSortDir"];
}
configuration.OrderByClause = oPadecimientosPropertyMapper.GetPropertyName(iSortCol) + " " + sortDirection;
if (!String.IsNullOrEmpty(order))
{
configuration.OrderByClause = order;
}
pageSize = pageSize == 0 ? int.MaxValue : pageSize;
var result = _IPadecimientosApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource;
if (result.Padecimientoss == null)
result.Padecimientoss = new List<Padecimientos>();
var data = result.Padecimientoss.Select(m => new PadecimientosGridModel
{
Clave = m.Clave
,Descripcion = m.Descripcion
}).ToList();
return PartialView("_Print", data);
}
/*
[HttpGet]
public ActionResult GetPadecimientosAll()
{
try
{
if (!_tokenManager.GenerateToken())
return Json(null, JsonRequestBehavior.AllowGet);
_IPadecimientosApiConsumer.SetAuthHeader(_tokenManager.Token);
var result = _IPadecimientosApiConsumer.SelAll(false).Resource;
return Json(result.OrderBy(m => m.).Select(m => new SelectListItem
{
Text = CultureHelper.GetTraductionNew(Convert.ToString(m.Clave), "Padecimientos", m.),
Value = Convert.ToString(m.Clave)
}).ToArray(), JsonRequestBehavior.AllowGet);
}
catch (ServiceException ex)
{
return Json(null, JsonRequestBehavior.AllowGet);
}
}
*/
/// <summary>
/// Get List of Padecimientos from Web API.
/// </summary>
/// <param name="draw"></param>
/// <param name="start"></param>
/// <param name="length"></param>
/// <returns>Return List of Padecimientos Entity</returns>
public ActionResult GetPadecimientosList(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;
_IPadecimientosApiConsumer.SetAuthHeader(_tokenManager.Token);
NameValueCollection filter = HttpUtility.ParseQueryString(param.filters);
var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" };
if (filter != null)
configuration = GridQueryHelper.GetDataTableConfigurationNew(param, new PadecimientosPropertyMapper());
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(PadecimientosAdvanceSearchModel))
{
var advanceFilter =
(PadecimientosAdvanceSearchModel)Session["AdvanceSearch"];
configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter);
}
else
{
Session.Remove("AdvanceSearch");
}
}
PadecimientosPropertyMapper oPadecimientosPropertyMapper = new PadecimientosPropertyMapper();
if (String.IsNullOrEmpty(order))
{
if (sortColumn != -1)
configuration.OrderByClause = oPadecimientosPropertyMapper.GetPropertyName(param.columns[sortColumn].name) + " " + sortDirection;
}
var pageSize = iDisplayLength;
var pageIndex = (iDisplayStart / iDisplayLength) + 1;
var result = _IPadecimientosApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource;
if (result.Padecimientoss == null)
result.Padecimientoss = new List<Padecimientos>();
return Json(new
{
aaData = result.Padecimientoss.Select(m => new PadecimientosGridModel
{
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 = ((string[])columnsVisible)[0].ToString().Split(',');
where = HttpUtility.UrlEncode(where);
if (!_tokenManager.GenerateToken())
return;
_IPadecimientosApiConsumer.SetAuthHeader(_tokenManager.Token);
NameValueCollection filter = Request.QueryString;
var configuration = new GridConfiguration() { OrderByClause = "", WhereClause = "" };
if (filter != null)
configuration = GridQueryHelper.GetDataTableConfiguration(filter, new PadecimientosPropertyMapper());
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 =
(PadecimientosAdvanceSearchModel)Session["AdvanceSearch"];
configuration.WhereClause = configuration.WhereClause == "" ? GetAdvanceFilter(advanceFilter) : configuration.WhereClause + " AND " + GetAdvanceFilter(advanceFilter);
}
string sortDirection = "asc";
PadecimientosPropertyMapper oPadecimientosPropertyMapper = new PadecimientosPropertyMapper();
if (Request.QueryString["sSortDir"] != null)
{
sortDirection = Request.QueryString["sSortDir"];
}
configuration.OrderByClause = oPadecimientosPropertyMapper.GetPropertyName(iSortCol) + " " + sortDirection;
pageSize = pageSize == 0 ? int.MaxValue : pageSize;
var result = _IPadecimientosApiConsumer.ListaSelAll((pageIndex * pageSize) - pageSize + 1, pageSize + ((pageIndex * pageSize) - pageSize), configuration.WhereClause, configuration.OrderByClause ?? "").Resource;
if (result.Padecimientoss == null)
result.Padecimientoss = new List<Padecimientos>();
var data = result.Padecimientoss.Select(m => new PadecimientosGridModel
{
Clave = m.Clave
,Descripcion = m.Descripcion
}).ToList();
switch (exportFormatType)
{
case ExportFormatType.PDF:
PdfConverter.ExportToPdf(data.ToDataTable(44315, arrayColumnsVisible), "PadecimientosList_" + DateTime.Now.ToString());
break;
case ExportFormatType.EXCEL:
ExcelConverter.ExportToExcel(data.ToDataTable(44315, arrayColumnsVisible), "PadecimientosList_" + DateTime.Now.ToString());
break;
case ExportFormatType.CSV:
CsvConverter.ExportToCSV(data.ToDataTable(44315, arrayColumnsVisible), "PadecimientosList_" + DateTime.Now.ToString());
break;
}
}