public static bool Update(ExcelDataSet.WorksheetsRow row) { try { WorksheetsTableAdapter adapter = new WorksheetsTableAdapter(); adapter.Update(row); return(true); } catch { throw; } }
public static bool Delete(int id) { try { ExcelDataSet.WorksheetsRow row = WorkSheet_DAL.GetDataRow(id); if (row == null) { return(true); } row.Delete(); return(WorkSheet_DAL.Update(Table)); } catch { throw; } }
public static int Create(string name, int workbookId) { try { ExcelDataSet.WorksheetsRow row = Table.NewWorksheetsRow(); row.Name = name; row.WorkbookId = workbookId; Table.AddWorksheetsRow(row); if (!WorkSheet_DAL.Update(Table)) { return(Constants.Constants.UNDEFINED_ID); } return(row.Id); } catch { throw; } }