public static List <viewPageViewCount> SelectWhere(Columns.ColumnNames Column, Equals Equals, Object Value)
{
string strSQL = "SELECT [PageID], [SumOfViewCount] FROM [viewPageViewCount]";
strSQL += " WHERE ";
if (Equals == Equals.EqualTo)
{
strSQL += Columns.GetColumnName(Column);
}
if (Equals == Equals.NotEquals)
{
strSQL += "NOT " + Columns.GetColumnName(Column);
}
if (Value.GetType() == typeof(string))
{
Value.ToString().Replace("*", "%");
strSQL += " LIKE ";
}
else
{
strSQL += " = ";
}
strSQL += "@SearchValue1";
Dictionary <Columns.ColumnNames, Object> Parameters = new Dictionary <Columns.ColumnNames, Object>();
Parameters.Add(Column, Value);
return(SelectRows(strSQL, Parameters));
}
public static List <viewPageViewCount> SelectWhere(Columns.ColumnNames Column, Equals Equals, Object Value, Columns.ColumnNames Column2, Equals Equals2, Object Value2, Columns.ColumnNames SortByColumn, Sorting SortOrder)
{
string strSQL = "SELECT [PageID], [SumOfViewCount] FROM [viewPageViewCount]";
strSQL += " WHERE ";
if (Equals == Equals.EqualTo)
{
strSQL += Columns.GetColumnName(Column);
}
if (Equals == Equals.NotEquals)
{
strSQL += "NOT " + Columns.GetColumnName(Column);
}
if (Value.GetType() == typeof(string))
{
Value.ToString().Replace("*", "%");
strSQL += " LIKE ";
}
else
{
strSQL += " = ";
}
strSQL += "@SearchValue1";
strSQL += " AND ";
if (Equals2 == Equals.EqualTo)
{
strSQL += Columns.GetColumnName(Column2);
}
if (Equals2 == Equals.NotEquals)
{
strSQL += "NOT " + Columns.GetColumnName(Column2);
}
if (Value.GetType() == typeof(string))
{
Value2.ToString().Replace("*", "%");
strSQL += " LIKE ";
}
else
{
strSQL += " = ";
}
strSQL += "@SearchValue2";
strSQL += " ORDER BY " + SortByColumn;
if (SortOrder == Sorting.Ascending)
{
strSQL += " ASC";
}
if (SortOrder == Sorting.Descending)
{
strSQL += " DESC";
}
Dictionary <Columns.ColumnNames, Object> Parameters = new Dictionary <Columns.ColumnNames, Object>();
Parameters.Add(Column, Value);
Parameters.Add(Column2, Value2);
;
return(SelectRows(strSQL, Parameters));
}
public static List <viewPageViewCount> SelectAll(Columns.ColumnNames Column, Sorting SortOrder)
{
string strSQL = SelectBaseSQL();
strSQL += " ORDER BY " + Column;
if (SortOrder == Sorting.Ascending)
{
strSQL += " ASC";
}
if (SortOrder == Sorting.Descending)
{
strSQL += " DESC";
}
return(SelectRows(strSQL, null));
}
