public UserForm()
{
InitializeComponent();
th = new Theatre(db);
custormer = new Customer(dg_tickets);
btn_cupon.Click += new EventHandler(cuponClick);
try
{
cmd = new SQLiteCommand("Select * from ELOADASOK", db.GetConnecton());
sda = new SQLiteDataAdapter(cmd);
sda.Fill(dt);
foreach (DataRow row in dt.Rows)
{
int id = int.Parse(row[0].ToString());
String date = row[1].ToString();
String name = row[2].ToString();
Play p = new Play(id, date, name);
listofPlays.Add(p);
cmb_eloadasok.Items.Add(p.printOut());
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.StackTrace);
}
}
public AdminForm()
{
InitializeComponent();
th = new Theatre(db);
try
{
dt = new DataTable();
cmd = new SQLiteCommand("Select * from ELOADASOK", db.GetConnecton());
sda = new SQLiteDataAdapter(cmd);
sda.Fill(dt);
foreach (DataRow row in dt.Rows)
{
int id = int.Parse(row[0].ToString());
String date = row[1].ToString();
String name = row[2].ToString();
Play p = new Play(id, date, name);
listofPlays.Add(p);
cmb_eloadasok.Items.Add(p.printOut());
}
dt = new DataTable();
cmd = new SQLiteCommand(
"SELECT id, ertek FROM KEDVEZMENYEK ", db.GetConnecton()
);
sda = new SQLiteDataAdapter(cmd);
sda.Fill(dt);
foreach (DataRow r in dt.Rows)
{
int id = int.Parse(r[0].ToString());
int dsc = int.Parse(r[1].ToString());
discounts.Add(id, dsc);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.StackTrace);
}
}