public List <AtributoBE> Get_Atributo_Producto(Int32 id_producto)
{
String cadena;
String sql = "Atributo_Get_Producto";
SqlParameter[] arrParameters = new SqlParameter[1];
AtributoBE objAtributoBE = null;
List <AtributoBE> lstAtributoBE = null;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@id_producto", id_producto);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (lstAtributoBE == null)
{
lstAtributoBE = new List <AtributoBE>();
}
objAtributoBE = new AtributoBE();
objAtributoBE.Descripcion = dr["descripcion"] != DBNull.Value ? dr["descripcion"].ToString() : null;
objAtributoBE.Id_Atributo = Convert.ToInt32(dr["id_atributo"]);
objAtributoBE.Nombre = dr["nombre"].ToString();
lstAtributoBE.Add(objAtributoBE);
}
}
}
}
return(lstAtributoBE);
}
catch (Exception)
{
throw;
}
}
public void Update_Atributo(AtributoBE objAtributoBE)
{
try
{
objAtributoDALC.Update_Atributo(objAtributoBE);
}
catch (Exception)
{
throw;
}
}
public int Insert_Atributo(AtributoBE objAtributoBE)
{
try
{
return(objAtributoDALC.Insert_Atributo(objAtributoBE));
}
catch (Exception)
{
throw;
}
}
public List <AtributoBE> Select_Atributo()
{
String cadena;
String sql = "Atributo_Select";
AtributoBE objAtributoBE = null;
List <AtributoBE> lstAtributoBE = null;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (lstAtributoBE == null)
{
lstAtributoBE = new List <AtributoBE>();
}
objAtributoBE = new AtributoBE();
objAtributoBE.Descripcion = dr["descripcion"] != DBNull.Value ? dr["descripcion"].ToString() : null;
objAtributoBE.Id_Atributo = Convert.ToInt32(dr["id_atributo"]);
objAtributoBE.Nombre = dr["nombre"].ToString();
lstAtributoBE.Add(objAtributoBE);
}
}
}
}
return(lstAtributoBE);
}
catch (Exception)
{
throw;
}
}
public int Insert_Atributo(AtributoBE objAtributoBE)
{
String cadena;
String sql = "Atributo_Insert";
SqlParameter[] arrParameters = new SqlParameter[2];
int codigo = 0;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@descripcion", objAtributoBE.Descripcion);
arrParameters[1] = new SqlParameter("@nombre", objAtributoBE.Nombre);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
codigo = Convert.ToInt32(cmd.ExecuteScalar());
}
}
return(codigo);
}
catch (Exception)
{
throw;
}
}
public void Update_Atributo(AtributoBE objAtributoBE)
{
String cadena;
String sql = "Atributo_Update";
SqlParameter[] arrParameters = new SqlParameter[3];
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@descripcion", objAtributoBE.Descripcion);
arrParameters[1] = new SqlParameter("@id_atributo", objAtributoBE.Id_Atributo);
arrParameters[2] = new SqlParameter("@nombre", objAtributoBE.Nombre);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception)
{
throw;
}
}
protected void gvAtributos_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
#region Nuevo
if (e.CommandName.Equals("Nuevo"))
{
TextBox txtNewNombre = (TextBox)gvAtributos.FooterRow.FindControl("txtNewNombre");
TextBox txtNewDescripcion = (TextBox)gvAtributos.FooterRow.FindControl("txtNewDescripcion");
AtributoBE objAtributoBE = new AtributoBE();
objAtributoBE.Nombre = txtNewNombre.Text;
objAtributoBE.Descripcion = txtNewDescripcion.Text;
AtributoBC objAtributoBC = new AtributoBC();
objAtributoBC.Insert_Atributo(objAtributoBE);
LlenarAtributos();
Tools.Unload(GetType(), this);
}
#endregion
#region Editar
else if (e.CommandName.Equals("Editar"))
{
GridViewRow gvRow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
gvAtributos.EditIndex = gvRow.RowIndex;
LlenarAtributos();
}
#endregion
#region Cancelar
else if (e.CommandName.Equals("Cancelar"))
{
gvAtributos.EditIndex = -1;
LlenarAtributos();
}
#endregion
#region Actualizar
else if (e.CommandName.Equals("Actualizar"))
{
GridViewRow gvRow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
TextBox txtNombre = (TextBox)gvRow.FindControl("txtNombre");
TextBox txtDescripcion = (TextBox)gvRow.FindControl("txtDescripcion");
AtributoBE objAtributoBE = new AtributoBE();
objAtributoBE.Id_Atributo = Convert.ToInt32(e.CommandArgument);
objAtributoBE.Nombre = txtNombre.Text;
objAtributoBE.Descripcion = txtDescripcion.Text;
AtributoBC objAtributoBC = new AtributoBC();
objAtributoBC.Update_Atributo(objAtributoBE);
gvAtributos.EditIndex = -1;
LlenarAtributos();
Tools.Unload(GetType(), this);
}
#endregion
#region Eliminar
else if (e.CommandName.Equals("Eliminar"))
{
AtributoBC objAtributoBC = new AtributoBC();
objAtributoBC.Delete_Atributo(Convert.ToInt32(e.CommandArgument));
LlenarAtributos();
Tools.Unload(GetType(), this);
}
#endregion
}
catch (Exception ex)
{
Tools.Error(GetType(), this, ex);
}
}
