public List <ItemApp> GetItemApps() { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = new SqlCommand("select * from itemTable", con); cmd.CommandType = CommandType.Text; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ItemApp itemApp = new ItemApp(); itemApp.ItemID = Convert.ToInt32(reader[0]); byte[] myImage = new byte[0]; myImage = (byte[])reader[1]; MemoryStream stream = new MemoryStream(myImage); itemApp.ImageFile = Image.FromStream(stream); itemApp.Title = reader[2].ToString(); itemApp.Description = reader[3].ToString(); itemApp.PriceTag = Convert.ToDouble(reader[4]); itemAppList.Add(itemApp); } reader.Close(); con.Close(); } return(itemAppList); }
public List <ItemApp> GetListaItems(int idrol) { List <ItemApp> litem = new List <ItemApp>(); List <ItemApp> lsubitem = new List <ItemApp>(); try { ConsultaMySql consulta = new ConsultaMySql(@"select * from newlafarnet.item_apps i inner join newlafarnet.item_rol ir on i.id = ir.id_item_app where ir.id_rol = " + idrol + @" and tipo = 'm';"); DataTable dt = consulta.EjecutarConsulta(Parametros.ConexionBDMySQL()); if (dt.Rows.Count <= 0) { throw new Exception("No trajo datos de la consulta de la base de datos"); } foreach (DataRow item in dt.Rows) { ItemApp ia = new ItemApp { id = Convert.ToInt32(item["id"]), url = (item["url"]).ToString(), icon = (item["icon"]).ToString(), app_id = Convert.ToInt32(item["app_id"]), itemName = (item["itemName"]).ToString(), tipo = (item["tipo"]).ToString(), id_mother = Convert.ToInt32(item["id_mother"]), usuario_creacion = (item["usuario_creacion"]).ToString(), fecha_creacion = Convert.ToDateTime(item["fecha_creacion"]), usuario_modificacion = (item["usuario_modificacion"]).ToString(), fecha_modificacion = Convert.ToDateTime(item["fecha_modificacion"]), items = this.GetListaSubItems(idrol, Convert.ToInt32(item["id"])) }; litem.Add(ia); } return(litem); } catch (Exception ex) { return(litem); } }