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