protected void TodosArticulos_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
TodosArticulos.PageIndex = e.NewPageIndex;
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
}
public void RefrescarGrillaMarca(string marca)
{
List <ArticuloxProveedorDTO> ListaGrillaDTO = null;
ListaGrillaDTO = ControlArticulo.BuscarXMarca(marca);
if (ListaGrillaDTO.Count != 0)
{
dt = new DataTable();
dt.Columns.Add(new DataColumn("articuloid", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombre", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("descripcion", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("marca", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("precioactual", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("cantidad", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("stockmin", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("costo", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("nombrefantasia", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("estado", System.Type.GetType("System.String")));
foreach (ArticuloxProveedorDTO Auxi in ListaGrillaDTO)
{
dt.Rows.Add(Auxi.Articuloid.Articuloid, Auxi.Articuloid.Nombre, Auxi.Articuloid.Descripcion, Auxi.Articuloid.Marca, Auxi.Articuloid.Precioactual.ToString("#,##0.00"), Auxi.Articuloid.Cantidad, Auxi.Articuloid.Stockmin, Auxi.Costo.ToString("#,##0.00"), Auxi.Proveedorid.Nombrefantasia, Auxi.Articuloid.Estado);
}
//TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
TodosArticulos.Visible = true;
PanelGrilla.Visible = true;
PanelPopUp.Attributes["display"] = "none";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login"] == null)
{
Response.Redirect("Login.aspx");
}
ControlArticulo = (C_Articulo)Session["ControlArticulo"];
ControlConfig = (C_Configuracion)Session["ControlConfig"];
if (!IsPostBack)
{
dt = new DataTable();
dt2 = new DataTable();
TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
GridCritico.PageSize = ControlConfig.DevolverNroMaxPaginacion();
GridCritico.DataSource = dt2;
GridCritico.DataBind();
GridCritico.DataSource = ListaDTO;
GridCritico.DataBind();
TodosArticulos.DataSource = ListaDTO;
TodosArticulos.DataBind();
RefrescarArticulos();
RefrescarCritico();
}
RefrescarArticulos2(TxtFiltro.Text);
}
protected void TxtFiltro_TextChanged(object sender, EventArgs e)
{
if (!_isRefresh)
{
TodosArticulos.DataSource = ListaDTO;
TodosArticulos.DataBind();
if (ControlArticulo.PruebaFiltrar(TxtFiltro.Text).Count != 0)
{
dt = new DataTable();
dt.Columns.Add(new DataColumn("articuloid", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombre", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("descripcion", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("marca", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("cantidad", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombrefantasia", System.Type.GetType("System.String")));
foreach (ArticuloxProveedorDTO Auxi in ControlArticulo.PruebaFiltrar(TxtFiltro.Text))
{
dt.Rows.Add(Auxi.Articuloid.Articuloid, Auxi.Articuloid.Nombre, Auxi.Articuloid.Descripcion, Auxi.Articuloid.Marca, Auxi.Articuloid.Cantidad, Auxi.Proveedorid.Nombrefantasia);
}
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
}
else
{
RefrescarArticulos();
}
}
else
{
Response.Redirect("Stock.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login"] == null)
{
Response.Redirect("Login.aspx");
}
ControlArticulo = (C_Articulo)Session["ControlArticulo"];
ControlProveedor = (C_Proveedor)Session["ControlProveedor"];
ControlConfig = (C_Configuracion)Session["ControlConfig"];
ControlArticuloxProveedor = (C_ArticuloxProveedor)Session["ControlArticuloxProveedor"];
if (!IsPostBack)
{
ArtId = 0;
CodBuscado = 0;
MarcaST = "";
NombreST = "";
DdlProveedor.DataSource = null;
DdlProveedor.DataValueField = "proveedorid";
DdlProveedor.DataTextField = "nombrefantasia";
DdlProveedor.DataSource = ControlProveedor.Listar();
DdlProveedor.DataBind();
//RadioSelecionado();
TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
//RefrescarGrillaNombre(NombreST);
//RefrescarGrillaMarca(MarcaST);
//RefrescarGrillaCod(CodBuscado);
}
RadioSelecionado();
RefrescarGrillaNombre(NombreST);
RefrescarGrillaMarca(MarcaST);
RefrescarGrillaCod(CodBuscado);
}
public void RefrescarGrillaCod(int id)
{
ArticuloxProveedorDTO AXPAux = null;
AXPAux = ControlArticuloxProveedor.ListaEspecial(Convert.ToInt32(id));
if (AXPAux != null)
{
//dt = new DataTable();
dt.Columns.Add(new DataColumn("articuloid", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombre", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("descripcion", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("marca", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("precioactual", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("cantidad", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("stockmin", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("costo", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("nombrefantasia", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("estado", System.Type.GetType("System.String")));
dt.Rows.Add(AXPAux.Articuloid.Articuloid, AXPAux.Articuloid.Nombre, AXPAux.Articuloid.Descripcion, AXPAux.Articuloid.Marca, AXPAux.Articuloid.Precioactual, AXPAux.Articuloid.Cantidad, AXPAux.Articuloid.Stockmin, AXPAux.Costo, AXPAux.Proveedorid.Nombrefantasia, AXPAux.Articuloid.Estado);
//TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
TodosArticulos.Visible = true;
PanelGrilla.Visible = true;
PanelPopUp.Attributes["display"] = "none";
}
}
protected void TodosArticulos_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
TodosArticulos.PageIndex = e.NewPageIndex;
RefrescarGrillaNombre(NombreST);
RefrescarGrillaMarca(MarcaST);
RefrescarGrillaCod(CodBuscado);
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login"] == null)
{
Response.Redirect("Login.aspx");
}
ControlArticulo = (C_Articulo)Session["ControlArticulo"];
ControlConfig = (C_Configuracion)Session["ControlConfig"];
ListaDTO = ControlArticulo.Listar();
TodosArticulos.DataSource = Aux;
TodosArticulos.DataBind();
if (ListaDTO.Count != 0)
{
dt = new DataTable();
dt.Columns.Add(new DataColumn("articuloid", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombre", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("descripcion", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("marca", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("precioactual", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("cantidad", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("stockmin", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("costo", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("nombrefantasia", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("estado", System.Type.GetType("System.String")));
foreach (ArticuloxProveedorDTO Auxi in ListaDTO)
{
dt.Rows.Add(Auxi.Articuloid.Articuloid, Auxi.Articuloid.Nombre, Auxi.Articuloid.Descripcion, Auxi.Articuloid.Marca, Auxi.Articuloid.Precioactual.ToString("#,##0.00"), Auxi.Articuloid.Cantidad, Auxi.Articuloid.Stockmin, Auxi.Costo.ToString("#,##0.00"), Auxi.Proveedorid.Nombrefantasia, Auxi.Articuloid.Estado);
}
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "erroralert();", true);
TodosArticulos.DataSource = Aux;
TodosArticulos.DataBind();
BtnConvtExcel.Enabled = false;
BtnConvtPDF.Enabled = false;
BtnConvtWord.Enabled = false;
}
if (!IsPostBack)
{
TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
}
}
protected void BtnBuscarMarca_Click(object sender, EventArgs e)
{
List <ArticuloxProveedorDTO> ListaDTO = new List <ArticuloxProveedorDTO>();
if (IsValid)
{
MarcaST = TxtBuscarMarca.Text;
if (RadioButtonListBusqueda.SelectedValue == "marca")
{
ListaDTO = ControlArticulo.BuscarXMarca(TxtBuscarMarca.Text.ToLower());
if (ListaDTO.Count != 0)
{
dt = new DataTable();
dt.Columns.Add(new DataColumn("articuloid", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombre", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("descripcion", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("marca", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("precioactual", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("cantidad", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("stockmin", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("costo", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("nombrefantasia", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("estado", System.Type.GetType("System.String")));
foreach (ArticuloxProveedorDTO Auxi in ListaDTO)
{
dt.Rows.Add(Auxi.Articuloid.Articuloid, Auxi.Articuloid.Nombre, Auxi.Articuloid.Descripcion, Auxi.Articuloid.Marca, Auxi.Articuloid.Precioactual.ToString("#,##0.00"), Auxi.Articuloid.Cantidad, Auxi.Articuloid.Stockmin, Auxi.Costo.ToString("#,##0.00"), Auxi.Proveedorid.Nombrefantasia, Auxi.Articuloid.Estado);
}
//TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
TodosArticulos.Visible = true;
PanelGrilla.Visible = true;
PanelPopUp.Attributes["display"] = "none";
}
else
{
TodosArticulos.Visible = false;
PanelGrilla.Visible = false;
PanelPopUp.Attributes["display"] = "none";
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "erroralert();", true);
}
}
}
}
public void ConvertExcel()
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=ListaArticuloExcel.xls");
Response.Charset = "";
Response.ContentType = "application/ms-excel ";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
TodosArticulos.AllowPaging = false;
TodosArticulos.DataBind();
TodosArticulos.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
public void RefrescarArticulos()
{
if (ControlArticulo.ListarActivos().Count != 0)
{
dt = new DataTable();
dt.Columns.Add(new DataColumn("articuloid", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombre", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("descripcion", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("marca", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("cantidad", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombrefantasia", System.Type.GetType("System.String")));
foreach (ArticuloxProveedorDTO Auxi in ControlArticulo.Listar())
{
dt.Rows.Add(Auxi.Articuloid.Articuloid, Auxi.Articuloid.Nombre, Auxi.Articuloid.Descripcion, Auxi.Articuloid.Marca, Auxi.Articuloid.Cantidad, Auxi.Proveedorid.Nombrefantasia);
}
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (!_isRefresh)
{
if (ControlArticulo.SumarStock(Convert.ToInt32(TextCant.Text), Artid))
{
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
RefrescarArticulos2(TxtFiltro.Text);
RefrescarCritico();
TextCant.Text = "1";
}
}
else
{
TextCant.Text = "1";
Response.Redirect("Stock.aspx");
}
}
protected void BtnBuscarCod_Click(object sender, EventArgs e)
{
if (IsValid)
{
CodBuscado = Convert.ToInt32(TxtBuscarCod.Text);
if (RadioButtonListBusqueda.SelectedValue == "cod")
{
AuxDTO = ControlArticuloxProveedor.ListaEspecial(Convert.ToInt32(TxtBuscarCod.Text));
if (AuxDTO != null)
{
dt = new DataTable();
dt.Columns.Add(new DataColumn("articuloid", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("nombre", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("descripcion", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("marca", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("precioactual", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("cantidad", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("stockmin", System.Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("costo", System.Type.GetType("System.Double")));
dt.Columns.Add(new DataColumn("nombrefantasia", System.Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("estado", System.Type.GetType("System.String")));
dt.Rows.Add(AuxDTO.Articuloid.Articuloid, AuxDTO.Articuloid.Nombre, AuxDTO.Articuloid.Descripcion, AuxDTO.Articuloid.Marca, AuxDTO.Articuloid.Precioactual, AuxDTO.Articuloid.Cantidad, AuxDTO.Articuloid.Stockmin, AuxDTO.Costo, AuxDTO.Proveedorid.Nombrefantasia, AuxDTO.Articuloid.Estado);
//TodosArticulos.PageSize = ControlConfig.DevolverNroMaxPaginacion();
TodosArticulos.DataSource = dt;
TodosArticulos.DataBind();
TodosArticulos.Visible = true;
PanelGrilla.Visible = true;
PanelPopUp.Attributes["display"] = "none";
}
else
{
TodosArticulos.Visible = false;
PanelGrilla.Visible = false;
PanelPopUp.Attributes["display"] = "none";
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "erroralert();", true);
}
}
}
}
public void ConvertPDF()
{
Response.AddHeader("content-disposition", "attachment;filename=ListaArticuloPDF.pdf");
Response.ContentType = "application/pdf ";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
TodosArticulos.AllowPaging = false;
TodosArticulos.DataBind();
TodosArticulos.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document DocPDF = new Document(PageSize.A3, 10f, 10f, 10f, 0f);
PdfWriter writer = PdfWriter.GetInstance(DocPDF, Response.OutputStream);
DocPDF.Open();
XMLWorkerHelper.GetInstance().ParseXHtml(writer, DocPDF, sr);
DocPDF.Close();
Response.Write(DocPDF);
Response.End();
}
