public bool Save(int workbookId) { if (WorksheetRow == null) { Id = Worksheet_BLL.Create(Name, workbookId); WorksheetRow = WorkSheet_DAL.GetDataRow(Id); WorkbookId = WorksheetRow.WorkbookId; } foreach (KeyValuePair <int, string> kvp in Cells.Keys.ToList()) { Cell cell = Cells[kvp]; if (!cell.Save(Id)) { return(false); } if (!cell.Included) { Cells.Remove(kvp); } } return(Id != Constants.Constants.UNDEFINED_ID); }
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); } }