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