private void Form1_Load(object sender, EventArgs e)
{
dtpHorarioSessao.Format = DateTimePickerFormat.Time;
FilmeDominio objBus = new FilmeDominio();
cbGenero.DataSource = objBus.listarGeneros();
cbGenero.ValueMember = "gen_id";
cbGenero.DisplayMember = "gen_filme";
cbFilmes.DataSource = objBus.listarFilmes();
cbFilmes.ValueMember = "fil_id";
cbFilmes.DisplayMember = "fil_titulo";
cbSalas.DataSource = objBus.listarSalas();
cbSalas.ValueMember = "sal_id";
cbSalas.DisplayMember = "sal_desc";
dgvSessoes.DataSource = objBus.listarSessoes();
dgvSessoes.Columns[0].Visible = false;
dgvSessoes.Columns[6].Visible = false;
dgvSessoes.Columns[1].HeaderText = "Numero da sala";
dgvSessoes.Columns[2].HeaderText = "Hora";
dgvSessoes.Columns[3].HeaderText = "Data";
dgvSessoes.Columns[4].HeaderText = "Qtd de lugares";
dgvSessoes.Columns[5].HeaderText = "Id do filme";
}
private void btnAlterarSessao_Click(object sender, EventArgs e)
{
FilmeDominio objdom = new FilmeDominio();
Sessoes sess = new Sessoes();
sess.ses_data = dtpDataSessao.Value;
sess.ses_horario = TimeSpan.Parse(dtpHorarioSessao.Value.ToShortTimeString());
sess.ses_idFilme = int.Parse(cbFilmes.SelectedValue.ToString());
sess.ses_num = int.Parse(cbSalas.SelectedValue.ToString());
sess.ses_qtdLugares = objdom.retornarSala(int.Parse(cbSalas.SelectedValue.ToString())).sal_qtdcadeira;
sess.ses_id = idSessao;
objdom.alterarSessao(sess);
MessageBox.Show("Sessao Alterada !");
limparTextBoxEMasked(tabPage2);
dgvSessoes.DataSource = objdom.listarSessoes();
dgvSessoes.Columns[0].Visible = false;
dgvSessoes.Columns[6].Visible = false;
dgvSessoes.Columns[1].HeaderText = "Numero da sala";
dgvSessoes.Columns[2].HeaderText = "Hora";
dgvSessoes.Columns[3].HeaderText = "Data";
dgvSessoes.Columns[4].HeaderText = "Qtd de lugares";
dgvSessoes.Columns[5].HeaderText = "Id do filme";
idSessao = 0;
}
