public WorkBook(int id) { WorkbookRow = WorkBook_DAL.GetDataRow(id); Id = id; Name = WorkbookRow.Name; Size = 0; Created = WorkbookRow.Created; Modified = WorkbookRow.Modified; Imported = WorkbookRow.Imported; WorkSheets = new Dictionary <string, WorkSheet>(); foreach (int worksheetId in Worksheet_BLL.Worksheets(Id)) { WorkSheet workSheet = new WorkSheet(worksheetId); WorkSheets.Add(workSheet.Name, workSheet); } }
public bool Save() { if (WorkbookRow == null) { Id = Workbook_BLL.Create(Name, Created, Modified); WorkbookRow = WorkBook_DAL.GetDataRow(Id); Imported = WorkbookRow.Imported; } foreach (string wsName in WorkSheets.Keys) { WorkSheet worksheet = WorkSheets[wsName]; worksheet.Save(Id); // Delete all worksheets those are empty if (worksheet.Cells.Count == 0) { WorkSheets.Remove(wsName); } } return(Id != Constants.Constants.UNDEFINED_ID); }