public int UpdateArticulo(ArticuloVO vo)
{
string resp = string.Empty;
try
{
string query = "sp_Articulo_actualizar";
MySqlCommand comando = this.Conexion.CreateCommand();
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = query;
comando.Parameters.AddWithValue("p_descripcion", vo.Descripcion);
comando.Parameters.AddWithValue("p_modelo", vo.Modelo);
comando.Parameters.AddWithValue("p_precio", vo.Precio);
comando.Parameters.AddWithValue("p_existencia", vo.Existencia);
comando.Parameters.AddWithValue("p_clave", vo.Clave);
// Se toma el valor devuelto
resp = comando.ExecuteScalar().ToString();
}
catch (Exception Ex)
{
throw Ex;
}
return(int.Parse(resp));
}
public List <ArticuloVO> GetArticuloList(BaseGridVO filtro)
{
List <ArticuloVO> lista = new List <ArticuloVO>();
MySqlDataReader dr = null;
try
{
string query = "sp_Articulos_select_lista";
MySqlCommand comando = this.Conexion.CreateCommand();
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = query;
comando.Parameters.Add("p_campobusqueda", MySqlDbType.VarChar).Value = filtro.campobusqueda ?? string.Empty;
comando.Parameters.Add("p_valorbusqueda", MySqlDbType.VarChar).Value = filtro.valorbusqueda ?? string.Empty;
comando.Parameters.Add("p_numeropagina", MySqlDbType.Int32).Value = filtro.pagina;
comando.Parameters.Add("p_porpagina", MySqlDbType.Int32).Value = filtro.porpagina;
comando.Parameters.Add("p_orderby", MySqlDbType.VarChar).Value = filtro.orderby;
comando.Parameters.Add("p_ordertype", MySqlDbType.VarChar).Value = filtro.ordertype;
// Se toma el valor devuelto
dr = comando.ExecuteReader();
if (dr.HasRows)
{
ArticuloVO vo;
while (dr.Read())
{
vo = new ArticuloVO();
vo.Clave = dr.GetInt32(dr.GetOrdinal("Clave"));
vo.Descripcion = dr["Descripcion"].ToString();
vo.Modelo = dr["Modelo"].ToString();
vo.Precio = dr.GetDecimal(dr.GetOrdinal("Precio"));
vo.Existencia = dr.GetInt32(dr.GetOrdinal("Existencia"));
vo.total = Convert.ToInt32(dr["total"]);
lista.Add(vo);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
dr = null;
}
return(lista);
}
public ActionResult CreateArticulo(ArticuloVO vo)
{
try
{
ArticulosBS BS = new ArticulosBS();
return(Json(BS.CreateArticulo(vo)));
}
catch (Exception ex)
{
return(Json(ParseException(new CCExcepcion(ex))));
}
}
public int UpdateArticulo(ArticuloVO vo)
{
try
{
return(this.Con.UpdateArticulo(vo));
}
catch (CCExcepcion)
{
throw;
}
catch (Exception ex)
{
throw new CCExcepcion(ex);
}
}
public ActionResult UpdateArticulo(ArticuloVO vo)
{
try
{
ArticulosBS BS = new ArticulosBS();
return(Json(BS.UpdateArticulo(vo)));
}
catch (CCExcepcion cfex)
{
List <object> lista = new List <object>();
lista.Add(ParseException(cfex));
return(Json(lista));
}
catch (Exception ex)
{
return(Json(ParseException(new CCExcepcion(ex))));
}
}
public ArticuloVO ArticuloObtenerPorClave(int claveArticulo)
{
MySqlDataReader dr = null;
ArticuloVO vo = null;
try
{
string query = "sp_Articulo_selectporclave";
MySqlCommand comando = this.Conexion.CreateCommand();
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = query;
comando.Parameters.AddWithValue("p_clave", claveArticulo);
// Se toma el valor devuelto
dr = comando.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
vo = new ArticuloVO();
vo.Clave = dr.GetInt32(dr.GetOrdinal("Clave"));
vo.Descripcion = dr["Descripcion"].ToString();
vo.Modelo = dr["Modelo"].ToString();
vo.Precio = dr.GetDecimal(dr.GetOrdinal("Precio"));
vo.Existencia = dr.GetInt32(dr.GetOrdinal("Existencia"));
}
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
dr = null;
}
return(vo);
}
public string ArticuloEliminar(ArticuloVO vo)
{
string resp = string.Empty;
try
{
string query = "sp_contaArticulo_eliminar";
MySqlCommand comando = this.Conexion.CreateCommand();
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = query;
comando.Parameters.AddWithValue("p_id", vo.Clave);
// Se toma el valor devuelto
resp = comando.ExecuteScalar().ToString();
}
catch (Exception Ex)
{
throw Ex;
}
return(resp);
}