public static Story GetSingleStory(int storyID) { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { return(context.Stories.FirstOrDefault(s => s.StoryID == storyID)); } }
public static Story GetSingleStoryByTitle(string title) { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { return(context.Stories.FirstOrDefault(s => s.Title == title)); } }
// Check if story with selected link already exists public static bool CheckStory(string link) { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { return(context.Stories.Any(s => s.Link == link)); } }
// Check if story with selected title already exists public static bool CheckStoryTitle(string title) { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { return(context.Stories.Any(s => s.Title == title)); } }
// Check if story with selected title already exists public static bool CheckStoryTitle(string title, bool isFavorit = false) { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { return(context.Stories.Any(s => s.Title == title && s.IsFavorite == isFavorit)); } }
/// <summary> /// Remove story by title /// </summary> /// <param name="title">Title to remove from stories</param> /// <param name="fromFavorits">Remove story completely or just from favorits</param> /// <returns>Success/Failure</returns> public static bool RemoveStory(string title, bool fromFavorits = false) { try { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { var story = context.Stories.FirstOrDefault(s => s.Title == title); if (story == null) { return(true); } if (!fromFavorits) { context.Stories.DeleteOnSubmit(story); } else { story.IsFavorite = false; //context.Stories.Attach(story); } context.SubmitChanges(); return(true); } } catch (Exception e) { BugSense.BugSenseHandler.Instance.LogException(e); } return(false); }
public static bool RemoveStory(Story story) { try { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { context.Stories.Attach(story); context.Stories.DeleteOnSubmit(story); context.SubmitChanges(); return(true); } } catch (Exception e) { BugSense.BugSenseHandler.Instance.LogError(e); } return(false); }
/// <summary> /// Remove story by title /// </summary> /// <param name="title">Title to remove from stories</param> /// <returns>Success/Failure</returns> public static bool RemoveStory(string title) { try { using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { var story = context.Stories.FirstOrDefault(s => s.Title == title); if (story == null) { return(true); } context.Stories.DeleteOnSubmit(story); context.SubmitChanges(); return(true); } } catch (Exception e) { BugSense.BugSenseHandler.Instance.LogError(e); } return(false); }
public static int AddNewStory(string title, DateTime datePublished, string link, string details, Action <int> callback) { try { InsertedID = 0; if (!Utilities.CheckNetwork()) { return(0); } // try to get full content from server var wc = new WebClient(); wc.DownloadStringCompleted += (s, e) => { if (e.Cancelled || e.Result == null) { return; } var value = JsonConvert.DeserializeObject <PostRoot>(e.Result); detailsGlobal = value.post.content; using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) { if (CheckStoryTitle(value.post.title)) { return; } Story st = new Story(); st.Title = value.post.title; st.DateCreated = DateTime.Now; st.DatePublished = DateTime.Parse(value.post.date); st.Link = value.post.url; st.Details = detailsGlobal; context.Stories.InsertOnSubmit(st); try { context.SubmitChanges(); } catch (Exception exception) { } if (callback != null) { callback(st.StoryID); } } }; try { wc.DownloadStringAsync(new Uri(link + "?json=1")); return(1); } catch (Exception exception) { BugSenseHandler.Instance.LogError(exception); } //while (!flag) //{ // Thread.Sleep(100); //} //using (StoryDataContext context = ConnectionFactory.GetStoryDataContext()) //{ // if (CheckStoryTitle(title)) // return 0; // Story s = new Story(); // s.Title = title; // s.DateCreated = DateTime.Now; // s.DatePublished = datePublished; // s.Link = link; // s.Details = detailsGlobal ?? details; // context.Stories.InsertOnSubmit(s); // context.SubmitChanges(); // return s.StoryID; //} } catch (Exception e) { BugSense.BugSenseHandler.Instance.LogError(e); } return(-1); }