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(); } }