public List <SiteModel> GetSitesByKeyword(string i_Keyword)
{
List <SiteModel> sites = new List <SiteModel>();
try
{
using (MyDiveEntities MyDiveDB = new MyDiveEntities())
{
ObjectResult <stp_GetSitesByKeywors_Result> sitesResult = MyDiveDB.stp_GetSitesByKeywors(i_Keyword);
foreach (stp_GetSitesByKeywors_Result site in sitesResult)
{
ObjectResult <stp_GetSiteCoordinates_Result> coordinates = MyDiveDB.stp_GetSiteCoordinates(site.SiteID);
sites.Add(new SiteModel
{
SiteID = site.SiteID,
Name = site.Name,
Rating = site.Rating,
Coordinates = getCoordinates(coordinates)
});
}
Logger.Instance.Notify("Fetch sites", eLogType.Info, i_Keyword);
}
}
catch (Exception ex)
{
Logger.Instance.Notify(ex.StackTrace, eLogType.Error, i_Keyword);
}
return(sites);
}
public IHttpActionResult GetUserWishList(int i_UserId)
{
LogControllerEntring("getuserwish");
IHttpActionResult result = Ok();
try
{
using (MyDiveEntities MyDiveDB = new MyDiveEntities())
{
ObjectResult <stp_GetUserWishList_Result> serverResult = MyDiveDB.stp_GetUserWishList(i_UserId);
List <UserWishListModel> userWishList = new List <UserWishListModel>();
foreach (stp_GetUserWishList_Result res in serverResult)
{
userWishList.Add(new UserWishListModel
{
WishID = res.WishID,
SiteID = res.SiteID,
UserID = res.UserID,
City = res.CityName,
Country = res.CountryName,
SiteInfo = new SiteModel
{
Name = res.Name,
Rating = res.Rating,
SiteID = res.SiteID,
Coordinates = SiteLogic.getCoordinates(MyDiveDB.stp_GetSiteCoordinates(res.SiteID))
}
});
}
LogData("fetch user wish list", i_UserId);
result = Ok(userWishList.Count > 0 ? userWishList : null);
}
}
catch (Exception ex)
{
result = LogException(ex, null);
}
return(result);
}
