protected void DisplayMenu() { ConnectionClass ConnObj = new ConnectionClass(); SqlCommand cmd1 = new SqlCommand("sp_select_brand_userpanelpermission"); cmd1.Parameters.AddWithValue("@user_id", SessionState._BrandAdmin.user_id); ConnObj.GetDataTab(cmd1); //CheckIfActivitiesWaitingVerification(); PrintChildItems(ConnObj.DataTab); ConnObj.ReleaseConnection(); }
private string getAccessToken(Int64 page_id) { string token=""; if (page_tokens.ContainsKey(page_id)) token = page_tokens[page_id]; else { // get user access token SqlCommand cmd = new SqlCommand("sp_Get_brands_sm_token_by_page_id"); cmd.Parameters.AddWithValue("@page_id", page_id); ConnectionClass ConnObj1 = new ConnectionClass(); ConnObj1.GetDataSet(cmd); if (ConnObj1.IsSuccess && ConnObj1.DataSet.Tables.Count > 0 && ConnObj1.DataSet.Tables[0].Rows.Count > 0) { page_tokens.Add(page_id, Convert.ToString(ConnObj1.DataSet.Tables[0].Rows[0]["token"])); page_verifier.Add(page_id, Convert.ToString(ConnObj1.DataSet.Tables[0].Rows[0]["verifier"])); token = page_tokens[page_id]; } ConnObj1.ReleaseConnection(); } return token; }
public void checkIfUserHasAddedAnyPost(string accessToken, List<fbuser> user, string hashtag, string defaulttext, String last_cron_run, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { fbuser t = user[0]; HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://api.instagram.com/v1/users/" + t.sm_uid + "/media/recent/?access_token=" + accessToken_1); request.Method = "GET"; request.ContentType = "application/x-www-form-urlencoded"; WebResponse response = request.GetResponse(); string responseData = new StreamReader(response.GetResponseStream()).ReadToEnd(); var tmpResult = JObject.Parse(responseData); var resultObject = tmpResult["data"].Values<JObject>() .Where(n => n["caption"].Count() > 0) .Where(n => n["caption"]["text"].Value<string>().Contains("@ichooseit")) .Select(n => new { img = n["images"]["thumbnail"]["url"], link = n["link"], text = n["caption"]["text"], mediaID = n["id"], created_time = n["created_time"], likes = n["likes"]["count"], Context = n.Parent }).ToArray(); //Loop through the returned users foreach (var i in resultObject) { Int32 brand_id1; Int64 campaign_id1; Int64 action_id1; string message = Convert.ToString( i.text ).ToLower(); hashtag = hashtag.Replace("@" + System.Configuration.ConfigurationManager.AppSettings["InstaIchooseItHashtag"], "").ToLower(); string[] hashtag_arr = hashtag.Split(' '); bool valid = true; foreach (string hash in hashtag_arr) { if (!message.Contains(hash.Trim())) { valid = false; break; } } if (valid == false) { //continue; } // case : default text defined for campaign if (defaulttext != "") { if (!message.Contains(defaulttext)) { valid = false; //continue; } } ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); // case : valid if (valid == true) { #region for brand post brand_id1 = brand_id; campaign_id1 = campaign_id; action_id1 = action_id; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", ConvertFromUnixTimestamp(Convert.ToDouble(i.created_time))); cmd.Parameters.AddWithValue("@pid", Convert.ToString(i.mediaID)); decimal points = 0; no_of_friends = 0; no_of_likes = 0; // reward table details if (reward_per_user > 0) { points += reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_on_likes > 0) { if ( Convert.ToInt32( i.likes ) > 0 ) { no_of_likes = Convert.ToInt32( i.likes ); } points += (no_of_likes * reward_on_likes); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); #endregion } else { brand_id1 = 2; campaign_id1 = 8; action_id1 = 27; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(ConvertFromUnixTimestamp(Convert.ToDouble(i.created_time))));// cmd.Parameters.AddWithValue("@pid", Convert.ToString( i.mediaID )); cmd.Parameters.AddWithValue("@reward_amount", 0); cmd.Parameters.AddWithValue("@reward_percent", 0); cmd.Parameters.AddWithValue("@reward_product", ""); cmd.Parameters.AddWithValue("@no_of_friends", 0); cmd.Parameters.AddWithValue("@no_of_likes", 0); cmd.Parameters.AddWithValue("@no_of_shares", 0); cmd.Parameters.AddWithValue("@reward_per_user", 0); cmd.Parameters.AddWithValue("@reward_on_friend", 0); cmd.Parameters.AddWithValue("@reward_on_likes", 0); cmd.Parameters.AddWithValue("@reward_on_shares", 0); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); } string id = cmd.Parameters["@returnid"].Value.ToString(); if (id == "") { continue; } Int64 activity_id = Convert.ToInt64(id); // insert facebook post cmd = new SqlCommand("sp1_IChooseIT_User_Insta_Activities_Insert"); cmd.Parameters.AddWithValue("@activity_id", activity_id); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", ConvertFromUnixTimestamp(Convert.ToDouble( i.created_time)) ); cmd.Parameters.AddWithValue("@updated_time", ConvertFromUnixTimestamp(Convert.ToDouble(i.created_time))); cmd.Parameters.AddWithValue("@sm_img_link", Convert.ToString(i.img)); cmd.Parameters.AddWithValue("@link", Convert.ToString(i.link)); cmd.Parameters.AddWithValue("@sm_desc", Convert.ToString(i.text)); cmd.Parameters.AddWithValue("@fb_post_id", Convert.ToString(i.mediaID)); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void checkIfUserLikesAPage(string accessToken, List<fbuser> user, string page_id, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { // database will have the list of pages that a user likes already // we only need to cross check with the database fbuser t = user[0]; // get the list of user who like the given page ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp_IChooseIT_Get_Users_WhoLikeAPage"); cmd.Parameters.AddWithValue("@page_id", page_id); cmd.Parameters.AddWithValue("@sm_id", 3); ConnObj.GetDataSet(cmd); decimal points = 0; if (ConnObj.IsSuccess && ConnObj.DataSet.Tables.Count > 0 && ConnObj.DataSet.Tables[0].Rows.Count > 0) { ConnectionClass ConnObj2 = new ConnectionClass(); foreach (DataRow dr in ConnObj.DataSet.Tables[0].Rows) { if (Convert.ToInt64(dr["reg_uid"]) != t.reg_uid) continue; SqlCommand cmd1 = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd1.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd1.Parameters.AddWithValue("@brand_id", brand_id); cmd1.Parameters.AddWithValue("@campaign_id", campaign_id); cmd1.Parameters.AddWithValue("@action_id", action_id); cmd1.Parameters.AddWithValue("@created_on", DateTime.Now.ToString()); cmd1.Parameters.AddWithValue("@pid", ""); // reward table details if (reward_per_user > 0) { points = reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (reward_on_friend * no_of_friends); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd1.Parameters.AddWithValue("@reward_amount", reward_amount); cmd1.Parameters.AddWithValue("@reward_percent", reward_percent); cmd1.Parameters.AddWithValue("@reward_product", reward_product); cmd1.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd1.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd1.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd1.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd1.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd1.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd1.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd1.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj2.GetDataTab(cmd1); } ConnObj2.ReleaseConnection(); ConnObj.ReleaseConnection(); } }
public void getUserTaggedPlaces(string accessToken, Int64 reg_uid) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/tagged_places"); String insert_stmt = ""; String insert_stmt_comma = ""; string uid = Convert.ToString(reg_uid); string location; string place_name; DateTime created_time; string data_id; string place_id; //Loop through the returned locations foreach (var i in posts["data"]) { created_time = Convert.ToDateTime(i["created_time"]); data_id = i["id"]; location = System.Web.HttpUtility.HtmlEncode(i["place"]["location"]); place_id = System.Web.HttpUtility.HtmlEncode(i["place"]["id"]); place_name = System.Web.HttpUtility.HtmlEncode(i["place"]["name"]); insert_stmt += insert_stmt_comma + "(" + uid + ", '" + data_id + "', '" + place_id + "','" + location + "', '" + place_name + "', '" + created_time.ToString() + "' )"; insert_stmt_comma = ","; } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_FB_Locations_Insert"); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void getUserPageLikes(string accessToken, Int64 reg_uid) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/likes"); String insert_stmt = ""; String insert_stmt_comma = ""; string uid = Convert.ToString( reg_uid ); string category; string page_name; DateTime created_time; string page_id; //Loop through the returned friends foreach (var i in posts["data"]) { category = System.Web.HttpUtility.HtmlEncode(i["category"]); page_name = System.Web.HttpUtility.HtmlEncode(i["name"]); created_time = Convert.ToDateTime( i["created_time"] ); page_id = i["id"]; insert_stmt += insert_stmt_comma + "(" + uid + ",'" + category + "', '" + page_name + "', '" + created_time.ToString() + "','" + page_id + "' )"; insert_stmt_comma = ","; } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_brandyy_User_FB_Likes_Insert"); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void getUserFriends(string accessToken, Int64 reg_uid) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/friends"); String insert_stmt = ""; String insert_stmt_comma = ""; string uid = Convert.ToString(reg_uid); string data_id; string sm_id; sm_id="1"; //Loop through the returned locations foreach (var i in posts["data"]) { data_id = i["id"]; insert_stmt += insert_stmt_comma + "(" + sm_id + ", " + uid + ", '" + data_id + "' )"; insert_stmt_comma = ","; } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_Insert_IChooseIT_UseR_SM_Friends"); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); cmd.Parameters.AddWithValue("@sm_id", sm_id); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void getAllProfileDetails(string accessToken) { var client = new FacebookClient(accessToken); //http://blog.prabir.me/posts/facebook-csharp-sdk-making-requests dynamic posts = (IDictionary<string, object>)client.Get("/me"); String insert_stmt = ""; String insert_stmt_comma = ""; //string reg_uid = Convert.ToString( SessionState._SignInUser.reg_uid ); string reg_uid = "1"; int verified_status=0; foreach (KeyValuePair<string, object> admObj in posts) { var id = Convert.ToString(admObj.Key); var value = Convert.ToString(admObj.Value); insert_stmt += insert_stmt_comma + "(1," + reg_uid + ",'" + id + "', '" + value + "', '/me' )"; insert_stmt_comma = ","; if (id == "verified") { verified_status = (value == "True") ? 1 : 0; } } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_Insert_IChooseIT_User_SM_All_Details"); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@sm_id", 1); ConnObj.GetDataTab(cmd); cmd = new SqlCommand("sp1_Update_IChooseIT_Registrations_FB_Verify"); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); cmd.Parameters.AddWithValue("@verified_status", verified_status); cmd.Parameters.AddWithValue("@sm_id", 1); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void checkIfUserHasAddedAnyPost(string accessToken, List<fbuser> user, string hashtag, string defaulttext, String last_cron_run, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { var client = new FacebookClient(accessToken); dynamic posts; if ((last_cron_run == "")) { posts = client.Get("/cooseit/tagged"); } else { posts = client.Get("/cooseit/tagged?since=" + last_cron_run); } fbuser t = user[0]; //Loop through the returned users foreach (var i in posts["data"]) { Int32 brand_id1; Int64 campaign_id1; Int64 action_id1; string message = i["message"]; hashtag = hashtag.Replace("@ichoose", ""); string[] hashtag_arr = hashtag.Split(' '); bool valid = true; foreach (string hash in hashtag_arr) { if (!message.Contains(hash.Trim())) { valid = false; break; } } if (valid == false) { //continue; } // case : default text defined for campaign if (defaulttext != "") { if (!message.Contains(defaulttext)) { valid = false; //continue; } } // check if the post link contains the post id if (t.sm_uid == i["from"].id) { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); // case : valid if (valid == true) { brand_id1 = brand_id; campaign_id1 = campaign_id; action_id1 = action_id; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i["created_time"])); cmd.Parameters.AddWithValue("@pid", i["id"]); decimal points = 0; no_of_friends = 0; no_of_likes = 0; // reward table details if (reward_per_user > 0) { points += reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_on_likes > 0) { if (i.ContainsKey("likes")) { no_of_likes = i["likes"].data.Count; } points += (no_of_likes * reward_on_likes); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); } else { brand_id1 = 2; campaign_id1 = 8; action_id1 = 16; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i["created_time"])); cmd.Parameters.AddWithValue("@pid", i["id"]); cmd.Parameters.AddWithValue("@reward_amount", 0); cmd.Parameters.AddWithValue("@reward_percent", 0); cmd.Parameters.AddWithValue("@reward_product", ""); cmd.Parameters.AddWithValue("@no_of_friends", 0); cmd.Parameters.AddWithValue("@no_of_likes", 0); cmd.Parameters.AddWithValue("@no_of_shares", 0); cmd.Parameters.AddWithValue("@reward_per_user", 0); cmd.Parameters.AddWithValue("@reward_on_friend", 0); cmd.Parameters.AddWithValue("@reward_on_likes", 0); cmd.Parameters.AddWithValue("@reward_on_shares", 0); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); } string id = cmd.Parameters["@returnid"].Value.ToString(); if (id == "") { continue; } Int64 activity_id = Convert.ToInt64(id); // insert facebook post cmd = new SqlCommand("sp1_IChooseIT_User_FB_Activities_Insert"); cmd.Parameters.AddWithValue("@activity_id", activity_id); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i["created_time"])); cmd.Parameters.AddWithValue("@updated_time", Convert.ToDateTime(i["updated_time"])); if (i.ContainsKey("picture")) { cmd.Parameters.AddWithValue("@sm_img_link", i["picture"]); } else { cmd.Parameters.AddWithValue("@sm_img_link", ""); } if (i.ContainsKey("link")) { cmd.Parameters.AddWithValue("@link", i["link"]); } else { if (i.ContainsKey("actions")) { cmd.Parameters.AddWithValue("@link", Convert.ToString(i["actions"][0]["link"])); } else { cmd.Parameters.AddWithValue("@link", ""); } } cmd.Parameters.AddWithValue("@sm_desc", i["message"]); cmd.Parameters.AddWithValue("@fb_post_id", i["id"]); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } } }
public void checkIfUserSharedAPost(string accessToken, List<fbuser> user, string post_id, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/links/"); fbuser u = user[0]; //Loop through the returned link decimal points = 0; string post1 = post_id; if (post_id.Split('_').Length > 1) { post1 = post_id.Split('_')[1]; } string json = Newtonsoft.Json.JsonConvert.SerializeObject(posts); JObject tmpResult = JObject.Parse(json); var i = tmpResult["data"].Values<JObject>() .Where(n => n["link"].Value<string>().Contains(post1)) .Select(n => new { link = n["created_time"] }).ToArray(); // check if the post link contains the post id if (i.Count() > 0 ) { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd.Parameters.AddWithValue("@reg_uid", u.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i[0].link)); cmd.Parameters.AddWithValue("@pid", ""); // reward table details if (reward_per_user > 0) { points = reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = u.no_of_friends; points += (reward_on_friend * no_of_friends); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void checkIfUserHasAddedAnyPost(string accessToken, List<fbuser> user, string hashtag, string defaulttext, String last_cron_run, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { hashtag = hashtag.Replace("@" + System.Configuration.ConfigurationManager.AppSettings["TwitterIchooseItHashtag"], ""); string[] hashtag_arr = hashtag.Split(' '); hashtag = ""; foreach (string hash in hashtag_arr) { string hash1 = hash.Replace('#', ' ').Trim(); if (hash1 != "") { hashtag += "%23" + hash1; } } // //string str = "@ichooseit256%20from:" + SessionState._SignInUser.reg_email + "&result_type=mixed"; string str = "@ichooseit256" + hashtag + "&result_type=mixed"; string url = "https://api.twitter.com/1.1/search/tweets.json?q=" + str; string posts = Search(url, str); fbuser t = user[0]; try { var jsonDat = (JObject.Parse(posts)); foreach (var key in jsonDat) { if (key.Key.Equals("statuses")) { for (int x = 0; x < key.Value.Count(); x++) { // case : default text defined for campaign if (defaulttext != "") { // check if tweet contains the default text if (!Convert.ToString(key.Value[x]["text"]).Contains(defaulttext)) { continue; } } // check if the post link contains the post id if (t.sm_uid == Convert.ToString(key.Value[x]["user"]["id"])) { #region save to sp1_IChooseIT_User_Activities_Insert ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); string temp = Convert.ToString(key.Value[x]["created_at"]); cmd.Parameters.AddWithValue("@created_on", ParseDateTime(Convert.ToString(key.Value[x]["created_at"]))); cmd.Parameters.AddWithValue("@pid", Convert.ToString(key.Value[x]["id"])); decimal points = 0; no_of_friends = 0; no_of_likes = 0; no_of_shares = 0; // reward table details if (reward_per_user > 0) { points = reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_on_likes > 0) { if (Convert.ToInt32(key.Value[x]["favorite_count"]) != 0) { no_of_likes = Convert.ToInt32(key.Value[x]["favorite_count"]); } points += (no_of_likes * reward_on_likes); } if (reward_on_shares > 0) { if (Convert.ToInt32(key.Value[x]["retweeted"]) != 0) { no_of_shares = Convert.ToInt32(key.Value[x]["retweeted"]); } points += (no_of_shares * reward_on_shares); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); string id = cmd.Parameters["@returnid"].Value.ToString(); if (id == "") { continue; } Int64 activity_id = Convert.ToInt64(id); #endregion #region save to IChooseIT_User_Activities_Tw_Post // insert twitter post cmd = new SqlCommand("sp1_IChooseIT_User_Tw_Activities_Insert"); cmd.Parameters.AddWithValue("@activity_id", activity_id); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", ParseDateTime(Convert.ToString(key.Value[x]["created_at"]))); cmd.Parameters.AddWithValue("@updated_time", ParseDateTime(Convert.ToString(key.Value[x]["created_at"]))); if (Convert.ToString(key.Value[x]["entities"]["media"]) != "") { cmd.Parameters.AddWithValue("@sm_img_link", Convert.ToString(key.Value[x]["entities"]["media"][0]["media_url"])); } else { cmd.Parameters.AddWithValue("@sm_img_link", ""); } cmd.Parameters.AddWithValue("@sm_desc", Convert.ToString(key.Value[x]["text"])); string link = "https://twitter.com/" + Convert.ToString(key.Value[x]["user"]["screen_name"]) + "/status/" + Convert.ToString(key.Value[x]["id"]); cmd.Parameters.AddWithValue("@link", link); cmd.Parameters.AddWithValue("@fb_post_id", Convert.ToString(key.Value[x]["id"])); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); #endregion } } } } } catch (Exception ex) { } }
private void CheckIfActivitiesWaitingVerification() { Int32 b_id = SessionState._BrandAdmin.brand_id; SqlCommand cmd = new SqlCommand("sp_brandyy_GetAllPendingActivitiesOverview"); cmd.Parameters.AddWithValue("@brand_id", SessionState._BrandAdmin.brand_id); cmd.Parameters.AddWithValue("@verification_status", 0); ConnectionClass ConnObj1 = new ConnectionClass(); ConnObj1.GetDataSet(cmd); if (ConnObj1.IsSuccess && ConnObj1.DataSet.Tables.Count > 0 && ConnObj1.DataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ConnObj1.DataSet.Tables[0].Rows) { if (Convert.ToInt64(dr["num_of_pending_activities"]) > 0) { display_verification = true; break; } } } ConnObj1.ReleaseConnection(); }