/// <summary>Main</summary>
public static void Main
(
string[] argv
)
{
Boolean booleanParseCommandLineArguments = false;
string exceptionMessage = null;
string filenameApplication = System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase;
HtmlInputFile htmlInputFileSource = null;
UtilityImageArgument utilityImageArgument = null;
utilityImageArgument = new UtilityImageArgument();
booleanParseCommandLineArguments = UtilityParseCommandLineArgument.ParseCommandLineArguments
(
argv,
utilityImageArgument
);
if ( booleanParseCommandLineArguments == false )
{
// error encountered in arguments. Display usage message
System.Console.Write
(
UtilityParseCommandLineArgument.CommandLineArgumentsUsage( typeof ( UtilityImageArgument ) )
);
return;
}//if ( booleanParseCommandLineArguments == false )
#if (DEBUG)
System.Console.WriteLine
(
"Filename Application: {0}",
filenameApplication
);
#endif
#if (DEBUG)
System.Console.WriteLine
(
"Argument FilenameSource: {0}",
utilityImageArgument.filenameSource
);
#endif
htmlInputFileSource = new HtmlInputFile();
DatabaseUpdate
(
ref DatabaseConnectionString,
ref utilityImageArgument,
ref exceptionMessage,
ref htmlInputFileSource
);
}//Main
}//public String FilenameSource
/// <summary>ButtonSubmit_Click().</summary>
public void ButtonSubmit_Click
(
Object sender,
EventArgs e
)
{
String exceptionMessage = null;
String filenameSource = null;
UtilityImageArgument utilityImageArgument = null;
filenameSource = FilenameSource;
/*
if( sender == ButtonSubmit )
{
Response.Write ( "ButtonSubmit" );
Feedback = "ButtonSubmit";
}
*/
utilityImageArgument = new UtilityImageArgument
(
filenameSource
);
UtilityImage.DatabaseSelect
(
ref DatabaseConnectionString,
ref utilityImageArgument,
ref exceptionMessage,
ref HtmlInputFileSource
);
Feedback = exceptionMessage;
}//public void ButtonSubmit_Click()
}//public static void DatabaseSelect()
/// <summary>DatabaseUpdate</summary>
public static void DatabaseUpdate
(
ref string databaseConnectionString,
ref UtilityImageArgument utilityImageArgument,
ref string exceptionMessage,
ref HtmlInputFile htmlInputFileSource
)
{
HttpContext httpContext = HttpContext.Current;
int databaseNumberOfRowsAffected = 0;
int sourceContentLength = 0;
int sourceContentRead = 0;
byte[] byteSource = null;
string filenameSource = null;
string sourceContentType = null;
OleDbCommand oleDbCommand = null;
OleDbConnection oleDbConnection = null;
OleDbParameter oleDbParameter = null;
Stream streamSource = null;
try
{
streamSource = htmlInputFileSource.PostedFile.InputStream;
sourceContentLength = htmlInputFileSource.PostedFile.ContentLength;
sourceContentType = htmlInputFileSource.PostedFile.ContentType;
filenameSource = htmlInputFileSource.Value;
byteSource = new byte[ sourceContentLength ];
/*
TypeCode typeCode = Type.GetTypeCode( byteSource.GetType() );
httpContext.Response.Write( typeCode.ToString() );
*/
sourceContentRead = streamSource.Read( byteSource, 0, sourceContentLength );
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
oleDbCommand = new OleDbCommand
(
"usp_ImageCarbonFormUpdate",
oleDbConnection
);
oleDbCommand.CommandType = CommandType.StoredProcedure;
oleDbParameter = new OleDbParameter( "@URIImage", OleDbType.VarChar, 255 );
oleDbParameter.Value = filenameSource;
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@ImageType", OleDbType.VarChar, 255 );
oleDbParameter.Value = sourceContentType;
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@ImageCarbonFormMatch", OleDbType.Binary );
oleDbParameter.Value = byteSource;
oleDbCommand.Parameters.Add( oleDbParameter );
databaseNumberOfRowsAffected = oleDbCommand.ExecuteNonQuery();
}//try
catch ( Exception exception )
{
exceptionMessage = "Exception: " + exception.Message;
}//catch ( Exception exception )
finally
{
if ( oleDbConnection != null )
{
oleDbConnection.Close();
}//if ( oleDbConnection != null )
}//finally
if ( exceptionMessage != null )
{
if ( httpContext == null )
{
System.Console.WriteLine( exceptionMessage );
}//if ( httpContext == null )
else
{
//httpContext.Response.Write( exceptionMessage );
}//else
}//if ( exceptionMessage != null )
}//public static void DatabaseUpdate()
}//Main
/// <summary>DatabaseSelect</summary>
public static void DatabaseSelect
(
ref string databaseConnectionString,
ref UtilityImageArgument utilityImageArgument,
ref string exceptionMessage,
ref HtmlInputFile htmlInputFileSource
)
{
HttpContext httpContext = HttpContext.Current;
string filenameSource = null;
string sqlSelectStatement = null;
IDataReader iDataReader = null;
try
{
filenameSource = htmlInputFileSource.Value;
sqlSelectStatement = "SELECT ImageCarbonFormMatch, ImageType FROM ImageCarbonForm WHERE URIImage = '"
+ filenameSource
+ "'";
UtilityDatabase.DatabaseQuery
(
databaseConnectionString,
ref exceptionMessage,
ref iDataReader,
sqlSelectStatement,
CommandType.Text
);
if ( iDataReader.Read() )
{
httpContext.Response.ContentType = iDataReader["ImageType"].ToString();
httpContext.Response.BinaryWrite( (byte[]) iDataReader["ImageCarbonFormMatch"] );
}//if ( iDataReader.Read() )
}//try
catch ( Exception exception )
{
exceptionMessage = "Exception: " + exception.Message;
}//catch ( Exception exception )
finally
{
if ( iDataReader != null )
{
iDataReader.Close();
}//if ( iDataReader != null )
}//finally
if ( exceptionMessage != null )
{
if ( httpContext == null )
{
System.Console.WriteLine( exceptionMessage );
}//if ( httpContext == null )
else
{
//httpContext.Response.Write( exceptionMessage );
}//else
}//if ( exceptionMessage != null )
}//public static void DatabaseSelect()
