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); } }
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);