public ANDORWhere(Column column, object value, Comparison comp, bool useOr)
{
_column = column;
_value = value;
_comp = comp;
_useOr = useOr;
}
public ANDORWhere(Column column, object value)
: this(column, value, false)
{
}
public ANDORWhere(Column column, object value, bool useOr)
: this(column, value, Comparison.Equals, useOr)
{
}
public void OrWhere(Column column, object value)
{
OrWhere(column, value, Comparison.Equals);
}
public void OrWhere(Column column, object value, Comparison comp)
{
_wheres.Add(new ANDORWhere(column, value, comp, true));
}
private void OrderBy(Column column, string direction)
{
_orders.Add(string.Format("{0}.{1} {2}"
, DataService.Provider.QuoteName( _Table.TableName )
, DataService.Provider.QuoteName( column.Name )
, direction
));
}
public void AndWhere(Column column, object value, Comparison comp)
{
_wheres.Add(new ANDORWhere(column, value, comp, false));
}
/// <summary>
/// Ads an Order by Asc
/// </summary>
/// <param name="column"></param>
public void OrderByAsc(Column column)
{
OrderBy(column, "ASC");
}
/// <summary>
/// Ads an Order by DESC
/// </summary>
/// <param name="column"></param>
public void OrderByDesc(Column column)
{
OrderBy(column, "DESC");
}
/// <summary>
/// Ors an IN clause
/// </summary>
/// <param name="column"></param>
/// <param name="ints"></param>
public void AndInWhere(Column column, params int[] ints)
{
_wheres.Add(new INWhere(column, false, ints));
}
/// <summary>
/// Ands an IN clause
/// </summary>
/// <param name="column"></param>
/// <param name="strings"></param>
public void AndInWhere(Column column, params string[] strings)
{
_wheres.Add(new INWhere(column,false,strings));
}
public INWhere(Column column, bool useOr, params string[] strings)
{
string_Keys = strings;
_column = column;
_useOr = useOr;
}
public INWhere(Column column, bool useOr, params int[] ints)
{
int_Ids = ints;
_column = column;
_useOr = useOr;
}
private static void DeleteByColumn(Column column, bool state)
{
List<string> idsToDelete = new List<string>();
List<int> postIdsChanged = new List<int>();
Query q = CreateQuery();
q.AndWhere(column,state);
q.AndWhere(Columns.Published, DateTime.Now.AddDays(-1 * Int32.Parse(ConfigurationManager.AppSettings["Graffiti::Comments::DaysToDelete"] ?? "7")),Comparison.LessOrEquals);
q.Top = "25";
q.OrderByAsc(Columns.Published);
CommentCollection cc = CommentCollection.FetchByQuery(q);
foreach(Comment c in cc)
{
idsToDelete.Add(c.Id.ToString());
if (!postIdsChanged.Contains(c.PostId))
postIdsChanged.Add(c.PostId);
}
if(idsToDelete.Count > 0)
{
QueryCommand deleteCommand =
new QueryCommand("DELETE FROM graffiti_Comments where Id in (" + string.Join(",", idsToDelete.ToArray()) + ")");
DataService.ExecuteNonQuery(deleteCommand);
foreach(int pid in postIdsChanged)
Core.Post.UpdateCommentCount(pid);
Log.Info("Deleted Comments", idsToDelete.Count + " comment(s) were removed from the database since they were older than " + (ConfigurationManager.AppSettings["Graffiti::Comments::DaysToDelete"] ?? "7") + " days and marked as " + ((column.Name == "IsDeleted") ? " deleted" : " unpublished") );
}
}
