/// <summary>
/// Runs synchronously the cleanup content operation.
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="connectionString">The connection string.</param>
/// <param name="progress">Used to report the progress of the operation.</param>
public static void Go(string siteURL, string connectionString, ProgressChangedEventHandler progress)
{
Linq2SQL.IPRDEV _sqledc = Linq2SQL.IPRDEV.Connect2SQL(connectionString, progress);
progress(null, new ProgressChangedEventArgs(1, String.Format("Opening connection to: {0}", siteURL)));
using (Entities _spedc = new Entities(siteURL))
{
progress(null, new ProgressChangedEventArgs(1, String.Format("Starting CleanupContent. It could take several minutes")));
progress(null, new ProgressChangedEventArgs(1, "Buffering StockLib entries"));
List <StockLib> _slList = _spedc.StockLibrary.ToList <StockLib>();
progress(null, new ProgressChangedEventArgs(1, String.Format("There are {0} StockLib entries", _slList.Count)));
progress(null, new ProgressChangedEventArgs(1, "Buffering StockEntry entries"));
List <StockEntry> _stockEntryAll = _spedc.StockEntry.ToList <StockEntry>().ToList <StockEntry>();
List <StockEntry> _seToBeDeleted = _stockEntryAll.Where <StockEntry>(x => x.StockLibraryIndex == null).ToList <StockEntry>();
//Delete not associated StockEntries
progress(null, new ProgressChangedEventArgs(1, String.Format("There are {0} StockEntry to be deleted because they are not associated with StockLib.", _seToBeDeleted.Count <StockEntry>())));
_spedc.StockEntry.Delete <StockEntry, NSLinq2SQL.History>
(_seToBeDeleted, null, x => _sqledc.StockEntry.GetAt <NSLinq2SQL.StockEntry>(x), (id, listName) => _sqledc.ArchivingLogs.AddLog(id, listName, Extensions.UserName()),
siteURL, x => _sqledc.History.AddHistoryEntry(x));
Link2SQLExtensions.SubmitChanges(_spedc, _sqledc, progress);
_seToBeDeleted.Clear();
//Delete StockLib and associated StockEntry
List <StockLib> _slToBeDeleted = new List <StockLib>();
foreach (StockLib _selX in _slList)
{
if (_selX.Stock2JSOXLibraryIndex != null)
{
continue;
}
_slToBeDeleted.Add(_selX);
_seToBeDeleted.AddRange(_stockEntryAll.Where(x => x.StockLibraryIndex == _selX));
}
progress(null, new ProgressChangedEventArgs(1, String.Format("To be deleted {0} StockLib and associated {1} StockEntry entries.", _slToBeDeleted.Count, _seToBeDeleted.Count())));
_spedc.StockEntry.Delete <StockEntry, NSLinq2SQL.History>
(_seToBeDeleted, null, x => _sqledc.StockEntry.GetAt <NSLinq2SQL.StockEntry>(x), (id, listName) => _sqledc.ArchivingLogs.AddLog(id, listName, Extensions.UserName()),
siteURL, x => _sqledc.History.AddHistoryEntry(x));
_spedc.StockLibrary.Delete <StockLib, NSLinq2SQL.History>
(_slToBeDeleted, null, x => _sqledc.StockLibrary.GetAt <NSLinq2SQL.StockLibrary>(x), (id, listName) => _sqledc.ArchivingLogs.AddLog(id, listName, Extensions.UserName()),
siteURL, x => _sqledc.History.AddHistoryEntry(x));
Link2SQLExtensions.SubmitChanges(_spedc, _sqledc, progress);
//Update Activities Log
Linq2SQL.ArchivingOperationLogs.UpdateActivitiesLogs(_sqledc, Linq2SQL.ArchivingOperationLogs.OperationName.Cleanup, progress);
}
progress(null, new ProgressChangedEventArgs(1, String.Format("Opening connection to: {0}", siteURL)));
//Delete all not associated BatchMaterial
using (Entities _spedc = new Entities(siteURL))
{
progress(null, new ProgressChangedEventArgs(1, "Buffering Material entries"));
List <Material> _mtrl2BeDeleted = _spedc.Material.ToList <Material>();
_mtrl2BeDeleted = _mtrl2BeDeleted.Where <Material>(x => x.Material2BatchIndex == null && x.Disposal.ToList <Disposal>().Count == 0).ToList <Material>();
progress(null, new ProgressChangedEventArgs(1, String.Format("There are {0} Material entries to be deleted because they are not associated with Batch and Disposal.", _mtrl2BeDeleted.Count())));
_spedc.Material.Delete <Material, NSLinq2SQL.History>
(_mtrl2BeDeleted, null, x => _sqledc.Material.GetAt <NSLinq2SQL.Material>(x), (id, listName) => _sqledc.ArchivingLogs.AddLog(id, listName, Extensions.UserName()),
siteURL, x => _sqledc.History.AddHistoryEntry(x));
Link2SQLExtensions.SubmitChanges(_spedc, _sqledc, progress);
}
progress(null, new ProgressChangedEventArgs(1, "Finished Cleanup Content Operation."));
}