public RouletteAwardItem[] GetCurrentRouletteAwardItemsList()
{
RouletteAwardItem[] items = null;
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string sqlText = "select c.`Index`, c.`AwarditemID`, r.* from currentrouletteawarditemlist c left join rouletteawarditem r on c.`AwarditemID` = r.`id` ;";
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlText;
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
DataTable table = new DataTable();
adapter.Fill(table);
items = MetaDBAdapter <RouletteAwardItem> .GetRouletteAwardItemFromDataTable(table);
table.Clear();
table.Dispose();
adapter.Dispose();
return(items);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
public RouletteAwardItem[] GetAllRouletteAwardItems()
{
RouletteAwardItem[] items = null;
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string sqlText = "select * from rouletteawarditem";
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlText;
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
DataTable table = new DataTable();
adapter.Fill(table);
items = MetaDBAdapter <RouletteAwardItem> .GetRouletteAwardItemFromDataTable(table);
table.Clear();
table.Dispose();
adapter.Dispose();
return(items);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}