private void getTweetCount(string strUserName)
{
//SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConString"]);
//SqlCommand cmd = new SqlCommand();
//string Query = @"usp_getFollowTweets";
//cmd = new SqlCommand(Query, con);
//cmd.Parameters.AddWithValue("@UserID", strUserName);
//DataSet ds = new DataSet();
//SqlDataAdapter sda = new SqlDataAdapter(Query, con);
//con.Open();
//sda.Fill(ds);
//con.Close();
int intFollowerTweets = 0;
int intFollowingTweets = 0;
//if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
//{
// intFollowerTweets = Convert.ToInt32(ds.Tables[0].Rows[0]["FollowerTweets"].ToString());
// intFollowingTweets = Convert.ToInt32(ds.Tables[0].Rows[0]["FollowingTweets"].ToString());
//}
testEntities dbTweetsEntity = new testEntities();
UserTweets objTweets = new UserTweets();
objTweets = dbTweetsEntity.getFollowTweets(strUserName);
intFollowerTweets = Convert.ToInt32(objTweets.FollowerTweets.ToString());
intFollowingTweets = Convert.ToInt32(objTweets.FollowingTweets.ToString());
var userTweet = new UserTweets()
{
fullName = Session["UserFullName"].ToString(),
TotalTweets = intFollowerTweets + intFollowingTweets,
FollowerTweets = intFollowerTweets,
FollowingTweets = intFollowingTweets
};
ViewBag.UserTweet = userTweet;
}