public void AddUser(Person objUser) { try { using (TwitterContext objContext = new TwitterContext()) { objContext.People.Add(objUser); objContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public void AddTweet(Tweet objTweet) { try { using (TwitterContext objContext = new TwitterContext()) { objContext.TWEETs.Add(objTweet); objContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public void EditTweet(Tweet objTweet) { try { using (TwitterContext objContext = new TwitterContext()) { objContext.TWEETs.Attach(objTweet); objContext.Entry(objTweet).State = System.Data.Entity.EntityState.Modified; objContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public void DeleteTweet(int id) { try { using (TwitterContext objContext = new TwitterContext()) { 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; } }