private static object PrivateExecuteScalar(string CommandText, CommandType CommandType, SqlParameterCollection Parameters)
{
try
{
SqlConnection connection = DataAccessSql.GetConnection();
connection.Open();
SqlCommand command = DataAccessSql.GetCommand();
command.CommandText = CommandText;
command.CommandType = CommandType;
command.Connection = connection;
if (Parameters != null)
{
foreach (SqlParameter parameter in (DbParameterCollection)Parameters)
{
command.Parameters.Add(new SqlParameter(parameter.ParameterName, parameter.SqlDbType, parameter.Size, parameter.Direction, parameter.Precision, parameter.Scale, parameter.SourceColumn, parameter.SourceVersion, parameter.SourceColumnNullMapping, parameter.Value, parameter.XmlSchemaCollectionDatabase, parameter.XmlSchemaCollectionOwningSchema, parameter.XmlSchemaCollectionName));
}
}
object obj = command.ExecuteScalar();
connection.Close();
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
private static DataSet RetrieveDataSet(string CommandText, CommandType CommandType, SqlParameterCollection Parameters)
{
try
{
DataSet dataSet = new DataSet();
SqlConnection connection = DataAccessSql.GetConnection();
connection.Open();
SqlDataAdapter dataAdapter = DataAccessSql.GetDataAdapter(CommandText, connection);
SqlCommand command = DataAccessSql.GetCommand();
command.CommandText = CommandText;
command.CommandType = CommandType;
command.Connection = connection;
dataAdapter.SelectCommand = command;
if (Parameters != null)
{
foreach (SqlParameter parameter in (DbParameterCollection)Parameters)
{
dataAdapter.SelectCommand.Parameters.Add(new SqlParameter(parameter.ParameterName, parameter.SqlDbType, parameter.Size, parameter.Direction, parameter.Precision, parameter.Scale, parameter.SourceColumn, parameter.SourceVersion, parameter.SourceColumnNullMapping, parameter.Value, parameter.XmlSchemaCollectionDatabase, parameter.XmlSchemaCollectionOwningSchema, parameter.XmlSchemaCollectionName));
}
}
dataAdapter.Fill(dataSet);
connection.Close();
return(dataSet);
}
catch (Exception ex)
{
throw ex;
}
}
public static SqlParameterCollection GetParametersCollection()
{
return(DataAccessSql.GetCommand().Parameters);
}