public static SNDK.DBI.Query GetCount(SNDK.DBI.Connection DBConnection, string TableName, string Where, params string[] OrderByColumns)
{
string querystring = string.Empty;
querystring += "SELECT ";
if (OrderByColumns.GetLength(0) >= 0)
{
foreach (string column in OrderByColumns)
{
querystring += column + ",";
}
}
querystring += "COUNT(*) as rowcount FROM " + TableName + " ";
if (Where != string.Empty)
{
querystring += "WHERE " + Where + " ";
}
if (OrderByColumns.GetLength(0) >= 0)
{
querystring += "ORDER BY ";
foreach (string column in OrderByColumns)
{
querystring += column + ",";
}
querystring = querystring.TrimEnd(",".ToCharArray());
}
return(DBConnection.Query(querystring));
}
public static int GetCount(SNDK.DBI.Connection DBConnection, string TableName, string Where)
{
int result = 0;
string querystring = string.Empty;
querystring += "SELECT ";
querystring += "COUNT(*) as rowcount FROM " + TableName + " ";
if (Where != string.Empty)
{
querystring += "WHERE " + Where + " ";
}
Query query = DBConnection.Query(querystring);
if (query.Success)
{
if (query.NextRow())
{
result = query.GetInt(0);
}
}
query.Dispose();
query = null;
querystring = null;
return(result);
}
public static bool GuidExists(SNDK.DBI.Connection DbConnection, string TableName, Guid Guid)
{
bool result = false;
QueryBuilder qb = new QueryBuilder(QueryBuilderType.Select);
qb.Table(TableName);
qb.Columns("id");
qb.AddWhere("id", "=", Guid);
Query query = DbConnection.Query(qb.QueryString);
if (query.Success)
{
if (query.NextRow())
{
result = true;
}
}
query.Dispose();
query = null;
qb = null;
return(result);
}
internal static IDbConnection Connect(SNDK.DBI.Connection Connection)
{
SqlConnection result = null;
string connectionstring = "Server=" + Connection.Hostname + ";Database=" + Connection.Database + ";User ID=" + Connection.Username + ";Password="******";";
try
{
result = new SqlConnection(connectionstring);
result.Open();
Connection.Connected = true;
}
catch
{
throw new Exception("Could not connection to database server.");
}
return(result);
}
public static int GetCount(SNDK.DBI.Connection DBConnection, string TableName)
{
return(SNDK.DBI.Helpers.GetCount(DBConnection, TableName, string.Empty));
}
