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