private void OnDataChanged(object sender, System.EventArgs e)
{
IDataMigrationView view = base._view as IDataMigrationView;
IDataMigrationModel model = base._model as IDataMigrationModel;
PresenterBase.SetModelPropertiesFromView <IDataMigrationModel, IDataMigrationView>(
ref model, view
);
}
protected override void Initialize()
{
IDataMigrationView view = base._view as IDataMigrationView;
IDataMigrationModel model = base._model as IDataMigrationModel;
PresenterBase.SetViewPropertiesFromModel <IDataMigrationView, IDataMigrationModel>(
ref view, model
);
}
protected override void UnWireViewEvents()
{
if (IsViewEventsWired)
{
IDataMigrationView view = base._view as IDataMigrationView;
view.DataChanged -= OnDataChanged;
view.CommandDisplayContent -= OnCommandDisplayContent;
view.CommandExportContent -= OnCommandExportContent;
view.CommandExportContentExcel -= OnCommandExportContentExcel;
IsViewEventsWired = false;
}
}
protected override void WireViewEvents()
{
if (!IsViewEventsWired)
{
IDataMigrationView view = base._view as IDataMigrationView;
view.DataChanged += OnDataChanged;
view.CommandDisplayContent += OnCommandDisplayContent;
view.CommandExportContent += OnCommandExportContent;
view.CommandExportContentExcel += OnCommandExportContentExcel;
IsViewEventsWired = true;
}
}
private void OnCommandDisplayContent(object sender, System.EventArgs e)
{
IDataMigrationView view = base._view as IDataMigrationView;
IDataMigrationModel model = base._model as IDataMigrationModel;
IList <ContentDisplayListViewItemModel> items = model.Contents;
if (items != null)
{
IMainPresenter presenter = SimpleResolver.Instance.Get <IMainPresenter>();
// lock UI
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.EnableControl(false);
presenter.ActivateSpinner(true);
presenter.UpdateProgressInfo("Searching...");
}, null);
}
Thread search = new Thread(() => {
TimerUtils util = new TimerUtils();
util.Start();
if (string.IsNullOrEmpty(model.AccessToken))
{
presenter.ShowErrorMessage(ErrorMessages.INVALID_TOKEN, ErrorMessages.DLG_DEFAULT_TITLE);
presenter.UpdateProgressInfo("");
presenter.ActivateSpinner(false);
presenter.EnableControl(true);
}
else
{
MemberServices service = new MemberServices(ApplicationResource.BaseUrl, ApplicationResource.ApiVersion);
// search all owners first.
IList <TeamListViewItemModel> owners = SearchOwner(model, presenter);
model.Contents.Clear(); // clear existing contents
Parallel.ForEach(owners, (owner) =>
{
if (SyncContext != null)
{
SyncContext.Post(delegate
{
presenter.UpdateProgressInfo(string.Format("Retrieving Owner's Content: {0}", owner.Email));
}, null);
}
SearchItems(service, owner, model, presenter);
});
// compute folder size.
if (SyncContext != null)
{
SyncContext.Post(delegate
{
presenter.UpdateProgressInfo(string.Format("Sorting Data..."));
}, null);
}
// sort by email then by folder path
model.Contents = model.Contents.OrderBy(s => s.Email).ThenBy(s => s.ItemPathDisplay).ToList();
ContentDisplayListViewItemModel currentFolderSelected = null;
foreach (ContentDisplayListViewItemModel lvItem in model.Contents)
{
if (lvItem.ItemType.ToLower().Equals("folder"))
{
if (currentFolderSelected != null)
{
// had previously selected folder.
currentFolderSelected.ItemSize = FileUtil.FormatFileSize(currentFolderSelected.ItemSizeByte);
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.UpdateProgressInfo(string.Format("Calculating Folder Size: {0}", currentFolderSelected.ItemName));
}, null);
}
}
currentFolderSelected = lvItem;
}
else if (lvItem.ItemType.ToLower().Equals("file"))
{
if (currentFolderSelected != null)
{
currentFolderSelected.ItemSizeByte += lvItem.ItemSizeByte;
}
}
}
}
if (SyncContext != null)
{
TimeSpan diff = util.Stop();
SyncContext.Post(delegate {
// update result and update view.
PresenterBase.SetViewPropertiesFromModel <IDataMigrationView, IDataMigrationModel>(
ref view, model
);
view.RenderContentSearchResult();
view.EnableExportControl(true);
presenter.UpdateProgressInfo(
string.Format("Completed. Total Content Count: {0} Elapsed Time: {1}", model.Contents.Count, TimerUtils.ToTimeStamp(diff))
);
presenter.ActivateSpinner(false);
presenter.EnableControl(true);
}, null);
}
});
search.Start();
}
}
private void OnCommandExportContentExcel(object sender, EventArgs e)
{
// Export to Excel
IDataMigrationView view = base._view as IDataMigrationView;
IDataMigrationModel model = base._model as IDataMigrationModel;
PresenterBase.SetModelPropertiesFromView <IDataMigrationModel, IDataMigrationView>(
ref model, view
);
IMainPresenter presenter = SimpleResolver.Instance.Get <IMainPresenter>();
try
{
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.EnableControl(false);
presenter.ActivateSpinner(true);
presenter.UpdateProgressInfo("Preparing Report...");
}, null);
}
FileInfo fileInfo = new FileInfo(model.OutputFileName);
if (Directory.Exists(fileInfo.DirectoryName))
{
Thread writeReportExcel = new Thread(() => {
int total = model.Contents.Count;
//set max rows per sheet to 1 million. Actual number Excel pukes on is anything over 1,048,576
int maxRowsPerSheet = 1000000;
int sheetCount = 1;
int modelStartRow = 0;
int modelEndRow = 1;
int totalRowsLeft = 0;
bool complete = false;
//get inital rows left
totalRowsLeft = model.Contents.Count - maxRowsPerSheet;
//round up for number of sheets based on rowcount
int totalSheets = Convert.ToInt32(Math.Ceiling((double)total / (double)maxRowsPerSheet));
Excel.Application xlApp = new Excel.Application();
xlApp.DisplayAlerts = false;
//Give error if Excel not installed on system
if (xlApp == null)
{
SyncContext.Post(delegate
{
presenter.EnableControl(true);
presenter.ActivateSpinner(false);
presenter.UpdateProgressInfo(ErrorMessages.EXCEL_MISSING);
}, null);
return;
}
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet = null;
object misValue = Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue);
//need code to add extra worksheets, based on how many rows we have above
Excel.Sheets worksheets = xlWorkBook.Worksheets;
while (!complete)
{
while (sheetCount <= totalSheets)
{
var xlNewSheet = (Excel.Worksheet)worksheets.Add(worksheets[sheetCount], Type.Missing, Type.Missing, Type.Missing);
xlNewSheet.Name = sheetCount.ToString();
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(sheetCount);
//write headers
xlWorkSheet.Cells[1, 1] = "Owner Name";
xlWorkSheet.Cells[1, 2] = "Owner Login";
xlWorkSheet.Cells[1, 3] = "Path";
xlWorkSheet.Cells[1, 4] = "Path ID";
xlWorkSheet.Cells[1, 5] = "Item Name";
xlWorkSheet.Cells[1, 6] = "Item ID";
xlWorkSheet.Cells[1, 7] = "Item Type";
xlWorkSheet.Cells[1, 8] = "Size";
xlWorkSheet.Cells[1, 9] = "Created";
xlWorkSheet.Cells[1, 10] = "Last Modified";
xlWorkSheet.Cells[1, 11] = "Uploaded";
int endRow = 0;
//over 1 million rows, setting values for output to Excel sheets
if (totalRowsLeft > 0 && totalRowsLeft > maxRowsPerSheet)
{
endRow = endRow + maxRowsPerSheet;
}
if (totalRowsLeft > 0 && totalRowsLeft < maxRowsPerSheet)
{
endRow = endRow + totalRowsLeft;
}
modelEndRow = modelEndRow + endRow;
if (modelEndRow < model.Contents.Count)
{
modelEndRow--;
}
if (modelEndRow > model.Contents.Count)
{
modelEndRow = model.Contents.Count;
}
//we only need one sheet
if (totalRowsLeft < 0)
{
modelEndRow = model.Contents.Count;
}
//start at 1 for each sheet so we can increment past header row
int rowCount = 1;
for (int i2 = modelStartRow; i2 < modelEndRow; i2++)
{
ContentDisplayListViewItemModel lvItem = model.Contents[i2];
rowCount++;
endRow++;
xlWorkSheet.Cells[rowCount, 1] = (!string.IsNullOrEmpty(lvItem.OwnerName) ? lvItem.OwnerName : "");
xlWorkSheet.Cells[rowCount, 2] = (lvItem.Email);
xlWorkSheet.Cells[rowCount, 3] = (lvItem.ItemPathDisplay);
xlWorkSheet.Cells[rowCount, 4] = (!string.IsNullOrEmpty(lvItem.ItemPathId) ? lvItem.ItemPathId : "");
xlWorkSheet.Cells[rowCount, 5] = (lvItem.ItemName);
xlWorkSheet.Cells[rowCount, 6] = (!string.IsNullOrEmpty(lvItem.ItemId) ? lvItem.ItemId : "");
xlWorkSheet.Cells[rowCount, 7] = (lvItem.ItemType);
xlWorkSheet.Cells[rowCount, 8] = (!string.IsNullOrEmpty(lvItem.ItemSize) ? lvItem.ItemSize : "");
xlWorkSheet.Cells[rowCount, 9] = (!string.IsNullOrEmpty(lvItem.Created) ? lvItem.Created : "");
xlWorkSheet.Cells[rowCount, 10] = (!string.IsNullOrEmpty(lvItem.LastModified) ? lvItem.LastModified : "");
xlWorkSheet.Cells[rowCount, 11] = (!string.IsNullOrEmpty(lvItem.Uploaded) ? lvItem.Uploaded : "");
if (SyncContext != null)
{
SyncContext.Post(delegate
{
presenter.UpdateProgressInfo(string.Format("Writing Record: {0}/{1}", (i2 + 1), total));
}, null);
}
}
//move one row count to make up for the header row
modelEndRow++;
modelStartRow = modelEndRow;
modelStartRow--;
sheetCount++;
//are we done?
if (modelEndRow >= model.Contents.Count)
{
complete = true;
}
}
}
//delete default sheet and save to output file name specified in UI
xlWorkBook.Sheets["Sheet1"].Delete();
xlWorkBook.SaveAs(model.OutputFileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue,
Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
//release all resources
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
Marshal.ReleaseComObject(xlWorkSheet);
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.EnableControl(true);
presenter.ActivateSpinner(false);
presenter.UpdateProgressInfo("Completed");
}, null);
}
});
writeReportExcel.Start();
}
else
{
throw new InvalidDataException(ErrorMessages.INVALID_EXPORT_FOLDER);
}
}
catch (Exception ex)
{
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.EnableControl(true);
presenter.ActivateSpinner(false);
presenter.UpdateProgressInfo("Completed with exception: " + ex.Message);
}, null);
}
}
}
private void OnCommandExportContent(object sender, EventArgs e)
{
// Export to CSV
IDataMigrationView view = base._view as IDataMigrationView;
IDataMigrationModel model = base._model as IDataMigrationModel;
PresenterBase.SetModelPropertiesFromView <IDataMigrationModel, IDataMigrationView>(
ref model, view
);
IMainPresenter presenter = SimpleResolver.Instance.Get <IMainPresenter>();
try
{
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.EnableControl(false);
presenter.ActivateSpinner(true);
presenter.UpdateProgressInfo("Preparing Report...");
}, null);
}
FileInfo fileInfo = new FileInfo(model.OutputFileName);
if (Directory.Exists(fileInfo.DirectoryName))
{
Thread writeReport = new Thread(() => {
CsvConfiguration config = new CsvConfiguration()
{
HasHeaderRecord = true,
Delimiter = ",",
Encoding = System.Text.Encoding.UTF8
};
config.RegisterClassMap(new DataMigrationHeaderMap());
int total = model.Contents.Count;
using (CsvWriter writer = new CsvWriter(new StreamWriter(model.OutputFileName), config))
{
writer.WriteHeader <DataMigrationHeaderRecord>();
for (int i = 0; i < model.Contents.Count; i++)
{
ContentDisplayListViewItemModel lvItem = model.Contents[i];
writer.WriteField <string>(!string.IsNullOrEmpty(lvItem.OwnerName) ? lvItem.OwnerName : "");
writer.WriteField <string>(lvItem.Email);
writer.WriteField <string>(lvItem.ItemPathDisplay);
writer.WriteField <string>(!string.IsNullOrEmpty(lvItem.ItemPathId) ? lvItem.ItemPathId : "");
writer.WriteField <string>(lvItem.ItemName);
writer.WriteField <string>(!string.IsNullOrEmpty(lvItem.ItemId) ? lvItem.ItemId : "");
writer.WriteField <string>(lvItem.ItemType);
writer.WriteField <string>(!string.IsNullOrEmpty(lvItem.ItemSize) ? lvItem.ItemSize : "");
writer.WriteField <string>(!string.IsNullOrEmpty(lvItem.Created) ? lvItem.Created : "");
writer.WriteField <string>(!string.IsNullOrEmpty(lvItem.LastModified) ? lvItem.LastModified : "");
writer.WriteField <string>(!string.IsNullOrEmpty(lvItem.Uploaded) ? lvItem.Uploaded : "");
writer.NextRecord();
if (SyncContext != null)
{
SyncContext.Post(delegate
{
presenter.UpdateProgressInfo(string.Format("Writing Record: {0}/{1}", (i + 1), total));
}, null);
}
}
}
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.EnableControl(true);
presenter.ActivateSpinner(false);
presenter.UpdateProgressInfo("Completed");
}, null);
}
});
writeReport.Start();
}
else
{
throw new InvalidDataException(ErrorMessages.INVALID_EXPORT_FOLDER);
}
}
catch (Exception ex)
{
if (SyncContext != null)
{
SyncContext.Post(delegate {
presenter.EnableControl(true);
presenter.ActivateSpinner(false);
presenter.UpdateProgressInfo("Completed with exception: " + ex.Message);
}, null);
}
}
}
public DataMigrationPresenter(IDataMigrationModel model, IDataMigrationView view)
: base(model, view)
{
}
public DataMigrationPresenter(IDataMigrationModel model, IDataMigrationView view)
: base(model, view) {
}
