public void AddTweet(Tweet objTweet) { try { using (var objcontext = new MVCSBAEntities()) { objcontext.Tweets.Add(objTweet); objcontext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public void AddUser(Person objUser) { try { using (var objcontext = new MVCSBAEntities()) { objcontext.Persons.Add(objUser); objcontext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public void EditTweet(Tweet objTweet) { try { using (MVCSBAEntities objcontext = new MVCSBAEntities()) { 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 (MVCSBAEntities objcontext = new MVCSBAEntities()) { var Query = (from obj in objcontext.Tweets where obj.TweetID == id select obj).FirstOrDefault(); objcontext.Tweets.Remove(Query); objcontext.SaveChanges(); } } catch (Exception ex) { throw ex; } }