public IEnumerable <TWEET> GetAllTweets() { List <TWEET> objTweets = new List <TWEET>(); try { using (TwitterCloneContext objContext = new TwitterCloneContext()) { var tweets = from obj in objContext.TWEETs select obj; foreach (var item in tweets) { objTweets.Add(new TWEET { user_id = item.user_id, tweet_id = item.tweet_id, message = item.message, created = item.created }); } } return(objTweets); } catch (Exception ex) { throw ex; } }
public void AddTweet(TWEET objTweet) { try { using (TwitterCloneContext objContext = new TwitterCloneContext()) { objContext.TWEETs.Add(objTweet); objContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public void AddUser(PERSON objUser) { try { using (TwitterCloneContext objContext = new TwitterCloneContext()) { objContext.People.Add(objUser); objContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public void EditTweet(TWEET objTweet) { try { using (TwitterCloneContext objContext = new TwitterCloneContext()) { objContext.TWEETs.Attach(objTweet); objContext.Entry(objTweet).State = System.Data.Entity.EntityState.Modified; objContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public TWEET FindTweet(int id) { try { using (TwitterCloneContext objContext = new TwitterCloneContext()) { var query = (from obj in objContext.TWEETs where obj.tweet_id == id select obj).FirstOrDefault(); return(query); } } catch (Exception ex) { throw ex; } }
public void DeleteTweet(int id) { try { using (TwitterCloneContext objContext = new TwitterCloneContext()) { var query = (from obj in objContext.TWEETs where obj.tweet_id == id select obj).FirstOrDefault(); objContext.TWEETs.Remove(query); objContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public bool VerifyUser(string username, string password) { try { using (TwitterCloneContext objContext = new TwitterCloneContext()) { var NoOfUsers = (from obj in objContext.People where obj.user_id == username && obj.password == password select obj).Count(); if (NoOfUsers > 0) { return(true); } else { return(false); } } } catch (Exception ex) { throw ex; } }