public static FBLoginDetails ActivateUser(FBLoginDetails _FBLoginDetails) { if ((SessionState._BrandAdmin != null)) { // get user long lived access token and other profile details importfbbranddetails t = new importfbbranddetails(); string longlivedtoken = t.getUserLongLivedAccessToken(_FBLoginDetails.AccessToken, SessionState._BrandAdmin.user_id); SqlCommand cmd = new SqlCommand("sp_insert_brands_social_media"); cmd.Parameters.AddWithValue("@brand_id", SessionState._BrandAdmin.brand_id); cmd.Parameters.AddWithValue("@sm_name", _FBLoginDetails.Name); cmd.Parameters.AddWithValue("@sm_email", _FBLoginDetails.Email); cmd.Parameters.AddWithValue("@sm_id", 1); cmd.Parameters.AddWithValue("@sm_uid", _FBLoginDetails.ID); cmd.Parameters.AddWithValue("@profile_url", _FBLoginDetails.ProfileUrl); cmd.Parameters.AddWithValue("@profile_img_link", _FBLoginDetails.ProfileImageUrl); cmd.Parameters.AddWithValue("@token", longlivedtoken); cmd.Parameters.AddWithValue("@created_by", SessionState._BrandAdmin.user_id); cmd.Parameters.AddWithValue("@sm_desc", "Facebook"); ConnObj.GetDataTab(cmd); if (ConnObj.IsSuccess == true & ConnObj.DataTab != null & ConnObj.DataTab.Rows.Count > 0) { if (Convert.ToInt64(ConnObj.DataTab.Rows[0]["brand_sm_id"]) == 0) { _FBLoginDetails.Message = "Invalid details"; _FBLoginDetails.LoginSuccessRedirectHomePage = SessionState.WebsiteURLBrand + "socialmedias.aspx"; } else { _FBLoginDetails.Message = "Success"; SessionState.EditId_2 = 1; SessionState.ActivityID = Convert.ToInt64(ConnObj.DataTab.Rows[0]["brand_sm_id"]); _FBLoginDetails.LoginSuccessRedirectHomePage = SessionState.WebsiteURLBrand + "socialmediapage-create.aspx"; } //ScriptManager.RegisterStartupScript(Page, typeof(Page), "Alert2", "closeAndRefresh();", true); //ScriptManager.RegisterStartupScript(this, GetType(), "closeAndRefresh", "closeAndRefresh();", true); //Page.ClientScript.RegisterStartupScript(this.GetType(), "val", "closeAndRefresh();",true); } } else { _FBLoginDetails.Message = "Your Login session has expired"; _FBLoginDetails.LoginSuccessRedirectHomePage = SessionState.WebsiteURLBrand; } return _FBLoginDetails; ; }
private void GetActiveCampaigns() { SqlCommand cmd = new SqlCommand("sp_select_brands_campaigns_by_status"); cmd.Parameters.AddWithValue("@status", _CommonVariableCodes.campaign_status_active); ConnObj.GetDataSet(cmd); if (ConnObj.IsSuccess == true && ConnObj.DataSet.Tables.Count > 0 && ConnObj.DataSet.Tables[0].Rows.Count > 0) { getAllUsers(); importfbbranddetails obj = new importfbbranddetails(); importtwitterbranddetails obj_tw = new importtwitterbranddetails(); importinstabranddetails obj_insta = new importinstabranddetails(); DataTable _DataTable = ConnObj.DataSet.Tables[0]; foreach (DataRow tbl in _DataTable.Rows) { cmd = new SqlCommand("sp_select_brands_campaigns_action"); cmd.Parameters.AddWithValue("@campaign_id", tbl["campaign_id"]); ConnObj.GetDataSet(cmd); if (ConnObj.IsSuccess == true && ConnObj.DataSet.Tables.Count > 0 && ConnObj.DataSet.Tables[0].Rows.Count > 0) { DataTable _DataTable_Action = ConnObj.DataSet.Tables[0]; foreach (DataRow tbl2 in _DataTable_Action.Rows) { #region reward setup Int32 no_of_friends = 0; Int32 no_of_likes = 0; Int32 no_of_shares = 0; decimal reward_per_user = 0; decimal reward_on_friend = 0; decimal reward_on_likes = 0; decimal reward_on_shares = 0; decimal max_brandyy_points = 0; max_brandyy_points = Convert.ToDecimal(tbl["max_brandyy_points"]); reward_per_user = Convert.ToDecimal(tbl2["reward_user"]); reward_on_friend = Convert.ToDecimal(tbl2["reward_per_friend"]); reward_on_likes = Convert.ToDecimal(tbl2["reward_per_like"]); reward_on_shares = Convert.ToDecimal(tbl2["reward_per_share"]); #endregion switch (Convert.ToByte( tbl2["campaign_type"] )) { case 1: obj.checkIfUserLikesAPage(getAccessToken(Convert.ToInt64(tbl2["val_1"])), fbsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 2: obj_tw.checkIfUserLikesAPage(getAccessToken(Convert.ToInt64(tbl2["val_1"])), twsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 3: obj_tw.checkIfUserSharedAPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), twsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 4: obj_tw.checkIfUserLikedAPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), twsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 5: obj.checkIfUserSharedAPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), fbsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 6: obj.checkIfUserLikesAPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), fbsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 8: obj.checkIfUserCheckedIn(getAccessToken(Convert.ToInt64(tbl2["val_1"])), fbsm_id, Convert.ToString(tbl2["val_3"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 9: obj_tw.checkIfUserHasAddedAnyPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), getAccessVerifier(Convert.ToInt64(tbl2["val_1"])),twsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToString(tbl2["val_3"]), Convert.ToString(tbl2["val_4"]), Convert.ToString(tbl["campaign_start"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 10: obj.checkIfUserHasAddedAnyPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), fbsm_id, Convert.ToString(tbl2["val_2"]), Convert.ToString(tbl2["val_3"]), Convert.ToString(tbl2["val_4"]), Convert.ToString(tbl["campaign_start"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 17: obj_insta.checkIfUserLikesAPage(getAccessToken(Convert.ToInt64(tbl2["val_1"])), instasm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 18: obj_insta.checkIfUserLikedAPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), instasm_id, Convert.ToString(tbl2["val_2"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; case 19: obj_insta.checkIfUserHasAddedAnyPost(getAccessToken(Convert.ToInt64(tbl2["val_1"])), instasm_id, Convert.ToString(tbl2["val_1"]) + Convert.ToString(tbl2["val_2"]), Convert.ToString(tbl2["val_3"]), Convert.ToString(tbl2["val_4"]), Convert.ToString(tbl["campaign_start"]), Convert.ToInt32(tbl2["brand_id"]), Convert.ToInt64(tbl2["campaign_id"]), Convert.ToInt64(tbl2["action_id"]), max_brandyy_points, no_of_friends, no_of_likes, no_of_shares, reward_per_user, reward_on_friend, reward_on_likes, reward_on_shares); break; } } } // Update camapign status if end of date approched if (Convert.ToByte(tbl["schedule_type"]) == _CommonVariableCodes.schedule_type_periodic) { if (DateTime.Now > Convert.ToDateTime( tbl["campaign_end"] )) { UpdateCampaignStatus( Convert.ToInt64( tbl["campaign_id"])); } } } } //Response.Redirect( SessionState.WebsiteURL + "syncactivitiesverification.aspx"); }