public IHttpActionResult PutDatDichVu(int id, DatDichVu datDichVu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != datDichVu.MaDat)
{
return(BadRequest());
}
db.Entry(datDichVu).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DatDichVuExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutHotel(int id, Hotel hotel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != hotel.hotel_id)
{
return(BadRequest());
}
db.Entry(hotel).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!HotelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public JsonResult CustomerRegistration(CustomerViewModel model)
{
string message = model.FirstName + " has been added";
Customerz cs = new Customerz();
cs.Company = model.Company;
cs.Email = model.Email;
cs.FirstName = model.FirstName;
cs.LastName = model.LastName;
cs.Password = model.Password;
foreach (var cust in bd.Customerz)
{
if (cust.Email == model.Email)
{
message = cust.FirstName + " already Exist, please Log in";
return(Json(message, JsonRequestBehavior.AllowGet));
}
}
bd.Customerz.Add(cs);
bd.SaveChanges();
return(Json(message, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult PutKhachHang(int id, KhachHang khachHang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != khachHang.MaKhachHang)
{
return(BadRequest());
}
db.Entry(khachHang).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KhachHangExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public HttpResponseMessage PostOrEditRooms(Room bs)
{
try
{
if (bs.RoomId == 0)
{
Room c = new Room();
c.RoomNumber = bs.RoomNumber;
c.RoomTitle = bs.RoomTitle;
c.RoomPrice = bs.RoomPrice;
mb.Rooms.Add(c);
mb.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.Created));
}
else
{
var obj = mb.Rooms.Where(x => x.RoomId == bs.RoomId).ToList().FirstOrDefault();
if (obj.RoomId > 0)
{
obj.RoomNumber = bs.RoomNumber;
obj.RoomTitle = bs.RoomTitle;
obj.RoomPrice = bs.RoomPrice;
mb.SaveChanges();
}
return(new HttpResponseMessage(HttpStatusCode.OK));
}
}
catch (Exception e)
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
public int Postgiaphong(int ma, [FromBody] int gia)
{
var kq = db.capnhatgiaphong(ma, gia);
db.SaveChanges();
return(kq);
}
public ActionResult Deleteroom(string id)
{
//string sd = id.ToString();
var room = context.Rooms.Where(x => x.room_num == id).FirstOrDefault();
context.Rooms.Remove(room);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "Id,Name,Description,RoomType,Price,State")] Room room)
{
if (ModelState.IsValid)
{
db.Rooms.Add(room);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(room));
}
public ActionResult Create([Bind(Include = "codigo_habitacion,tipo_habotacion,planta_ubicacion_habitacion")] Habitaciones habitaciones)
{
if (ModelState.IsValid)
{
db.Habitaciones.Add(habitaciones);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(habitaciones));
}
public ActionResult Create([Bind(Include = "id_agencia,nombre_agencia,direccion_agencia,telefono_agencia")] Agencia agencia)
{
if (ModelState.IsValid)
{
db.Agencia.Add(agencia);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(agencia));
}
public ActionResult Create([Bind(Include = "id_cate,descripcion_cate,estrellas_cate")] Categoria categoria)
{
if (ModelState.IsValid)
{
db.Categoria.Add(categoria);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoria));
}
public ActionResult Create([Bind(Include = "RoomId,RoomName,RoomDescription,Feature,AdditionalInformation,Adults,Children")] Rooms rooms)
{
if (ModelState.IsValid)
{
db.Rooms.Add(rooms);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rooms));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,DOB,Email,PhoneNumber")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "idUbicacion,longitud,latitud,nombre")] Ubicacion ubicacion)
{
if (ModelState.IsValid)
{
db.Ubicacion.Add(ubicacion);
db.SaveChanges();
return(RedirectToAction("/Index"));
}
return(View(ubicacion));
}
public ActionResult Add(Supplier sup)
{
if (!ModelState.IsValid)
{
return(View(sup));
}
context.Suppliers.Add(sup);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "codigo_descuento,porcentaje_descuento")] Descuentos descuentos)
{
if (ModelState.IsValid)
{
db.Descuentos.Add(descuentos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(descuentos));
}
public ActionResult Create([Bind(Include = "num_tarjeta,titular_tarjeta,fecha_venc_tarjeta")] Tarjetas tarjetas)
{
if (ModelState.IsValid)
{
db.Tarjetas.Add(tarjetas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tarjetas));
}
public ActionResult Create([Bind(Include = "Id,OrderId,Check_inDate,Rate,Feedback")] Rating rating)
{
if (ModelState.IsValid)
{
db.Ratings.Add(rating);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderId = new SelectList(db.Bookings, "Id", "Comments", rating.OrderId);
return(View(rating));
}
public ActionResult Create([Bind(Include = "id_cliente,nombre_cliente,direccion_cliente,telefono_cleinte,correo_cliente,num_tarjeta_cliente")] Clientes clientes)
{
if (ModelState.IsValid)
{
db.Clientes.Add(clientes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.num_tarjeta_cliente = new SelectList(db.Tarjetas, "num_tarjeta", "titular_tarjeta", clientes.num_tarjeta_cliente);
return(View(clientes));
}
public ActionResult Create([Bind(Include = "PriceId,Charge,Term,Month,Day,RoomId,Currency")] Price price)
{
if (ModelState.IsValid)
{
db.Price.Add(price);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RoomId = new SelectList(db.Rooms, "RoomId", "RoomName", price.RoomId);
return(View(price));
}
public ActionResult Create([Bind(Include = "PhotoId,Type,Url,RoomId")] Photo photo)
{
if (ModelState.IsValid)
{
db.Photo.Add(photo);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.RoomId = new SelectList(db.Rooms, "RoomId", "RoomName", photo.RoomId);
return View(photo);
}
public ActionResult Create([Bind(Include = "id_hotel,categoria_hotel,nombre_hotel,direccion_hotel,telefono_hotel")] Hoteles hoteles)
{
if (ModelState.IsValid)
{
db.Hoteles.Add(hoteles);
db.SaveChanges();
return(RedirectToAction("/Index"));
}
ViewBag.categoria_hotel = new SelectList(db.Categoria, "id_cate", "descripcion_cate", hoteles.categoria_hotel);
return(View(hoteles));
}
public ActionResult Create([Bind(Include = "id_factura,reservacion_factura")] Factura factura)
{
if (ModelState.IsValid)
{
db.Factura.Add(factura);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.reservacion_factura = new SelectList(db.Reservaciones, "id_reservacion", "nombre_reservacion", factura.reservacion_factura);
return(View(factura));
}
public ActionResult Create([Bind(Include = "id_relacion,id_hotel,codigo_habitacion,estado_habitacion")] HabitacionesXHotel habitacionesXHotel)
{
if (ModelState.IsValid)
{
db.HabitacionesXHotel.Add(habitacionesXHotel);
db.SaveChanges();
return(RedirectToAction("/Index"));
}
ViewBag.codigo_habitacion = new SelectList(db.Habitaciones, "codigo_habitacion", "tipo_habotacion", habitacionesXHotel.codigo_habitacion);
ViewBag.id_hotel = new SelectList(db.Hoteles, "id_hotel", "nombre_hotel", habitacionesXHotel.id_hotel);
return(View(habitacionesXHotel));
}
public int CrearUsuario(Usuarios usuario)
{
try
{
db.Usuarios.Add(usuario);
db.SaveChanges();
return(usuario.IdUsuario);
}
catch (Exception)
{
throw;
}
}
public int CrearPlatillo(Platillos platillo)
{
try
{
db.Platillos.Add(platillo);
db.SaveChanges();
return(platillo.IdPlatillo);
}
catch (Exception)
{
throw;
}
}
public int CrearRestaurante(Restaurantes restaurante)
{
try
{
db.Restaurantes.Add(restaurante);
db.SaveChanges();
return(restaurante.IdRestaurante);
}
catch (Exception)
{
throw;
}
}
public int CrearHabitacion(Habitacion habitacion)
{
try
{
db.Habitacion.Add(habitacion);
db.SaveChanges();
return(habitacion.IdHabitacion);
}
catch (Exception)
{
throw;
}
}
public ActionResult Create([Bind(Include = "Id,CustomerId,RoomId,Check_inDate,Check_outDate,TotalPrice,Comments")] Booking booking)
{
if (ModelState.IsValid)
{
db.Bookings.Add(booking);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Users, "Id", "FirstName", booking.CustomerId);
ViewBag.RoomId = new SelectList(db.Rooms, "Id", "Name", booking.RoomId);
return(View(booking));
}
/// <summary>
/// Add the specified room.
/// </summary>
/// <param name="model">Model.</param>
public void Add(RoomViewModel model)
{
Rooms room = new Rooms()
{
Size = model.Size,
Available = model.Available ? 1 : 0,
How_many_persons = model.HowManyPerson,
Price = model.Price
};
context.Rooms.Add(room);
context.SaveChanges();
}