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