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