public ActionResult ListSeed()
{
#region
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
if (memberData == null)
return RedirectToAction("Default", "Member");
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
IList<Location> locData = objLocation.GetLocationByMemberId(memberData.id.ToString());
List<Seed> currentSeedList = new List<Seed>();
if (locData != null)
{
foreach (Location tempLocation in locData)
{
IList<Seed> seedList = objSeed.GetSeedByLocationId(tempLocation.id.ToString());
foreach (Seed seedData in seedList)
{
if (seedData.status == SystemStatements.STATUS_NEW || seedData.status == SystemStatements.STATUS_GROWING)
currentSeedList.Add(seedData);
}
}
}
ViewData["ListSeed"] = currentSeedList;
return View();
#endregion
}
public string AddSeedData(AddSeed objAddSeedModel)
{
#region
bool actionCompleted = false;
Seed seedData = null;
SeedAction objSeed = new SeedAction();
Seed objSeedEntity = new Seed();
Member memberData = new Member();
Tag objTagEntity = new Tag();
objSeedEntity.title = objAddSeedModel.SeedName;
if (!string.IsNullOrEmpty(objAddSeedModel.rootSeedId))
objSeedEntity.rootSeedID = new Guid(objAddSeedModel.rootSeedId);
if (!string.IsNullOrEmpty(objAddSeedModel.parentSeedId))
objSeedEntity.parentSeedID = new Guid(objAddSeedModel.parentSeedId);
string s = Regex.Replace(objAddSeedModel.Description, @"<(.|\n)*?>", string.Empty);
s = s.Replace(" ", " ");
s = Regex.Replace(s, @"\s+", " ");
s = Regex.Replace(s, @"\r\n", "\n");
s = Regex.Replace(s, @"\n+", "\n");
string description = s;
if (description.Length > 999)
description = description.Substring(0, 995);
badWordsFilter objWords = new badWordsFilter();
string filePath = Server.MapPath("~/utils/badWords.xml");
List<string> lstBadWords = badWordsFilter.BadWordList(ref filePath);
description = objWords.FilterBadWords(lstBadWords, description);
objSeedEntity.description = description;
LocationAction objLocation = new LocationAction();
string cityid = objLocation.GetCityIdByCityName(objAddSeedModel.City, objAddSeedModel.StateCode);
if (string.IsNullOrEmpty(cityid))
cityid = objSeed.AddCity(objAddSeedModel.City, objAddSeedModel.StateCode);
if (string.IsNullOrEmpty(cityid))
throw new Exception("Please select associated state and city");
string latLong = objAddSeedModel.LongLat;
char[] separator = new char[] { ',' };
string[] strSplitLatLong = latLong.Split(separator);
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
string crossStreet = objAddSeedModel.StreetAddress.Trim();
Location objLoc = objLocation.CreateLocation(cityid, (objAddSeedModel.ZipCode).ToString(), Convert.ToDouble(lat), Convert.ToDouble(longt), crossStreet);
objSeedEntity.locationId = new Guid(objLoc.id.ToString());
if (SeedSpeak.Util.SessionStore.GetSessionValue(SeedSpeak.Util.SessionStore.Memberobject) != null)
memberData = (Member)SeedSpeak.Util.SessionStore.GetSessionValue(SeedSpeak.Util.SessionStore.Memberobject);
objSeedEntity.ownerId = memberData.id;
seedData = objSeed.AddSeed(objSeedEntity);
if (objSeedEntity.id != null)
{
if (!string.IsNullOrEmpty(objAddSeedModel.Tag))
{
objTagEntity.name = objAddSeedModel.Tag;
objTagEntity.seedId = objSeedEntity.id;
actionCompleted = objSeed.ManageTag(objTagEntity);
}
}
if (actionCompleted == false)
{
ModelState.AddModelError("", "Error while seed planting.");
RedirectToAction("AddSeed", "Seed");
}
return seedData.id.ToString();
#endregion
}
/// <summary>
/// This method is used to Add new Seeds.
/// </summary>
/// <param name="SeedName"></param>
/// <param name="Description"></param>
/// <param name="CityName"></param>
/// <param name="Street"></param>
/// <param name="RegionCode"></param>
/// <param name="LatLong"></param>
/// <param name="ZipCode"></param>
/// <param name="ownerId"></param>
/// <param name="tagName"></param>
/// <returns></returns>
public string AddSeedData(string SeedName, string Description, string CityName, string Street, string RegionCode, string Lat, string Lng, string ZipCode, string ownerId, string tagName, string imageName, string categoryNames)
{
bool actionCompleted = false;
Seed seedData = null;
string imagePath = imageName;
string result = "Error while seed planting.";
try
{
SeedAction objSeed = new SeedAction();
Seed objSeedEntity = new Seed();
Member memberData = new Member();
Tag objTagEntity = new Tag();
objSeedEntity.title = SeedName.Replace("|","&");
objSeedEntity.description = Description.Replace("|", "&");
LocationAction objLocation = new LocationAction();
string cityid = objLocation.GetCityIdByCityName(CityName, RegionCode);
if (string.IsNullOrEmpty(cityid))
cityid = objSeed.AddCity(CityName, RegionCode);
string lat = Lat;
string longt = Lng;
if (cityid.Length > 0)
{
Location objLoc = objLocation.CreateLocation(cityid, (ZipCode).ToString(), Convert.ToDouble(lat), Convert.ToDouble(longt), Street);
objSeedEntity.locationId = new Guid(objLoc.id.ToString());
objSeedEntity.ownerId = new Guid(ownerId);
seedData = objSeed.AddSeed(objSeedEntity);
actionCompleted = true;
result = seedData.id.ToString();
if (!string.IsNullOrEmpty(tagName))
{
if (seedData.id != null && tagName.Length > 0)
{
if (!tagName.Equals("(null)"))
{
objTagEntity.name = tagName;
objTagEntity.seedId = seedData.id;
actionCompleted = objSeed.ManageTag(objTagEntity);
}
}
}
if (!string.IsNullOrEmpty(imageName))
{
if (!imageName.Equals("No Image"))
{
AddMedia("Iphone Image1", imageName, seedData.id.ToString(), "Image", ownerId);
imagePath = System.Configuration.ConfigurationManager.AppSettings["RootURL"].ToString() + "/UploadedMedia/" + imageName;
}
}
if (!string.IsNullOrEmpty(categoryNames))
{
if (seedData.id != null && categoryNames.Length > 0)
{
if (!categoryNames.Equals("Select Category"))
{
string[] arrCategoryIds;
string[] arrCategoryNames;
string ids = string.Empty;
//categoryNames = categoryNames.TrimStart(',');
arrCategoryNames = categoryNames.Split(',');
CategoryAction objCategory = new CategoryAction();
for (int c = 0; c < arrCategoryNames.Length; c++)
{
if (!string.IsNullOrEmpty(ids))
ids = ids + "," + objCategory.GetCategoryIdByCategoryName(arrCategoryNames[c].ToString().Trim());
else
ids = objCategory.GetCategoryIdByCategoryName(arrCategoryNames[c].ToString().Trim());
}
arrCategoryIds = ids.Split(',');
if (categoryNames.Trim().ToString() != "" && arrCategoryIds.Length > 0)
{
objSeed.AddCategories(seedData.id.ToString(), arrCategoryIds);
}
}
}
}
result = seedData.id.ToString() + "||" + seedData.title + "||" + CityName + "||" + RegionCode + "||" + ZipCode + "||" + imageName + "||" + imagePath + "||" + DateTime.Now.ToString();
}
if (actionCompleted == false)
{
result = "Error while seed planting.";
}
}
catch (Exception ex)
{
result = "Error while seed planting.";
}
return result;
}
private void MyUsername(Privacy privacyData)
{
#region
LocationAction objLocation = new LocationAction();
var lstMyUsername = from u in objLocation.GetAllMyUsernameMessages()
select new
{
ViewUsername = u.id,
uMessage = u.displayMessage
};
if (privacyData != null)
{
Guid uName = new Guid(privacyData.viewUsername);
var selectedUserMessage = (from m in objLocation.GetMessageById(uName)
select new
{
ViewUsername = m.id,
uMessage = m.displayMessage
}).FirstOrDefault();
ViewData["MyUsername"] = new SelectList(lstMyUsername, "ViewUsername", "uMessage", selectedUserMessage.ViewUsername);
}
else
{
ViewData["MyUsername"] = new SelectList(lstMyUsername, "ViewUsername", "uMessage");
}
#endregion
}
public ContentResult Cities(string q, int limit, Int64 timestamp)
{
StringBuilder responseContentBuilder = new StringBuilder();
LocationAction objLoc = new LocationAction();
IList<City> lstCity = objLoc.GetAllCities(q).OrderBy(x => x.Region.code).ToList();
foreach (City city in lstCity)
responseContentBuilder.Append(String.Format("{0}|{1}|{2}\n", city.id, city.Region.code, city.name));
return Content(responseContentBuilder.ToString());
}
public ActionResult SortDBData(string id)
{
#region
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
LocationAction objLocation = new LocationAction();
Location memberLocation = objLocation.GetMemberLocationById(memberData.id.ToString());
if (memberLocation == null)
{
memberLocation = new Location();
memberLocation.localLong = SystemStatements.DEFAULT_Long;
memberLocation.localLat = SystemStatements.DEFAULT_Lat;
}
ViewData["Memberlocation"] = memberLocation;
IList<Seed> listSeed = null;
if (SessionStore.GetSessionValue(SessionStore.MySeeds) != null)
listSeed = (IList<Seed>)SessionStore.GetSessionValue(SessionStore.MySeeds);
if (listSeed.Count > 0)
{
switch (id)
{
case "Proximity":
//listSeed = ProximitySort();
//ViewData["StreamSeedList"] = listSeed;
break;
case "Date":
listSeed.OrderByDescending(x => x.createDate).ToList();
break;
case "Category":
listSeed.OrderBy(x => x.Categories.FirstOrDefault() != null ? x.Categories.FirstOrDefault().name : "").ToList();
break;
case "Likes":
listSeed.OrderByDescending(x => x.Ratings.ToList().Count).ToList();
break;
case "Comments":
listSeed.OrderByDescending(x => x.Comments.ToList().Count).ToList();
break;
case "SeedReplies":
listSeed.OrderByDescending(x => x.Seed1.ToList().Count).ToList();
break;
default:
listSeed.OrderByDescending(x => x.createDate).ToList();
break;
}
}
ViewData["ListSeed"] = listSeed;
string markerList = "";
foreach (Seed s1 in listSeed)
{
if (s1.Location.localLat != null && s1.Location.localLong != null)
{
//if (string.IsNullOrEmpty(markerList))
// markerList = s1.Location.localLat + "," + s1.Location.localLong;
//else
// markerList += "," + s1.Location.localLat + "," + s1.Location.localLong;
markerList += s1.Location.localLat + "," + s1.Location.localLong + "," + s1.title + "-<b>" + s1.status + "</b> <br />" + s1.Location.City.name + " " + s1.Location.zipcode + ",";
}
}
ViewData["LocationData"] = markerList;
return View("Dashboard");
#endregion
}
// *************************************
// URL: /Member/ManageProfile
// *************************************
private void GetRegions()
{
#region
LocationAction objLocation = new LocationAction();
MemberAction objMember = new MemberAction();
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
Location locData = objLocation.GetLocationDetailByMemberId(memberData.id.ToString());
string cityId = "";
string regionId = "";
if (locData != null)
{
if (locData.City != null)
{
cityId = locData.City.id.ToString();
if (locData.City.Region != null)
{
regionId = locData.City.Region.id.ToString();
}
}
}
IList<Model.Region> lstRegionItem = objLocation.GetAllRegions();
ViewData["CityId"] = cityId;
if (regionId.Length > 0)
{
Model.Region selLstRegionItem = objLocation.GetRegionById(regionId);
ViewData["RegionItem"] = new SelectList(lstRegionItem, "id", "name", selLstRegionItem.id);
}
else
{
ViewData["RegionItem"] = new SelectList(lstRegionItem, "id", "name");
}
#endregion
}
public ActionResult ShareIdea1(string returnAction, string txtSeedTitle, string txtDesc, string seedCoordinates, string seedLocation, string txtCategory, IEnumerable<HttpPostedFileBase> mediaFiles)
{
#region codeRegion
try
{
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
//Format address and create add seed model
string[] splitAddress = seedLocation.Split(',');
AddSeed seedData = new AddSeed();
seedData.SeedName = txtSeedTitle;
seedData.Description = txtDesc;
seedData.LongLat = seedCoordinates;
string seedCountry = string.Empty;
if (splitAddress.Length > 4)
{
seedData.StreetAddress = splitAddress[0].ToString() + ", " + splitAddress[1].ToString();
seedData.City = splitAddress[2].ToString().Trim();
string[] splitZipRegion = splitAddress[3].ToString().Trim().Split(' ');
seedData.ZipCode = splitZipRegion[1].ToString().Trim();
seedData.StateCode = splitZipRegion[0].ToString().Trim();
seedCountry = splitAddress[4].ToString();
}
else
{
seedData.StreetAddress = splitAddress[0].ToString();
seedData.City = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
seedData.ZipCode = splitZipRegion[1].ToString().Trim();
seedData.StateCode = splitZipRegion[0].ToString().Trim();
seedCountry = splitAddress[3].ToString();
}
//End formatting address
if (seedCountry.Trim().Equals("USA") || seedCountry.Trim().Equals("US"))
seedCountry = seedCountry.Trim();
else
throw new Exception("Seeds can not be planted outside region of United States");
string plantedSeedId = AddSeedData(seedData);
if (txtCategory != null)
{
string catIds = string.Empty;
string[] splitCategories = txtCategory.Split(',');
for (int i = 0; i < splitCategories.Length; i++)
{
CategoryAction objCatg = new CategoryAction();
string idCatg = objCatg.GetCategoryIdByCategoryName(splitCategories[i].ToString());
if (!string.IsNullOrEmpty(idCatg))
{
if (string.IsNullOrEmpty(catIds))
catIds = idCatg;
else
catIds = catIds + "," + idCatg;
}
}
//bool isPlanted = false;
if (!string.IsNullOrEmpty(catIds))
{
string[] arrCatIds = catIds.Split(',');
objSeed.AddCategories(plantedSeedId, arrCatIds);
}
}
if (mediaFiles != null)
{
foreach (var file in mediaFiles)
{
if (file.ContentLength > 0)
{
Bitmap sourceImage = new Bitmap(file.InputStream);
MediaManagement objMedia = new MediaManagement();
bool isMediaSaved = false;
int fileSize = file.ContentLength;
string fileOk = CheckFile(file.FileName, fileSize);
if (fileOk != "Invalid")
{
string strImgFileExtension = System.IO.Path.GetExtension(file.FileName);
DateTime datImg = DateTime.Now;
string ImgfileUploadtime = datImg.Day.ToString() + datImg.Month.ToString() + datImg.Year.ToString() + datImg.Hour.ToString() + datImg.Minute.ToString() + datImg.Second.ToString();
string filePath = Path.Combine(HttpContext.Server.MapPath("/UploadedMedia"), (plantedSeedId.ToString() + "_" + ImgfileUploadtime + strImgFileExtension));
objMedia.title = plantedSeedId.ToString() + "_" + ImgfileUploadtime;
objMedia.path = "../../UploadedMedia/" + (plantedSeedId.ToString() + "_" + ImgfileUploadtime + strImgFileExtension);
objMedia.type = fileOk;
objMedia.seedId = plantedSeedId;
sourceImage.Save(filePath, FileExtensionToImageFormat(filePath));
objMedia.embedScript = "Image Script";
isMediaSaved = SaveMediaInformation(objMedia);
}
else
throw new Exception("Please check file type or file size, Max Size Allowed : (Image : 2 MB) & (Video : 4 MB)");
}
}
}
Seed seed = GetSeedInformation(plantedSeedId);
// Creating array list for token
ArrayList arrTokens = new ArrayList();
arrTokens.Add(seed.Member.firstName + " " + seed.Member.lastName);
arrTokens.Add(seed.title);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Seed/SeedDetails/" + seed.id);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Member/Profile");
// Filling mail object
SendMail objSendMail = new SendMail();
Regex rgxEmail = new Regex("\\w+([-+.']\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*");
if (rgxEmail.IsMatch(seed.Member.username))
objSendMail.ToEmailId = seed.Member.username;
else
objSendMail.ToEmailId = seed.Member.Email;
objSendMail.Subject = "email.seedPlanted.subject.content";
objSendMail.MsgBody = "email.seedPlanted.body.content";
objSendMail.ChangesInMessage = arrTokens;
objSendMail.SendEmail(objSendMail);
return Redirect("/Seed/SeedDetails/" + seed.id);
}
catch (Exception ex)
{
SessionStore.SetSessionValue("PlantError", "Error occurred while planting seed#" + ex.Message.ToString());
//ViewData["PlantErrMsg"] = ex.Message.ToString();
return RedirectToAction("PlantError", "Seed");
}
#endregion
}
// *************************************
// URL: /Seed/DiscoverSeed
// *************************************
public ActionResult DiscoverSeed(string cstreet, string city, string zip, string category, string keyword, string LatLongMaster, string byUser, string byRating)
{
#region
string facebookLogin = (string)SessionStore.GetSessionValue(SessionStore.FacebookConnect);
if (!string.IsNullOrEmpty(facebookLogin))
{
if (city == "City" || city == null)
{
string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (string.IsNullOrEmpty(ip))
{
ip = Request.ServerVariables["REMOTE_ADDR"];
}
DataTable dtAddress = GetLocation(ip);
if (dtAddress != null)
{
if (dtAddress.Rows.Count > 0)
{
city = dtAddress.Rows[0]["City"].ToString();
if (string.IsNullOrEmpty(city))
city = "Phoenix";
}
else
{
city = "Phoenix";
}
}
}
}
LocationAction objLocation = new LocationAction();
SeedAction objSeed = new SeedAction();
CategoryAction objCategory = new CategoryAction();
string CatId = objCategory.GetCategoryIdByCategoryName(category);
IList<Seed> listSeed = null;
//Storing search result in session
if (string.IsNullOrEmpty(cstreet) && string.IsNullOrEmpty(city) && string.IsNullOrEmpty(zip) && string.IsNullOrEmpty(category) && string.IsNullOrEmpty(keyword) && string.IsNullOrEmpty(LatLongMaster))
{
if (SessionStore.GetSessionValue(SessionStore.DiscoverSeed) != null)
listSeed = (IList<Seed>)SessionStore.GetSessionValue(SessionStore.DiscoverSeed);
}
else
{
listSeed = this.getSearchResult(cstreet, city, CatId, keyword, zip, byUser, byRating);
}
if (listSeed.Count > 0)
SessionStore.SetSessionValue(SessionStore.DiscoverSeed, listSeed);
string latlong = "";
if (listSeed.Count > 0)
{
for (int i = 0; i < listSeed.Count; i++)
{
if (latlong == "")
{
latlong = listSeed[i].Location.localLat + "," + listSeed[i].Location.localLong + "," + listSeed[i].title + "-<b>" + listSeed[i].status + "</b> <br />" + listSeed[i].Location.City.name + " " + listSeed[i].Location.zipcode + ",";
}
else
{
latlong += listSeed[i].Location.localLat + "," + listSeed[i].Location.localLong + "," + listSeed[i].title + "-<b>" + listSeed[i].status + "</b> <br />" + listSeed[i].Location.City.name + " " + listSeed[i].Location.zipcode + ",";
}
}
}
Array late = latlong.Split(',');
ViewData["LatLongCollection"] = latlong;
if (listSeed.Count > 0)
ViewData["ListSeed"] = listSeed;
else
ViewData["SearchMsg"] = "No matching seed found for your search criteria";
return View();
#endregion
}
public ActionResult SetCategory(string seedId, string categoryIds, AddSeed objAddSeedModel)
{
#region
if (ModelState.IsValid)
{
try
{
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
AddSeed seedData = (AddSeed)objAddSeedModel;
string[] arrCategoryIds;
string latLong = seedData.LongLat;
char[] separator = new char[] { ',' };
string[] strSplitLatLong = latLong.Split(separator);
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
categoryIds = categoryIds.TrimStart(',');
arrCategoryIds = categoryIds.Split(',');
string plantedSeedId = AddSeedData(seedData);
bool isPlanted = false;
if (categoryIds.Trim().ToString() != "")
{
isPlanted = objSeed.AddCategories(plantedSeedId, arrCategoryIds);
}
bindCheckBox(plantedSeedId);
Seed seed = GetSeedInformation(plantedSeedId);
#region Send Mail
// Creating array list for token
ArrayList arrTokens = new ArrayList();
arrTokens.Add(seed.Member.firstName + " " + seed.Member.lastName);
arrTokens.Add(seed.title);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Seed/SeedDetails/" + seed.id);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Member/Profile");
// Filling mail object
SendMail objSendMail = new SendMail();
objSendMail.ToEmailId = seed.Member.username;
objSendMail.Subject = "email.seedPlanted.subject.content";
objSendMail.MsgBody = "email.seedPlanted.body.content";
objSendMail.ChangesInMessage = arrTokens;
objSendMail.SendEmail(objSendMail);
#endregion
return Redirect("/Seed/SeedDetails/" + seed.id);
}
catch (Exception ex)
{
ViewData["SeedPlant"] = ex.Message.ToString();
}
}
miniDashboard();
bindCategory();
RegionCode();
return View("../Member/Dashboard");
#endregion
}
public string ShareIdea(string txtSeedTitle, string txtDesc, string seedCoordinates, string seedLocation, string txtCategory)
{
#region
string returnMsg = string.Empty;
try
{
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
//Format address and create add seed model
string[] splitAddress = seedLocation.Split(',');
AddSeed seedData = new AddSeed();
seedData.SeedName = txtSeedTitle;
seedData.Description = txtDesc;
seedData.LongLat = seedCoordinates;
if (splitAddress.Length > 4)
{
seedData.StreetAddress = splitAddress[0].ToString() + ", " + splitAddress[1].ToString();
seedData.City = splitAddress[2].ToString().Trim();
string[] splitZipRegion = splitAddress[3].ToString().Trim().Split(' ');
seedData.ZipCode = splitZipRegion[1].ToString().Trim();
seedData.StateCode = splitZipRegion[0].ToString().Trim();
}
else
{
seedData.StreetAddress = splitAddress[0].ToString();
seedData.City = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
seedData.ZipCode = splitZipRegion[1].ToString().Trim();
seedData.StateCode = splitZipRegion[0].ToString().Trim();
}
//End formatting address
string plantedSeedId = AddSeedData(seedData);
if (txtCategory != null)
{
string catIds = string.Empty;
string[] splitCategories = txtCategory.Split(',');
for (int i = 0; i < splitCategories.Length; i++)
{
CategoryAction objCatg = new CategoryAction();
string idCatg = objCatg.GetCategoryIdByCategoryName(splitCategories[i].ToString());
if (!string.IsNullOrEmpty(idCatg))
{
if (string.IsNullOrEmpty(catIds))
catIds = idCatg;
else
catIds = catIds + "," + idCatg;
}
}
if (!string.IsNullOrEmpty(catIds))
{
string[] arrCatIds = catIds.Split(',');
objSeed.AddCategories(plantedSeedId, arrCatIds);
}
}
try
{
// Get the HttpFileCollection
HttpFileCollectionBase hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++)
{
if (hfc[i].ContentLength > 0)
{
hfc[i].SaveAs(Server.MapPath("UploadedMedia") + "\\" + System.IO.Path.GetFileName(hfc[i].FileName));
}
}
}
catch
{
}
#region code to send mail
Seed seed = GetSeedInformation(plantedSeedId);
// Creating array list for token
ArrayList arrTokens = new ArrayList();
arrTokens.Add(seed.Member.firstName + " " + seed.Member.lastName);
arrTokens.Add(seed.title);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Seed/SeedDetails/" + seed.id);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Member/Profile");
// Filling mail object
SendMail objSendMail = new SendMail();
objSendMail.ToEmailId = seed.Member.username;
objSendMail.Subject = "email.seedPlanted.subject.content";
objSendMail.MsgBody = "email.seedPlanted.body.content";
objSendMail.ChangesInMessage = arrTokens;
objSendMail.SendEmail(objSendMail);
#endregion
returnMsg = "Seed has been planted successfully";
}
catch (Exception ex)
{
returnMsg = ex.Message.ToString();
}
return returnMsg;
#endregion
}
public ActionResult SeedLocation(string InfoLatLong, string seedLocation)
{
#region
try
{
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
//Format address and create add seed model
string[] splitAddress = seedLocation.Split(',');
AddSeed seedData = (AddSeed)SessionStore.GetSessionValue(SessionStore.SeedInfo);
seedData.LongLat = InfoLatLong;
seedData.StreetAddress = splitAddress[0].ToString();
seedData.City = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
seedData.ZipCode = splitZipRegion[1].ToString().Trim();
seedData.StateCode = splitZipRegion[0].ToString().Trim();
//End formatting address
string categoryIds = (string)SessionStore.GetSessionValue(SessionStore.CategoryId);
string[] arrCategoryIds;
string latLong = seedData.LongLat;
char[] separator = new char[] { ',' };
string[] strSplitLatLong = latLong.Split(separator);
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
categoryIds = categoryIds.TrimStart(',');
arrCategoryIds = categoryIds.Split(',');
string plantedSeedId = AddSeedData(seedData);
bool isPlanted = false;
if (categoryIds.Trim().ToString() != "")
{
isPlanted = objSeed.AddCategories(plantedSeedId, arrCategoryIds);
}
bindCheckBox(plantedSeedId);
Seed seed = GetSeedInformation(plantedSeedId);
#region Send Mail
// Creating array list for token
ArrayList arrTokens = new ArrayList();
arrTokens.Add(seed.Member.firstName + " " + seed.Member.lastName);
arrTokens.Add(seed.title);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Seed/SeedDetails/" + seed.id);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Member/Profile");
// Filling mail object
SendMail objSendMail = new SendMail();
objSendMail.ToEmailId = seed.Member.username;
objSendMail.Subject = "email.seedPlanted.subject.content";
objSendMail.MsgBody = "email.seedPlanted.body.content";
objSendMail.ChangesInMessage = arrTokens;
objSendMail.SendEmail(objSendMail);
#endregion
return Redirect("/Seed/SeedDetails/" + seed.id);
}
catch (Exception ex)
{
ViewData["SeedPlant"] = ex.Message.ToString();
}
bindCategory();
return View();
#endregion
}
public ActionResult PlantSeed(string seedTitle, string description, string info, string address, string keyword, string categoryIds)
{
#region
try
{
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
//Format address and create add seed model
string[] splitAddress = address.Split(',');
AddSeed seedData = new AddSeed();
seedData.SeedName = seedTitle;
badWordsFilter objWords = new badWordsFilter();
string filePath=Server.MapPath("~/utils/badWords.xml");
List<string> lstBadWords = badWordsFilter.BadWordList(ref filePath);
description = objWords.FilterBadWords(lstBadWords, description);
seedData.Description = description;
seedData.LongLat = info;
seedData.Tag = keyword;
seedData.StreetAddress = splitAddress[0].ToString();
seedData.City = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
seedData.ZipCode = splitZipRegion[1].ToString().Trim();
seedData.StateCode = splitZipRegion[0].ToString().Trim();
//End formatting address
string[] arrCategoryIds;
string latLong = seedData.LongLat;
char[] separator = new char[] { ',' };
string[] strSplitLatLong = latLong.Split(separator);
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
categoryIds = categoryIds.TrimStart(',');
arrCategoryIds = categoryIds.Split(',');
string plantedSeedId = AddSeedData(seedData);
bool isPlanted = false;
if (categoryIds.Trim().ToString() != "")
{
isPlanted = objSeed.AddCategories(plantedSeedId, arrCategoryIds);
}
bindCheckBox(plantedSeedId);
Seed seed = GetSeedInformation(plantedSeedId);
#region Send Mail
// Creating array list for token
ArrayList arrTokens = new ArrayList();
arrTokens.Add(seed.Member.firstName + " " + seed.Member.lastName);
arrTokens.Add(seed.title);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Seed/SeedDetails/" + seed.id);
arrTokens.Add("http://" + Request.ServerVariables["SERVER_NAME"] + "/Member/Profile");
// Filling mail object
SendMail objSendMail = new SendMail();
objSendMail.ToEmailId = seed.Member.username;
objSendMail.Subject = "email.seedPlanted.subject.content";
objSendMail.MsgBody = "email.seedPlanted.body.content";
objSendMail.ChangesInMessage = arrTokens;
objSendMail.SendEmail(objSendMail);
#endregion
return Redirect("/Seed/SeedDetails/" + seed.id);
}
catch (Exception ex)
{
ViewData["SeedPlant"] = ex.Message.ToString();
}
bindCategory();
return View();
#endregion
}
public void miniDashboard()
{
#region
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
IList<Location> locData = objLocation.GetLocationByMemberId(memberData.id.ToString());
Location memberLocation = objLocation.GetMemberLocationById(memberData.id.ToString());
if (memberLocation == null)
{
memberLocation = new Location();
memberLocation.localLong = SystemStatements.DEFAULT_Long;
memberLocation.localLat = SystemStatements.DEFAULT_Lat;
}
IList<Seed> listSeed = objSeed.GetSeedsByUser(memberData.id.ToString()).ToList();
string locations = "";
if (locData == null)
{
locations = SystemStatements.DEFAULT_Lat + "," + SystemStatements.DEFAULT_Long;
}
else
{
int counter = 0;
foreach (Location tempLocation in locData)
{
if (counter == 10)
{
break;
}
locations += tempLocation.localLat + "," + tempLocation.localLong + ",";
counter++;
}
locations = locations.Substring(0, locations.Length - 1);
}
ViewData["ListSeed"] = listSeed;
ViewData["LocationData"] = locations;
ViewData["Memberlocation"] = memberLocation;
#endregion
}
public ActionResult Models1(string id)
{
string regId = id;
LocationAction objLocation = new LocationAction();
IEnumerable<SelectListItem> lstCityItem = objLocation.GetAllCitiesForRegion(regId).Select(c => new SelectListItem { Value = c.id.ToString(), Text = c.name });
return Json(lstCityItem.ToList(), JsonRequestBehavior.AllowGet);
}
public ActionResult EditSeedInfo(string txtEdtSeedTitle, string txtEdtDesc, string seedCoordinatesEdt, string seedLocationEdt, string txtCategoryEdt, IEnumerable<HttpPostedFileBase> mediaFilesEdt, string EdtSeedID)
{
#region codeRegion
try
{
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
Seed seed = GetSeedInformation(EdtSeedID);
seed.title = txtEdtSeedTitle;
string s = Regex.Replace(txtEdtDesc, @"<(.|\n)*?>", string.Empty);
s = s.Replace(" ", " ");
s = Regex.Replace(s, @"\s+", " ");
s = Regex.Replace(s, @"\r\n", "\n");
s = Regex.Replace(s, @"\n+", "\n");
string description = s;
badWordsFilter objWords = new badWordsFilter();
string wordsFilePath = Server.MapPath("~/utils/badWords.xml");
List<string> lstBadWords = badWordsFilter.BadWordList(ref wordsFilePath);
description = objWords.FilterBadWords(lstBadWords, description);
seed.description = description;
Location loc = seed.Location;
//Format address and create add seed model
string[] splitAddress = seedLocationEdt.Split(',');
string[] strSplitLatLong = seedCoordinatesEdt.Split(',');
loc.localLat = Convert.ToDouble(strSplitLatLong[0].ToString());
loc.localLong = Convert.ToDouble(strSplitLatLong[1].ToString());
if (splitAddress.Length > 4)
{
string[] splitZipRegion = splitAddress[3].ToString().Trim().Split(' ');
loc.crossStreet = splitAddress[0].ToString() + ", " + splitAddress[1].ToString();
string cityid = objLocation.GetCityIdByCityName(splitAddress[2].ToString().Trim(), splitZipRegion[0].ToString().Trim());
loc.cityId = new Guid(cityid);
loc.zipcode = splitZipRegion[1].ToString().Trim();
}
else
{
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
loc.crossStreet = splitAddress[0].ToString();
string cityid = objLocation.GetCityIdByCityName(splitAddress[1].ToString().Trim(), splitZipRegion[0].ToString().Trim());
loc.cityId = new Guid(cityid);
loc.zipcode = splitZipRegion[1].ToString().Trim();
}
//End formatting address
loc = objLocation.UpdateLocation(loc);
seed.locationId = loc.id;
seed = objSeed.UpdateSeed(seed);
string plantedSeedId = seed.id.ToString();
if (txtCategoryEdt != null)
{
string catIds = string.Empty;
string[] splitCategories = txtCategoryEdt.Split(',');
for (int i = 0; i < splitCategories.Length; i++)
{
CategoryAction objCatg = new CategoryAction();
string idCatg = objCatg.GetCategoryIdByCategoryName(splitCategories[i].ToString());
if (!string.IsNullOrEmpty(idCatg))
{
if (string.IsNullOrEmpty(catIds))
catIds = idCatg;
else
catIds = catIds + "," + idCatg;
}
}
//bool isPlanted = false;
if (!string.IsNullOrEmpty(catIds))
{
string[] arrCatIds = catIds.Split(',');
objSeed.AddCategories(plantedSeedId, arrCatIds);
}
}
if (mediaFilesEdt != null)
{
foreach (var file in mediaFilesEdt)
{
if (file.ContentLength > 0)
{
Bitmap sourceImage = new Bitmap(file.InputStream);
MediaManagement objMedia = new MediaManagement();
bool isMediaSaved = false;
int fileSize = file.ContentLength;
string fileOk = CheckFile(file.FileName, fileSize);
if (fileOk != "Invalid")
{
string strImgFileExtension = System.IO.Path.GetExtension(file.FileName);
DateTime datImg = DateTime.Now;
string ImgfileUploadtime = datImg.Day.ToString() + datImg.Month.ToString() + datImg.Year.ToString() + datImg.Hour.ToString() + datImg.Minute.ToString() + datImg.Second.ToString();
string filePath = Path.Combine(HttpContext.Server.MapPath("/UploadedMedia"), (plantedSeedId + "_" + ImgfileUploadtime + strImgFileExtension));
objMedia.title = plantedSeedId + "_" + ImgfileUploadtime;
objMedia.path = "../../UploadedMedia/" + (plantedSeedId + "_" + ImgfileUploadtime + strImgFileExtension);
objMedia.type = fileOk;
objMedia.seedId = plantedSeedId;
sourceImage.Save(filePath, FileExtensionToImageFormat(filePath));
objMedia.embedScript = "Image Script";
isMediaSaved = SaveMediaInformation(objMedia);
}
else
throw new Exception("Please check file type or file size, Max Size Allowed : (Image : 2 MB) & (Video : 4 MB)");
}
}
}
return Redirect("/Seed/SeedDetails/" + plantedSeedId);
}
catch (Exception ex)
{
SessionStore.SetSessionValue("PlantError", ex.Message.ToString());
return RedirectToAction("PlantError", "Seed");
}
#endregion
}
public void RegionCode()
{
LocationAction objLocation = new LocationAction();
MemberAction objMember = new MemberAction();
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
IList<Model.Region> lstRegion = objLocation.GetAllRegions();
ViewData["RegionList"] = new SelectList(lstRegion, "code", "code");
}
/// <summary>
/// Method to get all seeds by member location.
/// </summary>
/// <param name="MemberId"></param>
/// <returns></returns>
public string GetSeedByMemberLocation(string MemberId)
{
#region
SeedAction objSeed = new SeedAction();
LocationAction objLocation = new LocationAction();
string returnList = "";
IList<Location> locData = objLocation.GetLocationByMemberId(MemberId);
Location memberLocation = objLocation.GetMemberLocationById(MemberId);
if (memberLocation == null)
{
memberLocation = new Location();
memberLocation.localLong = -112.0740373;
memberLocation.localLat = 33.4483771;
}
IList<Seed> tempList1 = objSeed.GetSeedsByUser(MemberId).ToList();
IList<Seed> tempList2 = objSeed.GetAllSeedsCommentedByMe(MemberId);
var tempList3 = tempList1.Union(tempList2);
IList<Seed> listSeed = (from gs in tempList3 select gs).OrderByDescending(x => x.createDate).Distinct().ToList();
List<Seed> currentSeedList = new List<Seed>();
if (locData == null)
{
returnList = "33.4483771,-112.0740373";
}
else
{
foreach (Location tempLocation in locData)
{
IList<Seed> seedList = objSeed.GetSeedByLocationId(tempLocation.id.ToString());
foreach (Seed seedData in seedList)
{
returnList += "," + tempLocation.localLat.ToString() + "," + tempLocation.localLong.ToString();
}
}
if (returnList.Length == 0)
{
returnList = "33.4483771,-112.0740373";
}
else
{
returnList = returnList.Substring(1);
}
}
return returnList;
#endregion
}
private void GetAllCities1(string regId)
{
if (regId == null)
regId = "31a173d8-4bba-df11-9a64-7071bc4b6942";
LocationAction objLocation = new LocationAction();
IEnumerable<SelectListItem> lstCityItem = objLocation.GetAllCitiesForRegion(regId).Select(c => new SelectListItem { Value = c.id.ToString(), Text = c.name });
ViewData["CityListItem"] = lstCityItem;
}
public ActionResult AddStreamFeed(string gFeedTitle, string gFeedDesc, string gIsPublic, string seedLocationStreamFeed, string seedCoordinatesStreamFeed, string txtCategoryStreamFeed, string feedLocation, string profileLocValue, string NewLocValue, string LocationRadius, string CoordinatesRadius, string gIsMedia, string txtIncludeTerms, string txtExcludeTerms, string isEdit, string StreamId)
{
#region Front Logic
try
{
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
StreamAction objStream = new StreamAction();
ssStream stream = new ssStream();
stream.title = gFeedTitle;
stream.description = gFeedDesc;
string feedQuery = "Select Seed.* from Seed where (seed.[status] = 'New' or seed.[status] = 'Growing')";
#region add location in query
if (!string.IsNullOrEmpty(feedLocation))
{
if (feedLocation != "AllLocations")
{
string radius = string.Empty;
string radiusZipList = string.Empty;
string ZipCodeFeed = string.Empty;
if (feedLocation == "ProfileLocation")
{
radius = profileLocValue;
if (memberData.MemberProfiles != null)
{
if (memberData.MemberProfiles.FirstOrDefault().Location.zipcode != null)
ZipCodeFeed = Convert.ToString(memberData.MemberProfiles.FirstOrDefault().Location.zipcode);
}
else
ZipCodeFeed = "85027";
}
if (feedLocation == "NewLocation")
{
radius = NewLocValue;
//Format address
string[] splitAddressFeed = LocationRadius.Split(',');
if (splitAddressFeed.Length > 4)
{
string[] splitZipRegion = splitAddressFeed[3].ToString().Trim().Split(' ');
ZipCodeFeed = splitZipRegion[1].ToString().Trim();
}
else
{
string[] splitZipRegion = splitAddressFeed[2].ToString().Trim().Split(' ');
ZipCodeFeed = splitZipRegion[1].ToString().Trim();
}
//End formatting address
}
//Get zip codes according to radius
CommonMethods objCommon = new CommonMethods();
radiusZipList = objCommon.GetZipByRadius(radius, ZipCodeFeed);
//End get zip codes according to radius
if (string.IsNullOrEmpty(radiusZipList))
radiusZipList = ZipCodeFeed;
feedQuery += " and locationId in (Select id from Location where zipcode in (" + radiusZipList + "))";
}
}
#endregion
#region include terms in query
if (!string.IsNullOrEmpty(txtIncludeTerms))
{
string inCondition = string.Empty;
string[] includeTerms = txtIncludeTerms.Split(',');
for (int i = 0; i < includeTerms.Length; i++)
{
if (i == 0)
inCondition = "'" + includeTerms[i].ToString() + "'";
else
inCondition += ",'" + includeTerms[i].ToString() + "'";
}
feedQuery += " 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(txtExcludeTerms))
{
string exCondition = string.Empty;
string[] excludeTerms = txtExcludeTerms.Split(',');
for (int i = 0; i < excludeTerms.Length; i++)
{
if (i == 0)
exCondition = "'" + excludeTerms[i].ToString() + "'";
else
exCondition += ",'" + excludeTerms[i].ToString() + "'";
}
feedQuery += " 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(gIsMedia))
{
switch (gIsMedia)
{
case "All":
feedQuery += " and Seed.id in (Select m.seedId from Media m)";
break;
case "NoMedia":
feedQuery += " and Seed.id not in (Select m.seedId from Media m)";
break;
case "PhotosOnly":
feedQuery += " and Seed.id in (Select m.seedId from Media m where m.[type]='" + SystemStatements.MEDIA_IMAGE + "')";
break;
case "VideosOnly":
feedQuery += " and Seed.id in (Select m.seedId from Media m where m.[type]='" + SystemStatements.MEDIA_VIDEO + "')";
break;
default:
break;
}
}
#endregion
stream.criteria = feedQuery;
stream.streamType = SystemStatements.STREAM_FEED;
stream.ownerId = memberData.id;
if (isEdit == "Yes" && !string.IsNullOrEmpty(StreamId))
{
ssStream ss = objStream.GetStreamById(StreamId);
ss.title = gFeedTitle;
ss.description = gFeedDesc;
ss.criteria = feedQuery;
ss.isPublic = Convert.ToBoolean(gIsPublic);
if (!string.IsNullOrEmpty(seedLocationStreamFeed))
{
//Format address
string StreetAddress = string.Empty;
string City = string.Empty;
string ZipCode = string.Empty;
string StateCode = string.Empty;
string[] splitAddress = seedLocationStreamFeed.Split(',');
string feedCountry = string.Empty;
if (splitAddress.Length > 4)
{
StreetAddress = splitAddress[0].ToString() + ", " + splitAddress[1].ToString();
City = splitAddress[2].ToString().Trim();
string[] splitZipRegion = splitAddress[3].ToString().Trim().Split(' ');
ZipCode = splitZipRegion[1].ToString().Trim();
StateCode = splitZipRegion[0].ToString().Trim();
feedCountry = splitAddress[4].ToString();
}
else
{
StreetAddress = splitAddress[0].ToString();
City = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
ZipCode = splitZipRegion[1].ToString().Trim();
StateCode = splitZipRegion[0].ToString().Trim();
feedCountry = splitAddress[3].ToString();
}
//End formatting address
if (feedCountry.Trim().Equals("USA") || feedCountry.Trim().Equals("US"))
feedCountry = feedCountry.Trim();
else
throw new Exception("Feeds can not be created outside region of United States");
LocationAction objLocation = new LocationAction();
SeedAction objSeed = new SeedAction();
string latLong = seedCoordinatesStreamFeed;
string[] strSplitLatLong = latLong.Split(',');
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
string crossStreet = StreetAddress.Trim();
string cityId = objLocation.GetCityIdByCityName(City, StateCode);
if (string.IsNullOrEmpty(cityId))
cityId = objSeed.AddCity(City, StateCode);
Location loc = objLocation.CreateLocation(cityId, ZipCode, Convert.ToDouble(lat), Convert.ToDouble(longt), crossStreet);
ss.locationId = loc.id;
}
ss = objStream.UpdateStream1(ss);
if (txtCategoryStreamFeed != null)
{
string catIds = string.Empty;
string[] splitCategories = txtCategoryStreamFeed.Split(',');
for (int i = 0; i < splitCategories.Length; i++)
{
CategoryAction objCatg = new CategoryAction();
string idCatg = objCatg.GetCategoryIdByCategoryName(splitCategories[i].ToString());
if (!string.IsNullOrEmpty(idCatg))
{
if (string.IsNullOrEmpty(catIds))
catIds = idCatg;
else
catIds = catIds + "," + idCatg;
}
}
if (!string.IsNullOrEmpty(catIds))
{
string[] arrCatIds = catIds.Split(',');
objStream.AddFeedCategories(Convert.ToString(ss.id), arrCatIds);
}
}
if (!string.IsNullOrEmpty(Convert.ToString(ss.id)))
{
return RedirectToAction("ManageMyFeeds", "SeedStream");
}
return RedirectToAction("UnexpectedError", "Error");
}
if (!string.IsNullOrEmpty(seedLocationStreamFeed))
{
//Format address
string StreetAddress = string.Empty;
string City = string.Empty;
string ZipCode = string.Empty;
string StateCode = string.Empty;
string[] splitAddress = seedLocationStreamFeed.Split(',');
string feedCountry = string.Empty;
if (splitAddress.Length > 4)
{
StreetAddress = splitAddress[0].ToString() + ", " + splitAddress[1].ToString();
City = splitAddress[2].ToString().Trim();
string[] splitZipRegion = splitAddress[3].ToString().Trim().Split(' ');
ZipCode = splitZipRegion[1].ToString().Trim();
StateCode = splitZipRegion[0].ToString().Trim();
feedCountry = splitAddress[4].ToString();
}
else
{
StreetAddress = splitAddress[0].ToString();
City = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
ZipCode = splitZipRegion[1].ToString().Trim();
StateCode = splitZipRegion[0].ToString().Trim();
feedCountry = splitAddress[3].ToString();
}
//End formatting address
if (feedCountry.Trim().Equals("USA") || feedCountry.Trim().Equals("US"))
feedCountry = feedCountry.Trim();
else
throw new Exception("Feeds can not be created outside region of United States");
LocationAction objLocation = new LocationAction();
SeedAction objSeed = new SeedAction();
string latLong = seedCoordinatesStreamFeed;
string[] strSplitLatLong = latLong.Split(',');
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
string crossStreet = StreetAddress.Trim();
string cityId = objLocation.GetCityIdByCityName(City, StateCode);
if (string.IsNullOrEmpty(cityId))
cityId = objSeed.AddCity(City, StateCode);
Location loc = objLocation.CreateLocation(cityId, ZipCode, Convert.ToDouble(lat), Convert.ToDouble(longt), crossStreet);
stream.locationId = loc.id;
}
stream.isPublic = Convert.ToBoolean(gIsPublic);
stream = objStream.CreateStream1(stream);
if (txtCategoryStreamFeed != null)
{
string catIds = string.Empty;
string[] splitCategories = txtCategoryStreamFeed.Split(',');
for (int i = 0; i < splitCategories.Length; i++)
{
CategoryAction objCatg = new CategoryAction();
string idCatg = objCatg.GetCategoryIdByCategoryName(splitCategories[i].ToString());
if (!string.IsNullOrEmpty(idCatg))
{
if (string.IsNullOrEmpty(catIds))
catIds = idCatg;
else
catIds = catIds + "," + idCatg;
}
}
if (!string.IsNullOrEmpty(catIds))
{
string[] arrCatIds = catIds.Split(',');
objStream.AddFeedCategories(Convert.ToString(stream.id), arrCatIds);
}
}
if (!string.IsNullOrEmpty(Convert.ToString(stream.id)))
{
return RedirectToAction("ManageMyFeeds", "SeedStream");
}
return RedirectToAction("UnexpectedError", "Error");
}
catch (Exception ex)
{
SessionStore.SetSessionValue("PlantError", "Error occurred while creating feed#" + ex.Message.ToString());
return RedirectToAction("PlantError", "Seed");
}
#endregion
}
// *************************************
// URL: /Member/Profile
// *************************************
private void GetRegions1()
{
LocationAction objLocation = new LocationAction();
IEnumerable<SelectListItem> lstRegionItem = objLocation.GetAllRegions().Select(r => new SelectListItem { Value = r.id.ToString(), Text = r.name });
ViewData["RegionItem"] = lstRegionItem;
}
public ActionResult AddStream(string gTitle, string gDesc, string gIsPublic, string streamType, string seedLocationStreamMini, string seedCoordinatesStreamMini, string txtCategoryStreamMini, string isEdit, string StreamId)
{
#region Front Logic
try
{
Member memberData = (Member)SessionStore.GetSessionValue(SessionStore.Memberobject);
StreamAction objStream = new StreamAction();
TempData["StreamTab"] = 1;
if (isEdit == "Yes" && !string.IsNullOrEmpty(StreamId))
{
ssStream ss = objStream.GetStreamById(StreamId);
ss.title = gTitle;
ss.description = gDesc;
ss.isPublic = Convert.ToBoolean(gIsPublic);
//Format address
string StreetAddress1 = string.Empty;
string City1 = string.Empty;
string ZipCode1 = string.Empty;
string StateCode1 = string.Empty;
if (!string.IsNullOrEmpty(seedLocationStreamMini))
{
string[] splitAddress = seedLocationStreamMini.Split(',');
if (splitAddress.Length > 4)
{
StreetAddress1 = splitAddress[0].ToString() + ", " + splitAddress[1].ToString();
City1 = splitAddress[2].ToString().Trim();
string[] splitZipRegion = splitAddress[3].ToString().Trim().Split(' ');
ZipCode1 = splitZipRegion[1].ToString().Trim();
StateCode1 = splitZipRegion[0].ToString().Trim();
}
else
{
StreetAddress1 = splitAddress[0].ToString();
City1 = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
ZipCode1 = splitZipRegion[1].ToString().Trim();
StateCode1 = splitZipRegion[0].ToString().Trim();
}
//End formatting address
LocationAction objLocation = new LocationAction();
SeedAction objSeed = new SeedAction();
string latLong = seedCoordinatesStreamMini;
string[] strSplitLatLong = latLong.Split(',');
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
string crossStreet = StreetAddress1.Trim();
string cityId = objLocation.GetCityIdByCityName(City1, StateCode1);
if (string.IsNullOrEmpty(cityId))
cityId = objSeed.AddCity(City1, StateCode1);
Location loc = objLocation.CreateLocation(cityId, ZipCode1, Convert.ToDouble(lat), Convert.ToDouble(longt), crossStreet);
ss.locationId = loc.id;
}
ss = objStream.UpdateStream1(ss);
if (txtCategoryStreamMini != null)
{
string catIds = string.Empty;
string[] splitCategories = txtCategoryStreamMini.Split(',');
for (int i = 0; i < splitCategories.Length; i++)
{
CategoryAction objCatg = new CategoryAction();
string idCatg = objCatg.GetCategoryIdByCategoryName(splitCategories[i].ToString());
if (!string.IsNullOrEmpty(idCatg))
{
if (string.IsNullOrEmpty(catIds))
catIds = idCatg;
else
catIds = catIds + "," + idCatg;
}
}
if (!string.IsNullOrEmpty(catIds))
{
string[] arrCatIds = catIds.Split(',');
objStream.AddFeedCategories(Convert.ToString(ss.id), arrCatIds);
}
}
if (!string.IsNullOrEmpty(Convert.ToString(ss.id)))
{
return RedirectToAction("ManageMyFeeds", "SeedStream");
}
return RedirectToAction("UnexpectedError", "Error");
}
ssStream stream = new ssStream();
stream.title = gTitle;
stream.description = gDesc;
if (streamType == SystemStatements.STREAM_FEED)
{
string defaultFeed = (string)SessionStore.GetSessionValue(SessionStore.DefaultFeed);
if (!string.IsNullOrEmpty(defaultFeed))
stream.criteria = defaultFeed;
stream.streamType = streamType;
}
else if (streamType == SystemStatements.STREAM_HANDPICKED)
{
stream.streamType = streamType;
}
stream.ownerId = memberData.id;
//Format address
string StreetAddress = string.Empty;
string City = string.Empty;
string ZipCode = string.Empty;
string StateCode = string.Empty;
if (!string.IsNullOrEmpty(seedLocationStreamMini))
{
string[] splitAddress = seedLocationStreamMini.Split(',');
if (splitAddress.Length > 4)
{
StreetAddress = splitAddress[0].ToString() + ", " + splitAddress[1].ToString();
City = splitAddress[2].ToString().Trim();
string[] splitZipRegion = splitAddress[3].ToString().Trim().Split(' ');
ZipCode = splitZipRegion[1].ToString().Trim();
StateCode = splitZipRegion[0].ToString().Trim();
}
else
{
StreetAddress = splitAddress[0].ToString();
City = splitAddress[1].ToString().Trim();
string[] splitZipRegion = splitAddress[2].ToString().Trim().Split(' ');
ZipCode = splitZipRegion[1].ToString().Trim();
StateCode = splitZipRegion[0].ToString().Trim();
}
//End formatting address
LocationAction objLocation = new LocationAction();
SeedAction objSeed = new SeedAction();
string latLong = seedCoordinatesStreamMini;
string[] strSplitLatLong = latLong.Split(',');
string lat = strSplitLatLong[0].ToString();
string longt = strSplitLatLong[1].ToString();
string crossStreet = StreetAddress.Trim();
string cityId = objLocation.GetCityIdByCityName(City, StateCode);
if (string.IsNullOrEmpty(cityId))
cityId = objSeed.AddCity(City, StateCode);
Location loc = objLocation.CreateLocation(cityId, ZipCode, Convert.ToDouble(lat), Convert.ToDouble(longt), crossStreet);
stream.locationId = loc.id;
}
stream.isPublic = Convert.ToBoolean(gIsPublic);
stream = objStream.CreateStream1(stream);
if (txtCategoryStreamMini != null)
{
string catIds = string.Empty;
string[] splitCategories = txtCategoryStreamMini.Split(',');
for (int i = 0; i < splitCategories.Length; i++)
{
CategoryAction objCatg = new CategoryAction();
string idCatg = objCatg.GetCategoryIdByCategoryName(splitCategories[i].ToString());
if (!string.IsNullOrEmpty(idCatg))
{
if (string.IsNullOrEmpty(catIds))
catIds = idCatg;
else
catIds = catIds + "," + idCatg;
}
}
if (!string.IsNullOrEmpty(catIds))
{
string[] arrCatIds = catIds.Split(',');
objStream.AddFeedCategories(Convert.ToString(stream.id), arrCatIds);
}
}
if (!string.IsNullOrEmpty(Convert.ToString(stream.id)))
{
return RedirectToAction("ManageMyFeeds", "SeedStream");
}
return RedirectToAction("UnexpectedError", "Error");
}
catch (Exception ex)
{
SessionStore.SetSessionValue("PlantError", "Error occurred while creating list#" + ex.Message.ToString());
return RedirectToAction("PlantError", "Seed");
}
#endregion
}
private void SeedContributionMessage(Privacy privacyData)
{
#region
LocationAction objLocation = new LocationAction();
var lstSeedContributionMessage = from u in objLocation.GetAllSeedContributionMessages()
select new
{
seedContribution = u.id,
cMessage = u.displayMessage
};
if (privacyData != null)
{
Guid uName = new Guid(privacyData.seedContribution);
var selectedContriMessage = (from m in objLocation.GetMessageById(uName)
select new
{
seedContribution = m.id,
cMessage = m.displayMessage
}).FirstOrDefault();
ViewData["VSeedContribution"] = new SelectList(lstSeedContributionMessage, "seedContribution", "cMessage", selectedContriMessage.seedContribution);
}
else
{
ViewData["VSeedContribution"] = new SelectList(lstSeedContributionMessage, "seedContribution", "cMessage");
}
#endregion
}
public ContentResult SearchHelp(string q, int limit, Int64 timestamp)
{
#region
StringBuilder responseContentBuilder = new StringBuilder();
CategoryAction objCat = new CategoryAction();
StreamAction objStream = new StreamAction();
LocationAction objLocation = new LocationAction();
IList<Category> lstCat = objCat.GetAllCategoriesByName(q).OrderBy(x => x.name).ToList();
IList<Member> lstMember = objStream.GetAllMembersByName(q).OrderBy(x => x.firstName).ToList();
IList<City> lstCity = objLocation.GetAllCities(q).OrderBy(x => x.name).ToList();
foreach (Category cat in lstCat)
responseContentBuilder.Append(String.Format("{0}|{1}\n", cat.id, cat.name));
foreach (Member mem in lstMember)
responseContentBuilder.Append(String.Format("{0}|{1}\n", mem.id, mem.firstName));
foreach (City ct in lstCity)
responseContentBuilder.Append(String.Format("{0}|{1}\n", ct.id, ct.name));
return Content(responseContentBuilder.ToString());
#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();
}
/// <summary>
/// Method to Manage Member Profile.
/// </summary>
/// <param name="cityName"></param>
/// <param name="zipcode"></param>
/// <param name="localLat"></param>
/// <param name="localLong"></param>
/// <param name="regionName"></param>
/// <param name="sex"></param>
/// <param name="dob"></param>
/// <returns></returns>
public bool ManageMemberProfile(Member member, string cityId, string zipcode, double localLat, double localLong, string sex, DateTime dob, string url, string bio)
{
#region Business Logic
bool actionCompleted = false;
try
{
LocationAction lrepo = new LocationAction();
//Get the location
Location location = lrepo.CreateLocation(cityId, zipcode, localLat, localLong, "");
//Updates the member profile
this.UpdateMemberProfile(member, sex, dob, location, url, bio);
actionCompleted = true;
}
catch (Exception ex)
{
WriteError(ex);
}
return actionCompleted;
#endregion
}
