public static TextureColorModel GetDataFromSqlite(string id)
{
TextureColorModel model;
lock (m_sqliteConnect)
{
using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM assets WHERE id=:id", m_sqliteConnect))
{
cmd.Parameters.Add(new SQLiteParameter(":id", id));
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
model = new TextureColorModel((string)reader["id"], Convert.ToByte(reader["a"]), Convert.ToByte(reader["r"]), Convert.ToByte(reader["g"]), Convert.ToByte(reader["b"]));
reader.Close();
}
else
{
model = new TextureColorModel(null, 255, 255, 0, 0);
reader.Close();
}
}
}
}
return(model);
}
public static TextureColorModel GetDataFromFile(string id)
{
TextureColorModel model;
string file = "textureColorCache//" + id;
if (!File.Exists(file))
{
model = new TextureColorModel(null, 255, 255, 0, 0);
}
else
{
TextReader tr = new StreamReader(file);
byte a = Convert.ToByte(tr.ReadLine());
byte r = Convert.ToByte(tr.ReadLine());
byte g = Convert.ToByte(tr.ReadLine());
byte b = Convert.ToByte(tr.ReadLine());
model = new TextureColorModel(id, a, r, g, b);
tr.Close();
}
return(model);
}
public static TextureColorModel GetDataFromSqlite(string id)
{
TextureColorModel model;
lock (m_sqliteConnect)
{
using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM assets WHERE id=:id", m_sqliteConnect))
{
cmd.Parameters.Add(new SQLiteParameter(":id", id));
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
model = new TextureColorModel((string)reader["id"], Convert.ToByte(reader["a"]), Convert.ToByte(reader["r"]), Convert.ToByte(reader["g"]), Convert.ToByte(reader["b"]));
reader.Close();
}
else
{
model = new TextureColorModel(null, 255, 255, 0, 0);
reader.Close();
}
}
}
}
return model;
}
public static TextureColorModel GetDataFromFile(string id)
{
TextureColorModel model;
string file = "textureColorCache//" + id;
if (!File.Exists(file))
model = new TextureColorModel(null, 255, 255, 0, 0);
else
{
TextReader tr = new StreamReader(file);
byte a = Convert.ToByte(tr.ReadLine());
byte r = Convert.ToByte(tr.ReadLine());
byte g = Convert.ToByte(tr.ReadLine());
byte b = Convert.ToByte(tr.ReadLine());
model = new TextureColorModel(id, a, r, g, b);
tr.Close();
}
return model;
}
