public void export() { string file = @"D:\sem2\Result"; SpectacoleDao spectacol = new SpectacoleDao(); DataSet ds = new DataSet(); DataTable spectacoleTable = spectacol.read(); Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("first"); for (int i = 0; i < spectacoleTable.Columns.Count; i++) { worksheet.Cells[0, i] = new Cell(spectacoleTable.Columns[i].ColumnName); // Populate row data for (int j = 0; j < spectacoleTable.Rows.Count; j++) { worksheet.Cells[j + 1, i] = new Cell(spectacoleTable.Rows[j][i]); } } workbook.Worksheets.Add(worksheet); workbook.Save(file); }
public void updateBL(String titlu, String regia, String distributia, String data, Int32 numarbilete) { SpectacoleDao spectacol = new SpectacoleDao(); spectacol.update(titlu, regia, distributia, data, numarbilete); }
public void deleteBL(String titlu) { SpectacoleDao spectacol = new SpectacoleDao(); spectacol.delete(titlu); }
public DataTable readBL() { SpectacoleDao spectacol = new SpectacoleDao(); return(spectacol.read()); }