public async Task <ActionResult <reserva> > Postreserva(reserva reserva)
{
_context.reservas.Add(reserva);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getreserva", new { id = reserva.ReservaId }, reserva));
}
public void EliminarReserva(string codigoreserva)
{
reserva reserva = ObtenerReserva(codigoreserva);
db.reservas.Remove(reserva);
db.SaveChanges();
}
public int Crear(ReservaModel obj)
{
{
try
{
var entidad = new reserva();
entidad.idhabitacion = obj.idhabitacion;
entidad.idcliente = obj.idcliente;
entidad.fecha = obj.fecha;
entidad.numdias = generarNumdias(obj.fecha, obj.fechaout);
entidad.fechaout = obj.fechaout;
var habitacion = obtHabitacion(obj.idhabitacion);
entidad.total = generarTotal(habitacion.valordia, generarNumdias(obj.fecha, obj.fechaout));
entidad.estado = 0;
db.reserva.AddOrUpdate(entidad);
db.SaveChanges();
return(entidad.idreserva);
}
catch (Exception exe)
{
return(0);
}
}
}
public ActionResult Index(ReservaHab model)
{
DataClasses1DataContext db = new DataClasses1DataContext();
reserva reserr = new reserva();
System.Guid id = System.Guid.Parse((System.Web.Security.Membership.GetUser(User.Identity.Name).ProviderUserKey).ToString());
reserr.idusuario = id;
var cliiii = 0;
if (model.tipocli2 == 1)
{
db.personas.Where(a => (a.cliente.nombre + " " + a.apellido).ToString() == model.buscarpersona.ToString()).Select(a => a.id).First();
}
if (model.tipocli2 == 2)
{
db.empresas.Where(a => a.cliente.nombre.ToString() == model.buscarempresa.ToString()).Select(a => a.id).First();
}
if (model.tipocli2 == 3)
{
db.agencias.Where(a => a.cliente.nombre.ToString() == model.buscaragencia.ToString()).Select(a => a.id).First();
}
reserr.idcli = cliiii;
reserr.idHab = model.idhab;
string ini = model.Fecha_I.Substring(3, 3) + model.Fecha_I.Substring(0, 3) + model.Fecha_I.Substring(6, 4);
string fin = model.Fecha_F.Substring(3, 3) + model.Fecha_F.Substring(0, 3) + model.Fecha_F.Substring(6, 4);
reserr.fecha_ini = DateTime.Parse(ini);
reserr.fecha_fin = DateTime.Parse(fin);
reserr.estado = "pendiente";
var ppago = db.habitacions.Where(a => a.numero == model.idhab).Select(a => a.precio).First();
reserr.pago = ppago * model.CantD;
db.reservas.InsertOnSubmit(reserr);
db.SubmitChanges();
return View();
}
public void cadastrarReserva(reserva reserva)
{
BancoDeDados banco = new BancoDeDados();
banco.reserva.Add(reserva);
banco.SaveChanges();
}
public async Task <IActionResult> Putreserva(int id, reserva reserva)
{
if (id != reserva.ReservaId)
{
return(BadRequest());
}
_context.Entry(reserva).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!reservaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IHttpActionResult> Putreserva(int id, reserva reserva)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != reserva.idReserva)
{
return(BadRequest());
}
db.Entry(reserva).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!reservaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static bool Salvar(ReservaModel obj)
{
irt_bibEntities db = new irt_bibEntities();
reserva reservaObj = db.reserva.FirstOrDefault(x => x.res_id_reserva == obj.idReserva) ?? new reserva();
reservaObj.res_id_reserva = obj.idReserva;
reservaObj.res_id_livro = obj.idLivro;
reservaObj.res_ds_usuario = obj.nomeUsuario;
reservaObj.res_dt_entrega = Convert.ToDateTime(obj.dataEntrega);
if (Convert.ToDateTime(obj.dataEntrega).Date <= DateTime.Now.Date)
{
throw new Exception("A data da entrega deve maior do que a data de hoje.");
}
if (db.reserva.Any(x => x.res_id_livro == obj.idLivro))
{
throw new Exception("Este livro ja foi reservado.");
}
if (reservaObj.res_id_reserva > 0)
{
db.reserva.Attach(reservaObj);
db.Entry(reservaObj).State = EntityState.Modified;
}
else
{
db.reserva.Add(reservaObj);
}
bool result = db.SaveChanges() > 0;
return(result);
}
public void excluirReserva(reserva reserva)
{
var ve = banco.reserva.Find(reserva.ID);
banco.reserva.Remove(ve);
banco.SaveChanges();
}
public void afegirReserva(DateTime dataInici, DateTime dataFinal, decimal preuTotal, decimal bestreta, string pensioFk, int idClientFk)
{
reserva r = new reserva(dataInici, dataFinal, preuTotal, bestreta, pensioFk, idClientFk);
context.reservas.Add(r);
context.SaveChanges();
}
public void alterarReserva(reserva reserva)
{
var veicu = banco.reserva.Find(reserva.ID);
banco.Entry(veicu).State = System.Data.Entity.EntityState.Modified;
banco.SaveChanges();
}
public async Task <IActionResult> Edit(int id, [Bind("idReserva,docSolicitante,estadoPago,metodoPago,cantidadSillas,fkIdTarjeta")] reserva reserva)
{
if (id != reserva.idReserva)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(reserva);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!reservaExists(reserva.idReserva))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(reserva));
}
public static void Add(reserva novaReserva, SqlConnection conexaoSql)
{
string sql = "INSERT INTO " + NOME_TABELA + " (cd_reserva, cd_cliente, cd_sala, dt_entrada, dt_saida, vl_reserva, fl_pago) "
+ " values (@" + reserva.CD_RESERVA + ", @" + reserva.CD_CLIENTE + ", @" + reserva.CD_SALA + ", @" + reserva.DT_ENTRADA + ", @" +
reserva.DT_SAIDA + ", @" + reserva.VL_RESERVA + ", @" + reserva.FL_PAGO + ") ";
SqlCommand cmd = conexaoSql.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.Add(DBUtils.criaParametro <int>(reserva.CD_RESERVA, novaReserva.cd_reserva, SqlDbType.Int));
cmd.Parameters.Add(DBUtils.criaParametro <int>(reserva.CD_CLIENTE, novaReserva.cd_cliente, SqlDbType.Int));
cmd.Parameters.Add(DBUtils.criaParametro <int>(reserva.CD_SALA, novaReserva.cd_sala, SqlDbType.Int));
cmd.Parameters.Add(DBUtils.criaParametro <string>(reserva.DT_ENTRADA, novaReserva.dt_entrada.ToString("yyyy-MM-ddTHH:mm:ss"), SqlDbType.DateTime));
cmd.Parameters.Add(DBUtils.criaParametro <string>(reserva.DT_SAIDA, novaReserva.dt_saida.ToString("yyyy-MM-ddTHH:mm:ss"), SqlDbType.DateTime));
cmd.Parameters.Add(DBUtils.criaParametro <float>(reserva.VL_RESERVA, novaReserva.vl_reserva, SqlDbType.Float));
cmd.Parameters.Add(DBUtils.criaParametro <char>(reserva.FL_PAGO, novaReserva.fl_pago ? '1' : '0', SqlDbType.Char));
int rowCount = cmd.ExecuteNonQuery();
AcessoBanco.comandosSqlExecutados += DBUtils.MontaComandoSql(cmd) + "\r\n";
Debug.Write("Linhas afetadas: " + rowCount);
}
public ReservaCadastro(reserva reserva, ReservaDAO reservadao, string metodo) // Sobrecarga de metodo para passar parametro de morador
{
this.metodo = metodo;
this.reserva = reserva;
this.reservadao = reservadao;
InitializeComponent();
}
public reserva CrearReserva(reserva reservaACrear)
{
db.reservas.Add(reservaACrear);
db.SaveChanges();
reserva reserva = ObtenerReserva(reservaACrear.codigoreserva);
return(reserva);
}
public reserva ObtenerReserva(string codigoreserva)
{
var query = from reserva in db.reservas.Where(x => (x.codigoreserva == codigoreserva))
select reserva;
reserva resultado = query.FirstOrDefault();
return(resultado);
}
public reserva ModificarReserva(reserva reservaAModificar)
{
db.Entry(reservaAModificar).State = EntityState.Modified;
db.SaveChanges();
reserva reserva = ObtenerReserva(reservaAModificar.codigoreserva);
return(reserva);
}
public ActionResult DeleteConfirmed(int id)
{
reserva reserva = db.reserva.Find(id);
db.reserva.Remove(reserva);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static ReservaModel ObterRegistro(int idReserva)
{
irt_bibEntities db = new irt_bibEntities();
reserva reservaObj = db.reserva.FirstOrDefault(x => x.res_id_reserva == idReserva) ?? new reserva();
ReservaModel returnObj = PreencherObj(reservaObj);
returnObj.listaReservas = Lista();
return(returnObj);
}
public ActionResult Edit([Bind(Include = "reserva_Id,hospede,data_nascimento1,cpf1,sexo,data_reserva,data_saida,horario_entrada,horario_saida,tipo_reserva,quarto,num_quarto,status_relacionamento1,telefone1,email1")] reserva reserva)
{
if (ModelState.IsValid)
{
db.Entry(reserva).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(reserva));
}
public IHttpActionResult Getreserva(int id)
{
reserva reserva = db.reserva.Find(id);
if (reserva == null)
{
return(NotFound());
}
return(Ok(reserva));
}
public async Task <IActionResult> Create([Bind("idReserva,docSolicitante,estadoPago,metodoPago,cantidadSillas,fkIdTarjeta")] reserva reserva)
{
if (ModelState.IsValid)
{
_context.Add(reserva);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(reserva));
}
public ActionResult Edit([Bind(Include = "idReserva,docSolicitante,precio,estadoPago,metodoDePago,fkIdTarjeta")] reserva reserva)
{
if (ModelState.IsValid)
{
db.Entry(reserva).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.fkIdTarjeta = new SelectList(db.Tarjeta, "idTarjeta", "Propietario", reserva.fkIdTarjeta);
return(View(reserva));
}
internal void AddReserva(reserva novaReserva = null)
{
if (_debug)
{
_preencheBancoUtils.AddReservas(_conexaoSql);
}
else
{
ReservaDAO.Add(novaReserva, _conexaoSql);
}
}
public async Task <IHttpActionResult> Getreserva(int id)
{
reserva reserva = await db.reserva.FindAsync(id);
if (reserva == null)
{
return(NotFound());
}
return(Ok(reserva));
}
public ActionResult Edit([Bind(Include = "id,fecha,finalizada,cliente,mesa")] reserva reserva)
{
if (ModelState.IsValid)
{
db.Entry(reserva).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cliente = new SelectList(db.cliente, "id", "nombre", reserva.cliente);
ViewBag.mesa = new SelectList(db.mesa, "id", "id", reserva.mesa);
return(View(reserva));
}
private void carregaReserva()
{
if (reserva == null)
{
reserva = new reserva();
}
reserva.MORADOR_ID = reserva.MORADOR_ID;
reserva.DESCRICAO_RESERVA = tbDescricao.Text;
reserva.LOCAL_RESERVA = tbLocal.Text;
reserva.PERMITIR = checkBoxPermitir.Checked;
}
public IHttpActionResult Postreserva(reserva reserva)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.reserva.Add(reserva);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = reserva.idreserva }, reserva));
}
private void button1_Click(object sender, EventArgs e)
{
DataTable db = new DataTable();
db.Columns.Add("Número", typeof(string));
db.Columns.Add("Nome", typeof(string));
db.Columns.Add("Telefone", typeof(string));
db.Columns.Add("Cidade", typeof(string));
db.Columns.Add("Data de Entrada", typeof(string));
db.Columns.Add("Data de Saída", typeof(string));
db.Columns.Add("Qtd de Pessoas", typeof(string));
db.Columns.Add("Feriado", typeof(string));
db.Columns.Add("Desconto", typeof(string));
db.Columns.Add("Valor", typeof(string));
db.Columns.Add("Pago?", typeof(string));
db.Columns.Add("Data do Pagamento", typeof(string));
int linha = reserva.getNextNumber(Program.pathReserva);
for (int i = 1; i < linha; i++)
{
reserva dados = new reserva(reserva.retornaReserva(i));
DataRow Linha = db.NewRow();
Linha["Número"] = dados.Numero;
Linha["Nome"] = dados.ClienteNome;
Linha["Telefone"] = dados.Telefone;
Linha["Cidade"] = dados.Cidade;
Linha["Data de Entrada"] = dados.DataEntrada;
Linha["Data de Saída"] = dados.DataSaida;
Linha["Qtd de Pessoas"] = dados.QtdPessoas;
Linha["Feriado"] = dados.FeriadoTipo;
Linha["Desconto"] = dados.Desconto;
Linha["Valor"] = dados.Valor;
Linha["Pago?"] = dados.Pago;
Linha["Data do Pagamento"] = dados.DataPago;
if (dados.Numero.ToString().ToUpper().Contains(numero.ToUpper()) &&
dados.ClienteNome.ToUpper().Contains(nome.ToUpper()) &&
dados.Cidade.ToUpper().Contains(cidade.ToUpper()) &&
dados.DataEntrada.ToString().Substring(3, 2).Contains(mes) &&
dados.FeriadoTipo.Contains(feriado) &&
dados.DataEntrada.ToString().Substring(0, 10).Contains(dataEntrada) &&
dados.DataSaida.ToString().Substring(0, 10).Contains(dataSaida) &&
dados.DataPago.ToString().Substring(0, 10).Contains(dataPagamento))
{
db.Rows.Add(Linha);
}
}
dataGridView1.DataSource = db;
}
internal static List <cliente_reserva> BuscaReservasAgrupCliente(reserva reserva, SortOrder order, SqlConnection conexaoSql)
{
string sql = " select cliente.nm_cliente, reserva.vl_reserva ";
sql += " from cliente, reserva ";
sql += " group by cliente.nm_cliente, reserva.cd_cliente, cliente.cd_cliente, reserva.vl_reserva, reserva.fl_pago ";
sql += " having cliente.cd_cliente = reserva.cd_cliente ";
sql += " and reserva.fl_pago = " + (reserva.fl_pago ? "1" : "0");
sql += " order by reserva.vl_reserva " + (order == SortOrder.Ascending ? "asc" : "desc");
return(LeClienteReserva(sql, conexaoSql));
}
public async Task <IHttpActionResult> Postreserva(reserva reserva)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.reserva.Add(reserva);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = reserva.idReserva }, reserva));
}
