public static IList<vEstContratos> getActas(string cod_con)
{
GCRegActasBL gcRa = new GCRegActasBL();
IList<vEstContratos> lst = gcRa.GetActas(cod_con);
return lst;
}
public void ProcessRequest(HttpContext context)
{
JavaScriptSerializer ser = new JavaScriptSerializer();//Retorno
int iDisplayLength = Convert.ToInt32(HttpContext.Current.Request["iDisplayLength"]);
string codcon = HttpContext.Current.Request["codcon"];
int iDisplayStart = Convert.ToInt32(HttpContext.Current.Request["iDisplayStart"]);
int iEcho = Convert.ToInt32(HttpContext.Current.Request["sEcho"]);
int iSortingCols = Convert.ToInt32(HttpContext.Current.Request["iSortingCols"]);
int iSortCol = Convert.ToInt32(HttpContext.Current.Request["iSortCol_0"]);
int iColumns = Convert.ToInt32(HttpContext.Current.Request["iColumns"]);
string searchString = HttpContext.Current.Request["sSearch"];
string sSortDir = HttpContext.Current.Request["sSortDir_0"];
GCRegActasBL gcRa = new GCRegActasBL();
IEnumerable<vEstContratos> lst = gcRa.GetActas(codcon);
//Datos Totales de la Consulta
var list = new FormatedList();
list.sEcho = iEcho;
list.iTotalRecords = lst.Count();
if(iDisplayLength>-1)
lst = lst.Skip(iDisplayStart).Take(iDisplayLength);
if (!String.IsNullOrEmpty(searchString))
{
//Se puede escoger las colomnas
lst=lst.Where(p => p.NOM_EST.Contains(searchString));
}
// iSortCol_0 // 0=cust Ac 1=cust name 2=rep
// iSortDir_0 // asc or desc...
if (iSortingCols == 1)
{
if (sSortDir == "asc" && iSortCol == 0) { lst = lst.OrderBy(p => p.ID); }
if (sSortDir == "desc" && iSortCol == 0) { lst = lst.OrderByDescending(p => p.ID); }
if (sSortDir == "asc" && iSortCol == 1) { lst = lst.OrderBy(p => p.NRO_DOC); }
if (sSortDir == "desc" && iSortCol == 1) { lst = lst.OrderByDescending(p => p.NRO_DOC); }
if (sSortDir == "asc" && iSortCol == 2) { lst = lst.OrderBy(p => p.sFEC_ENT); }
if (sSortDir == "desc" && iSortCol == 2) { lst = lst.OrderByDescending(p => p.sFEC_ENT); }
}
//string cod_con)
List<List<string>> lightList = new List<List<string>>();
int index=0;
foreach (vEstContratos obj in lst)
{
var item = new List<string>();
item.Add(obj.ID.ToString());
item.Add(obj.NOM_EST.ToString());
item.Add(obj.NRO_DOC.ToString());
item.Add(obj.sFEC_ENT.ToString());
item.Add(obj.NVISITAS.ToString());
item.Add(obj.POR_EJE_FIS.ToString());
item.Add(obj.VAL_PAGO.ToString());
var Editar = "<input id='Editar' class='button_editar' type='button' />";
item.Add(Editar);
var Anular = (index == lst.Count() - 1) ? "<input id='Anular' class='button_anular' type='button' />" : "";
index = index + 1;
item.Add(Anular);
lightList.Add(item);
}
list.iTotalDisplayRecords = lst.Count();
list.aaData = lightList;
var json = Newtonsoft.Json.JsonConvert.SerializeObject(list);
//context.Response.ContentType = "text/plain";
context.Response.ContentType = ("text/html");
context.Response.BufferOutput = true;
//ser.Serialize(
context.Response.Write(json);
context.Response.End();
}
