public List <CataProducts> AllProducts() { List <CataProducts> cDetails = new List <CataProducts>(); using (DatabaseClient dbClient = AleedaEnvironment.GetDatabase().GetClient()) { foreach (DataRow row in dbClient.ReadDataTable("SELECT * FROM catalogue_products").Rows) { CataProducts C = Aleeda.HabboHotel.Catalog.CataProducts.Parse(row); if (C != null) { cDetails.Add(C); } } } return(cDetails); }
public List <CataProducts> CataProductsBySpriteID(int ID) { List <CataProducts> cDetails = new List <CataProducts>(); using (DatabaseClient dbClient = AleedaEnvironment.GetDatabase().GetClient()) { dbClient.AddParamWithValue("@id", Convert.ToInt32(ID)); foreach (DataRow row in dbClient.ReadDataTable("SELECT * FROM catalogue_products WHERE sprite_id = @id;").Rows) { CataProducts C = Aleeda.HabboHotel.Catalog.CataProducts.Parse(row); if (C != null) { cDetails.Add(C); } } } return(cDetails); }
public static CataProducts Parse(DataRow row) { CataProducts details = new CataProducts(); try { details.cPageId = Convert.ToInt32(row["page_id"]); details.cID = Convert.ToInt32(row["id"]); details.cType = Convert.ToString(row["type"]); details.cItemID = Convert.ToInt32(row["sprite_id"]); details.cCCT = Convert.ToString(row["sprite_name"]); details.cCredits = Convert.ToInt32(row["credits"]); details.cPixels = Convert.ToInt32(row["pixels"]); details.cAmount = Convert.ToInt32(row["combo_count"]); return(details); } catch (Exception ex) { AleedaEnvironment.GetLog().WriteUnhandledExceptionError("CatalogPage.Parse", ex); } return(null); }