public void ExecNonQuery()
{
string sqlConnectionString = string.Empty;
if (SqlTimeOut > 0)
{
sqlConnectionString = BasicEntity.ConnectionString + ";Connection Timeout=" + SqlTimeOut.ToString();
}
else
{
sqlConnectionString = BasicEntity.ConnectionString;
}
if (Parameters.Count > 0)
{
SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName, Parameters.ToArray());
}
else
{
SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName);
}
}
public SqlDataReader ExecReader()
{
string sqlConnectionString = string.Empty;
if (SqlTimeOut > 0)
{
sqlConnectionString = BasicEntity.ConnectionString + ";Connection Timeout=" + SqlTimeOut.ToString();
}
else
{
sqlConnectionString = BasicEntity.ConnectionString;
}
if (this.Parameters.Count > 0)
{
return(SqlHelper.ExecuteReader(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName, Parameters.ToArray()));
}
else
{
return(SqlHelper.ExecuteReader(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName));
}
}
