/** public void makeRatingJson(string studentId, string accommoId, string ratingValue)
* {
*
* }*/
string IRateAccommodationService.makeRatingJson(string studentId, string accommoId, string ratingValue)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
ClientHotelRatings ratings = new ClientHotelRatings()
{
HotelID = Convert.ToInt32(accommoId),
RatingValue = Convert.ToInt32(ratingValue),
ClientID = Convert.ToInt32(studentId),
};
makeRating(ratings);
return("Successfully Submitted");
}
}
catch (Exception e)
{
e.GetBaseException();
}
return("Didnt submit");
}
public void makeRating(ClientHotelRatings ratingMade)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from rating in db.CLIENT_HOTEL_RATINGs
where rating.CLIENT_ID.Equals(Convert.ToInt32(ratingMade.ClientID)) && rating.HOTEL_ID.Equals(Convert.ToInt32(ratingMade.HotelID))
select rating);
int count = query.Count();
if (count == 0)
{
CLIENT_HOTEL_RATING AccommoRating = new CLIENT_HOTEL_RATING()
{
HOTEL_ID = ratingMade.HotelID,
CLIENT_ID = ratingMade.ClientID,
RATING_VALUE = ratingMade.RatingValue
};
db.CLIENT_HOTEL_RATINGs.InsertOnSubmit(AccommoRating);
db.SubmitChanges();
}
if (count == 1)
{
CLIENT_HOTEL_RATING update = new CLIENT_HOTEL_RATING();
update = query.Single();
update.RATING_VALUE = ratingMade.RatingValue;
}
}
}
catch (Exception e)
{
e.GetBaseException();
}
}
