private void CarregarGridAlunoParaConsulta()
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
dgvaluno.AutoGenerateColumns = false;
dgvaluno.DataSource = reservaBusiness.ConsultarReservadoLocatarioPorNomeAluno(txtfiltraraluno.Text);
}
private void CarregarGridLocatarioParaConsulta()
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
dgvReserva.AutoGenerateColumns = false;
dgvReserva.DataSource = reservaBusiness.ConsultarReservadoLocatarioPorNome(txtlocatario.Text);
}
private void CarregarGridAluno()
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
dgvaluno.AutoGenerateColumns = false;
dgvaluno.DataSource = reservaBusiness.ListaReservadoAluno();
}
private void CarregarGridLocatario()
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
dgvReserva.AutoGenerateColumns = false;
dgvReserva.DataSource = reservaBusiness.ListaReservadoLocatario();
}
private void CarregarGridpornomeLivroAluno()
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
dgvaluno.AutoGenerateColumns = false;
dgvaluno.DataSource = reservaBusiness.ConsultarPornomedoLivroAluno(txtlivroaluno.Text);
txtfiltraraluno.Text = string.Empty;
}
private void CarregarGridpornomedoLivroLocatario()
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
dgvReserva.AutoGenerateColumns = false;
dgvReserva.DataSource = reservaBusiness.ConsultarPornomedoLivroLocatario(txtnomelivro.Text);
txtnomelivro.Text = string.Empty;
}
private void RemoverAluno()
{
vw_reserva_aluno removeraluno = dgvaluno.CurrentRow.DataBoundItem as vw_reserva_aluno;
ReservaBusiness reserva = new ReservaBusiness();
reserva.RemoverDados(removeraluno.id_reserva);
CarregarGridAluno();
MessageBox.Show("Remoção realizada com sucesso.", "Biblioteca", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void cargarGrillaAsistio()
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
dgvAsistio.DataSource = reservaBusiness.listarReservas(3);
dgvAsistio.Columns["idreserva"].Visible = false;
dgvAsistio.Columns["estado"].Visible = false;
dgvAsistio.Columns["fechahora"].HeaderText = "Fecha de Reserva";
dgvAsistio.Columns["numeromesa"].HeaderText = "Numero de Mesa";
dgvAsistio.Columns["mozoasignado"].HeaderText = "Mozo Asignado";
dgvAsistio.Columns["hora"].HeaderText = "Hora";
dgvAsistio.Columns["minutos"].HeaderText = "Minutos";
}
private void txtBuscarMozo_TextChanged(object sender, EventArgs e)
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
string busqueda = txtBuscarMozo.Text.Trim();
try
{
dgvReservas.DataSource = reservaBusiness.listarMozo(busqueda);
}
catch (Exception ex)
{
throw ex;
}
}
private void SalvarDadosAlunos()
{
tb_reserva dto = new tb_reserva();
if (rdnaluno.Checked == true)
{
tb_livro livro = cbolivro.SelectedItem as tb_livro;
dto.tb_livro_id_livro = livro.id_livro;
//dto.tb_locatario_id_locatario = idlocatario;
dto.tb_turma_aluno_id_turma_aluno = idaluno;
dto.dt_reserva = DateTime.Now;
ReservaBusiness reserva = new ReservaBusiness();
reserva.SalvarReserva(dto);
}
}
public static RetornoIncluirReservaDto MapperToIncluirDto(Int32 codigo)
{
Int32 _codigo;
Int32.TryParse(codigo.ToString(), out _codigo);
if (codigo == 0)
{
return(null);
}
return(new RetornoIncluirReservaDto()
{
Codigo = codigo,
Mensagem = ReservaBusiness.MensagemRetorno(codigo)
});
}
private void btnCancelar_Click(object sender, EventArgs e)
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
try
{
if (MessageBox.Show("Esta seguro de cancelar la reserva?", "Cerrar", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Reserva reserva = (Reserva)dgvReservas.CurrentRow.DataBoundItem;
reservaBusiness.cancelarReserva(Convert.ToString(reserva.idreserva), 0);
cargarGrilla();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void iniciar()
{
MesaBusiness mesaBusiness = new MesaBusiness();
MozoBusiness mozoxmesaBusiness = new MozoBusiness();
UsuarioBusiness usuarioBusiness = new UsuarioBusiness();
ReservaBusiness reservaBusiness = new ReservaBusiness();
Form cargar = new Bienvenida();
reservaBusiness.verificarReservasHorarios();
cargar.ShowDialog();
btnCerrarSesion.Enabled = false;
btnFacturacion.Enabled = false;
btnInsumos.Enabled = false;
btnUsuarios.Enabled = false;
btnMesas.Enabled = false;
btnReserva.Enabled = false;
timer1.Start();
cmbUsuario.DisplayMember = "usuario";
cmbUsuario.DataSource = usuarioBusiness.leerUsuarios();
}
private void btnReservar_Click(object sender, EventArgs e)
{
ReservaBusiness reservaBusiness = new ReservaBusiness();
Reserva reserva = new Reserva();
int hora = Convert.ToInt32(DateTime.Now.ToString("HH"));
int minutos = Convert.ToInt32(DateTime.Now.ToString("mm"));
if (string.IsNullOrEmpty(cmbCliente.Text) || string.IsNullOrEmpty(cmbHora.Text) || string.IsNullOrEmpty(cmbMesas.Text) && string.IsNullOrEmpty(cmbMinutos.Text) || string.IsNullOrEmpty(cmbMozo.Text))
{
MessageBox.Show("No debe dejar campos sin completar");
return;
}
else
{
reserva.cliente = cmbCliente.SelectedItem.ToString();
reserva.fechahora = Convert.ToDateTime(dtpReserva.Value.ToShortDateString());
reserva.mozoasignado = cmbMozo.SelectedItem.ToString();
reserva.numeromesa = Convert.ToInt32(cmbMesas.SelectedItem.ToString());
reserva.hora = Convert.ToInt32(cmbHora.SelectedItem);
reserva.minutos = Convert.ToInt32(cmbMinutos.SelectedItem);
if (hora > Convert.ToInt32(reserva.hora) && minutos > Convert.ToInt32(reserva.minutos) && reserva.fechahora.Equals(DateTime.Today))
{
MessageBox.Show("El horario no puede ser menor a la hora actual");
return;
}
if (reservaBusiness.verificarReserva(reserva.numeromesa, reserva.fechahora, reserva.hora, reserva.minutos) == 1)
{
MessageBox.Show("No se puede realizar la reserva, mesa ya ocupada en ese horario y fecha");
}
else
{
reservaBusiness.guardarReserva(reserva);
MessageBox.Show("Reserva realizada con éxito!");
}
}
}
public ReservaController()
{
_veiculoBLL = new VeiculoBusiness();
_reservaBLL = new ReservaBusiness();
}
public ListagemAluguelController()
{
_reservaBusiness = new ReservaBusiness();
}
