public void Alterar(ReservaAreaDeLazer reservaAreaDeLazer)
        {
            var parametros = new DynamicParameters();

            {
                parametros.Add("@IdReservaAreaDeLazer", reservaAreaDeLazer.Id);
                parametros.Add("@IdAreaDeLazer", reservaAreaDeLazer.IdAreaDeLazer);
                parametros.Add("@IdMorador", reservaAreaDeLazer.IdMorador);
                parametros.Add("@Descricao", reservaAreaDeLazer.Descricao);
                parametros.Add("@DataReserva", reservaAreaDeLazer.DataReserva);
                parametros.Add("@DataSolicitacao", reservaAreaDeLazer.DataSolicitacaoDoPedido);
                parametros.Add("@Status", StatusReserva.Reservado);
            }

            Connection.Execute("Update_ReservaAreaDeLazer", parametros, commandType: CommandType.StoredProcedure);
        }
        public void Inserir(ReservaAreaDeLazer reservaAreaDeLazer)
        {
            using (Connection = new SqlConnection(StringConnection))
            {
                var parametros = new DynamicParameters();
                {
                    parametros.Add("@IdAreaDeLazer", reservaAreaDeLazer.IdAreaDeLazer);
                    parametros.Add("@IdMorador", reservaAreaDeLazer.IdMorador);
                    parametros.Add("@Descricao", reservaAreaDeLazer.Descricao);
                    parametros.Add("@DataReserva", reservaAreaDeLazer.DataReserva);
                    parametros.Add("@DataSolicitacao", DateTime.Now);
                    parametros.Add("@Status", StatusReserva.Reservado);
                }

                Connection.Execute("Insert_ReservaAreaDeLazer", parametros, commandType: CommandType.StoredProcedure);
            }
        }
예제 #3
0
        protected void btnSolicitarPedido_OnClick(object sender, EventArgs e)
        {
            try
            {
                var reservaArea =
                    new ReservaAreaDeLazer
                {
                    IdAreaDeLazer           = Convert.ToInt32(ViewState["IdAreaDeLazer"]),
                    IdMorador               = Convert.ToInt32(Session["idMoradorUsuarioLogado"]),
                    DataReserva             = Convert.ToDateTime(txtDataReserva.Text).Date,
                    Descricao               = Convert.ToString(txtObservacao.Value),
                    DataSolicitacaoDoPedido = DateTime.Now
                };

                _reservaAreaDeLazerControl.InserirReservarAreaDeLazer(reservaArea);
                RedirecionaPagina();
            }
            catch (Exception exception)
            {
                _mensagens.MensagemDeExcessao(exception.Message, Page);
            }
        }
 public void AlterarReservaAreaDeLazer(ReservaAreaDeLazer reserva)
 => _reservaAreaRepositorio.Alterar(reserva);
 public void InserirReservarAreaDeLazer(ReservaAreaDeLazer reserva)
 => _reservaAreaRepositorio.Inserir(reserva);