public static int Create(string name, DateTime created, DateTime modified)
{
try
{
ExcelDataSet.WorkbooksRow row = Table.NewWorkbooksRow();
DateTime now = DateTime.Now;
row.Name = name;
row.Created = created;
row.Modified = modified;
row.Imported = now;
Table.AddWorkbooksRow(row);
if (!WorkBook_DAL.Update(Table))
{
return(Constants.Constants.UNDEFINED_ID);
}
return(row.Id);
}
catch
{
throw;
}
}
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 static bool Delete(int id)
{
try
{
ExcelDataSet.WorkbooksRow row = WorkBook_DAL.GetDataRow(id);
if (row == null)
{
return(true);
}
row.Delete();
return(WorkBook_DAL.Update(Table));
}
catch
{
throw;
}
}
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);
}
