public SprocketFile SelectSprocketFile(long id, bool getFileData) { try { using (TransactionScope scope = new TransactionScope()) { SQLiteConnection connection = (SQLiteConnection)DatabaseManager.DatabaseEngine.GetConnection(); SQLiteCommand cmd = connection.CreateCommand(); cmd.Connection = connection; cmd.CommandText = procs["Select SprocketFile"]; cmd.Parameters.Add(new SQLiteParameter("@SprocketFileID", id)); cmd.Parameters.Add(new SQLiteParameter("@GetFileData", getFileData)); SQLiteDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); SprocketFile entity; if (!reader.Read()) { entity = null; } else { entity = new SprocketFile(reader); } reader.Close(); scope.Complete(); return(entity); } } finally { DatabaseManager.DatabaseEngine.ReleaseConnection(); } }
public Result Delete(SprocketFile sprocketFile) { Result result = new Result(); if (OnBeforeDeleteSprocketFile != null) OnBeforeDeleteSprocketFile(sprocketFile, result); SQLiteConnection conn = null; if (result.Succeeded) { try { using (TransactionScope scope = new TransactionScope()) { conn = (SQLiteConnection)DatabaseManager.DatabaseEngine.GetConnection(); SQLiteCommand cmd = new SQLiteCommand(procs["Delete SprocketFile"], conn); cmd.Parameters.Add(new SQLiteParameter("@SprocketFileID", sprocketFile.SprocketFileID)); cmd.ExecuteNonQuery(); scope.Complete(); } } catch (Exception ex) { return new Result(ex.Message); } finally { DatabaseManager.DatabaseEngine.ReleaseConnection(); } if (OnSprocketFileDeleted != null) OnSprocketFileDeleted(sprocketFile); } return result; }
public Result ReadAdminField(out IEditFieldData efdata) { ImageEditFieldData data = new ImageEditFieldData(); SprocketFile file = null; if (HttpContext.Current.Request.Files[fieldName] != null) { if (HttpContext.Current.Request.Files[fieldName].ContentLength > 0) { file = new SprocketFile(SecurityProvider.ClientSpaceID, HttpContext.Current.Request.Files[fieldName], "", ""); Image img; Result r = file.ValidateImageData(out img); if (!r.Succeeded) { efdata = new ImageEditFieldData(); return(new Result("The image selected could not be loaded. The system reported back the following error: " + r.Message)); } if (maxwidth > 0 || maxheight > 0) { SizingOptions options = new SizingOptions(maxwidth, maxheight, SizingOptions.Display.Constrain, 0); options.Image = img; MemoryStream stream = new MemoryStream(); FileManager.FileManager.Instance.ResizeImage(options, stream); file.FileData = stream.ToArray(); } } } bool deleted = HttpContext.Current.Request.Form["deleteimage_" + fieldName] != null; long existing; if (!long.TryParse(HttpContext.Current.Request.Form["existingimage_" + fieldName], out existing)) { existing = 0; } if (deleted) { data.SprocketFileID = 0; } else if (file != null) { data.SprocketFile = file; } else { data.SprocketFileID = existing; } efdata = data; return(new Result()); }
public Result Store(SprocketFile sprocketFile) { SQLiteConnection conn = null; try { using (TransactionScope scope = new TransactionScope()) { conn = (SQLiteConnection)DatabaseManager.DatabaseEngine.GetConnection(); SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = conn; if (sprocketFile.SprocketFileID == 0) { sprocketFile.SprocketFileID = DatabaseManager.GetUniqueID(); cmd.CommandText = procs["Insert SprocketFile"]; } else if (SelectSprocketFile(sprocketFile.SprocketFileID, false) == null) { cmd.CommandText = procs["Insert SprocketFile"]; } else { cmd.CommandText = procs["Update SprocketFile"]; } cmd.Parameters.Add(NewSqlParameter("@SprocketFileID", sprocketFile.SprocketFileID, DbType.Int64)); cmd.Parameters.Add(NewSqlParameter("@ClientSpaceID", sprocketFile.ClientSpaceID, DbType.Int64)); cmd.Parameters.Add(NewSqlParameter("@FileData", sprocketFile.FileData, DbType.Object)); cmd.Parameters.Add(NewSqlParameter("@FileTypeExtension", sprocketFile.FileTypeExtension, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@OriginalFileName", sprocketFile.OriginalFileName, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@ContentType", sprocketFile.ContentType, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@Title", sprocketFile.Title, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@Description", sprocketFile.Description, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@UploadDate", sprocketFile.UploadDate, DbType.DateTime)); cmd.ExecuteNonQuery(); scope.Complete(); } } catch (Exception ex) { return(new Result(ex.Message)); } finally { DatabaseManager.DatabaseEngine.ReleaseConnection(); } return(new Result()); }
public Result Delete(SprocketFile sprocketFile) { Result result = new Result(); if (OnBeforeDeleteSprocketFile != null) { OnBeforeDeleteSprocketFile(sprocketFile, result); } SQLiteConnection conn = null; if (result.Succeeded) { try { using (TransactionScope scope = new TransactionScope()) { conn = (SQLiteConnection)DatabaseManager.DatabaseEngine.GetConnection(); SQLiteCommand cmd = new SQLiteCommand(procs["Delete SprocketFile"], conn); cmd.Parameters.Add(new SQLiteParameter("@SprocketFileID", sprocketFile.SprocketFileID)); cmd.ExecuteNonQuery(); scope.Complete(); } } catch (Exception ex) { return(new Result(ex.Message)); } finally { DatabaseManager.DatabaseEngine.ReleaseConnection(); } if (OnSprocketFileDeleted != null) { OnSprocketFileDeleted(sprocketFile); } } return(result); }
public Result Store(SprocketFile sprocketFile) { SQLiteConnection conn = null; try { using (TransactionScope scope = new TransactionScope()) { conn = (SQLiteConnection)DatabaseManager.DatabaseEngine.GetConnection(); SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = conn; if (sprocketFile.SprocketFileID == 0) { sprocketFile.SprocketFileID = DatabaseManager.GetUniqueID(); cmd.CommandText = procs["Insert SprocketFile"]; } else if (SelectSprocketFile(sprocketFile.SprocketFileID, false) == null) cmd.CommandText = procs["Insert SprocketFile"]; else cmd.CommandText = procs["Update SprocketFile"]; cmd.Parameters.Add(NewSqlParameter("@SprocketFileID", sprocketFile.SprocketFileID, DbType.Int64)); cmd.Parameters.Add(NewSqlParameter("@ClientSpaceID", sprocketFile.ClientSpaceID, DbType.Int64)); cmd.Parameters.Add(NewSqlParameter("@FileData", sprocketFile.FileData, DbType.Object)); cmd.Parameters.Add(NewSqlParameter("@FileTypeExtension", sprocketFile.FileTypeExtension, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@OriginalFileName", sprocketFile.OriginalFileName, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@ContentType", sprocketFile.ContentType, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@Title", sprocketFile.Title, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@Description", sprocketFile.Description, DbType.String)); cmd.Parameters.Add(NewSqlParameter("@UploadDate", sprocketFile.UploadDate, DbType.DateTime)); cmd.ExecuteNonQuery(); scope.Complete(); } } catch (Exception ex) { return new Result(ex.Message); } finally { DatabaseManager.DatabaseEngine.ReleaseConnection(); } return new Result(); }
public SprocketFile SelectSprocketFile(long id, bool getFileData) { try { using (TransactionScope scope = new TransactionScope()) { SQLiteConnection connection = (SQLiteConnection)DatabaseManager.DatabaseEngine.GetConnection(); SQLiteCommand cmd = connection.CreateCommand(); cmd.Connection = connection; cmd.CommandText = procs["Select SprocketFile"]; cmd.Parameters.Add(new SQLiteParameter("@SprocketFileID", id)); cmd.Parameters.Add(new SQLiteParameter("@GetFileData", getFileData)); SQLiteDataReader reader = cmd.ExecuteReader(); SprocketFile entity; if (!reader.Read()) entity = null; else entity = new SprocketFile(reader); reader.Close(); scope.Complete(); return entity; } } finally { DatabaseManager.DatabaseEngine.ReleaseConnection(); } }