public int rememberRating(string studId, string accommoId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from rate in db.CLIENT_HOTEL_RATINGs where rate.CLIENT_ID.Equals(Convert.ToInt32(studId)) && rate.HOTEL_ID.Equals(Convert.ToInt32(accommoId)) select rate);
if (query.Count() == 1)
{
CLIENT_HOTEL_RATING tbl = query.Single();
return(tbl.RATING_VALUE);
}
else
{
}
return(-1);
}
}
catch (Exception)
{
return(-1);
}
}
public int getAccommoRatingsByStud(string studId, string accommoId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from rating in db.CLIENT_HOTEL_RATINGs
where rating.CLIENT_ID.Equals(Convert.ToInt32(studId)) && rating.HOTEL_ID.Equals(Convert.ToInt32(accommoId))
select rating);
CLIENT_HOTEL_RATING ratedAccommo = query.Single();
return(ratedAccommo.RATING_VALUE);
}
}
catch (Exception)
{
return(-1);
}
}
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();
}
}
