public User GetUser(string emailAddress, out string password)
{
User user = null;
using (DatabaseLayer dbLayer = new DatabaseLayer())
{
SqlCommand sqlCmd = new SqlCommand("GetUser");
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@emailAddress", emailAddress);
user = new User();
DataSet dataSet = dbLayer.FillDataSet(sqlCmd);
user.EmailAddress = dataSet.Tables[0].Rows[0]["EmailAddress"].ToString();
user.CreatedOn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["CreatedOn"].ToString());
user.DOB = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["DOB"].ToString());
user.FirstName = dataSet.Tables[0].Rows[0]["FirstName"].ToString();
user.Gender = dataSet.Tables[0].Rows[0]["Gender"].ToString();
user.Id = Convert.ToInt32(dataSet.Tables[0].Rows[0]["Id"].ToString());
user.LastLoggedIn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["LastLoggedIn"].ToString());
user.LastName = dataSet.Tables[0].Rows[0]["LastName"].ToString();
user.ProfilePicPath = dataSet.Tables[0].Rows[0]["ProfilePicPath"].ToString();
password = dataSet.Tables[0].Rows[0]["Password"].ToString();
}
return user;
}
public List<Post> GetPosts(string emailAddress)
{
List<Post> lstPosts = new List<Post>();
using (DatabaseLayer dbLayer = new DatabaseLayer())
{
SqlCommand cmd = new SqlCommand("GetPosts");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@emailAddress", emailAddress);
DataSet postDataset = dbLayer.FillDataSet(cmd);
if (postDataset != null && postDataset.Tables.Count > 0)
{
foreach (DataRow row in postDataset.Tables[0].Rows)
{
Post post = new Post();
post.Id = Convert.ToInt32(row["Id"].ToString());
post.Message = row["Message"].ToString();
post.CreatedOn = Convert.ToDateTime(row["CreatedOn"].ToString());
post.CreatedByString = row["CreatedByString"].ToString();
post.CreatedBy = Convert.ToInt32(row["CreatedBy"].ToString());
lstPosts.Add(post);
}
}
}
return lstPosts;
}
public User UpdateUserInfo(int userId,string lastName,string firstName,string profilePicPath)
{
User user = null;
using (DatabaseLayer dbLayer = new DatabaseLayer())
{
SqlCommand sqlCmd = new SqlCommand("UpdateUserInfo");
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@id", userId);
sqlCmd.Parameters.AddWithValue("@lastName", lastName);
sqlCmd.Parameters.AddWithValue("@firstName", firstName);
sqlCmd.Parameters.AddWithValue("@profilePic", profilePicPath);
user = new User();
DataSet dataSet = dbLayer.FillDataSet(sqlCmd);
user.EmailAddress = dataSet.Tables[0].Rows[0]["EmailAddress"].ToString();
user.CreatedOn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["CreatedOn"].ToString());
user.FirstName = dataSet.Tables[0].Rows[0]["FirstName"].ToString();
user.Id = Convert.ToInt32(dataSet.Tables[0].Rows[0]["Id"].ToString());
user.LastLoggedIn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["LastLoggedIn"].ToString());
user.LastName = dataSet.Tables[0].Rows[0]["LastName"].ToString();
user.ProfilePicPath = dataSet.Tables[0].Rows[0]["ProfilePicPath"].ToString();
}
return user;
}