public Task MoveRow(int fromRow, int toRow, bool active)
{
LastEditedDateTime = DateTime.Now;
TaskSheet sheet = GetSheet(active);
return(sheet.MoveRow(ProjectIndex(fromRow), ProjectIndex(toRow)));
}
private void OpenProjectXLSX()
{
FileInfo file = new FileInfo(FullPath);
ExcelPackage excelPackage = new ExcelPackage(file);
activeSheet = new TaskSheet(excelPackage, ACTIVE_SHEET_NAME, true);
inactiveSheet = new TaskSheet(excelPackage, INACTIVE_SHEET_NAME, false);
config = new ConfigSheet(excelPackage);
}
private void OpenProjectXML()
{
try
{
MSExcel2003XmlFile xmlFile = new MSExcel2003XmlFile(FullPath);
activeSheet = new TaskSheet(xmlFile, ACTIVE_SHEET_NAME, isActive: true);
inactiveSheet = new TaskSheet(xmlFile, INACTIVE_SHEET_NAME, isActive: false);
config = new ConfigSheet(xmlFile);
}
catch
{
CreateNewProject();
return;
}
}
public StatusChangeResult UpdateStatus(int row, string status, bool active)
{
LastEditedDateTime = DateTime.Now;
TaskSheet selectedSheet = GetSheet(active);
TaskSheet otherSheet = GetSheet(!active);
StatusChangeResult result = selectedSheet.UpdateStatus(ProjectIndex(row), status, config.ActiveStatuses);
if (result.ActiveInactiveChanged)
{
Task task = selectedSheet.GetTask(ProjectIndex(row));
task.DoneDate = DateTime.Now;
otherSheet.InsertTask(0, task);
selectedSheet.RemoveTask(ProjectIndex(row));
}
return(result);
}
private void CreateNewProject()
{
config = new ConfigSheet();
activeSheet = new TaskSheet(isActive: true);
inactiveSheet = new TaskSheet(isActive: false);
}