public IHttpActionResult Put(int res_id, ReservationPoco reservation)
{
var updated_reservation = db.ReservationVIEW.FirstOrDefault(x => x.Id == res_id);
if (updated_reservation != null)
{
updated_reservation.Firstname = reservation.FirstName;
updated_reservation.Lastname = reservation.LastName;
updated_reservation.Fromdate = reservation.FromDate;
updated_reservation.Todate = reservation.ToDate;
updated_reservation.RoomType = reservation.RoomType;
updated_reservation.Nation = reservation.Nation;
updated_reservation.VIPStatusText = reservation.VIPStatus;
updated_reservation.Phone = reservation.Phone;
updated_reservation.ContractName = reservation.ContractName;
updated_reservation.StatusText = reservation.Status;
updated_reservation.NumberOfChild = reservation.NumberOfChild;
updated_reservation.NumberOfBaby = reservation.NumberOfBaby;
updated_reservation.BookDate = reservation.BookDate;
db.SubmitChanges();
}
else
{
return(NotFound());
}
return(Ok());
}
public ActionResult GetReservation(Guid id)
{
ReservationPoco poco = _logic.Get(id);
if (poco == null)
{
return(NotFound());
}
else
{
return(Ok(poco));
}
}
public ReservationPoco GetById(int id)
{
ReservationPoco reservationpoco = null;
var reservationdb = db.ReservationVIEW.FirstOrDefault(x => x.Id == id);
if (reservationdb != null)
{
reservationpoco = new ReservationPoco
{
Room_No = reservationdb.RoomNo,
FirstName = reservationdb.Firstname,
LastName = reservationdb.Lastname,
FromDate = reservationdb.Fromdate,
ToDate = reservationdb.Todate,
RoomType = reservationdb.RoomType,
Nation = reservationdb.Nation,
VIPStatus = reservationdb.VIPStatusText,
Phone = reservationdb.Phone,
ContractName = reservationdb.ContractName,
Status = reservationdb.StatusText,
NumberOfChild = reservationdb.NumberOfChild,
ChildAge1 = reservationdb.ChildAge1,
ChildAge2 = reservationdb.ChildAge2,
ChildAge3 = reservationdb.ChildAge3,
ChildAge4 = reservationdb.ChildAge4,
NumberOfBaby = reservationdb.NumberOfBaby,
BabyAge1 = reservationdb.BabyAge1,
BabyAge2 = reservationdb.BabyAge2,
BookDate = reservationdb.BookDate
};
}
else
{
reservationpoco = new ReservationPoco();
}
return(reservationpoco);
}
public List <ReservationPoco> GetReservationbyRoomNo(int Otel_Id, string room_number)
{
List <ReservationVIEW> reservationList = (from x in db.ReservationVIEW
where x.HotelId == Otel_Id && x.RoomNo == room_number
select x).ToList();
List <ReservationPoco> reservationPocoList = new List <ReservationPoco>();
foreach (var reservationdb in reservationList)
{
ReservationPoco reservationpoco = new ReservationPoco
{
Room_No = reservationdb.RoomNo,
FirstName = reservationdb.Firstname,
LastName = reservationdb.Lastname,
FromDate = reservationdb.Fromdate,
ToDate = reservationdb.Todate,
RoomType = reservationdb.RoomType,
Nation = reservationdb.Nation,
VIPStatus = reservationdb.VIPStatusText,
Phone = reservationdb.Phone,
ContractName = reservationdb.ContractName,
Status = reservationdb.StatusText,
NumberOfChild = reservationdb.NumberOfChild,
ChildAge1 = reservationdb.ChildAge1,
ChildAge2 = reservationdb.ChildAge2,
ChildAge3 = reservationdb.ChildAge3,
ChildAge4 = reservationdb.ChildAge4,
NumberOfBaby = reservationdb.NumberOfBaby,
BabyAge1 = reservationdb.BabyAge1,
BabyAge2 = reservationdb.BabyAge2,
BookDate = reservationdb.BookDate
};
reservationPocoList.Add(reservationpoco);
}
return(reservationPocoList);
}
