public IEnumerable <Tweet> GetAllTweets()
{
List <Tweet> objTweets = new List <Tweet>();
try
{
using (MVCSBAEntities objcontext = new MVCSBAEntities())
{
var tweets = from obj in objcontext.Tweets
select obj;
foreach (var item in tweets)
{
objTweets.Add(new Tweet {
userid = item.userid, TweetID = item.TweetID, message = item.message, created = item.created
});
}
}
return(objTweets);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <Tweet> ViewTweetsByUsername(string username)
{
List <Tweet> objTweets = new List <Tweet>();
try
{
using (MVCSBAEntities objcontext = new MVCSBAEntities())
{
var Query = from obj in objcontext.Tweets
where obj.userid == username
select new
{
obj.message
};
foreach (var item in Query)
{
objTweets.Add(new Tweet {
message = item.message
});
}
}
}
catch (Exception ex)
{
throw ex;
}
return(objTweets);
}
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 Tweet FindTweet(int id)
{
try
{
using (MVCSBAEntities objcontext = new MVCSBAEntities())
{
var Query = (from obj in objcontext.Tweets
where obj.TweetID == id
select obj).FirstOrDefault();
return(Query);
}
}
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;
}
}
public bool VerifyUser(string Username, string Password)
{
bool IsvalidUser = false;
try
{
using (var objcontext = new MVCSBAEntities())
{
var NoOfusers = (from obj in objcontext.Persons
where obj.userid == Username && obj.password == Password
select obj).Count();
IsvalidUser = NoOfusers > 0;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsvalidUser);
}