public User (UserResponseModel model) { this.facebook_id = model.facebook_id; this.gender = model.gender; this.email = model.email; this.name = model.name; this.first_name = model.first_name; this.last_name = model.last_name; }
public static bool VerifyFacebook(string fbId, string accessToken, out UserResponseModel model) { try { string graphUrl = string.Format("https://graph.facebook.com/me?access_token={0}", accessToken); WebRequest request = WebRequest.Create(graphUrl); WebResponse response = request.GetResponse(); Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); string responseData = reader.ReadToEnd(); reader.Close(); response.Close(); JObject graphData = JObject.Parse(responseData); string graphId = graphData.GetValue("id").ToString(); model = new UserResponseModel(); model.facebook_id = graphId; model.gender = graphData.GetValue("gender").ToString(); model.email = graphData.GetValue("email").ToString(); model.name = graphData.GetValue("name").ToString(); model.first_name = graphData.GetValue("first_name").ToString(); model.last_name = graphData.GetValue("last_name").ToString(); if (graphId.Equals(fbId)) { return true; } else { return false; } } catch { model = new UserResponseModel(); return false; } }
public async Task<List<UserResponseModel>> ListGroupMember(Guid groupid) { List<UserResponseModel> users = new List<UserResponseModel>(); Exception err = null; string sql = "SELECT users.id, users.facebook_id, users.gender, users.email, users.name, users.first_name, users.last_name FROM dbo.Memberships WITH (NOLOCK), dbo.Users WITH (NOLOCK) WHERE user_id LIKE users.id AND group_id LIKE @group_id"; if (db.State != ConnectionState.Open) await db.OpenAsync(); try { DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(sql, db); cmd.Parameters.AddWithValue("@group_id", groupid); SqlDataAdapter adp = new SqlDataAdapter(); adp.SelectCommand = cmd; adp.Fill(dt); if (dt != null && !dt.HasErrors && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { UserResponseModel user = new UserResponseModel(); user.id = (Guid)dr["id"]; user.facebook_id = dr["facebook_id"].ToString(); user.gender = dr["gender"].ToString(); user.email = dr["email"].ToString(); user.name = dr["name"].ToString(); user.first_name = dr["first_name"].ToString(); user.last_name = dr["last_name"].ToString(); users.Add(user); } } } catch (Exception e) { err = e; } finally { db.Close(); } if (err != null) { throw err; } return users; }