public bool Person_Update(Person person)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user_id", person.User_id),
new SqlParameter("@FullName", person.FullName),
new SqlParameter("@Email", person.Email),
};
return(SqlDBHelper.ExecuteNonQuery("Person_Update", CommandType.StoredProcedure, parameters));
}
public bool Tweet_Add(Tweet tweet)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@User_id", tweet.User_id),
new SqlParameter("@Message", tweet.Message),
new SqlParameter("@Created", tweet.Created)
};
return(SqlDBHelper.ExecuteNonQuery("Tweet_Add", CommandType.StoredProcedure, parameters));
}
public bool Reply_Add(Reply reply)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@tweet_id", reply.User_id),
new SqlParameter("@user_id", reply.Message),
new SqlParameter("@message", reply.Created),
new SqlParameter("@created", reply.Created)
};
return(SqlDBHelper.ExecuteNonQuery("Reply_Add", CommandType.StoredProcedure, parameters));
}
public bool Person_Add(Person person)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user_id", person.User_id),
new SqlParameter("@Password", person.Password),
new SqlParameter("@FullName", person.FullName),
new SqlParameter("@Email", person.Email),
new SqlParameter("@Joined", person.Joined),
new SqlParameter("@Active", person.Active)
};
return(SqlDBHelper.ExecuteNonQuery("Person_Add", CommandType.StoredProcedure, parameters));
}
public int Tweet_Count(string user_id)
{
int count = 0;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user_id", user_id)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Tweet_Count", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count == 1)
{
count = Convert.ToInt32(table.Rows[0][0]);
}
}
return(count);
}
public List <Tweet> Reply_List(string reply_id)
{
List <Tweet> tweetListFollowing = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user_id", reply_id)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Reply_List", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
tweetListFollowing = new List <Tweet>();
foreach (DataRow row in table.Rows)
{
Tweet tweet = new Tweet();
tweet.Tweet_id = Convert.ToInt32(row["tweet_id"]);
tweet.User_id = row["user_id"].ToString();
tweet.FullName = row["fullName"].ToString();
tweet.Message = row["message"].ToString();
tweet.ProfilePic = (bool)row["profilepic"];
if (tweet.ProfilePic == true)
{
tweet.ProfilepicUrl = "~/ProfilePic/" + reply_id + ".jpg";
}
else
{
tweet.ProfilepicUrl = "~/ProfilePic/default.png";
}
tweet.User_idShow = "(@" + tweet.User_id + ")";
tweetListFollowing.Add(tweet);
}
}
}
return(tweetListFollowing);
}
public ProfileCoverPic ProfileCoverPic_Details(string user_id)
{
ProfileCoverPic profilecoverpic = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user_id", user_id)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ProfileCoverPic_Details", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
profilecoverpic = new ProfileCoverPic();
profilecoverpic.ProfilePic = (bool)row["profilepic"];
profilecoverpic.CoverPic = (bool)row["coverpic"];
}
}
return(profilecoverpic);
}
public Person Login(string user_id)
{
Person person = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user_id", user_id)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Login", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
person = new Person();
person.User_id = row["user_id"].ToString();
person.Password = ObjectToByteArray(row["password"]);
}
}
return(person);
}
public List <Person> Search_Results(string user)
{
List <Person> personList = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user", user)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Search_Results", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
personList = new List <Person>();
foreach (DataRow row in table.Rows)
{
Person person = new Person();
person.User_id = row["user_id"].ToString();
person.FullName = row["fullName"].ToString();
person.ProfilePic = (bool)row["profilepic"];
if (person.ProfilePic == true)
{
person.ProfilepicUrl = "~/ProfilePic/" + person.User_id + ".jpg";
}
else
{
person.ProfilepicUrl = "~/ProfilePic/default.png";
}
person.User_idShow = "(@" + person.User_id + ")";
personList.Add(person);
}
}
}
return(personList);
}
public List <Following> Find_Followers_Names(string following_id)
{
List <Following> followersList = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Following_id", following_id)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Find_Followers_Names", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
followersList = new List <Following>();
foreach (DataRow row in table.Rows)
{
Following following = new Following();
following.User_id = row["user_id"].ToString();
following.FullName = row["fullName"].ToString();
following.ProfilePic = (bool)row["profilepic"];
if (following.ProfilePic == true)
{
following.ProfilepicUrl = "~/ProfilePic/" + following.User_id + ".jpg";
}
else
{
following.ProfilepicUrl = "~/ProfilePic/default.png";
}
following.User_idShow = "(@" + following.User_id + ")";
followersList.Add(following);
}
}
}
return(followersList);
}
public Person Person_Details(string user_id)
{
Person person = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@user_id", user_id)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Person_Details", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
person = new Person();
person.FullName = row["fullName"].ToString();
person.Password = ObjectToByteArray(row["password"]);
person.Email = row["email"].ToString();
person.Joined = (DateTime)row["joined"];
}
}
return(person);
}