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);
}
