protected void btnBuscarDesdeHasta_Click(object sender, EventArgs e)
{
SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15);
IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas();
DataSet ds = new DataSet();
buenaspracticas.MovilID = Convert.ToInt32(this.ddlMoviles.SelectedValue);
string desde = this.txtFiltroDesde.Text;
string hasta = this.txtFiltroHasta.Text;
DateTime desdeDateTime = DateTime.ParseExact(desde, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime hastaDateTime = DateTime.ParseExact(hasta, "dd/MM/yyyy", CultureInfo.InvariantCulture);
buenaspracticas.FechaDesde = desdeDateTime;
buenaspracticas.FechaHasta = hastaDateTime;
ds = buenaspracticas.GetBuenasPracticasEmitidas();
this.dtgBuenasPracticasEmitidas.DataSource = ds.Tables[0];
this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0;
this.dtgBuenasPracticasEmitidas.DataBind();
Session.Remove("DsGridView");
this.Session["DsGridView"] = ds;
//this.Session["DsGridView"] = ds;
}
private void BindGrid(int currentPage)
{
SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15);
IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas();
DataSet ds = new DataSet();
ds = buenaspracticas.GetBuenasPracticasEmitidas();
this.dtgBuenasPracticasEmitidas.DataSource = ds.Tables[0];
this.dtgBuenasPracticasEmitidas.CurrentPageIndex = currentPage;
this.dtgBuenasPracticasEmitidas.DataBind();
//this.Session["DsGridView"] = ds;
}
protected void ddlMoviles_SelectedIndexChanged(object sender, EventArgs e)
{
this.txtFiltroDesde.Text = "";
this.txtFiltroHasta.Text = "";
SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15);
IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas();
DataSet ds = new DataSet();
buenaspracticas.MovilID = Convert.ToInt32(this.ddlMoviles.SelectedValue);
ds = buenaspracticas.GetBuenasPracticasEmitidas();
this.dtgBuenasPracticasEmitidas.DataSource = ds.Tables[0];
this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0;
this.dtgBuenasPracticasEmitidas.DataBind();
Session.Remove("DsGridView");
this.Session["DsGridView"] = ds;
}
protected void btnExportarExcel_Click(object sender, EventArgs e)
{
SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15, true, false);
dtgBuenasPracticasEmitidas.FooterStyle.CssClass = "TextoGrilla";
dtgBuenasPracticasEmitidas.AllowPaging = false;
int mov1 = 0;
int mov2 = 0;
int DtoCreditos = 0;
decimal DtoConAyudante = 0;
decimal DtoSinAyudante = 0;
if (Session["DsGridView"] != null)
{
DataSet ds = new DataSet();
ds = Session["DsGridView"] as DataSet;
if (ds.Tables[0].Rows.Count != 0)
{
ds.Tables[0].Columns.RemoveAt(9);
dtgBuenasPracticasEmitidas.Columns.RemoveAt(9);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
mov1 = Convert.ToInt32(ds.Tables[0].Rows[0]["movilid"]);
mov2 = Convert.ToInt32(ds.Tables[0].Rows[i]["movilid"]);
string aa = ds.Tables[0].Rows[i]["descontar"].ToString();
if (mov2 == mov1)
{
if (aa == "Si")
{
DtoCreditos += Convert.ToInt32(ds.Tables[0].Rows[i]["DtoCreditos"]);
DtoConAyudante += Convert.ToDecimal(ds.Tables[0].Rows[i]["DtoConAyudante"]);
DtoSinAyudante += Convert.ToDecimal(ds.Tables[0].Rows[i]["DtoSinAyudante"]);
}
}
}
DataRow dr = null;
dr = ds.Tables[0].NewRow();
dr["Descontar"] = "TOTAL: ";
dr["DtoCreditos"] = DtoCreditos;
dr["DtoConAyudante"] = DtoConAyudante;
dr["DtoSinAyudante"] = DtoSinAyudante;
ds.Tables[0].Rows.Add(dr);
this.dtgBuenasPracticasEmitidas.DataSource = ds;
this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0;
this.dtgBuenasPracticasEmitidas.DataBind();
new Utiles.DataGridExcelExporter(dtgBuenasPracticasEmitidas, "Buenas Practicas Emitidas").Export("BuenasPracticasExcel.xls");
Session.Remove("DsGridView");
}
}
else
{
IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas();
DataSet ds = new DataSet();
ds = buenaspracticas.GetBuenasPracticasEmitidas();
ds.Tables[0].Columns.RemoveAt(9);
dtgBuenasPracticasEmitidas.Columns.RemoveAt(9);
this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0;
this.dtgBuenasPracticasEmitidas.DataSource = ds;
this.dtgBuenasPracticasEmitidas.DataBind();
new Utiles.DataGridExcelExporter(dtgBuenasPracticasEmitidas, "Buenas Practicas Emitidas").Export("BuenasPracticasExcel.xls");
}
}