public static ProductoRecetaInsumo Fetch(int id) { ProductoRecetaInsumo m_entidad = new ProductoRecetaInsumo(); using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "pro_productosrecetasinsumos_traerregistro"; command.Parameters.Add(new MySqlParameter("@n_id", id)); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { m_entidad = SetObject(reader); } } } } return(m_entidad); }
public static ObservableListSource <ProductoRecetaInsumo> FetchList(int n_idpro, int n_idrec) { ObservableListSource <ProductoRecetaInsumo> m_listentidad = new ObservableListSource <ProductoRecetaInsumo>(); using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "pro_productosrecetasinsumos_listar_v2"; command.Parameters.Add(new MySqlParameter("@n_idpro", n_idpro)); command.Parameters.Add(new MySqlParameter("@n_idrec", n_idrec)); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ProductoRecetaInsumo m_entidad = SetObject(reader); m_listentidad.Add(m_entidad); } } } } return(m_listentidad); }