public List<Booking> GetOccupants(string userInput, DateTime todaysDate)
{
List<Booking> listCurrentOccupants = null;
//RoomType roomType = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@UserInput", userInput),
new SqlParameter("@TodaysDate", todaysDate)
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetCurrentOccupants", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
listCurrentOccupants = new List<Booking>();
foreach (DataRow row in table.Rows)
{
Booking booking = new Booking();
booking.BookingID = Convert.ToInt32(row["BookingID"]);
booking.ArriveDate = Convert.ToDateTime(row["ArriveDate"]);
booking.DepartDate = Convert.ToDateTime(row["DepartDate"]);
booking.FullName = Convert.ToString(row["FullName"]);
booking.RoomsBooked = Convert.ToString(row["RoomsBooked"]);
booking.MemberID = Convert.ToInt32(row["MemberID"]);
listCurrentOccupants.Add(booking);
}
}
}
return listCurrentOccupants;
}
public IHttpActionResult PostBooking(Booking booking)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
repository.AddBooking(booking);
return CreatedAtRoute("DefaultApi", new { id = booking.Id }, booking);
}
public bool UpdateProofOfPayment(Booking booking)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@BookingID", booking.BookingID),
new SqlParameter("@ProofOfPayment", booking.ProofOfPayment)
};
return DBHelper.ExecuteNonQuery("sp_UpdateProofOfPayment", CommandType.StoredProcedure, parameters);
}
public List<Booking> GetBookingHistory(int memberID)
{
List<Booking> bookingHistory = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MemberID", memberID)
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetBookingHistory", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
bookingHistory = new List<Booking>();
foreach (DataRow row in table.Rows)
{
Booking booking = new Booking();
booking.BookingID = Convert.ToInt32(row["BookingID"]);
booking.ArriveDate = Convert.ToDateTime(row["ArriveDate"]);
booking.DepartDate = Convert.ToDateTime(row["DepartDate"]);
booking.ProofOfPayment = row["ProofOfPayment"].ToString();
booking.Status = row["Status"].ToString();
bookingHistory.Add(booking);
}
}
}
return bookingHistory;
}
public Booking()
{
d_Booking = new DAL.Booking();
}
