public ActionResult TopPeople(string peopleSearch)
{
#region
MemberAction objMember = new MemberAction();
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
//Search User by name
IList<Member> memberSearchList = objMember.GetMembersByName(peopleSearch);
if (memberSearchList.Count > 0)
{
ViewData["MostActive"] = memberSearchList;
SessionStore.SetSessionValue(SessionStore.PeopleSearch, memberSearchList);
}
else
{
//Most Active if search does not return result
IList<Member> memberList = objMember.GetAllMember();
if (memberData != null)
{
memberList = memberList.Where(x => x.id != memberData.id).OrderByDescending(x => x.Seeds.Count()).ToList();
}
else
{
memberList = memberList.OrderByDescending(x => x.Seeds.Count()).ToList();
}
ViewData["MostActive"] = memberList;
ViewData["NoResult"] = "Your search did not return any result, showing most active users";
}
//Nearby Users
CommonMethods objCmnMethods = new CommonMethods();
string strIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
if (strIpAddress == "127.0.0.1")
strIpAddress = "61.246.241.162";
string ipLocation = objCmnMethods.IP2AddressAPI(strIpAddress);
string zipCodeSearch = string.Empty;
string[] currentAddress;
if (!string.IsNullOrEmpty(ipLocation))
{
//IPaddressAPI
currentAddress = ipLocation.Split(',');
if (string.IsNullOrEmpty(currentAddress[7].Replace("\"", "").ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[7].Replace("\"", "").ToString();
}
else
{
//MaxMind
ipLocation = objCmnMethods.IP2AddressMaxMind();
currentAddress = ipLocation.Split('\'');
if (string.IsNullOrEmpty(currentAddress[15].ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[15].ToString();
}
IList<Member> lstMember = new List<Member>();
if (memberData != null)
lstMember = objMember.GetMembersByZip(zipCodeSearch).Where(x => x.id != memberData.id).ToList();
else
lstMember = objMember.GetMembersByZip(zipCodeSearch);
ViewData["NearbyUsers"] = lstMember.Distinct().ToList();
return View();
#endregion
}
public ActionResult Default()
{
#region PreviousCoding
Repository repoObj = new Repository();
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
if (memberData != null)
{
//ViewData["LocationData"] = locations;
//ViewData["Memberlocation"] = memberLocation;
}
else
{
string logoutString = TempData["Logout"] as string;
if (logoutString != "Logout")
{
const string myFacebookApiKey = "101151816623334";
const string myFacebookSecret = "65f49046dce2d1f54d6991e43c4af675";
var connectSession = new ConnectSession(myFacebookApiKey, myFacebookSecret);
if (connectSession.IsConnected())
{
ViewData["FBConnected"] = true;
var api = new Api(connectSession);
ViewData["FBUser"] = api.Users.GetInfo();
ViewData["UserID"] = api.Users.GetInfo().uid;
SessionStore.SetSessionValue(SessionStore.FacebookConnect, "FacebookUserLoggedIn");
string[] fbDetails = new string[2];
fbDetails[0] = Convert.ToString("fb_" + api.Users.GetInfo().uid);
fbDetails[1] = api.Users.GetInfo().name;
SessionStore.SetSessionValue("FacebookDetails", fbDetails);
api.Session.Logout();
connectSession.Logout();
return RedirectToAction("FBUser", "Member");
}
}
}
#endregion
GetTopPlanters();
CommonMethods objCmnMethods = new CommonMethods();
string strIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
if (strIpAddress == "127.0.0.1")
strIpAddress = "61.246.241.162";
string citySearch = string.Empty;
string stateSearch = string.Empty;
string zipCodeSearch = string.Empty;
string latSearch = string.Empty;
string lngSearch = string.Empty;
string[] currentAddress;
string ipLocation = objCmnMethods.MaxMindIPData(strIpAddress);
if (!string.IsNullOrEmpty(ipLocation) && (!ipLocation.Contains("IP_NOT_FOUND")))
{
//IPaddressAPI
currentAddress = ipLocation.Split(',');
if (string.IsNullOrEmpty(currentAddress[1].Replace("\"", "").ToString()))
stateSearch = "AZ";
else
{
stateSearch = currentAddress[1].Replace("\"", "").ToString();
//stateSearch = "WA";
}
if (string.IsNullOrEmpty(currentAddress[2].ToString()))
citySearch = "Phoenix";
else
{
citySearch = currentAddress[2].Replace("\"", "").ToString();
//citySearch = "Seattle";
}
if (string.IsNullOrEmpty(currentAddress[3].Replace("\"", "").ToString()))
{
//zipCodeSearch = "85027";
SeedAction objS = new SeedAction();
LocationAction objLocation = new LocationAction();
string cityId = objLocation.GetCityIdByCityName(citySearch, stateSearch);
zipCodeSearch = objS.GetZipOfSeedByCityId(cityId);
}
else
zipCodeSearch = currentAddress[3].Replace("\"", "").ToString();
latSearch = currentAddress[4].Replace("\"", "").ToString();
lngSearch = currentAddress[5].Replace("\"", "").ToString();
}
else
{
//MaxMind
ipLocation = objCmnMethods.IP2AddressMaxMind();
currentAddress = ipLocation.Split('\'');
if (string.IsNullOrEmpty(currentAddress[7].ToString()))
stateSearch = "AZ";
else
stateSearch = currentAddress[7].ToString();
if (string.IsNullOrEmpty(currentAddress[5].ToString()))
citySearch = "Phoenix";
else
citySearch = currentAddress[5].ToString();
if (string.IsNullOrEmpty(currentAddress[15].ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[15].ToString();
latSearch = currentAddress[11].ToString();
lngSearch = currentAddress[13].ToString();
}
ViewData["LocLat"] = latSearch;
ViewData["LocLng"] = lngSearch;
Session["LocLatLng"] = latSearch + "," + lngSearch;
SeedAction objSeed = new SeedAction();
IList<Seed> lstSeed = getHomeSearchResult(citySearch, "", "", zipCodeSearch, "");
if (lstSeed.Count > 0)
{
ViewData["SeedList"] = lstSeed.OrderByDescending(x => x.createDate).ToList();
ViewData["userLocation"] = "Your Location : " + citySearch + ", " + stateSearch;
ViewData["CatLocation"] = citySearch + ", " + stateSearch;
}
else
{
lstSeed = repoObj.List<Seed>().Where(x => x.status.Equals(SystemStatements.STATUS_NEW) || x.status.Equals(SystemStatements.STATUS_GROWING)).OrderByDescending(x => x.createDate).Take(20).ToList();
ViewData["SeedList"] = lstSeed;
ViewData["userLocation"] = "Your Location : " + citySearch + ", " + stateSearch;
ViewData["CatLocation"] = citySearch + ", " + stateSearch;
ViewData["CitySearchMsg"] = "<span>Sorry, no seeds planted in '" + citySearch + "' area. Showing latest additions.</span>";
string streamFeed = "Select top 20 * from Seed order by createDate desc";
SessionStore.SetSessionValue(SessionStore.DefaultFeed, streamFeed);
}
string advSearch = TempData["DiscoverSeed"] as string;
if (advSearch != "AdvanceSearch")
{
if (lstSeed.Count > 0)
SessionStore.SetSessionValue(SessionStore.DiscoverSeed, lstSeed);
}
if (SessionStore.GetSessionValue(SessionStore.DiscoverSeed) != null)
lstSeed = (IList<Seed>)SessionStore.GetSessionValue(SessionStore.DiscoverSeed);
int rowCount = lstSeed.Count;
Session["RowCount"] = rowCount;
Session["PageCount"] = "1";
ViewData["SeedList"] = lstSeed.Take(10).ToList();
ViewData["PrevVisibility"] = "visibility:hidden;";
if (lstSeed.Count > 10)
ViewData["NxtVisibility"] = "visibility:visible;";
else
ViewData["NxtVisibility"] = "visibility:hidden;";
foreach (Seed sd in lstSeed)
{
sd.seedDistance = (int)objCmnMethods.distance(Convert.ToDouble(latSearch), Convert.ToDouble(lngSearch), Convert.ToDouble(sd.Location.localLat), Convert.ToDouble(sd.Location.localLong));
}
if (lstSeed.Count > 0)
SessionStore.SetSessionValue(SessionStore.DiscoverSeed, lstSeed);
ViewData["SeedList"] = lstSeed.OrderBy(x => x.seedDistance).ToList();
ViewData["MarkerList"] = MarkerGenerator((IList<Seed>)ViewData["SeedList"]);
//ListBox
if (Session["SelectedCategory"] != null)
{
Session["SelectedCategory"] = null;
}
else
{
if (str != null)
{
string myString = null;
for (int i = 0; i < str.Length; i++)
{
if (i == 0)
{
myString = str[i];
}
else
{
myString = myString + "," + str[i];
}
}
Session["SelectedCategory"] = myString;
ViewData["SelectedCategories"] = myString;
}
}
//ListBox
if (lstSeed.Count > 0)
{
CategoryAction objCat = new CategoryAction();
IList<Category> categ = new List<Category>();
Category c = null;
foreach (Seed s in lstSeed)
{
IList<Category> listCategory = s.Categories.ToList();
if (listCategory.Count > 0)
{
foreach (Category c1 in listCategory)
{
c = objCat.GetCategoryById(s.Categories.FirstOrDefault().id.ToString());
if (c != null)
categ.Add(c);
}
}
}
ViewData["SeedCategories"] = categ.Distinct().ToList();
}
return View();
}
public IList<Seed> ProximitySort()
{
IList<Seed> listSeed = null;
string ip = System.Web.HttpContext.Current.Request.UserHostAddress;
if (ip == "127.0.0.1")
ip = "61.246.241.162";
CommonMethods objCmnMethods = new CommonMethods();
//MaxMind
string zipSearch = string.Empty;
string[] currentAddress = objCmnMethods.IP2AddressMaxMind().Split('\'');
if (currentAddress[15].ToString() == "")
zipSearch = "85027";
listSeed = getHomeSearchResult("", "", "", zipSearch, "");
return listSeed;
}
public IList<Seed> getNewestNearby(string radius)
{
#region
CommonMethods objCmnMethods = new CommonMethods();
string strIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
if (strIpAddress == "127.0.0.1")
strIpAddress = "61.246.241.162";
string ipLocation = objCmnMethods.IP2AddressAPI(strIpAddress);
string citySearch = string.Empty;
string stateSearch = string.Empty;
string zipCodeSearch = string.Empty;
string latSearch = string.Empty;
string lngSearch = string.Empty;
string[] currentAddress;
if (!string.IsNullOrEmpty(ipLocation))
{
//IPaddressAPI
currentAddress = ipLocation.Split(',');
if (string.IsNullOrEmpty(currentAddress[4].Replace("\"", "").ToString()))
stateSearch = "AZ";
else
stateSearch = currentAddress[4].Replace("\"", "").ToString();
if (string.IsNullOrEmpty(currentAddress[6].ToString()))
citySearch = "Phoenix";
else
citySearch = currentAddress[6].Replace("\"", "").ToString();
if (string.IsNullOrEmpty(currentAddress[7].Replace("\"", "").ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[7].Replace("\"", "").ToString();
latSearch = currentAddress[8].Replace("\"", "").ToString();
lngSearch = currentAddress[9].Replace("\"", "").ToString();
}
else
{
//MaxMind
ipLocation = objCmnMethods.IP2AddressMaxMind();
currentAddress = ipLocation.Split('\'');
if (string.IsNullOrEmpty(currentAddress[7].ToString()))
stateSearch = "AZ";
else
stateSearch = currentAddress[7].ToString();
if (string.IsNullOrEmpty(currentAddress[5].ToString()))
citySearch = "Phoenix";
else
citySearch = currentAddress[5].ToString();
if (string.IsNullOrEmpty(currentAddress[15].ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[15].ToString();
latSearch = currentAddress[11].ToString();
lngSearch = currentAddress[13].ToString();
}
SeedAction objSeed = new SeedAction();
IList<Seed> lstSeed = objSeed.GetAllSeedsByZip(radius, zipCodeSearch);
return lstSeed.Where(x => (x.status.Equals(SystemStatements.STATUS_NEW) || x.status.Equals(SystemStatements.STATUS_GROWING))).ToList();
#endregion
}
public ActionResult Streams()
{
#region
CommonMethods objCmnMethods = new CommonMethods();
string strIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
if (strIpAddress == "127.0.0.1")
strIpAddress = "61.246.241.162";
string ipLocation = objCmnMethods.IP2AddressAPI(strIpAddress);
string zipCodeSearch = string.Empty;
string[] currentAddress;
if (!string.IsNullOrEmpty(ipLocation))
{
//IPaddressAPI
currentAddress = ipLocation.Split(',');
if (string.IsNullOrEmpty(currentAddress[7].Replace("\"", "").ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[7].Replace("\"", "").ToString();
}
else
{
//MaxMind
ipLocation = objCmnMethods.IP2AddressMaxMind();
currentAddress = ipLocation.Split('\'');
if (string.IsNullOrEmpty(currentAddress[15].ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[15].ToString();
}
StreamAction objStream = new StreamAction();
IList<ssStream> streamData = new List<ssStream>();
streamData = objStream.GetAllStreamByZip(zipCodeSearch);
if (streamData.Count() < 1)
streamData = objStream.GetLatestStreams();
streamData = streamData.Distinct().ToList();
ViewData["SearchStream"] = streamData;
IList<ssStream> latestStreams = new List<ssStream>();
latestStreams = objStream.GetLatestStreams();
ViewData["LatestStreams"] = latestStreams;
IList<ssStream> mostPopularStreams = new List<ssStream>();
mostPopularStreams = objStream.GetMostPopularStreams();
ViewData["MostPopular"] = mostPopularStreams;
ViewData["SearchTerm"] = "Nearby Feeds";
return View();
#endregion
}
public ActionResult SearchSeeds()
{
#region
CommonMethods objCmnMethods = new CommonMethods();
string strIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
if (strIpAddress == "127.0.0.1")
strIpAddress = "61.246.241.162";
string ipLocation = objCmnMethods.IP2AddressAPI(strIpAddress);
string citySearch = string.Empty;
string stateSearch = string.Empty;
string zipCodeSearch = string.Empty;
string latSearch = string.Empty;
string lngSearch = string.Empty;
string[] currentAddress;
if (!string.IsNullOrEmpty(ipLocation))
{
//IPaddressAPI
currentAddress = ipLocation.Split(',');
if (string.IsNullOrEmpty(currentAddress[4].Replace("\"", "").ToString()))
stateSearch = "AZ";
else
stateSearch = currentAddress[4].Replace("\"", "").ToString();
if (string.IsNullOrEmpty(currentAddress[6].ToString()))
citySearch = "Phoenix";
else
citySearch = currentAddress[6].Replace("\"", "").ToString();
if (string.IsNullOrEmpty(currentAddress[7].Replace("\"", "").ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[7].Replace("\"", "").ToString();
latSearch = currentAddress[8].Replace("\"", "").ToString();
lngSearch = currentAddress[9].Replace("\"", "").ToString();
}
else
{
//MaxMind
ipLocation = objCmnMethods.IP2AddressMaxMind();
currentAddress = ipLocation.Split('\'');
if (string.IsNullOrEmpty(currentAddress[7].ToString()))
stateSearch = "AZ";
else
stateSearch = currentAddress[7].ToString();
if (string.IsNullOrEmpty(currentAddress[5].ToString()))
citySearch = "Phoenix";
else
citySearch = currentAddress[5].ToString();
if (string.IsNullOrEmpty(currentAddress[15].ToString()))
zipCodeSearch = "85027";
else
zipCodeSearch = currentAddress[15].ToString();
latSearch = currentAddress[11].ToString();
lngSearch = currentAddress[13].ToString();
}
IList<Seed> lstSeed = null;
if (SessionStore.GetSessionValue(SessionStore.SearchSeeds) != null)
lstSeed = (IList<Seed>)SessionStore.GetSessionValue(SessionStore.SearchSeeds);
foreach (Seed sd in lstSeed)
{
sd.seedDistance = (int)objCmnMethods.distance(Convert.ToDouble(latSearch), Convert.ToDouble(lngSearch), Convert.ToDouble(sd.Location.localLat), Convert.ToDouble(sd.Location.localLong));
}
ViewData["SearchSeeds"] = lstSeed;
return View();
#endregion
}
public ActionResult AdvanceSearch(string AdvLocation, string currentLocValue, string AnotherLocValue, string LocationAdvSearchRadius, string CoordinatesAdvSearchRadius, string advMedia, string advReplySeeds, string txtAdvSearchIncludeTerms, string txtAdvSearchExcludeTerms)
{
#region Front Logic
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
SeedAction objSeed = new SeedAction();
string advSearchQuery = "Select Seed.* from Seed where (seed.[status] = 'New' or seed.[status] = 'Growing')";
if (advReplySeeds != "IncludeReplySeeds")
advSearchQuery += " and seed.parentSeedID is null";
#region add location in query
if (!string.IsNullOrEmpty(AdvLocation))
{
if (AdvLocation != "AllLocations")
{
string radius = string.Empty;
string radiusZipList = string.Empty;
string ZipCodeAdvSearch = string.Empty;
if (AdvLocation == "CurrentLocation")
{
radius = currentLocValue;
CommonMethods objCmnMethods = new CommonMethods();
string strIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
if (strIpAddress == "127.0.0.1")
strIpAddress = "61.246.241.162";
string ipLocation = objCmnMethods.IP2AddressAPI(strIpAddress);
string[] currentAddress;
if (!string.IsNullOrEmpty(ipLocation))
{
//IPaddressAPI
currentAddress = ipLocation.Split(',');
if (string.IsNullOrEmpty(currentAddress[7].Replace("\"", "").ToString()))
ZipCodeAdvSearch = "85027";
else
ZipCodeAdvSearch = currentAddress[7].Replace("\"", "").ToString();
}
else
{
//MaxMind
ipLocation = objCmnMethods.IP2AddressMaxMind();
currentAddress = ipLocation.Split('\'');
if (string.IsNullOrEmpty(currentAddress[15].ToString()))
ZipCodeAdvSearch = "85027";
else
ZipCodeAdvSearch = currentAddress[15].ToString();
}
}
if (AdvLocation == "NewLocation")
{
radius = AnotherLocValue;
//Format address
string[] splitAddressSearch = LocationAdvSearchRadius.Split(',');
if (splitAddressSearch.Length > 4)
{
string[] splitZipRegion = splitAddressSearch[3].ToString().Trim().Split(' ');
ZipCodeAdvSearch = splitZipRegion[1].ToString().Trim();
}
else
{
string[] splitZipRegion = splitAddressSearch[2].ToString().Trim().Split(' ');
ZipCodeAdvSearch = splitZipRegion[1].ToString().Trim();
}
//End formatting address
}
//Get zip codes according to radius
CommonMethods objCommon = new CommonMethods();
radiusZipList = objCommon.GetZipByRadiusNew(radius, ZipCodeAdvSearch);
//End get zip codes according to radius
if (string.IsNullOrEmpty(radiusZipList))
radiusZipList = ZipCodeAdvSearch;
advSearchQuery += " and locationId in (Select id from Location where zipcode in (" + radiusZipList + "))";
}
}
#endregion
#region include terms in query
if (!string.IsNullOrEmpty(txtAdvSearchIncludeTerms))
{
string inCondition = string.Empty;
string[] includeTerms = txtAdvSearchIncludeTerms.Split(',');
for (int i = 0; i < includeTerms.Length; i++)
{
if (i == 0)
inCondition = "'" + includeTerms[i].ToString() + "'";
else
inCondition += ",'" + includeTerms[i].ToString() + "'";
}
advSearchQuery += " and Seed.id in (select sc.seedId from Category c ,Seed_has_Category sc where c.id=sc.categoryId and c.name in (" + inCondition + ") union select Seed.id from Seed,Member where Member.id = Seed.ownerId and Member.firstName in (" + inCondition + "))";
}
#endregion
#region exclude terms in query
if (!string.IsNullOrEmpty(txtAdvSearchExcludeTerms))
{
string exCondition = string.Empty;
string[] excludeTerms = txtAdvSearchExcludeTerms.Split(',');
for (int i = 0; i < excludeTerms.Length; i++)
{
if (i == 0)
exCondition = "'" + excludeTerms[i].ToString() + "'";
else
exCondition += ",'" + excludeTerms[i].ToString() + "'";
}
advSearchQuery += " and Seed.id not in (select sc.seedId from Category c ,Seed_has_Category sc where c.id=sc.categoryId and c.name in (" + exCondition + ") union select Seed.id from Seed,Member where Member.id = Seed.ownerId and Member.firstName in (" + exCondition + "))";
}
#endregion
#region add media in query
if (!string.IsNullOrEmpty(advMedia))
{
switch (advMedia)
{
case "All":
advSearchQuery += " and Seed.id in (Select m.seedId from Media m)";
break;
case "NoMedia":
advSearchQuery += " and Seed.id not in (Select m.seedId from Media m)";
break;
case "PhotosOnly":
advSearchQuery += " and Seed.id in (Select m.seedId from Media m where m.[type]='" + SystemStatements.MEDIA_IMAGE + "')";
break;
case "VideosOnly":
advSearchQuery += " and Seed.id in (Select m.seedId from Media m where m.[type]='" + SystemStatements.MEDIA_VIDEO + "')";
break;
default:
break;
}
}
#endregion
IList<Seed> lstSeed = null;
lstSeed = objSeed.GetSeedListByCriteria(advSearchQuery);
lstSeed = lstSeed.Distinct().ToList();
SessionStore.SetSessionValue(SessionStore.SearchSeeds, lstSeed);
TempData["DiscoverSeed"] = "AdvanceSearch";
#endregion
return RedirectToAction("SearchSeeds", "Home");
}
