public HttpResponseMessage GetRoomDetailsByID(RoomDetails room)
{
RoomResponse Response = new RoomResponse();
RoomDetails roomdetail = new RoomDetails();
try
{
roomdetail = ObjVideo.GetRoomBySID(room.Id);
Response.Status = con.StatusSuccess;
Response.Data = roomdetail;
}
catch (Exception ex)
{
Response.Status = con.StatusFailed;
Response.Message = con.MessageFailed + ", Exception : " + ex.Message;
}
return(ConvertToJSON(Response));
}
public void Admin_AddRoom_NullValuePassing()
{
//Arrange
RoomDetails room = new RoomDetails();
AdminController adminController = new AdminController()
{
Request = new HttpRequestMessage()
{
Properties = { { HttpPropertyKeys.HttpConfigurationKey, new HttpConfiguration() } }
}
};
//Act
var response = adminController.AddRoom(room);
//Assert
Assert.AreEqual(HttpStatusCode.Conflict, response.StatusCode);
}
public RoomDetails GetRoomBySID(string RoomSID)
{
ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
TwilioClient.Init(accountSid, authToken);
RoomDetails RoomDetail = new RoomDetails();
try
{
var room = RoomResource.Fetch(pathSid: RoomSID);
RoomDetail.Id = room.Sid;
RoomDetail.Name = room.UniqueName;
RoomDetail.MaxParticipants = Convert.ToInt32(room.MaxParticipants);
RoomDetail.Status = room.Status.ToString();
}
catch (Exception ex)
{
throw;
}
return(RoomDetail);
}
public RoomDetails CreateRoom(string RoomUniqueName)
{
ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
TwilioClient.Init(accountSid, authToken);
RoomDetails RoomDetail = new RoomDetails();
try
{
var room = RoomResource.Create(
enableTurn: true,
type: RoomResource.RoomTypeEnum.PeerToPeer,
uniqueName: RoomUniqueName);
RoomDetail.Id = room.Sid;
RoomDetail.Name = room.UniqueName;
RoomDetail.MaxParticipants = Convert.ToInt32(room.MaxParticipants);
RoomDetail.Status = room.Status.ToString();
}
catch (Exception ex)
{
throw;
}
return(RoomDetail);
}
private IEnumerator GetRoomByAddressCoroutine(string url, RoomDetails roomDetails)
{
using (WWW www = new WWW(url))
{
yield return(www);
if (www.error != null)
{
Debug.Log(string.Format("Server returned error, retrying up to 3 times. Error{0}", www.error));
RetryGetRoomByAddress(url, roomDetails);
}
// Parse and cache events
var roomWithEventData = new RoomWithEventData();
try
{
roomWithEventData = RoomWithEventData.CreateFromJSON(www.text);
}
catch (ArgumentException e)
{
Debug.Log(string.Format("Caught exception parsing server response. retrying up to 3 times. exception message: {0}", e.Message));
RetryGetRoomByAddress(url, roomDetails);
}
retries = 0;
roomDetails.TicksAtLastUpdate = DateTime.Now.Ticks;
AddressOfLastAccess.Value = roomDetails.Address;
for (int i = 0; i < roomWithEventData.Events.Length; i++)
{
RoomEvents[i].Id = roomWithEventData.Events[i].Id;
RoomEvents[i].Subject = roomWithEventData.Events[i].Subject;
RoomEvents[i].StartTime = DateTime.Parse(roomWithEventData.Events[i].Start);
RoomEvents[i].EndTime = DateTime.Parse(roomWithEventData.Events[i].End);
}
DataReadyToDisplay.Raise();
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
try {
RoomDetails room = new RoomDetails();
if (txt_Availability.Text == "" || txt_HotelId.Text == "" || txt_PerNightRate.Text == "" || txt_RoomId.Text == "" || txt_RoomNo.Text == "" || txt_RoomType.Text == "")
{
throw new HMS_Exception("All data must be entered");
}
else
{
room.Availability = Convert.ToInt32(txt_Availability.Text);
room.HotelID = txt_HotelId.Text;
room.PerNightrate = Convert.ToInt32(txt_PerNightRate.Text);
//room.photo = openFileDialog1.FileName;
room.RoomID = txt_RoomId.Text;
room.RoomNo = txt_RoomNo.Text;
room.RoomType = txt_RoomType.Text;
bool Roomadded = HBMS_BLL.AddRoomBL(room);
if (!Roomadded)
{
throw new HMS_Exception("Room Cannot be added");
}
else
{
MessageBox.Show("Room Added Successfully");
//HomeView hh = new HomeView();
Response.Redirect("HomeView.aspx");
}
}
}
catch (HMS_Exception ex)
{ MessageBox.Show(ex.Message); }
catch (SqlException e2)
{ MessageBox.Show(e2.Message); }
catch (Exception e1)
{ MessageBox.Show(e1.Message); }
}
public void Admin_AddRoom_WrongDetails()
{
//Arrange
RoomDetails room = new RoomDetails();
AdminController adminController = new AdminController()
{
Request = new HttpRequestMessage()
{
Properties = { { HttpPropertyKeys.HttpConfigurationKey, new HttpConfiguration() } }
}
};
room.roomNumber = 101;
room.starRating = 5;
room.price = 2000;
room.roomType = "Single";
room.hotelId = 13;
room.imageUrl = "/assets/HotelPic/Hotel1.jpg";
//Act
var response = adminController.AddRoom(room);
//Assert
Assert.AreEqual(HttpStatusCode.Conflict, response.StatusCode);
}
/*------------------------------------------------END OF Deleting the City------------------------------------------------*/
// CRUD on Hotel Table
//Adding Hotel in the hotelDetails Table
public bool AddHotel(CityHotelDetailsFromAdmin hotel)
{
CityDetails cityDetails = new CityDetails();
cityDetails.cityName = hotel.cityName;
HotelDetails hotelDetails = new HotelDetails();
hotelDetails.hotelName = hotel.hotelName;
hotelDetails.hotelAddress = hotel.hotelAddress;
hotelDetails.doubleRooms = hotel.numberOfDoubleRooms;
hotelDetails.starRating = hotel.hotelRating;
hotelDetails.singleRooms = hotel.numberOfSingleRooms;
RoomDetails roomDetails = new RoomDetails();
if (CheckCityIfExists(cityDetails.cityName))
{
if (!AddCity(cityDetails))
{
return(false);
}
}
int cityId = dbContext.cityDetails.Where(y => y.cityName == cityDetails.cityName).Select(y => y.cityId).FirstOrDefault();
if (CheckHotelIfExists(hotelDetails.hotelName, cityId))
{
dbContext.hotelDetails.Add(hotelDetails);
dbContext.SaveChanges();
int hotelId = FindTheAppropriateHotelId(hotel.hotelName);
//Calling a different function to map Hotel and City Id
if (!CityIdHotelIdUpdate(cityId, hotelId))
{
return(false);
}
//Starting to add rooms
for (int i = 1; i <= hotel.numberOfSingleRooms; i++)
{
roomDetails.hotelId = hotelId;
roomDetails.roomType = "Single";
roomDetails.price = hotel.priceOfSingleRoom;
if (!AddRoom(roomDetails))
{
return(false);
}
}
for (int i = 1; i <= hotel.numberOfDoubleRooms; i++)
{
roomDetails.hotelId = hotelId;
roomDetails.roomType = "Double";
roomDetails.price = hotel.priceOfDoubleRoom;
if (!AddRoom(roomDetails))
{
return(false);
}
}
return(true);
}
else
{
return(false);
}
}
public RoomDetails FindRoomDetails(RoomDetails RoomDetails)
{
_log.LogError("");
return(_repository.Find <RoomDetails>(R => R.ID == RoomDetails.ID));
}
public bool DeleteRoomDetails(RoomDetails RoomDetails)
{
_log.LogError("");
return(_repository.Delete <RoomDetails>(RoomDetails));
}
public bool EditRoomDetails(RoomDetails RoomDetails)
{
_log.LogError("");
return(_repository.Update <RoomDetails>(RoomDetails));
}
public bool RecoredRoomDetails(RoomDetails RoomDetails)
{
_log.LogError("");
return(_repository.Create <RoomDetails>(RoomDetails));
}
// Start is called before the first frame update
void Start()
{
countdown = transform.GetChild(0).GetComponent <TextMeshProUGUI>();
roomDetails = transform.GetComponentInParent <UIGameManager>().RoomDetails;
}
public void GetRoomDetailsByRoomAddress(string roomAddress, RoomDetails roomDetails)
{
var url = ServerUrl + RoomInformantionPath + "/" + Regex.Match(roomAddress, @"(.*)@ptc.com").Groups[1].Value;
StartCoroutine(GetRoomByAddressCoroutine(url, roomDetails));
}
/// <summary>
/// Function to generate the room list entered by the hotel
/// </summary>
/// <param name="hotel"></param>
/// <returns></returns>
public static List <RoomDetails> FilterRoomsDAL(string hotel)
{
List <RoomDetails> BookList = null;
try
{
conTraining.Open();
SqlCommand cmdAddRoom = new SqlCommand();
cmdAddRoom.Connection = conTraining;
cmdAddRoom.CommandType = CommandType.StoredProcedure;
//conTraining.Open();
//await conTraining.OpenAsync();
cmdAddRoom.CommandText = "[GROUP3].[USP_DisplayRoomDetails]";
SqlParameter[] paramRoom = new SqlParameter[1];
paramRoom[0] = new SqlParameter("@hotel_id", SqlDbType.VarChar, 10);
paramRoom[0].Direction = ParameterDirection.Input;
paramRoom[0].Value = hotel;
cmdAddRoom.Parameters.Add(paramRoom[0]);
SqlDataReader readerHotel = null;
readerHotel = cmdAddRoom.ExecuteReader();
DataTable BookTable = new DataTable();
//Load the Data into the table from the Datareader.
BookTable.Load(readerHotel);
if (BookTable.Rows.Count > 0)
{
BookList = new List <RoomDetails>();
foreach (DataRow row in BookTable.Rows)
{
RoomDetails Room = new RoomDetails();
Room.HotelID = (string)(row[0]);
Room.RoomID = (string)(row[1]);
Room.RoomNo = (string)(row[2]);
Room.RoomType = (string)(row[3]);
Room.PerNightrate = (int)(row[4]);
Room.Availability = (int)(row[5]);
BookList.Add(Room);
}
}
else
{
throw new HMS_Exception("No Records Found");
}
}
catch (HMS_Exception)
{ throw; }
catch (SqlException ex)
{
throw ex;
}
catch (SystemException ex)
{ throw ex; }
finally
{
conTraining.Close();
}
return(BookList);
}
private void RoomCard(HoverTextDrawer hoverTextDrawer)
{
CavityInfo cavityForCell = Game.Instance.roomProber.GetCavityForCell(cellPos);
if (cavityForCell == null)
{
return;
}
Room room = cavityForCell.room;
RoomType roomType = room?.roomType;
hoverTextDrawer.BeginShadowBar(false);
string roomTypeName = roomType?.Name ?? UI.OVERLAYS.ROOMS.NOROOM.HEADER;
hoverTextDrawer.DrawText(roomTypeName, __this.Styles_BodyText.Standard);
if (room != null)
{
string roomEffect = RoomDetails.EFFECT.resolve_string_function.Invoke(room);
string roomAssignee = RoomDetails.ASSIGNED_TO.resolve_string_function.Invoke(room);
string roomCriteria = RoomConstraints.RoomCriteriaString(room);
string roomEffects = RoomDetails.EFFECTS.resolve_string_function.Invoke(room);
if (roomEffect != "")
{
hoverTextDrawer.NewLine(26);
hoverTextDrawer.DrawText(roomEffect, __this.Styles_BodyText.Standard);
}
if (roomAssignee != "" && roomType != Db.Get().RoomTypes.Neutral)
{
hoverTextDrawer.NewLine(26);
hoverTextDrawer.DrawText(roomAssignee, __this.Styles_BodyText.Standard);
}
hoverTextDrawer.NewLine(22);
hoverTextDrawer.DrawText(RoomDetails.RoomDetailString(room), __this.Styles_BodyText.Standard);
if (roomCriteria != "")
{
hoverTextDrawer.NewLine(26);
hoverTextDrawer.DrawText(roomCriteria, __this.Styles_BodyText.Standard);
}
if (roomEffects != "")
{
hoverTextDrawer.NewLine(26);
hoverTextDrawer.DrawText(roomEffects, __this.Styles_BodyText.Standard);
}
}
else
{
string roomNA = UI.OVERLAYS.ROOMS.NOROOM.DESC;
int maxRoomSize = TuningData <RoomProber.Tuning> .Get().maxRoomSize;
if (cavityForCell.numCells > maxRoomSize)
{
roomNA = roomNA + "\n" + string.Format(UI.OVERLAYS.ROOMS.NOROOM.TOO_BIG, cavityForCell.numCells, maxRoomSize);
}
hoverTextDrawer.NewLine(26);
hoverTextDrawer.DrawText(roomNA, __this.Styles_BodyText.Standard);
}
hoverTextDrawer.EndShadowBar();
}
/// <summary>
/// To add room details
/// </summary>
/// <param name="newRoom"></param>
/// <returns></returns>
public static bool AddRoomDAL(RoomDetails newRoom)
{
bool RoomAdded = false;
try
{
SqlCommand cmdAddRoom = new SqlCommand();
cmdAddRoom.Connection = conTraining;
cmdAddRoom.CommandType = CommandType.StoredProcedure;
cmdAddRoom.CommandText = "[GROUP3].[USP_InsertRoomDetails]";
conTraining.Open();
SqlParameter[] paramRoom = new SqlParameter[6];
paramRoom[0] = new SqlParameter("@hotel_id", SqlDbType.NVarChar, 4);
paramRoom[0].Direction = ParameterDirection.Input;
paramRoom[0].Value = newRoom.HotelID;
cmdAddRoom.Parameters.Add(paramRoom[0]);
paramRoom[1] = new SqlParameter("@room_id", SqlDbType.NVarChar, 4);
paramRoom[1].Direction = ParameterDirection.Input;
paramRoom[1].Value = newRoom.RoomID;
cmdAddRoom.Parameters.Add(paramRoom[1]);
paramRoom[2] = new SqlParameter("@room_no", SqlDbType.NVarChar, 3);
paramRoom[2].Direction = ParameterDirection.Input;
paramRoom[2].Value = newRoom.RoomNo;
cmdAddRoom.Parameters.Add(paramRoom[2]);
paramRoom[3] = new SqlParameter("@room_type", SqlDbType.NVarChar, 20);
paramRoom[3].Direction = ParameterDirection.Input;
paramRoom[3].Value = newRoom.RoomType;
cmdAddRoom.Parameters.Add(paramRoom[3]);
paramRoom[4] = new SqlParameter("@per_night_rate", SqlDbType.Int);
paramRoom[4].Direction = ParameterDirection.Input;
paramRoom[4].Value = newRoom.PerNightrate;
cmdAddRoom.Parameters.Add(paramRoom[4]);
paramRoom[5] = new SqlParameter("@RoomAvailability", SqlDbType.Int);
paramRoom[5].Direction = ParameterDirection.Input;
paramRoom[5].Value = newRoom.Availability;
cmdAddRoom.Parameters.Add(paramRoom[5]);
//paramRoom[6] = new SqlParameter("@photo", SqlDbType.Image);
//paramRoom[6].Direction = ParameterDirection.Input;
//paramRoom[6].Value = newRoom.photo;
//cmdAddRoom.Parameters.Add(paramRoom[6]);
int affectedRows = cmdAddRoom.ExecuteNonQuery(); // DataConnection.ExecuteNonQueryCommand(cmdAddProduct);
if (affectedRows > 0)
{
RoomAdded = true;
}
}
catch (HMS_Exception)
{ throw; }
catch (SqlException)
{
throw;
}
catch (Exception)
{ throw; }
conTraining.Close();
return(RoomAdded);
}
/// <summary>
/// Function to validate Room
/// </summary>
/// <param name="Room"></param>
/// <returns></returns>
private static bool ValidateRoom(RoomDetails Room)
{
bool validroom = true;
StringBuilder message = new StringBuilder();
//validating for first name
if ((Room.HotelID.Length == 0))
{
validroom = false;
message.Append(Environment.NewLine + " Hotel ID is Required");
}
if (!(Regex.IsMatch(Room.HotelID, @"^[0-9]{4}$")))
{
validroom = false;
message.Append(Environment.NewLine + "Hotel id must Contain 4 digits only");
}
if ((Room.RoomID.Length == 0))
{
validroom = false;
message.Append(Environment.NewLine + " Room ID is Required");
}
if (!(Regex.IsMatch(Room.RoomID, @"^[0-9]{4}$")))
{
validroom = false;
message.Append(Environment.NewLine + "Room id must Contain 4 digits only");
}
if ((Room.RoomNo.Length == 0))
{
validroom = false;
message.Append(Environment.NewLine + " Room number is Required");
}
if ((Room.RoomType.Length == 0))
{
validroom = false;
message.Append(Environment.NewLine + "Room Type is Required");
}
if (Room.PerNightrate.ToString().Equals(string.Empty))
{
validroom = false;
message.Append(Environment.NewLine + " Per Night Rate is required");
}
if (Room.Availability.ToString().Equals(string.Empty))
{
validroom = false;
message.Append(Environment.NewLine + " Per Night Rate is required");
}
//if (Room.photo.ToString().Equals(string.Empty))
//{
// validroom = false;
// message.Append(Environment.NewLine + "Phone Number rate is required ");
//}
if (validroom == false)
{
throw new HMS_Exception(message.ToString());
}
return(validroom);
}
public ActionResult RoomInformation(string sVendorId, string sRoomTypeId)
{
var propDetail = TempData["propDetailsTG"] as PropDetailsM;
RoomDetails objRoomDetails = BL_PropDetailsTG.GetRoomDetails(sVendorId, sRoomTypeId);
if (objRoomDetails.Policy == null)
{
objRoomDetails.Policy = new List <RoomPolicy>();
}
if (propDetail != null)
{
var roomDetail = propDetail.TG_Hotel.RoomDetails.Where(x => x.RoomId == sRoomTypeId).FirstOrDefault();
if (roomDetail != null)
{
if (roomDetail.RoomImages != null && roomDetail.RoomImages.Count > 0)
{
objRoomDetails.Images = new List <RoomImages>();
objRoomDetails.ThumbImages = new List <RoomImages>();
foreach (var item in roomDetail.RoomImages)
{
if (!string.IsNullOrEmpty(item))
{
objRoomDetails.ThumbImages.Add(new RoomImages()
{
sRoomImage = item
});
objRoomDetails.Images.Add(new RoomImages()
{
sRoomImage = item
});
var imageName = Path.GetFileName(item);
//if (imageName.Contains("_TN"))
//{
// objRoomDetails.ThumbImages.Add(new RoomImages() { sRoomImage = item });
//}
//else
//{
// objRoomDetails.Images.Add(new RoomImages() { sRoomImage = item });
//}
}
}
}
var ratePlans = roomDetail.RatePlans;
objRoomDetails.sRoomName = roomDetail.RoomName;
objRoomDetails.ExtrabedCharge = ratePlans.FirstOrDefault().TotalExtraBedCharge.ToString();
foreach (var item in roomDetail.RatePlans)
{
objRoomDetails.RateInclusions += item.RateInclusions + Environment.NewLine;
objRoomDetails.CancellationPolicy += item.CancellationPolicyDescription + Environment.NewLine;
// TO DO
//var roomPolicy = new RoomPolicy();
//roomPolicy.sExtraCharge = item.TotalExtraBedCharge.ToString();
//roomPolicy.iMax_Guest_Occupancy = short.Parse(roomDetail.MaxOccupancy);
//roomPolicy.iMax_Adult_Occupancy = short.Parse(roomDetail.MaxAdult);
//roomPolicy.iMax_Child_Occupancy = short.Parse(roomDetail.MaxChild);
//roomPolicy.sAge = roomDetail.MinChildAge;
//objRoomDetails.Policy.Add(roomPolicy);
}
}
}
else
{
objRoomDetails.ThumbImages = objRoomDetails.Images;
}
return(PartialView("pvRoomInfo", objRoomDetails));
}
