public bool AddRoomBookingDetails(RoomBookingModel room)
{
bool result = false;
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand sqlCommand = new SqlCommand("sp_insertRoomBookingDetails", sqlConnection);
try
{
sqlConnection.Open();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@RoomID", room.RoomID));
sqlCommand.Parameters.Add(new SqlParameter("@GuestName", room.GuestName));
sqlCommand.Parameters.Add(new SqlParameter("@age", room.Age));
sqlCommand.Parameters.Add(new SqlParameter("@sex", room.Sex));
sqlCommand.Parameters.Add(new SqlParameter("@bookingStartDate", room.BookingStartDate));
sqlCommand.Parameters.Add(new SqlParameter("@bookingEndDate", room.BookingEndDate));
sqlCommand.Parameters.Add(new SqlParameter("@User", room.CreatedBy));
sqlCommand.ExecuteNonQuery();
result = true;
}
catch (Exception e)
{
Console.WriteLine("Error Generated. Details: " + e.ToString());
result = false;
}
finally
{
sqlConnection.Close();
}
return(result);
}
public IHttpActionResult AddRoomBooking([FromBody] dynamic requestBody)
{
try
{
string columnsData = Convert.ToString(requestBody);
if (!string.IsNullOrEmpty(columnsData))
{
var columns = JObject.Parse(columnsData);
RoomBookingModel roomBookingModel = new RoomBookingModel();
roomBookingModel.RoomID = int.Parse(columns["roomID"].ToString());
roomBookingModel.GuestName = columns["guestName"].ToString();
roomBookingModel.Age = int.Parse(columns["age"].ToString());
roomBookingModel.Sex = columns["sex"].ToString();
roomBookingModel.BookingStartDate = DateTime.Parse(columns["bookStartDate"].ToString());
roomBookingModel.BookingEndDate = DateTime.Parse(columns["bookEndDate"].ToString());
roomBookingModel.CreatedBy = columns["user"].ToString();
RoomBL room = new RoomBL();
room.AddRoomBookingDetails(roomBookingModel);
}
return(Ok("Room Booking Details are added successfully."));
}
catch (Exception ex)
{
string msg = "Room Booking Details are failed to add. \n Error Message: " + ex.Message;
return(InternalServerError(ex));
}
}
// Booking data
public List <RoomBookingModel> GetAvailableRooms(RoomBookingModel model)
{
List <RoomBookingModel> list = new List <RoomBookingModel>();
using (MySqlConnection conn = GetConnection())
{
MySqlCommand getDataCmd = new MySqlCommand("Get_RR_AvailableRooms", conn);
getDataCmd.CommandType = CommandType.StoredProcedure;
getDataCmd.Parameters.Add(new MySqlParameter("RoomTypeID", model.Roomtype));
getDataCmd.Parameters.Add(new MySqlParameter("dFrom", model.DateFrom.ToShortDateString()));
getDataCmd.Parameters.Add(new MySqlParameter("dTo", model.DateTo.ToShortDateString()));
conn.Open();
using (MySqlDataReader reader = getDataCmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new RoomBookingModel()
{
RoomID = reader.GetInt32(0)
});
}
}
}
return(list);
}
/// <summary>
/// Add Booking Details
/// </summary>
/// <param name="roomBookingDetails"></param>
/// <returns></returns>
public bool AddRoomBookingDetails(RoomBookingModel roomBookingDetails)
{
bool result = false;
RoomDL room = new RoomDL();
result = room.AddRoomBookingDetails(roomBookingDetails);
return(result);
}
async public static Task<Tuple<string, RoomBookingModel>> GetBookings(int selectedRoomId, Context context = null)
{
string endPoint = ConstantHelper.AllBookings + "?" + "roomId" + "=" + selectedRoomId + "&" + "limit" + "=" + ConstantHelper.NumberOfBookingsPerPage;
Tuple<string, string> data = await APIHelper.GetAsync(endPoint);
string responseContent = data.Item1;
if (responseContent != null)
{
if (!string.IsNullOrEmpty(responseContent))
{
RoomBookingModel list = JsonConvert.DeserializeObject<RoomBookingModel>(responseContent);
return new Tuple<string, RoomBookingModel>(null, list);
}
}
return new Tuple<string, RoomBookingModel>(data.Item2, null);
}
// View for registration success
public IActionResult RegisterRoomBooking([Bind] RoomBookingModel booking)
{
WebDbContext db = HttpContext.RequestServices.GetService(typeof(Web.Utils.WebDbContext)) as WebDbContext;
var guestid = Convert.ToInt32(HttpContext.User.FindFirstValue(ClaimTypes.Name));
ModelState.Remove("AvailableRooms");
ModelState.Remove("Room");
if (ModelState.IsValid)
{
// Register new room booking
db.RegisterBooking(guestid, booking);
// Redirect to user area
ModelState.Clear();
return(View());
}
return(View());
}
async public void SetList()
{
try
{
bool check = false;
Tuple <string, RoomBookingModel> data = await BookingHelper.GetBookings(CurrentRoom.Id);
if (!string.IsNullOrEmpty(data.Item1))
{
Activity.RunOnUiThread(() =>
{
Toast.MakeText(Activity, data.Item1, ToastLength.Short).Show();
});
return;
}
RoomBookingModel model = data.Item2;
List <BookingDetailModel> list = model.data;
//List<BookingDetailModel> list = await BookingHelper.GetBookings(CurrentRoom.Id);
if (BookingList != null && BookingList.Count > 0)
{
check = list.Equals(BookingList);
}
BookingList = list;
if (!check)
{
InvokeSetList?.Invoke(list, EventArgs.Empty);
}
}
catch (Exception exc)
{
}
finally
{
Activity.RunOnUiThread(() =>
{
Activity.ProgressBar.Visibility = ViewStates.Gone;
});
}
}
public IActionResult AvailableRooms(RoomBookingModel booking)
{
WebDbContext db = HttpContext.RequestServices.GetService(typeof(Web.Utils.WebDbContext)) as WebDbContext;
var today = DateTime.Now;
if (booking.DateFrom > booking.DateTo || booking.DateFrom < today.AddDays(-1))
{
return(View("RegisterRoomBookingModelFailed", booking));
}
if (ModelState.IsValid)
{
// Return list of available rooms and convert to int values
booking.AvailableRooms = db.GetAvailableRooms(booking);
//List<int> roomlist = booking.AvailableRooms.ConvertAll<int>(Converter<RoomModel, int.Parse>);
// Select first item in list and make reservation
booking = booking.AvailableRooms.First();
return(RedirectToAction("RegisterRoomBooking", booking));
}
return(View("Index", booking));
}
public void RegisterBooking(int guestid, RoomBookingModel model)
{
using (MySqlConnection conn = GetConnection())
{
MySqlCommand setDataCmd = new MySqlCommand("Set_RR_Add", conn);
setDataCmd.CommandType = CommandType.StoredProcedure;
setDataCmd.Parameters.Add(new MySqlParameter("GID", guestid));
setDataCmd.Parameters.Add(new MySqlParameter("RID", model.RoomID));
setDataCmd.Parameters.Add(new MySqlParameter("DFrom", model.DateFrom));
setDataCmd.Parameters.Add(new MySqlParameter("DTo", model.DateTo));
if (model.Remark != null)
{
setDataCmd.Parameters.Add(new MySqlParameter("Remark", model.Remark));
}
else
{
setDataCmd.Parameters.Add(new MySqlParameter("Remark", Convert.DBNull));
}
conn.Open();
setDataCmd.ExecuteNonQuery();
conn.Close();
}
}
