public void loadActiveContracts()
{
contractLesseesflowLayoutPanel.Controls.Clear();
int sp = 3;
int ep = 3;
try
{
_cc.getActiveContracts();
foreach (DataRow row in _cc.QueryExe().Rows)
{
Button b = new Button();
b.Name = row["lessee_id"].ToString();
b.Text = row["l_lastname"].ToString() + " ," + row["l_firstname"].ToString();
b.Location = new Point(sp, ep);
b.Height = 41;
b.Width = 210;
b.FlatStyle = FlatStyle.Popup;
b.BackColor = SystemColors.Control;
contractLesseesflowLayoutPanel.Controls.Add(b);
ep += 10;
b.Click += delegate(object sender, EventArgs evt) { btn_Click(sender, evt, row); };
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void displayTermidatedContracts()
{
_cc.terminatedContracts();
terminatedListDataGridView.DataSource = _cc.QueryExe();
terminatedListDataGridView.Columns[0].Width = 250;
terminatedListDataGridView.Columns[1].Width = 250;
terminatedListDataGridView.Columns[2].Width = 250;
terminatedListDataGridView.Columns[4].Width = 200;
terminatedListDataGridView.Columns[9].Width = 200;
}
private void displayContracts(string status)
{
stallNumberCbx.SelectedIndex = -1;
_status = status;
_cc.getContracts(_status);
contractListDataGridView.DataSource = _cc.QueryExe();
contractListDataGridView.Columns[0].Width = 150;
contractListDataGridView.Columns[1].Width = 150;
contractListDataGridView.Columns[2].Width = 250;
contractListDataGridView.Columns[3].Width = 250;
contractListDataGridView.Columns[4].Width = 200;
contractListDataGridView.Columns[9].Width = 200;
contractListDataGridView.Columns[10].Width = 250;
}
public void clearPanelAndLoad()
{
stallNumberflowLayoutPanel.Controls.Clear();
int sp = 11;
int ep = 17;
try
{
_cc.getPendingLesseeRentedStalls(lesseeId);
foreach (DataRow row in _cc.QueryExe().Rows)
{
Button b = new Button();
b.Name = row["stallId"].ToString();
b.Text = row["stall_number"].ToString();
b.Location = new Point(sp, ep);
b.Height = 50;
b.Width = 90;
stallNumberflowLayoutPanel.Controls.Add(b);
ep += 10;
b.Click += delegate(object s, EventArgs evt) { btn_Click(s, evt, row); };
}
_cc.closeConn();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
