private void ObtenerPlaya(bool forzarBD)
{
if (ViewState["lista"] == null || forzarBD)
{
PlayaBC zona = new PlayaBC();
DataTable dt = zona.ObtenerXSite(int.Parse(ddl_site.SelectedValue));
ViewState["lista"] = dt;
ViewState.Remove("filtrados");
}
DataView dw;
if (ViewState["filtrados"] == null)
{
dw = new DataView((DataTable)ViewState["lista"]);
}
else
{
dw = new DataView((DataTable)ViewState["filtrados"]);
}
if (ViewState["sortExpresion"] != null && ViewState["sortExpresion"].ToString() != "")
{
dw.Sort = (String)ViewState["sortExpresion"];
}
this.gv_listar.DataSource = dw;
this.gv_listar.DataBind();
}
private void ObtenerDestinos(bool forzarBD)
{
PlayaBC p = new PlayaBC();
DataTable playas;
if (ViewState["playas"] == null || forzarBD)
{
playas = p.ObtenerXSite(int.Parse(hf_idSite.Value));
ViewState["playas"] = playas;
}
playas = (DataTable)ViewState["playas"];
DataView playasNS = playas.AsDataView();
string filtros = "";
filtros += "ZONA_ID = " + ddl_destinoZona.SelectedValue;
if (!string.IsNullOrEmpty(hf_seleccionados.Value))
{
filtros += " AND PLAY_ID NOT IN (" + hf_seleccionados.Value + ")";
}
playasNS.RowFilter = filtros;
ViewState["nosel"] = playasNS.ToTable();
gv_noSeleccionados.DataSource = playasNS.ToTable();
gv_noSeleccionados.DataBind();
}
private void ObtenerDestinos(bool forzarBD)
{
PlayaBC p = new PlayaBC();
DataTable playas;
if (this.ViewState["playas"] == null || forzarBD)
{
playas = p.ObtenerXSite(Convert.ToInt32(this.ddl_destinoSite.SelectedValue));
this.ViewState["playas"] = playas;
}
playas = (DataTable)this.ViewState["playas"];
//DataView playasS = playas.AsDataView();
//playasS.RowFilter = "ID IN (" + hf_seleccionados.Value + ")";
//gv_seleccionados.DataSource = (DataTable)ViewState["seleccionados"];
//gv_seleccionados.DataBind();
DataView playasNS = playas.AsDataView();
string filtros = "";
filtros += string.Format("ZONA_ID = {0}", this.ddl_destinoZona.SelectedValue);
if (!string.IsNullOrEmpty(this.hf_seleccionados.Value))
{
filtros += string.Format(" AND PLAY_ID NOT IN ({0})", this.hf_seleccionados.Value);
}
playasNS.RowFilter = filtros;
this.ViewState["nosel"] = playasNS.ToTable();
this.gv_noSeleccionados.DataSource = playasNS.ToTable();
this.gv_noSeleccionados.DataBind();
}
public void Playa_Todos(System.Web.UI.WebControls.DropDownList ddl, int zona_id = 0, int site_id = 0)
{
UtilsWeb u = new UtilsWeb();
DataTable dt;
if (zona_id != 0)
{
dt = p.ObtenerXZona(zona_id);
}
else if (site_id != 0)
{
dt = p.ObtenerXSite(site_id);
}
else
{
dt = p.ObtenerTodas();
}
DataView dw = dt.AsDataView();
dw.Sort = "DESCRIPCION ASC";
u.CargaDropTodos(ddl, "ID", "DESCRIPCION", dw.ToTable());
}
private void ObtenerPlayas(bool forzarBD)
{
if (this.ViewState["playas"] == null || forzarBD)
{
PlayaBC p = new PlayaBC();
DataTable playas = p.ObtenerXSite(Convert.ToInt32(this.hf_idSite.Value));
this.ViewState["playas"] = playas;
}
DataView playasNS = new DataView((DataTable)this.ViewState["playas"]);
string filtro = string.Format("ZONA_ID = {0}", this.ddl_asignarZona.SelectedValue);
if (!string.IsNullOrEmpty(hf_seleccionados.Value))
{
filtro += string.Format(" AND PLAY_ID NOT IN ({0})", hf_seleccionados.Value);
}
playasNS.RowFilter = filtro;
this.ViewState["nosel"] = playasNS.ToTable();
this.gv_noSeleccionados.DataSource = this.ViewState["nosel"];
this.gv_noSeleccionados.DataBind();
ObtenerSeleccionados(false);
}
