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; }