protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["code"]))
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret, fbUrl);
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
if (fb != null && fb.fbUser != null)
{
conn.Open();
//int loginID = LoginUser.InsertUpdateLoginUser(fb, conn); // Talal - you need to change the method so it will insert all the details requiered.
Session["login"] = "******";
Session["userId"] = fb.fbUser.id;
Session["token"] = fb.fbUser.tmpToken;
//Response.Write(fb.fbUser.id);
//Session["userId"] = loginID;
Session["Logged"] = "Yes";
conn.Close();
Page.ClientScript.RegisterStartupScript(GetType(), "closePopup", "window.opener.socialLoginAdmin('" + fb.fbUser.tmpToken + "'); window.close();", true);
}
else
{
Response.Write("has no fb user");
}
}
}
else
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret);
fb.LoginClick(fbUrl, "user_hometown,email,user_location,manage_pages,publish_stream,read_insights");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["code"]))
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret, fbUrl);
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
if (fb != null && fb.fbUser != null)
{
conn.Open();
int loginID = LoginUser.InsertUpdateLoginUser(fb, conn);
Session["login"] = "******";
Session["userId"] = loginID;
Session["Logged"] = "Yes";
Session["LoggedUserMail"] = fb.fbUser.email;
conn.Close();
Page.ClientScript.RegisterStartupScript(GetType(), "closePopup", "window.opener.socialLogin('" + fb.fbUser.id + "','" + fb.fbUser.picture + "','" + fb.fbUser.first_name + "'); window.close();", true);
}
else
{
Response.Write("has no fb user");
}
}
}
else
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret);
fb.LoginClick(fbUrl, "user_hometown,email,user_location");
}
}
protected void RegisterFBLinkButton_Click(object sender, EventArgs e)
{
Session["login"] = null;
Session["id"] = null;
if (!String.IsNullOrEmpty(Request.QueryString["special"]) && Request.QueryString["special"] == "true")
{
Session["SanFransisco"] = "true";
}
if (Request.QueryString != null && Request.QueryString["grp"] != null && Request.QueryString["grp"] != "")
{
HttpCookie cookieGrp = new HttpCookie("JoinUsGroup");
cookieGrp.Value = Request.QueryString["grp"];
cookieGrp.Expires = DateTime.Now.AddMinutes(2.5);
Response.SetCookie(cookieGrp);
}
if (Session["login"] == null && Session["id"] == null)
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret);
//Response.Redirect("http://comstar.co/?aa=aaa");
fb.LoginClick(fbUrl, "user_hometown,email,user_location");
}
}
protected void btnPost_Click(object sender, EventArgs e) //מתודת שליחת פוסט לקיר של הדף בפייסבוק
{
FacebookPagePost _post = new FacebookPagePost();
string _postResponse = "";
_post.message = ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("txt_PostText")).Text;
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
_cmd.CommandText = "select * from facebookpages where FacebookPagesID = 1";
MySqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.Read())
{
_post.id = _dr["PageID"].ToString();
_post.access_token = _dr["AccessToken"].ToString();
}
_dr.Close();
con.Close();
}
_post.link = ((ASP.controls_cmstrtextboxcontrol_ascx)BlogTypeMyForm.FindControl("Post_Link")).Text;
if (_post.access_token != "" && _post.access_token != null) //בדיקה האם יש טוקן במערכת והאם יש קבוצה שניתן "לפרסם" בה
{
_postResponse = FacebookCode.PostOnFacebookPage(_post); //ביצוע פוסט + קבלת מספר פוסט בכתשובה
if (_postResponse != "") //בדיקה האם חזר מספר פוסט כתשובה מפייסבוק
{
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
_cmd.CommandText = "UPDATE tblpages set FB_PostID='" + _postResponse + "' where idtblpages =" + contatctid;
_cmd.ExecuteNonQuery();
con.Close();
}
((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "פוסט נשלח בהצלחה!";
}
else
{
((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "הייתה בעיה בשליחת הפוסט";
}
}
else
{
((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "לא בוצע התחברות לדף פייסבוק עדיין, אנא התחבר לדף";
}
//((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = "פוסט נשלח בהצלחה - אנא לחץ שמור לשמירת הנתונים!";
//((Label)BlogTypeMyForm.FindControl("lblStatus")).Text = _postResponse;
hid_PostID.Value = _postResponse;
//((Button)BlogTypeMyForm.FindControl("btnSavePost")).Visible = true;
}
protected void SignByFaceLinkButton_Click(object sender, EventArgs e)
{
using (MySqlConnection conn = new MySqlConnection(cmstrDefualts.ConnStr))
{
conn.Open();
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret);
fb.LoginClick(fbUrl, "user_hometown,email,user_location");
Badge.AddBadge(BadgTypeEnum.Join, conn, Session["LoggedUserMail"].ToString());
}
}
protected void PublishPost_Click(object sender, EventArgs e)
{
string token_test = Session["token"].ToString();
bool itemSelected = false;
fbPages_test = FacebookCode.GetFacebookPages(token_test);
//FacebookApp app = new FacebookApp();
string album_id = "";
string access_Token = "";
string _pageName = "";
FacebookPagePost myPost = new FacebookPagePost();
bool sendingSucceed = false;
foreach (ListItem item in FacebookPagesList.Items)
{
if (item.Selected)
{
foreach (FacebookPage page in fbPages_test.data)
{
if (item.Value == page.id)
{
itemSelected = true;
//myPost.id = page.id;
//myPost.access_token = page.access_token;
access_Token = page.access_token;
album_id = page.id;
_pageName = page.name;
break;
}
}
//myPost.message = TextToPost.Text.ToString().Replace("\n", "").Replace("\r", "").Replace("\"", "''");
//string fbMsgID = FacebookCode.PostOnFacebookPage(myPost);
sendingSucceed = true;
}
}
if (itemSelected)
{
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
_cmd.CommandText = string.Format("UPDATE facebookpages set PageName='{0}', PageID='{1}', AccessToken='{2}' where FacebookPagesID=1", _pageName, album_id, access_Token);
_cmd.ExecuteNonQuery();
con.Close();
}
lbl_status.Text = "דף נשמר בהצלחה";
}
}
protected void RegisterFBLinkButton_Click(object sender, EventArgs e)
{
Session["login"] = null;
Session["id"] = null;
if (Session["login"] == null && Session["id"] == null)
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret);
//Response.Redirect("http://comstar.co/?aa=aaa");
fb.LoginClick(fbUrl, "user_hometown,email,user_location");
}
}
protected void ClickToGetPages_Click(object sender, EventArgs e)
{
if (Session["token"] != null)
{
string userId = Session["userId"].ToString();
string token = Session["token"].ToString();
FacebookPages fbPages = FacebookCode.GetFacebookPages(token);
foreach (FacebookPage page in fbPages.data)
{
FacebookPagesList.Items.Add(new ListItem(page.name, page.id));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["code"]))
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret, fbUrl);
if (Session != null && Session["LoggedUserMail"] != null && Session["LoggedUserMail"].ToString() != "")
{
myemail = Session["LoggedUserMail"].ToString();
}
bool faceExists = false;
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
if (fb != null && fb.fbUser.id != null && Session["LoggedUserID"] != null)
{
conn.Open();
// check if facebook id exists (Logintypeid)
string sql = String.Format("Select LoginTypeID from tblusers where LoginTypeID='{0}' and LoginTypeID is not null", fb.fbUser.id);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
faceExists = true;
}
dr.Close();
if (!faceExists)
{
cmd.CommandText = String.Format("UPDATE tblUsers SET CountryName='{1}',LoginProfilePic='{2}',LoginTypeToken='{3}',LoginType ='{4}',LoginTypeID='{5}',LoginMailAddress='{6}',SignInByFace=1 WHERE EmailAddress='{7}'",
Session["LoggedUserID"].ToString(), NullProof(fb.fbUser.countryName), "http://graph.facebook.com/" + NullProof(fb.fbUser.id) + "/picture?type=square", NullProof(fb.fbUser.tmpToken), "fb", NullProof(fb.fbUser.id), NullProof(fb.fbUser.email), NullProof(myemail));
cmd.ExecuteNonQuery();
Badge.AddBadge(BadgTypeEnum.Join, conn, Session["LoggedUserMail"].ToString());
Adduser_WL(5078, fb.fbUser.email, fb.fbUser.first_name + " " + fb.fbUser.last_name);
Response.Redirect("./");
}
else
{
Response.Redirect("./?fb=exists&");
}
//int loginID = LoginUser.InsertNewFaceBookUser(fb, conn);
//Session["login"] = "******";
//Session["userId"] = loginID;
//Session["Logged"] = "Yes";
//conn.Close();
//if (loginID == -1)
//{
// Response.Write("user exists in the system!");
//}
//else
//{
// Adduser_WL(5078, fb.fbUser.email, fb.fbUser.first_name + " " + fb.fbUser.last_name);
// Page.ClientScript.RegisterStartupScript(GetType(), "closePopup", "window.opener.socialLogin('" + fb.fbUser.id + "','" + fb.fbUser.picture + "','" + fb.fbUser.first_name + "'); window.close();", true);
//}
}
else
{
//Response.Write("Error at if (fb != null && fb.fbUser != null)");
Response.Redirect("./");
}
}
}
else
{
Response.Redirect("./");
//Response.Write("doesn't have a code");
}
}
protected void RegisterFBLinkButton_Click(object sender, EventArgs e)
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret);
fb.LoginClick(fbUrl, "user_hometown,email,user_location");
}
public static int InsertNewFaceBookUser(object socialObj, MySqlConnection conn)
{
string outlog = "";
int loginID = 0;
string myresult = "";
User u = new User();
if (socialObj is FacebookCode)
{
FacebookCode fb = (FacebookCode)socialObj;
u.LoginType = "fb";
u.LoginTypeID = fb.fbUser.id;
u.LoginFirstName = fb.fbUser.first_name;
u.LoginLastName = fb.fbUser.last_name;
u.LoginCountryName = fb.fbUser.countryName;
if (String.IsNullOrEmpty(fb.fbUser.email))
{
Random myrand = new Random();
int myVal = myrand.Next(10000, 99999);
fb.fbUser.email = myVal + "@facebookJoin.com";
u.LoginMail = myVal + "@facebookJoin.com";
}
else
{
u.LoginMail = fb.fbUser.email;
}
u.LoginProfilePic = "http://graph.facebook.com/" + fb.fbUser.id + "/picture?type=square";
u.LoginTmpToken = fb.fbUser.tmpToken;
}
int userIdInt = 0;
bool userIdValid = false;
try
{
foreach (char num in u.LoginTypeID)
{
if (!int.TryParse(num.ToString(), out userIdInt))
{
userIdValid = false;
break;
}
else
{
userIdValid = true;
}
}
}
catch (Exception)
{
}
if (userIdValid)
{
bool AddBadge = false;
//string sql = String.Format("SELECT UserID FROM tblUsers WHERE LoginType='{0}' AND LoginTypeID='{1}'", u.LoginType, u.LoginTypeID);
string sql = String.Format("SELECT UserID FROM tblUsers WHERE EmailAddress='{0}' OR LoginMailAddress='{0}' OR LoginTypeID='{1}' ", u.LoginMail, u.LoginTypeID);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (!dr.Read()) // if not exist!!
{
loginID = -1;
// int.TryParse(dr["UserID"].ToString(), out loginID);
}
else // if exist in DB!!!
{
loginID = 0;
}
dr.Close();
outlog = "aaaa" + loginID;
if (loginID == -1)
{
string generatedPassword = System.Web.Security.Membership.GeneratePassword(8, 0);
sql = String.Format("Insert Into tblUsers (`FullName`,`EmailAddress`,`Password`,`CreationTime`,`LoginType`,`LoginTypeID`,`LoginTypeToken`,`LoginProfilePic`,`FirstName`,`LastName`,`CountryName`,`LoginMailAddress`,`isActive`,`SignInByFace` ) Values ('{0}','{1}','{2}',Now(),'fb','{3}','{4}','{5}','{6}','{7}','{8}','{1}',1,1) ", u.LoginFirstName + " " + u.LoginLastName, u.LoginMail, generatedPassword, u.LoginTypeID, u.LoginTmpToken, u.LoginProfilePic, u.LoginFirstName, u.LoginLastName, u.LoginCountryName);
if (u.LoginType == "fb")
{
AddBadge = true;
}
myresult = sql;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
cmd.CommandText = "Select LAST_INSERT_ID() as myID";
dr = cmd.ExecuteReader();
if (dr.Read())
{
int.TryParse(dr["myID"].ToString(), out loginID);
}
dr.Close();
}
else
{
HttpContext.Current.Response.Redirect("./");
}
//try
//{
//if (AddBadge)
//{
// Badge.AddBadge(BadgTypeEnum.Join, conn, loginID);
//}
//}
//catch (Exception ex)
//{
// myresult = ex.Message + " **** " + ex.Source;
//}
}
return(loginID);
}
public static int InsertUpdateLoginUser(object socialObj, MySqlConnection conn)
{
int loginID = 0;
User u = new User();
if (socialObj is FacebookCode)
{
FacebookCode fb = (FacebookCode)socialObj;
u.LoginType = "fb";
u.LoginTypeID = fb.fbUser.id;
u.LoginFirstName = fb.fbUser.first_name;
u.LoginLastName = fb.fbUser.last_name;
u.LoginCountryName = fb.fbUser.countryName;
u.LoginMail = fb.fbUser.email;
//u.LoginProfilePic = fb.fbUser.picture.data.url;
u.LoginProfilePic = "http://graph.facebook.com/" + fb.fbUser.id + "/picture?type=square";
u.LoginTmpToken = fb.fbUser.tmpToken;
}
//else if (socialObj is GooglePlus)
//{
// GooglePlus gp = (GooglePlus)socialObj;
// u.LoginType = "gp";
// u.LoginTypeID = gp.gpUser.id;
// u.LoginFirstName = gp.gpUser.name.givenName;
// u.LoginLastName = gp.gpUser.name.familyName;
// u.LoginCountryName = gp.gpUser.countryName;
// u.LoginProfilePic = gp.gpUser.image.url;
// //u.LoginProfilePic = "https://plus.google.com/s2/photos/profile/" + gp.gpUser.id + "?sz=50";
// u.LoginTmpToken = gp.gpUser.tmpToken;
//}
//else if (socialObj is Twitter)
//{
// Twitter twit = (Twitter)socialObj;
// u.LoginType = "twit";
// u.LoginTypeID = twit.twitUser.id.ToString();
// u.LoginFirstName = twit.twitUser.name.Remove(twit.twitUser.name.IndexOf(' ')).Trim();
// u.LoginLastName = twit.twitUser.name.Substring(twit.twitUser.name.IndexOf(' ')).Trim();
// u.LoginCountryName = twit.twitUser.location.ToString();
// u.LoginProfilePic = twit.twitUser.profile_image_url;
// u.LoginTmpToken = "";
//}
int userIdInt = 0;
bool userIdValid = false;
foreach (char num in u.LoginTypeID)
{
if (!int.TryParse(num.ToString(), out userIdInt))
{
userIdValid = false;
break;
}
else
{
userIdValid = true;
}
}
if (userIdValid)
{
bool AddBadge = false;
//string sql = String.Format("SELECT UserID FROM tblUsers WHERE LoginType='{0}' AND LoginTypeID='{1}'", u.LoginType, u.LoginTypeID);
string sql = String.Format("SELECT UserID FROM tblUsers WHERE EmailAddress='{0}'", HttpContext.Current.Session["WLmail"]);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
int.TryParse(dr["UserID"].ToString(), out loginID);
}
dr.Close();
if (loginID > 0)
{
sql = String.Format("UPDATE tblUsers SET CountryName='{1}',LoginProfilePic='{2}',LoginTypeToken='{3}',LoginType ='{4}',LoginTypeID='{5}',LoginMailAddress='{6}' WHERE UserID={0}",
loginID, u.LoginCountryName, u.LoginProfilePic, u.LoginTmpToken, u.LoginType, u.LoginTypeID, u.LoginMail);
if (u.LoginType == "fb")
{
AddBadge = true;
}
}
else
{
//sql = String.Format("UPDATE tblUsers SET LoginDate=now(),CountryName='{1}',LoginProfilePic='{2}LoginTypeToken='{3}' WHERE EmailAddress={0}",
// u.LoginMail, u.LoginCountryName, u.LoginProfilePic, u.LoginTmpToken);
}
object lastId;
try
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
if (AddBadge)
{
Badge.AddBadge(BadgTypeEnum.Join, conn, loginID);
}
//if (loginID == 0)
//{
// sql = "SELECT @@IDENTITY;";
// cmd.CommandText = sql;
// lastId = cmd.ExecuteScalar();
// int.TryParse(lastId.ToString(), out loginID);
//}
}
catch (Exception ex)
{
}
}
return(loginID);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["code"]))
{
fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret, fbUrl);
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
if (fb != null && fb.fbUser != null)
{
conn.Open();
int loginID = LoginUser.InsertNewFaceBookUser(fb, conn);
conn.Close();
//Response.Redirect("http://comstar.co/?aa=" + loginID);
if (loginID == 0)
{
Response.Redirect("joinus.aspx");
}
if (loginID == -1)
{
Response.Redirect("./");
}
else
{
if (Session["SanFransisco"] != null && Session["SanFransisco"] == "true")
{
string SanFransiscoUrl = "https://panel.i-send.co.il/AddUserFromSite.aspx?eMail=" + fb.fbUser.email + "&1=" + fb.fbUser.first_name + " " + fb.fbUser.last_name + "&4=1&5=0&form=6557__d9fda905-f5aa-49ae-b6a6-e186f1f4613d";
HttpWebRequest webRequest = (HttpWebRequest)System.Net.WebRequest.Create(SanFransiscoUrl); //setting an httpWebRequest with the URL of the API
webRequest.Method = "GET"; //the type of method the API returns
webRequest.Timeout = 20000; //sets the timeout for the request
webRequest.ContentType = "application/x-www-form-urlencoded"; //the content type. most of the times it will be application/x-www-form-urlencoded
string responseData = "";
try
{
StreamReader MyStream = new StreamReader(webRequest.GetResponse().GetResponseStream()); //creating a stream reader to read the results from the API
responseData = MyStream.ReadToEnd(); //reading the result from the API into a string
}
catch
{
}
}
Adduser_WL(5078, fb.fbUser.email, fb.fbUser.first_name + " " + fb.fbUser.last_name);
Page.ClientScript.RegisterStartupScript(GetType(), "closePopup", "window.opener.socialLogin('" + fb.fbUser.id + "','" + fb.fbUser.picture + "','" + fb.fbUser.first_name + "'); window.close();", true);
Session["login"] = "******";
Session["userId"] = loginID;
Session["Logged"] = "Yes";
Session["LoggedUserMail"] = fb.fbUser.email;
Session["LoggedUserPicture"] = "http://graph.facebook.com/" + fb.fbUser.id + "/picture?type=square";
}
Session["showStrap"] = true;
Response.Redirect("./?firsttime=face");
}
else
{
Response.Write("has no fb user");
}
}
}
else
{
Response.Redirect("./");
//fb = new FacebookCode(siteDefaults.FbClientId, siteDefaults.FbClientSecret);
//fb.LoginClick(fbUrl, "user_hometown,email,user_location");
}
}
