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