public ActionResult ManageTweets(TweetsModel model)
{
MarketingService _attSvc = new MarketingService();
TweetsBE tweet = new TweetsBE();
tweet.UserId = model.UserId;
tweet.UserName = model.UserName;
tweet.Tweet = model.Tweet;
tweet.Date = model.Date;
tweet.Location = "Riyadh, KSA";
if (_attSvc.AddTweet(tweet))
{
ModelState.AddModelError("", "Tweet Saved Successfully");
}
else
{
ModelState.AddModelError("", "Unable to Save Tweet");
}
model.TweetsList = _attSvc.GetAllTweets();
return(View(model));
}
public bool AddTweet(TweetsBE tweet)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=localhost\sqlexpress; Initial Catalog=ERP; Integrated Security=true;";
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Insert into tTweets (UserId, UserName, Date, Tweet, Location) values(@UserId, @UserName, @Date, @Tweet, @Location)";
cmd.Parameters.AddWithValue("@UserId", tweet.UserId);
cmd.Parameters.AddWithValue("@UserName", tweet.UserName);
cmd.Parameters.AddWithValue("@Date", tweet.Date);
cmd.Parameters.AddWithValue("@Tweet", tweet.Tweet);
cmd.Parameters.AddWithValue("@Location", tweet.Location);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return(true);
}
public List <TweetsBE> GetAllTweets()
{
List <TweetsBE> tweetsList = new List <TweetsBE>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=localhost\sqlexpress; Initial Catalog=ERP; Integrated Security=true;";
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select * from tTweets";
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
TweetsBE twt = new TweetsBE();
twt.KeyId = (int)rdr["KeyId"];
twt.UserId = (string)rdr["UserId"];
twt.Date = (DateTime)rdr["Date"];
twt.Tweet = (string)rdr["Tweet"];
twt.UserName = (string)rdr["UserName"];
twt.Location = (string)rdr["Location"];
tweetsList.Add(twt);
}
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return(tweetsList);
}
public bool ModifyTweet(TweetsBE tweet)
{
//Not yet Defined
throw new NotImplementedException();
}
