public ActionResult SubmitFlag(int lampId, string info)
{
//instantiate new lamp entities database
LampBaeEntities1 db = new LampBaeEntities1();
//instantiating new list and populating it with report where the ID != 0
List <Report> ReportList = (from r in db.Reports
where r.ReportID != 0
select r).ToList();
//instantiate new report object
Report report = new Report();
report.LampID = lampId;
report.Info = info;
report.UserID = User.Identity.Name;
report.DateAdded = DateTime.Now;
//instantiate and populate from listing
Listing newListing = (from r in db.Listings
where r.ID == lampId
select r).Single();
newListing.ReportCount++;
db.Reports.Add(report);
db.SaveChanges();
return(RedirectToAction("Lamps"));
}
public ActionResult GetFriendsByEmail(string email)
{
//instantiate DB
LampBaeEntities1 db = new LampBaeEntities1();
AspNetUser friend = new AspNetUser();
List <AspNetUser> SearchResults = new List <AspNetUser>();
if (email != "")
{
try
{
SearchResults = (from u in db.AspNetUsers
where u.Email.Contains(email)
select u).ToList();
}
catch
{
Exception e;
}
}
return(Json(SearchResults));
}
public ActionResult GetAddToFavorites(int lampID)
{
//instabtiate DB
LampBaeEntities1 db = new LampBaeEntities1();
Listing foundListing = new Listing();
Favorite listing = new Favorite();
List <Favorite> ListOfUserFavorites = new List <Favorite>();
//ListOfUserFavorites is all of the Favorites records where the userID is the current user
ListOfUserFavorites = (from u in db.Favorites
where u.ItemID != 0 &&
u.UserID == User.Identity.Name
select u).ToList();
try
{
listing = (from t in db.Favorites
where t.ItemID == lampID && t.UserID == User.Identity.Name
select t).Single();
}
catch
{
Exception e;
}
string message;
if (listing.FavoriteID == 0)
{
// find a listing in the Listings database with the specified lamp ID
foundListing = (from t in db.Listings
where t.ID == lampID
select t).Single();
listing.ItemID = lampID;
listing.UserID = User.Identity.Name;
listing.Title = foundListing.Title;
listing.Image = foundListing.Image;
listing.Price = foundListing.Price;
listing.ItemSearchURL = foundListing.ItemSearchURL;
listing.PostalCode = foundListing.PostalCode;
db.Favorites.Add(listing);
db.SaveChanges();
message = "Lamp Added";
}
else
{
message = "Already added to Favorites!";
}
return(Json(message));
}
public ActionResult FriendLampList(string friendID)
{
LampBaeEntities1 db = new LampBaeEntities1();
List <Rating> FriendLampRList = new List <Rating>();
FriendLampRList = (from p in db.Ratings
where p.UserID == friendID
select p).ToList();
//randomize the llist
var rand = new Random();
FriendLampRList = FriendLampRList.OrderBy(x => rand.Next()).ToList();
ViewBag.FriendLampRList = FriendLampRList;
Listing listing = new Listing();
List <Listing> FriendLampListings = new List <Listing>();
if (FriendLampRList.Count != 0)
{
if (FriendLampRList.Count < 5)
{
for (int i = 0; i < FriendLampRList.Count; i++)
{
var LampId = FriendLampRList[i].ItemID;
listing = db.Listings.Find(LampId);
FriendLampListings.Add(listing);
}
}
else
{
for (int i = 0; i < 5; i++)
{
var LampId = FriendLampRList[i].ItemID;
listing = db.Listings.Find(LampId);
FriendLampListings.Add(listing);
}
}
}
else
{
}
ViewBag.FriendLampListings = FriendLampListings;
return(View());
}
public ActionResult LinkImage(int?lampid)
{
LampBaeEntities1 db = new LampBaeEntities1();
Listing listing;
listing = (from p in db.Listings
where p.ID == lampid
select p).Single();
ViewData["ImageURL"] = Url.Content("~/Content/" + listing.Image);
ViewData["Price"] = ("$" + listing.Price);
ViewData["Name"] = listing.Title;
ViewData["ContactInfo"] = listing.Email;
ViewData["CurrentLampID"] = listing.ID;
return(View());
}
public ActionResult NewLamp(HttpPostedFileBase file, Listing model)
{
ViewBag.Title = "Upload A New Lamp";
var db = new LampBaeEntities1();
var path = "";
if (file != null)
{
if (file.ContentLength > 0)
{
//for checking uploaded file is valid or not
if (Path.GetExtension(file.FileName).ToLower() == ".png" ||
Path.GetExtension(file.FileName).ToLower() == ".jpg" ||
Path.GetExtension(file.FileName).ToLower() == ".jpeg" ||
Path.GetExtension(file.FileName).ToLower() == ".gif")
{
//saves to server
path = Path.Combine(Server.MapPath("~/Content/Images"), file.FileName);
file.SaveAs(path);
//formats path for simplified SQL database storage & HTML retrieval
path = path.Substring(path.IndexOf("Images"));
path = path.Replace(@"\\", @"/");
path = path.Replace(@"\", @"/");
//assign formatted path to image column of this record.
model.Image = path;
}
}
}
db.Listings.Add(model);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public ActionResult Login(string returnUrl)
{
string userIP = UtilityClass.GetIP();
string postalcode = UtilityClass.GetZip(userIP);
JArray items;
string keyword = "lamp";
int page;
for (page = 1; page < 5; page++)
{
HttpWebRequest WR = WebRequest.CreateHttp($"http://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsByKeywords" +
$"&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-US&SECURITY-APPNAME=shaunitt-studenta-PRD-b7141958a-1d5c6f0c&RESPONSE-DATA-FORMAT=JSON&REST-PAYLOAD=TRUE" +
$"&keywords={keyword}&buyerPostalCode={postalcode}&itemFilter.name=MaxDistance&itemFilter.value=40" +
$"&paginationInput.entriesPerPage=100&paginationInput.pageNumber={page}");
HttpWebResponse Response;
try
{
Response = (HttpWebResponse)WR.GetResponse();
}
catch (WebException e)
{
ViewBag.Error = "Exception";
ViewBag.ErrorDescription = e.Message;
return(View());
}
//reads response
StreamReader reader = new StreamReader(Response.GetResponseStream());
string searchData = reader.ReadToEnd();
//parses JSON
JObject JsonData = JObject.Parse(searchData);
//J array for items returned
items = (JArray)JsonData["findItemsByKeywordsResponse"][0]["searchResult"][0]["item"];
//instantiate new ebaylisting object
Listing listing = new Listing();
//instantiate new lamp entities database
LampBaeEntities1 db = new LampBaeEntities1();
List <Listing> LampDBList = new List <Listing>();
LampDBList = (from p in db.Listings
where p.ID != 0
select p).ToList();
for (int i = 0; i < items.Count; i++)
{
if (LampDBList.Exists(x => x.EbayItemNumber != null && x.EbayItemNumber.ToString() == (string)items[i]["itemId"][0]))
{
//dupes detected
}
else
{
listing.ItemSearchURL = (string)items[i]["viewItemURL"][0];
listing.Title = (string)items[i]["title"][0];
listing.Image = (string)items[i]["galleryURL"][0];
listing.PostalCode = (string)items[i]["postalCode"][0];
listing.EbayItemNumber = (string)items[i]["itemId"][0];
listing.EndDate = (DateTime)items[i]["listingInfo"][0]["endTime"][0];
listing.Price = (decimal)items[i]["sellingStatus"][0]["currentPrice"][0]["__value__"];
new Listing()
{
EbayItemNumber = listing.EbayItemNumber, ItemSearchURL = listing.ItemSearchURL, Title = listing.Title, PostalCode = listing.PostalCode, Image = listing.Image
};
db.Listings.Add(listing);
db.SaveChanges();
}
}
}
ViewBag.ReturnUrl = returnUrl;
return(View());
}
public ActionResult Lamps(int?lampid)
{
ViewBag.Title = "Lamps";
string userIP = UtilityClass.GetIP();
string userZip = UtilityClass.GetZip(userIP);
//instantiate DB from model
LampBaeEntities1 db = new LampBaeEntities1();
//instantiate new list for lamp id's
List <Listing> LampDBList = new List <Listing>();
//populate list from Listing
LampDBList = (from p in db.Listings
where p.ID != 0 ||
p.EndDate > DateTime.Now || //doesnt show lamps after its ended auction
p.ReportCount > 0 //doesn't show lamps that have been reported/flagged
select p).ToList();
//instantiate new list for ratings
List <ViewCount> ViewCountList = (from p in db.ViewCounts
where p.ViewID != 0
select p).ToList();
//declaring our listing object
Listing listing = null;
string ItemZipCode = "";
// if no lampid is provided, a random id will be generated and assigned to x
if (lampid == null || lampid > LampDBList.Count || lampid < 0)
{
//instantiate new random object & create a new random int based on range of list count as max value
Random r = new Random();
lampid = r.Next(1, LampDBList.Count());
listing = (from p in db.Listings
where p.ID == lampid
select p).Single();
ItemZipCode = listing.PostalCode;
}
else
{
//grabs a listing from list
listing = (from p in db.Listings
where p.ID == lampid
select p).Single();
ItemZipCode = listing.PostalCode;
}
//handling for ebay listings vs user listings (the image url structure is different)
if (listing.EbayItemNumber == null)
{
ViewData["ItemTitle"] = listing.Title;
ViewData["Price"] = listing.Price;
ViewData["viewItemURL"] = ("/Home/LinkImage?lampid=" + listing.ID);
ViewData["ImageURL"] = Url.Content("~/Content/" + listing.Image);
}
else
{
ViewData["ItemTitle"] = listing.Title;
ViewData["Price"] = listing.Price;
ViewData["viewItemURL"] = listing.ItemSearchURL;
ViewData["ImageURL"] = listing.Image;
}
//test if view record exists already
ViewCount existingViewCount = null;
try
{
existingViewCount = (from m in db.ViewCounts
where m.ItemID == lampid &&
m.UserID == User.Identity.Name
select m).Single();
}
catch (Exception e)
{
Console.WriteLine("An error occurred: '{0}'", e);
}
// if a view record already exists, simply increment
if (existingViewCount != null)
{
existingViewCount.ViewCount1 = existingViewCount.ViewCount1 + 1;
db.SaveChanges();
}
//if a view record doesn't already exist, create a new record and assign it a value of one
else
{
ViewCount newviewcount = new ViewCount();
newviewcount.UserID = User.Identity.Name;
newviewcount.ItemID = (int)lampid;
newviewcount.ViewCount1 = 1;
newviewcount.ViewDate = DateTime.Now;
new ViewCount()
{
UserID = newviewcount.UserID, ItemID = (int)lampid, ViewCount1 = 1, ViewDate = DateTime.Now
};
db.ViewCounts.Add(newviewcount);
db.SaveChanges();
}
string distance = UtilityClass.GetZipCodeDistance(userZip, ItemZipCode);
ViewBag.Distance = distance;
ViewData["CurrentLampID"] = listing.ID;
ViewBag.UserZip = userZip;
ViewBag.CurrentUser = User.Identity.Name;
ViewBag.CurrentUserIP = userIP;
return(View());
}
//handles user and global rating.
public ActionResult Rating(int lampid, int ratingvalue)
{
LampBaeEntities1 db = new LampBaeEntities1();
//instantiate new list for lamp id's
List <Listing> LampDBList = new List <Listing>();
//grab listing based on lampid provided
Listing listing = (from p in db.Listings
where p.ID == lampid
select p).Single();
if (listing.Rating == null)
{
listing.Rating = 0;
listing.Rating = listing.Rating + ratingvalue;
}
else
{
//global rating
listing.Rating = listing.Rating + ratingvalue;
}
//user rating
//instantiate new list for ratings
List <Rating> RatingList = (from p in db.Ratings
where p.RatingID != 0
select p).ToList();
Rating ratingrecord = new Rating();
ratingrecord = null;
// try to find a lamp with the lamp id/user id combo
try
{
ratingrecord = (from m in db.Ratings
where m.ItemID == lampid &&
m.UserID == User.Identity.Name
select m).Single();
}
catch (Exception e)
{ }
// if the record does not exist, then assign values, instantiate object and add the record.
if (ratingrecord == null)
{
Rating rating = new Rating();
rating.ItemID = lampid;
rating.UserID = User.Identity.Name;
rating.Rating1 = ratingvalue;
new Rating {
ItemID = lampid, UserID = User.Identity.Name, Rating1 = ratingvalue
};
db.Ratings.Add(rating);
db.SaveChanges();
}
// else, if a record exists, then increment or decrement the rating
else
{
ratingrecord.Rating1 = ratingrecord.Rating1 + ratingvalue;
}
db.SaveChanges();
return(RedirectToAction("Lamps"));
}
public ActionResult HotLamps()
{
LampBaeEntities1 db = new LampBaeEntities1();
List <Listing> RatedLampList = new List <Listing>();
RatedLampList = (from p in db.Listings
where p.Rating >= 1 &&
p.EndDate > DateTime.Now //doesnt show lamps after its ended auction
select p).ToList();
//randomize the llist
var rand = new Random();
RatedLampList = RatedLampList.OrderBy(x => rand.Next()).ToList();
ViewBag.RatedLampList = RatedLampList;
//consider using try catch if ratedlamplist count returns 0
if (RatedLampList.Count > 5)
{
ViewBag.RatedLampListCount = 5;
}
else if (RatedLampList.Count <= 5 && RatedLampList.Count != 0)
{
ViewBag.RatedLampListCount = RatedLampList.Count;
}
else
{
ViewBag.RatedLampListCount = "We don't have any popular lamps yet, check with us again soon!";
}
//instantiate list
List <Rating> UserLikedLamps = new List <Rating>();
//create list based on user ratings where rating is greater
//than or equal to 1 and user ID from ratings matches logged in user name
UserLikedLamps = (from u in db.Ratings
where u.Rating1 > 0 &&
u.UserID == User.Identity.Name
select u).ToList();
//instantiate new list to add top liked lamps to later
List <Listing> TopUserLikedLamps = new List <Listing>();
//instantiate new listing object
Listing listing = new Listing();
//add top 5 rated lamps to top user like lamps
if (UserLikedLamps.Count != 0)
{
if (UserLikedLamps.Count < 5)
{
for (int i = 0; i < UserLikedLamps.Count; i++)
{
var LampId = UserLikedLamps[i].ItemID;
listing = db.Listings.Find(LampId);
TopUserLikedLamps.Add(listing);
}
}
else
{
for (int i = 0; i < 5; i++)
{
var LampId = UserLikedLamps[i].ItemID;
listing = db.Listings.Find(LampId);
TopUserLikedLamps.Add(listing);
}
}
}
else
{
}
TopUserLikedLamps = TopUserLikedLamps.OrderBy(x => rand.Next()).ToList();
//place list results in viewbag
ViewBag.TU = TopUserLikedLamps;
List <Friend> UserFriendPairs = new List <Friend>();
UserFriendPairs = (from u in db.Friends
where u.UserID1 == User.Identity.Name ||
u.UserID2 == User.Identity.Name
select u).ToList();
List <string> FriendsList = new List <string>();
foreach (Friend friends in UserFriendPairs)
{
if (friends.UserID1 != User.Identity.Name.ToString() &&
!FriendsList.Contains(friends.UserID1))
{
FriendsList.Add(friends.UserID1);
}
else if (
friends.UserID2 != User.Identity.Name.ToString() &&
!FriendsList.Contains(friends.UserID2))
{
FriendsList.Add(friends.UserID2);
}
}
List <Rating> FriendsLikedLamps = new List <Rating>();
foreach (string friend in FriendsList)
{
FriendsLikedLamps = (from u in db.Ratings
where u.Rating1 > 0 &&
u.UserID == friend
select u).ToList();
}
//instantiate new list to add top liked lamps to later
List <Listing> FriendsLikedLampListings = new List <Listing>();
//add 5 rated lamps to FriendsLikedLampListings
if (FriendsLikedLamps.Count != 0)
{
if (FriendsLikedLamps.Count < 5)
{
for (int i = 0; i < FriendsLikedLamps.Count; i++)
{
var LampId = FriendsLikedLamps[i].ItemID;
listing = db.Listings.Find(LampId);
FriendsLikedLampListings.Add(listing);
}
}
else
{
for (int i = 0; i < 5; i++)
{
var LampId = FriendsLikedLamps[i].ItemID;
listing = db.Listings.Find(LampId);
FriendsLikedLampListings.Add(listing);
}
}
}
else
{
}
FriendsLikedLampListings = FriendsLikedLampListings.OrderBy(x => rand.Next()).ToList();
ViewBag.FriendsLamps = FriendsLikedLampListings;
return(View());
}
