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