public static PaginateClienteBean GetAllPaginate(ClienteBean item)
{
List <ClienteBean> lobj = new List <ClienteBean>();
DataTable dt = ClienteModel.GetAllPaginate(item);
int total = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
total = int.Parse(row["total"].ToString());
ClienteBean obj = new ClienteBean
{
CLI_PK = int.Parse(row["CLI_PK"].ToString()),
Razon_Social = row["Razon_Social"].ToString(),
RUC = row["RUC"].ToString(),
Direccion = row["Direccion"].ToString(),
Referencia = row["Referencia"].ToString(),
IdNegocio = Int64.Parse(row["IdNegocio"].ToString()),
Negocio = row["Negocio"].ToString(),
FlgHabilitado = row["FlgHabilitado"].ToString()
};
lobj.Add(obj);
}
}
PaginateClienteBean pobj = new PaginateClienteBean();
pobj.lstResultados = lobj;
pobj.totalrows = total;
pobj.totalPages = Utility.calculateNumberOfPages(pobj.totalrows, item.rows);
return(pobj);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["lgn_id"] == null)
{
Session.Clear();
string myScript = ConfigurationManager.AppSettings["URL_LOGIN"];
String lsScript = "parent.document.location.href = '" + myScript + "/default.aspx?acc=SES';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", lsScript, true);
}
else
{
try
{
string json = new System.IO.StreamReader(Request.InputStream).ReadToEnd();
Dictionary <string, string> dataJSON = JsonConvert.DeserializeObject <Dictionary <string, string> >(json);
String Razon_Social = dataJSON["Razon_Social"].ToString();
String RUC = dataJSON["RUC"].ToString();
String Direccion = dataJSON["Direccion"].ToString();
String Referencia = dataJSON["Referencia"].ToString();
String IdCanal = dataJSON["IdCanal"].ToString() == String.Empty?"0": dataJSON["IdCanal"].ToString();
//String IdZona = dataJSON["IdZona"].ToString() == String.Empty ? "0" : dataJSON["IdZona"].ToString();
String chkHabilitado = dataJSON["chkFlgHabilitado"].ToString();
//PAG
String pagina = dataJSON["pagina"].ToString();
String filas = dataJSON["filas"].ToString();
var item = new ClienteBean
{
Razon_Social = Razon_Social,
RUC = RUC,
Direccion = Direccion,
Referencia = Referencia,
IdNegocio = Int64.Parse(IdCanal),
FlgHabilitado = chkHabilitado,
page = int.Parse(pagina),
rows = int.Parse(filas)
};
PaginateClienteBean paginate = ClienteController.GetAllPaginate(item);
if ((Int32.Parse(pagina) > 0) && (Int32.Parse(pagina) <= paginate.totalPages))
{
Utility.ConfiguraPaginacion(this.lbTpaginaTop, this.linkPaginaTop,
this.lblTFilasTop, this.linkPaginaAnteriorTop, this.linkPaginaSiguienteTop,
paginate.totalPages.ToString(), pagina, paginate.totalrows.ToString(),
ddlMostrarTop, filas);
Utility.ConfiguraPaginacion(this.lbTpaginaBooton, this.linkPaginaBooton,
this.lblTFilasBooton, this.linkPaginaAnteriorBooton, this.linkPaginaSiguienteBooton,
paginate.totalPages.ToString(), pagina, paginate.totalrows.ToString(),
ddlMostrarBooton, filas);
List <ClienteBean> lst = new List <ClienteBean>();
lst = paginate.lstResultados;
grdMant.DataSource = lst;
grdMant.DataBind();
grdMant.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
String htmlNoData = "<div class='gridNoData'><div class='col-sm-12 form-group'>" +
"<img src='../../images/alert/ico_alert.png' style='float: left;height: 32px;'>" +
"<p style='float: left;line-height: 32px;margin-left: 10px!important;'>No se encontraron datos para mostrar</p>" +
"</p></div>";
this.divGridView.InnerHtml = htmlNoData;
this.divGridViewPagintatorTop.Visible = false;
this.divGridViewPagintatorBooton.Visible = false;
}
}
catch (Exception ex)
{
LogHelper.LogException(ex, "Error :" + this);
//string myScript = "parent.document.location.href = '../../default.aspx?acc=EXT';";
String htmlNoData = "<div class='col-sm-12 form-group'>" +
"<img src='../../images/icons/grid/ico_grid_nodata.png' style='float: left;height: 32px;'/>" +
"<p style='float: left;line-height: 32px;margin-left: 10px!important;'>No se encontraron datos para mostrar</p>" +
"</div>";
this.divGridView.InnerHtml = htmlNoData;
this.divGridViewPagintatorBooton.Visible = false;
this.divGridViewPagintatorTop.Visible = false;
string myScript = "addnotify('notify', \"" + ex.Message + "\", 'registeruser');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", myScript, true);
}
}
}