public static string addToReadLater(int userID, int itemID)
{
try
{
var query = from toreadlist in dataModel.ToReadList
where toreadlist.UserID == userID && toreadlist.ItemID == itemID
select toreadlist;
int count = query.Count();
if (count > 0)
{
return("Fail, item already exists.");
}
else
{
SmartNewspaper.iEntities entities = dataModel;
entities.ToReadList.Add(new SmartNewspaper.ToReadList()
{
UserID = userID,
ItemID = itemID
});
entities.SaveChanges();
return("Success");
}
}
catch (Exception ex)
{
return("Fail");
throw ex;
}
}
//public static List<SmartNewspaper.Item> GetNewsOfCustomFilter(int userID, string filter)
//{
// SmartNewspaper.SNWebService.SNEntities entities = new SNWebService.SNEntities(new Uri("http://interestoriservice.cloudapp.net/SNDataService.svc/"));
// IEnumerable<SmartNewspaper.Item> query = entities.CreateQuery<SmartNewspaper.Item>("GetNewsOfCustomFilter").AddQueryOption("userID", userID).AddQueryOption("filter", '\'' + filter + '\'');
// try
// {
// return query.ToList<SmartNewspaper.Item>();
// }
// catch (Exception ex)
// {
// return null;
// throw ex;
// }
//}
public static List <SmartNewspaper.Item> GetCustomNews(int userID, int categoryID, int sourceID, int noOfItems)
{
SmartNewspaper.SNWebService.ICategory x = new SNWebService.ICategory();
var sw = new Stopwatch();
sw.Start();
Debug.WriteLine("Starting GetCustomNews... " + DateTime.Now);
SmartNewspaper.iEntities entities = dataModel;
IEnumerable <SmartNewspaper.Item> query = HelperClass.itemFactory.GetCustomNews(userID, categoryID, sourceID, noOfItems);
try
{
Debug.Write("So far: ");
Debug.WriteLine(sw.ElapsedMilliseconds);
var result = query.ToList <SmartNewspaper.Item>();
Debug.WriteLine("Finished...... @" + DateTime.Now);
Debug.WriteLine("Exection Time: ");
Debug.WriteLine(sw.ElapsedMilliseconds);
Debug.WriteLine("****");
return(result);
}
catch (Exception ex)
{
return(null);
throw ex;
}
}
public static bool registerUser(User user)
{
if (usernameExists(user.UserName) || emailExists(user.Email))
{
return(false);
}
else
{
try
{
SmartNewspaper.iEntities entities = dataModel;
entities.Users.Add(new SmartNewspaper.User()
{
UserName = user.UserName,
Password = user.Password,
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
UserPic = user.UserPic,
FacebookProfile = user.FacebookProfile
});
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public static string addPreference(string type, int userID, int itemID)
{
try
{
if (type.Equals("removeFromReadLater"))
{
try
{
var readLaterItem = (from item in dataModel.ToReadList
where item.UserID == userID && item.ItemID == itemID
select item).FirstOrDefault();
dataModel.ToReadList.Remove(readLaterItem);
dataModel.SaveChanges();
return("Success");
}
catch (Exception)
{
return("Failure");
throw;
}
}
else
{
var newEntities = new SmartNewspaper.iEntities();
//newEntities.UsePostTunneling = true;
var result = GeneralFactory.AddPreference(userID, itemID, type);
string response = result;
return(response);
}
}
catch (Exception ex)
{
throw ex;
}
}
