public bool Add(Tweet tweet)
{
using (var dbItem = new TwitterEntities())
{
dbItem.Tweets.Add(tweet);
return dbItem.SaveChanges() > 0;
}
}
public bool Save(Tweet tweet)
{
using (var dbItem = new TwitterEntities())
{
dbItem.Tweets.Attach(tweet);
dbItem.Entry(tweet).State = EntityState.Modified;
return dbItem.SaveChanges() > 0;
}
}
public bool Add(User user)
{
using (var dbContext = new TwitterEntities())
{
user.Password = Encryptdata(user.Password);
dbContext.Users.Add(user);
if (dbContext.SaveChanges() > 0)
return true;
else
return false;
}
}
public bool Delete(int id)
{
using (var dbItem = new TwitterEntities())
{
var _tweet = dbItem.Tweets.Find(id);
if (!(_tweet).Equals(null))
{
dbItem.Tweets.Remove(_tweet);
}
return dbItem.SaveChanges() > 0;
}
}
public bool Activated(string email)
{
using (var dbContext = new TwitterEntities())
{
var result = dbContext.Users.Where(currentUser => currentUser.Email == email).FirstOrDefault();
result.Activated = true;
dbContext.Users.Attach(result);
dbContext.Entry(result).State = EntityState.Modified;
if ( dbContext.SaveChanges() > 0)
return true;
else
return false;
}
}
public bool Delete(int id)
{
using (var dbContext = new TwitterEntities())
{
var userToDelete = dbContext.Users.FirstOrDefault(currentUser => currentUser.id_user == id);
var tweetToDelete =
from tweet in dbContext.Tweets
where tweet.id_user == id
select tweet;
foreach(var tweet in tweetToDelete){
dbContext.Tweets.Remove(tweet);
}
dbContext.Users.Remove(userToDelete);
if (dbContext.SaveChanges() > 0)
return true;
else
return false;
}
}
public bool Save(User user)
{
using (var dbContext = new TwitterEntities())
{
dbContext.Users.Attach(user);
dbContext.Entry(user).State = EntityState.Modified;
dbContext.SaveChanges();
return true;
}
}