public Image(IDBLayer idb, long id, string name, long picId, EnumImageCategories imageType, bool deleteable)
: base(idb, id)
{
this.name = name;
this.picId = picId;
this.imgFact = null;
this.type = imageType;
this.deleteable = deleteable;
}
private List<Image> GetImages(EnumImageCategories category)
{
using (OleDbDataReader myReader = DBUtils.ExecSQL(this.DBConString, "SELECT [id], [FileName], [Name], [Deleteable] FROM [Images] WHERE ([ImageCategory] = ?) ORDER BY [Name]", new object[] { category }))
{
List<Image> a = new List<Image>();
while (true == myReader.Read())
{
Image img = null;
try
{
img = new Image(this, (int)myReader["id"], (string)myReader["Name"], (int)myReader["id"], category, (bool)myReader["Deleteable"]);
}
catch (Exception)
{
img = new Image(this, (int)myReader["id"], (string)myReader["name"], -1, category, (bool)myReader["Deleteable"]);
}
a.Add(img);
}
return a;
}
}
private Image AddImage(EnumImageCategories category, String name, String fileName, byte[] data, EnumImageCategories imageType)
{
byte[] buffer = data;
if (null != fileName)
{
if (null == buffer)
{
using (FileStream stream = new FileStream(fileName, FileMode.Open, FileAccess.Read))
{
buffer = new byte[stream.Length];
stream.Read(buffer, 0, (int)stream.Length);
}
}
}
int id = DBUtils.InsertSQL(this.DBConString, "INSERT INTO Images ([FileName], [Image], [Name], [ImageCategory]) VALUES(?, ?, ?, ?)", new object[] {fileName, buffer, name, category});
return new Image(this, id, name, id, buffer, imageType, true);
}
public Image(IDBLayer idb, long id, string name, long picId, byte[] data, EnumImageCategories imageType, bool deleteable)
: this(idb, id, name, picId, imageType, deleteable)
{
this.image = BuildImage(data);
}
