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);
}
}
