public bool DeleteOldMessages(UserVO from, UserVO to) { List <MessageVO> m = GetMessages(from, to); if (m.Count <= ConfigurationManager.MAXIMUM_MESSAGES_COUNT) { return(true); } m.Sort(new MessageSorter()); int firstOldMessageIndex = m.Count - 1 - ConfigurationManager.MAXIMUM_MESSAGES_COUNT; MessageVO firstOldMessage = m[firstOldMessageIndex]; DateTime toDeleteDate = firstOldMessage.Date; string condition = string.Format("({0} <= @{0} and {1}=@{1} and {2}=@{2})", messageDate, messageFrom, messageTo); string statement = SqlStatememtGenerator.Delete_ByCondition(tableName, condition); SqlCeParameter[] parameters = { MakeSqlParameter(messageDate, toDeleteDate, SqlDbType.DateTime), MakeSqlParameter(messageFrom, from.Id), MakeSqlParameter(messageTo, to.Id) }; return(executer.ExecuteDeleteStatement(statement, parameters)); }
private bool DeleteAssociationsOfTableElement(VO tableElement, string providedTableColumnName) { string condition = string.Format("{0} = @{0}", providedTableColumnName); string statement = SqlStatememtGenerator.Delete_ByCondition(tableName, condition); SqlCeParameter[] parameters = new SqlCeParameter[] { MakeSqlParameter(providedTableColumnName, tableElement.Id) }; return(executer.ExecuteDeleteStatement(statement, parameters)); }
public bool Detach(T1 firstTableVO, T2 secondTableVO) { string condition = string.Format("{0} = @{0} and {1} = @{1}", firstTableIdColumnName, secondTableIdColumnName); string statement = SqlStatememtGenerator.Delete_ByCondition(tableName, condition); SqlCeParameter[] parameters = new SqlCeParameter[2]; parameters[0] = MakeSqlParameter(firstTableIdColumnName, firstTableVO.Id); parameters[1] = MakeSqlParameter(secondTableIdColumnName, secondTableVO.Id); return(executer.ExecuteDeleteStatement(statement, parameters)); }
public virtual bool DeleteAll() { string statement = SqlStatememtGenerator.Delete_ByCondition(tableName, "1=1"); return executer.ExecuteDeleteStatement(statement, null); }