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 static bool Update(ExcelDataSet.WorkbooksRow row)
{
try
{
WorkbooksTableAdapter adapter = new WorkbooksTableAdapter();
adapter.Update(row);
return(true);
}
catch
{
throw;
}
}
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;
}
}
