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 int GetDaysInQuarter(int Year, SNDK.Enums.Quarter Quarter)
{
int result = 0;
DateTime begin = GetStartOfQuarter (Year, Quarter);
DateTime end = GetEndOfQuarter (Year, Quarter);
result = (end - begin).Days + 1;
return result;
}
internal static IDbConnection Connect(SNDK.DBI.Connection Connection)
{
MySqlConnection result = null;
string connectionstring = "Server="+ Connection.Hostname +";Database="+ Connection.Database +";User ID="+ Connection.Username +";Password="******";pooling=true;min pool size=4;max pool size=100";
try
{
result = new MySqlConnection (connectionstring);
result.Open ();
Connection.Connected = true;
}
catch
{
throw new Exception ("Could not connection to database.");
}
return result;
}
public static string SHAHash(SNDK.Enums.SHAHashAlgorithm HashAlgorithm, string PlainText, string Salt)
{
string result = string.Empty;
HashAlgorithm hash = null;
byte[] plaintextbytes;
switch (HashAlgorithm)
{
case SNDK.Enums.SHAHashAlgorithm.SHA1:
hash = new SHA1Managed ();
break;
case SNDK.Enums.SHAHashAlgorithm.SHA256:
hash = new SHA256Managed ();
break;
case SNDK.Enums.SHAHashAlgorithm.SHA384:
hash = new SHA384Managed ();
break;
case SNDK.Enums.SHAHashAlgorithm.SHA512:
hash = new SHA512Managed ();
break;
}
if (Salt != string.Empty || Salt != null)
{
plaintextbytes = Encoding.UTF8.GetBytes (PlainText+Salt);
}
else
{
plaintextbytes = Encoding.UTF8.GetBytes (PlainText);
}
byte[] plaintexthash = hash.ComputeHash (plaintextbytes);
foreach (byte x in plaintexthash)
{
result += String.Format("{0:x2}", x);
}
return result;
}
public static DateTime GetEndOfQuarter(int Year, SNDK.Enums.Quarter Quarter)
{
switch (Quarter)
{
case SNDK.Enums.Quarter.First:
return new DateTime (Year, 3, DateTime.DaysInMonth (Year, 3), 23, 59, 59, 999);
case SNDK.Enums.Quarter.Second:
return new DateTime (Year, 6, DateTime.DaysInMonth (Year, 6), 23, 59, 59, 999);
case SNDK.Enums.Quarter.Third:
return new DateTime (Year, 9, DateTime.DaysInMonth (Year, 9), 23, 59, 59, 999);
case SNDK.Enums.Quarter.Fourth:
return new DateTime (Year, 12, DateTime.DaysInMonth (Year, 12), 23, 59, 59, 999);
}
return DateTime.Now;
}
public static DateTime GetStartOfQuarter(int Year, SNDK.Enums.Quarter Quarter)
{
switch (Quarter)
{
case SNDK.Enums.Quarter.First:
return new DateTime (Year, 1, 1, 0, 0, 0, 0);
case SNDK.Enums.Quarter.Second:
return new DateTime (Year, 4, 1, 0, 0, 0, 0);
case SNDK.Enums.Quarter.Third:
return new DateTime (Year, 7, 1, 0, 0, 0, 0);
case SNDK.Enums.Quarter.Fourth:
return new DateTime (Year, 10, 1, 0, 0, 0, 0);
}
return DateTime.Now;
}
public static SNDK.Enums.Quarter GetQuarter(SNDK.Enums.Month Month)
{
if (Month <= SNDK.Enums.Month.March)
{
return SNDK.Enums.Quarter.First;
}
else if ((Month >= SNDK.Enums.Month.April) && (Month <= SNDK.Enums.Month.June))
{
return SNDK.Enums.Quarter.Second;
}
else if ((Month >= SNDK.Enums.Month.July) && (Month <= SNDK.Enums.Month.September))
{
return SNDK.Enums.Quarter.Third;
} else
{
return SNDK.Enums.Quarter.Fourth;
}
}
public static string SHAHash(SNDK.Enums.SHAHashAlgorithm HashAlgorithm, string PlainText)
{
return SNDK.Crypto.SHAHash (HashAlgorithm, PlainText, string.Empty);
}
public static int GetCount(SNDK.DBI.Connection DBConnection, string TableName)
{
return SNDK.DBI.Helpers.GetCount (DBConnection, TableName, string.Empty);
}
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;
}
