using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Text;
using System.Configuration;
using System.Data.Common;
using System.Data.SqlClient;
using System.IO;
public class DatabaseHelper : IDisposable, IError
{
private SqlConnection objConnection;
private SqlCommand objCommand;
private bool boolHandleErrors;
private string strLastError;
private bool boolLogError;
private string strLogFile;
public event System.EventHandler IError;
public delegate void OnExecuteErrorEventHandler(string Reason, string Message, string Location);
protected void ErrorOccured(string Reason, string Message, string Location)
{
if (OnExecuteError != null) {
OnExecuteError(Reason, Message, Location);
}
}
public DatabaseHelper()
{
objConnection = new SqlConnection(ConfigurationManager.ConnectionStrings("conn").ConnectionString);
objCommand = new SqlCommand();
objConnection.ConnectionString = ConfigurationManager.ConnectionStrings("conn").ConnectionString;
objCommand.Connection = objConnection;
}
public DatabaseHelper(string DatabaseName)
{
objConnection = new SqlConnection(ConfigurationManager.ConnectionStrings("conn").ConnectionString);
objCommand = new SqlCommand();
objConnection.ConnectionString = ConfigurationManager.ConnectionStrings("conn").ConnectionString;
objCommand.Connection = objConnection;
}
public bool HandleErrors {
get { return boolHandleErrors; }
set { boolHandleErrors = value; }
}
public string LastError {
get { return strLastError; }
}
public bool LogErrors {
get { return boolLogError; }
set { boolLogError = value; }
}
public string LogFile {
get { return strLogFile; }
set { strLogFile = value; }
}
public object AddParameter(SqlParameter parameter)
{
return objCommand.Parameters.Add(parameter);
}
public object AddParameter(string name)
{
SqlParameter p = new SqlParameter();
p.ParameterName = name;
p.SqlDbType = SqlDbType.Int;
p.Direction = ParameterDirection.Output;
return objCommand.Parameters.Add(p);
}
public object AddParameter(string name, object value, SqlDbType StrSqlDbType, int IntSize , ParameterDirection StrDirection )
{
SqlParameter p = new SqlParameter();
p.ParameterName = name;
p.Value = value;
p.SqlDbType = StrSqlDbType;
p.Direction = StrDirection;
p.Size = IntSize;
return objCommand.Parameters.Add(p);
}
public object AddOptionalParameter(string name, ParameterDirection StrDirection = ParameterDirection.Output, SqlDbType StrSqlDbType = SqlDbType.Int, int IntSize )
{
SqlParameter p = new SqlParameter();
p.ParameterName = name;
p.SqlDbType = StrSqlDbType;
p.Direction = StrDirection;
p.Size = IntSize;
return objCommand.Parameters.Add(p);
}
public SqlCommand Command {
get { return objCommand; }
}
public SqlConnection Connection {
get { return objConnection; }
}
public SqlParameter GetObjParameter {
get {
SqlParameter p = new SqlParameter();
return p;
}
}
public void BeginTransaction()
{
if (objConnection.State == System.Data.ConnectionState.Closed) {
objConnection.Open();
}
objCommand.Transaction = objConnection.BeginTransaction();
}
public void CommitTransaction()
{
objCommand.Transaction.Commit();
objConnection.Close();
}
public void RollbackTransaction()
{
objCommand.Transaction.Rollback();
objConnection.Close();
}
public int ExecuteNonQuery(string query)
{
return ExecuteNonQuery(query, CommandType.Text, ConnectionState.CloseOnExit);
}
public int ExecuteNonQuery(string query, CommandType commandtype)
{
return ExecuteNonQuery(query, commandtype, ConnectionState.CloseOnExit);
}
public int ExecuteNonQuery(string query, ConnectionState connectionstate)
{
return ExecuteNonQuery(query, CommandType.Text, connectionstate);
}
public int ExecuteNonQuery(SqlCommand objCommand, ConnectionState connectionstate)
{
int i = -1;
try {
if (objConnection.State == System.Data.ConnectionState.Closed) {
objConnection.Open();
}
i = objCommand.ExecuteNonQuery();
} catch (Exception ex) {
HandleExceptions(ex);
} finally {
objCommand.Parameters.Clear();
if (connectionstate == connectionstate.CloseOnExit) {
objConnection.Close();
}
}
return i;
}
public int ExecuteNonQuery(string query, CommandType commandtype, ConnectionState connectionstate)
{
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
int i = -1;
try {
if (objConnection.State == System.Data.ConnectionState.Closed) {
objConnection.Open();
}
i = objCommand.ExecuteNonQuery();
} catch (Exception ex) {
HandleExceptions(ex);
} finally {
objCommand.Parameters.Clear();
if (connectionstate == connectionstate.CloseOnExit) {
objConnection.Close();
}
}
return i;
}
public object ExecuteScalar(string query)
{
return ExecuteScalar(query, CommandType.Text, ConnectionState.CloseOnExit);
}
public object ExecuteScalar(string query, CommandType commandtype)
{
return ExecuteScalar(query, commandtype, ConnectionState.CloseOnExit);
}
public object ExecuteScalar(string query, ConnectionState connectionstate)
{
return ExecuteScalar(query, CommandType.Text, connectionstate);
}
public object ExecuteScalar(string query, CommandType commandtype, ConnectionState connectionstate)
{
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
object o = null;
try {
if (objConnection.State == System.Data.ConnectionState.Closed) {
objConnection.Open();
}
o = objCommand.ExecuteScalar();
} catch (Exception ex) {
HandleExceptions(ex);
} finally {
objCommand.Parameters.Clear();
if (connectionstate == connectionstate.CloseOnExit) {
objConnection.Close();
}
}
return o;
}
public SqlDataReader ExecuteReader(string query)
{
return ExecuteReader(query, CommandType.Text, ConnectionState.CloseOnExit);
}
public SqlDataReader ExecuteReader(string query, CommandType commandtype)
{
return ExecuteReader(query, commandtype, ConnectionState.CloseOnExit);
}
public SqlDataReader ExecuteReader(string query, ConnectionState connectionstate)
{
return ExecuteReader(query, CommandType.Text, connectionstate);
}
public SqlDataReader ExecuteReader(string query, CommandType commandtype, ConnectionState connectionstate)
{
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
SqlDataReader reader = null;
try {
if (objConnection.State == System.Data.ConnectionState.Closed) {
objConnection.Open();
}
if (connectionstate == connectionstate.CloseOnExit) {
reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
} else {
reader = objCommand.ExecuteReader();
}
} catch (Exception ex) {
HandleExceptions(ex);
} finally {
objCommand.Parameters.Clear();
}
return reader;
}
public SqlDataReader ExecuteReader(SqlCommand cmd, ConnectionState connectionstate)
{
SqlDataReader reader = null;
try {
if (objConnection.State == System.Data.ConnectionState.Closed) {
objConnection.Open();
}
if (connectionstate == connectionstate.CloseOnExit) {
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
} else {
reader = cmd.ExecuteReader();
}
} catch (Exception ex) {
throw ex;
} finally {
}
return reader;
}
public DataSet ExecuteDataSet(string query)
{
return ExecuteDataSet(query, CommandType.Text, ConnectionState.CloseOnExit);
}
public DataSet ExecuteDataSet(string query, CommandType commandtype)
{
return ExecuteDataSet(query, commandtype, ConnectionState.CloseOnExit);
}
public DataSet ExecuteDataSet(string query, ConnectionState connectionstate)
{
return ExecuteDataSet(query, CommandType.Text, connectionstate);
}
public DataSet ExecuteDataSet(string query, CommandType commandtype, ConnectionState connectionstate)
{
SqlDataAdapter adapter = new SqlDataAdapter();
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
adapter.SelectCommand = objCommand;
DataSet ds = new DataSet();
try {
adapter.Fill(ds);
} catch (Exception ex) {
HandleExceptions(ex);
} finally {
objCommand.Parameters.Clear();
if (connectionstate == connectionstate.CloseOnExit) {
if (objConnection.State == System.Data.ConnectionState.Open) {
objConnection.Close();
}
}
}
return ds;
}
private void HandleExceptions(Exception ex)
{
if (LogErrors) {
WriteToLog(ex.Message);
}
if (HandleErrors) {
strLastError = ex.Message;
} else {
throw ex;
}
}
private void WriteToLog(string msg)
{
StreamWriter writer = File.AppendText(LogFile);
writer.WriteLine(DateTime.Now.ToString() + " - " + msg);
writer.Close();
}
public void Dispose1()
{
objConnection.Close();
objConnection.Dispose();
objCommand.Dispose();
}
void System.IDisposable.Dispose()
{
Dispose1();
}
}
public enum Providers
{
SqlServer,
OleDb,
Oracle,
ODBC,
ConfigDefined
}
public enum ConnectionState
{
KeepOpen,
CloseOnExit
}
public interface IError
{
event OnExecuteErrorEventHandler OnExecuteError;
delegate void OnExecuteErrorEventHandler(string Reason, string Message, string Location);
}
------------------
This is my C# Global Class Declaration.But Whene I Run my Pages ..It Gives The Error Like
----------
Error 1'OnExecuteErrorEventHandler': interfaces cannot declare types D:\Working Project\SOUBHAGYA\App_Code\DAL\DatabaseHelper.cs 370 16 D:\Working Project\SOUBHAGYA\
Error 2
Default parameter specifiers are not permitted<br />
D:\Working Project\SOUBHAGYA\App_Code\DAL\DatabaseHelper.cs 97 82 D:\Working Project\SOUBHAGYA\
Error 3
Default parameter specifiers are not permitted <br />
D:\Working Project\SOUBHAGYA\App_Code\DAL\DatabaseHelper.cs 97 134 D:\Working Project\SOUBHAGYA\
-----------------------
Please help!