//
//=================================================================================
/// <summary>
/// create sql criteria for all authoring control records related to a tableid and recordid
/// </summary>
/// <param name="tableId"></param>
/// <param name="recordId"></param>
/// <returns></returns>
//private static string getAuthoringControlCriteria(int tableId, int recordId) {
// return getAuthoringControlCriteria(getTableRecordKey(tableId, recordId));
//}
//
//==========================================================================================
/// <summary>
/// create sql criteria for a specific type of authoring control records related to a table/record
/// </summary>
/// <param name="userId"></param>
/// <param name="tableRecordKey"></param>
/// <param name="ControlType"></param>
/// <returns></returns>
public static string getAuthoringControlCriteria(string tableRecordKey, AuthoringControls ControlType, DateTime dateTimeMockable)
=> "(controltype=" + (int)ControlType + ")and(" + getAuthoringControlCriteria(tableRecordKey, dateTimeMockable) + ")";
//
//=====================================================================================================
/// <summary>
/// Clear the Approved Authoring Control
/// </summary>
/// <param name="ContentName"></param>
/// <param name="RecordID"></param>
/// <param name="authoringControl"></param>
/// <param name="MemberID"></param>
public static void clearAuthoringControl(CoreController core, string ContentName, int RecordID, AuthoringControls authoringControl, int MemberID)
{
try {
string Criteria = getAuthoringControlCriteria(core, ContentName, RecordID) + "And(ControlType=" + authoringControl + ")";
switch (authoringControl)
{
case AuthoringControls.Editing:
MetadataController.deleteContentRecords(core, "Authoring Controls", Criteria + "And(CreatedBy=" + DbController.encodeSQLNumber(MemberID) + ")", MemberID);
break;
case AuthoringControls.Submitted:
case AuthoringControls.Approved:
case AuthoringControls.Modified:
MetadataController.deleteContentRecords(core, "Authoring Controls", Criteria, MemberID);
break;
}
} catch (Exception ex) {
LogController.logError(core, ex);
throw;
}
}
