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;
}
}