コード例 #1
0
        public IHttpActionResult GetGroupGoogleAnalytics(string GroupId, string UserId)
        {
            Guid grpId = Guid.Empty;

            try
            {
                grpId = Guid.Parse(GroupId);
            }
            catch (Exception ex)
            {
                logger.Error(ex.Message);
                logger.Error(ex.StackTrace);
                return(BadRequest("Invalid GroupId"));
            }
            List <Domain.Socioboard.Domain.GroupProfile>           lstGroupProfiles          = grpProfilesRepo.GetAllGroupProfilesByProfileType(grpId, "googleanalytics");
            List <Domain.Socioboard.Domain.GoogleAnalyticsAccount> lstGoogleAnalyticsAccount = new List <Domain.Socioboard.Domain.GoogleAnalyticsAccount>();
            GoogleAnalyticsAccountRepository _GoogleAnalyticsAccountRepository = new GoogleAnalyticsAccountRepository();

            foreach (var profile in lstGroupProfiles)
            {
                try
                {
                    Domain.Socioboard.Domain.GoogleAnalyticsAccount _GoogleAnalyticsAccount = _GoogleAnalyticsAccountRepository.getGoogleAnalyticsAccountDetailsById(profile.ProfileId, Guid.Parse(UserId));
                    lstGoogleAnalyticsAccount.Add(_GoogleAnalyticsAccount);
                }
                catch (Exception ex)
                {
                    logger.Error(ex.Message);
                    logger.Error(ex.StackTrace);
                }
            }
            return(Ok(lstGoogleAnalyticsAccount));
        }
コード例 #2
0
        public DataTable getDayWiseAnalyticsApi(string profileId, Guid user)
        {
            DataTable dtAnalytics = new DataTable();

            try
            {
                Analytics    objAlyt = new Analytics();
                oAuthTokenGa obj     = new oAuthTokenGa();
                GoogleAnalyticsAccountRepository objGaAccRepo   = new GoogleAnalyticsAccountRepository();
                GoogleAnalyticsStats             objGaStats     = new GoogleAnalyticsStats();
                GoogleAnalyticsStatsRepository   objGaStatsRepo = new GoogleAnalyticsStatsRepository();
                GoogleAnalyticsAccount           objGaAcc       = objGaAccRepo.getGoogelAnalyticsAccountDetailsById(profileId, user);
                string strRefresh = obj.GetAccessToken(objGaAcc.RefreshToken);
                if (!strRefresh.StartsWith("["))
                {
                    strRefresh = "[" + strRefresh + "]";
                }
                JArray objArray = JArray.Parse(strRefresh);
                foreach (var itemRefresh in objArray)
                {
                    objGaAcc.AccessToken = itemRefresh["access_token"].ToString();
                }
                XmlDocument xDoc    = new XmlDocument();
                DateTime    startdt = DateTime.Now.AddMonths(-3);
                DateTime    enddt   = DateTime.Now;
                xDoc.LoadXml(objAlyt.getAnalyticsData(objGaAcc.GaProfileId, "metrics=ga:visits&dimensions=ga:day", startdt.ToShortDateString().Replace("/", "-"), "2013-07-25", objGaAcc.AccessToken));
                dtAnalytics = getdatafromXml(xDoc);
                for (int i = 0; i < dtAnalytics.Rows.Count; i++)
                {
                    objGaStats.EntryDate   = DateTime.Now;
                    objGaStats.GaAccountId = objGaAcc.GaAccountId;
                    if (dtAnalytics.Rows[i]["title"].ToString().Contains("ga:day"))
                    {
                        objGaStats.gaDate = dtAnalytics.Rows[i]["title"].ToString().Substring(8);
                    }
                    objGaStats.gaVisits    = dtAnalytics.Rows[i]["ga:visitors"].ToString();
                    objGaStats.Id          = Guid.NewGuid();
                    objGaStats.UserId      = user;
                    objGaStats.GaProfileId = objGaAcc.GaProfileId;
                    if (!objGaStatsRepo.checkGoogleAnalyticsDateStatsExists(objGaAcc.GaProfileId, "day", dtAnalytics.Rows[i]["title"].ToString(), user))
                    {
                        objGaStatsRepo.addGoogleAnalyticsStats(objGaStats);
                    }
                    else
                    {
                        objGaStatsRepo.updateGoogleAnalyticsStats(objGaStats);
                    }
                }
            }
            catch (Exception Err)
            {
                Console.Write(Err.StackTrace);
            }
            return(dtAnalytics);
        }
コード例 #3
0
        public DataTable getRegionWiseAnalyticsApi(string profileId)
        {
            DataTable dtAnalytics = new DataTable();

            try
            {
                User         user    = (User)HttpContext.Current.Session["LoggedUser"];
                Analytics    objAlyt = new Analytics();
                oAuthTokenGa obj     = new oAuthTokenGa();
                GoogleAnalyticsAccountRepository objGaAccRepo   = new GoogleAnalyticsAccountRepository();
                GoogleAnalyticsStats             objGaStats     = new GoogleAnalyticsStats();
                GoogleAnalyticsStatsRepository   objGaStatsRepo = new GoogleAnalyticsStatsRepository();
                GoogleAnalyticsAccount           objGaAcc       = objGaAccRepo.getGoogelAnalyticsAccountDetailsById(profileId, user.Id);
                string strRefresh = obj.GetAccessToken(objGaAcc.RefreshToken);
                if (!strRefresh.StartsWith("["))
                {
                    strRefresh = "[" + strRefresh + "]";
                }
                JArray objArray = JArray.Parse(strRefresh);
                foreach (var itemRefresh in objArray)
                {
                    objGaAcc.AccessToken = itemRefresh["access_token"].ToString();
                }
                XmlDocument xDoc = new XmlDocument();
                xDoc.LoadXml(objAlyt.getAnalyticsData(objGaAcc.GaProfileId, "metrics=ga:visits&dimensions=ga:year", "2013-01-01", "2013-07-15", objGaAcc.AccessToken));
                dtAnalytics = getdatafromXml(xDoc);
                for (int i = 0; i < dtAnalytics.Rows.Count; i++)
                {
                    objGaStats.EntryDate   = DateTime.Now;
                    objGaStats.GaAccountId = objGaAcc.GaAccountId;
                    if (dtAnalytics.Rows[i]["title"].ToString().Contains("ga:year"))
                    {
                        objGaStats.gaYear = dtAnalytics.Rows[i]["title"].ToString().Substring(8);
                    }
                    objGaStats.gaVisits    = dtAnalytics.Rows[i]["ga:visitors"].ToString();
                    objGaStats.Id          = Guid.NewGuid();
                    objGaStats.UserId      = user.Id;
                    objGaStats.GaProfileId = objGaAcc.GaProfileId;
                    if (!objGaStatsRepo.checkGoogleAnalyticsDateStatsExists(objGaAcc.GaProfileId, "year", dtAnalytics.Rows[i]["title"].ToString(), user.Id))
                    {
                        objGaStatsRepo.addGoogleAnalyticsStats(objGaStats);
                    }
                    else
                    {
                        objGaStatsRepo.updateGoogleAnalyticsStats(objGaStats);
                    }
                }
            }
            catch (Exception Err)
            {
                Console.Write(Err.StackTrace);
            }
            return(dtAnalytics);
        }
コード例 #4
0
        public void getProfilesofAccount(string accountid)
        {
            GoogleAnalyticsAccountRepository objGaAccRepo = new GoogleAnalyticsAccountRepository();
            User user = (User)HttpContext.Current.Session["LoggedUser"];
            // if (ddlAccounts.SelectedIndex > -1)
            // {
            ArrayList arrProfile = objGaAccRepo.getGoogelAnalyticsProfilesOfUser(accountid, user.Id);

            foreach (GoogleAnalyticsAccount item in arrProfile)
            {
                ddlProfile.Items.Add(new ListItem(item.GaProfileName, item.GaProfileId));
            }
            // ddlProfile.Items.Insert(0, "--Select--");

            //  }
        }
コード例 #5
0
        public void GetData(object obj)
        {
            GanalyticsHelper objGaHelper = new GanalyticsHelper();
            Guid             user        = Guid.Parse(obj.ToString());

            GoogleAnalyticsAccountRepository gAccRepo = new GoogleAnalyticsAccountRepository();
            ArrayList aslt = gAccRepo.getGoogelAnalyticsAccountsOfUser(user);


            foreach (var item in aslt)
            {
                Array temp = (Array)item;
                objGaHelper.getCountryAnalyticsApi(temp.GetValue(0).ToString(), user);
                objGaHelper.getYearWiseAnalyticsApi(temp.GetValue(0).ToString(), user);
            }
        }
コード例 #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                User user = (User)HttpContext.Current.Session["LoggedUser"];

                // objGaHelper.getAnalytics();
                GoogleAnalyticsStatsRepository   objGaStatsRepo = new GoogleAnalyticsStatsRepository();
                GoogleAnalyticsAccountRepository objGaAccRepo   = new GoogleAnalyticsAccountRepository();
                ArrayList arrAcc = objGaAccRepo.getGoogelAnalyticsAccountsOfUser(user.Id);
                foreach (var item in arrAcc)
                {
                    Array temp = (Array)item;
                    //objGaHelper.getYearWiseAnalyticsApi(item);
                    ddlAccounts.Items.Add(new ListItem(temp.GetValue(1).ToString(), temp.GetValue(0).ToString()));
                }
                getProfilesofAccount(ddlAccounts.SelectedValue);
                getanalytics();
                //ddlAccounts.Items.Insert(0, "--Select--");
            }
        }
コード例 #7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            oAuthTokenGa obj     = new oAuthTokenGa();
            Accounts     objAcc  = new Accounts();
            Analytics    objAlyt = new Analytics();
            User         user    = (User)Session["LoggedUser"];

            if (!IsPostBack)
            {
                if (Session["login"] == null)
                {
                    if (user == null)
                    {
                        Response.Redirect("Default.aspx");
                    }
                }

                try
                {
                    string strRefresh = obj.GetRefreshToken(Request.QueryString["code"].ToString());
                    if (!strRefresh.StartsWith("["))
                    {
                        strRefresh = "[" + strRefresh + "]";
                    }
                    JArray objArray = JArray.Parse(strRefresh);
                    GoogleAnalyticsAccount           objGaAcc     = new GoogleAnalyticsAccount();
                    GoogleAnalyticsAccountRepository objGaAccRepo = new GoogleAnalyticsAccountRepository();
                    GanalyticsHelper         objGaHelper          = new GanalyticsHelper();
                    SocialProfilesRepository socioprofilerepo     = new SocialProfilesRepository();
                    SocialProfile            socioprofile         = new SocialProfile();
                    foreach (var item in objArray)
                    {
                        DataSet dsAccount = objAcc.getGaAccounts(item["access_token"].ToString());
                        objGaAcc.RefreshToken  = item["refresh_token"].ToString();
                        objGaAcc.AccessToken   = item["access_token"].ToString();
                        objGaAcc.EmailId       = dsAccount.Tables["title"].Rows[0]["title_Text"].ToString();
                        objGaAcc.EntryDate     = DateTime.Now;
                        objGaAcc.GaAccountId   = dsAccount.Tables["property"].Rows[0]["value"].ToString();
                        objGaAcc.GaAccountName = dsAccount.Tables["property"].Rows[1]["value"].ToString();
                        objGaAcc.Id            = Guid.NewGuid();
                        objGaAcc.IsActive      = true;
                        objGaAcc.UserId        = user.Id;
                        DataSet dsProfile    = objAcc.getGaProfiles(item["access_token"].ToString(), objGaAcc.GaAccountId);
                        int     profileCount = dsProfile.Tables["property"].Select("name='ga:profileId'").Length;
                        string[,] names = new string[profileCount, 2];


                        int tempCount = 0;
                        foreach (DataRow dRow in dsProfile.Tables["property"].Rows)
                        {
                            //if (dRow["name"].Equals("ga:profileId") || dRow["name"].Equals("ga:profileName"))
                            {
                                if (dRow["name"].Equals("ga:profileId"))
                                {
                                    objGaAcc.GaProfileId = dRow["value"].ToString();
                                    names[tempCount, 0]  = dRow["value"].ToString();
                                }
                                if (dRow["name"].Equals("ga:profileName"))
                                {
                                    names[tempCount, 1]    = dRow["value"].ToString();
                                    objGaAcc.GaProfileName = dRow["value"].ToString();
                                }
                                if (tempCount >= profileCount)
                                {
                                    break;
                                }
                                if (names[tempCount, 0] != null && names[tempCount, 1] != null)
                                {
                                    tempCount++;
                                }
                            }
                        }

                        socioprofile.Id          = Guid.NewGuid();
                        socioprofile.ProfileDate = DateTime.Now;
                        socioprofile.ProfileId   = objGaAcc.GaAccountId;
                        socioprofile.ProfileType = "googleanalytics";
                        socioprofile.UserId      = user.Id;

                        if (!objGaAccRepo.checkGoogelAnalyticsUserExists(objGaAcc.GaAccountId, user.Id))
                        {
                            for (int i = 0; i < profileCount; i++)
                            {
                                objGaAcc.GaProfileId   = names[i, 0];
                                objGaAcc.GaProfileName = names[i, 1];
                                if (!objGaAccRepo.checkGoogelAnalyticsProfileExists(objGaAcc.GaAccountId, objGaAcc.GaProfileId, user.Id))
                                {
                                    objGaAccRepo.addGoogleAnalyticsUser(objGaAcc);
                                }
                                else
                                {
                                    objGaAccRepo.updateGoogelAnalyticsUser(objGaAcc);
                                }


                                objGaHelper.getCountryAnalyticsApi(objGaAcc.GaProfileId, user.Id);
                                objGaHelper.getYearWiseAnalyticsApi(objGaAcc.GaProfileId, user.Id);
                                objGaHelper.getMonthWiseAnalyticsApi(objGaAcc.GaProfileId, user.Id);
                                objGaHelper.getDayWiseAnalyticsApi(objGaAcc.GaProfileId, user.Id);
                            }

                            if (!socioprofilerepo.checkUserProfileExist(socioprofile))
                            {
                                socioprofilerepo.addNewProfileForUser(socioprofile);
                            }
                            else
                            {
                                socioprofilerepo.updateSocialProfile(socioprofile);
                            }
                        }
                        else
                        {
                            //objGaAccRepo.updateGoogelAnalyticsUser(objGaAcc);
                            for (int i = 0; i < names.Length; i++)
                            {
                                objGaAcc.GaProfileId   = names[i, 0];
                                objGaAcc.GaProfileName = names[i, 1];
                                if (!objGaAccRepo.checkGoogelAnalyticsProfileExists(objGaAcc.GaAccountId, objGaAcc.GaProfileId, user.Id))
                                {
                                    objGaAccRepo.addGoogleAnalyticsUser(objGaAcc);
                                }
                                else
                                {
                                    objGaAccRepo.updateGoogelAnalyticsUser(objGaAcc);
                                }
                            }
                            if (!socioprofilerepo.checkUserProfileExist(socioprofile))
                            {
                                socioprofilerepo.addNewProfileForUser(socioprofile);
                            }
                            else
                            {
                                socioprofilerepo.updateSocialProfile(socioprofile);
                            }
                        }
                        Response.Redirect("Home.aspx");
                    }
                }
                catch (Exception Err)
                {
                    logger.Error(Err.StackTrace);
                    try
                    {
                        Response.Redirect("/Home.aspx");
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.StackTrace);
                    }
                }
            }
        }
コード例 #8
0
        public string DeleteAllUsersByCreateDate(string date)
        {
            int                                i                                     = 0;
            int                                count                                 = 0;
            UserRepository                     objUserRepository                     = new UserRepository();
            List <User>                        lstuser                               = objUserRepository.GetAllUsersByCreateDate(date);
            ArchiveMessageRepository           objArchiveMessageRepository           = new ArchiveMessageRepository();
            DiscoverySearchRepository          objDiscoverySearchRepository          = new DiscoverySearchRepository();
            DraftsRepository                   objDraftsRepository                   = new DraftsRepository();
            FacebookAccountRepository          objFacebookAccountRepository          = new FacebookAccountRepository();
            FacebookFeedRepository             objFacebookFeedRepository             = new FacebookFeedRepository();
            FacebookInsightPostStatsRepository objFacebookInsightPostStatsRepository = new FacebookInsightPostStatsRepository();
            FacebookInsightStatsRepository     objFacebookInsightStatsRepository     = new FacebookInsightStatsRepository();
            FacebookMessageRepository          objFacebookMessageRepository          = new FacebookMessageRepository();
            FacebookStatsRepository            objFacebookStatsRepository            = new FacebookStatsRepository();
            GoogleAnalyticsAccountRepository   objGoogleAnalyticsAccountRepository   = new GoogleAnalyticsAccountRepository();
            GoogleAnalyticsStatsRepository     objGoogleAnalyticsStatsRepository     = new GoogleAnalyticsStatsRepository();
            GooglePlusAccountRepository        objGooglePlusAccountRepository        = new GooglePlusAccountRepository();
            GooglePlusActivitiesRepository     objGooglePlusActivitiesRepository     = new GooglePlusActivitiesRepository();
            GroupProfileRepository             objGroupProfileRepository             = new GroupProfileRepository();
            GroupRepository                    objGroupRepository                    = new GroupRepository();
            InstagramAccountRepository         objInstagramAccountRepository         = new InstagramAccountRepository();
            InstagramCommentRepository         objInstagramCommentRepository         = new InstagramCommentRepository();
            InstagramFeedRepository            objInstagramFeedRepository            = new InstagramFeedRepository();
            LinkedInAccountRepository          objLinkedInAccountRepository          = new LinkedInAccountRepository();
            LinkedInFeedRepository             objLinkedInFeedRepository             = new LinkedInFeedRepository();
            LogRepository                      objLogRepository                      = new LogRepository();
            RssFeedsRepository                 objRssFeedsRepository                 = new RssFeedsRepository();
            RssReaderRepository                objRssReaderRepository                = new RssReaderRepository();
            ScheduledMessageRepository         objScheduledMessageRepository         = new ScheduledMessageRepository();
            SocialProfilesRepository           objSocialProfilesRepository           = new SocialProfilesRepository();
            TaskCommentRepository              objTaskCommentRepository              = new TaskCommentRepository();
            TaskRepository                     objTaskRepository                     = new TaskRepository();
            TeamRepository                     objTeamRepository                     = new TeamRepository();
            TeamMemberProfileRepository        objTeamMemberProfileRepository        = new TeamMemberProfileRepository();
            TwitterAccountRepository           objTwitterAccountRepository           = new TwitterAccountRepository();
            TwitterDirectMessageRepository     objTwitterDirectMessageRepository     = new TwitterDirectMessageRepository();
            TwitterFeedRepository              objTwitterFeedRepository              = new TwitterFeedRepository();
            TwitterMessageRepository           objTwitterMessageRepository           = new TwitterMessageRepository();
            TwitterStatsRepository             objTwitterStatsRepository             = new TwitterStatsRepository();
            UserActivationRepository           objUserActivationRepository           = new UserActivationRepository();
            UserPackageRelationRepository      objUserPackageRelationRepository      = new UserPackageRelationRepository();



            count = lstuser.Count();


            foreach (var item in lstuser)
            {
                i++;
                try
                {
                    if (item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**")
                    {
                    }
                    else
                    {
                        objArchiveMessageRepository.DeleteArchiveMessageByUserid(item.Id);
                        objDiscoverySearchRepository.DeleteDiscoverySearchByUserid(item.Id);
                        objDraftsRepository.DeleteDraftsByUserid(item.Id);
                        objFacebookAccountRepository.DeleteFacebookAccountByUserid(item.Id);
                        objFacebookFeedRepository.DeleteFacebookFeedByUserid(item.Id);
                        objFacebookInsightPostStatsRepository.DeleteFacebookInsightPostStatsByUserid(item.Id);
                        objFacebookInsightStatsRepository.DeleteFacebookInsightStatsByUserid(item.Id);
                        objFacebookMessageRepository.DeleteFacebookMessageByUserid(item.Id);
                        objFacebookStatsRepository.DeleteFacebookStatsByUserid(item.Id);
                        objGoogleAnalyticsAccountRepository.DeleteGoogleAnalyticsAccountByUserid(item.Id);
                        objGoogleAnalyticsStatsRepository.DeleteGoogleAnalyticsStatsByUserid(item.Id);
                        objGooglePlusAccountRepository.DeleteGooglePlusAccountByUserid(item.Id);
                        objGooglePlusActivitiesRepository.DeleteGooglePlusActivitiesByUserid(item.Id);
                        objGroupProfileRepository.DeleteGroupProfileByUserid(item.Id);
                        objGroupRepository.DeleteGroupsByUserid(item.Id);
                        objInstagramAccountRepository.DeleteInstagramAccountByUserid(item.Id);
                        objInstagramCommentRepository.DeleteInstagramCommentByUserid(item.Id);
                        objInstagramFeedRepository.DeleteInstagramFeedByUserid(item.Id);
                        objLinkedInAccountRepository.DeleteLinkedInAccountByUserid(item.Id);
                        objLinkedInFeedRepository.DeleteLinkedInFeedByUserid(item.Id);
                        objLogRepository.DeleteLogByUserid(item.Id);
                        objRssFeedsRepository.DeleteRssFeedsByUserid(item.Id);
                        objRssReaderRepository.DeleteRssReaderByUserid(item.Id);
                        objScheduledMessageRepository.DeleteScheduledMessageByUserid(item.Id);
                        objSocialProfilesRepository.DeleteSocialProfileByUserid(item.Id);
                        objTaskCommentRepository.DeleteTaskCommentByUserid(item.Id);
                        objTaskRepository.DeleteTasksByUserid(item.Id);
                        objTeamRepository.DeleteTeamByUserid(item.Id);
                        objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(item.Id);
                        objTwitterAccountRepository.DeleteTwitterAccountByUserid(item.Id);
                        objTwitterDirectMessageRepository.DeleteTwitterDirectMessagesByUserid(item.Id);
                        objTwitterFeedRepository.DeleteTwitterFeedByUserid(item.Id);
                        objTwitterMessageRepository.DeleteTwitterMessageByUserid(item.Id);
                        objTwitterStatsRepository.DeleteTwitterStatsByUserid(item.Id);
                        objUserActivationRepository.DeleteUserActivationByUserid(item.Id);
                        objUserPackageRelationRepository.DeleteuserPackageRelationByUserid(item.Id);
                        objUserRepository.DeleteUserByUserid(item.Id);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
            return(i + " " + count);
        }
コード例 #9
0
        public IHttpActionResult DeleteUserDetails(string user)
        {
            GroupsRepository                 _GroupsRepository                 = new GroupsRepository();
            GroupMembersRepository           _GroupMembersRepository           = new GroupMembersRepository();
            GroupProfileRepository           _GroupProfileRepository           = new GroupProfileRepository();
            TaskRepository                   _TaskRepository                   = new TaskRepository();
            TaskCommentRepository            _TaskCommentRepository            = new TaskCommentRepository();
            InboxMessagesRepository          _InboxMessagesRepository          = new InboxMessagesRepository();
            FacebookAccountRepository        _FacebookAccountRepository        = new FacebookAccountRepository();
            GoogleAnalyticsAccountRepository _GoogleAnalyticsAccountRepository = new GoogleAnalyticsAccountRepository();
            GooglePlusAccountRepository      _GooglePlusAccountRepository      = new GooglePlusAccountRepository();
            InstagramAccountRepository       _InstagramAccountRepository       = new InstagramAccountRepository();
            LinkedInAccountRepository        _LinkedInAccountRepository        = new LinkedInAccountRepository();
            LinkedinCompanyPageRepository    _LinkedinCompanyPageRepository    = new LinkedinCompanyPageRepository();
            ScheduledMessageRepository       _ScheduledMessageRepository       = new ScheduledMessageRepository();
            SocialProfilesRepository         _SocialProfilesRepository         = new SocialProfilesRepository();
            TwitterAccountRepository         _TwitterAccountRepository         = new TwitterAccountRepository();
            TumblrAccountRepository          _TumblrAccountRepository          = new TumblrAccountRepository();
            YoutubeAccountRepository         _YoutubeAccountRepository         = new YoutubeAccountRepository();
            YoutubeChannelRepository         _YoutubeChannelRepository         = new YoutubeChannelRepository();

            try
            {
                Domain.Socioboard.Domain.User _User = userrepo.getUserInfoByEmail(user);
                if (_User != null)
                {
                    List <Domain.Socioboard.Domain.Groups> lstGroups = _GroupsRepository.getAllGroups(_User.Id);
                    foreach (Domain.Socioboard.Domain.Groups item_group in lstGroups)
                    {
                        int  i  = _GroupMembersRepository.DeleteGroupMember(item_group.Id.ToString());
                        int  j  = _GroupProfileRepository.DeleteAllGroupProfile(item_group.Id);
                        bool rt = _GroupProfileRepository.DeleteGroupReport(item_group.Id);
                        int  k  = _TaskRepository.DeleteTaskOfGroup(item_group.Id);
                    }
                    int g = _GroupMembersRepository.DeleteGroupMemberByUserId(user);
                    int h = _GroupsRepository.DeleteGroupsByUserid(_User.Id);
                    int l = _TaskCommentRepository.DeleteTaskCommentByUserid(_User.Id);
                    int m = _InboxMessagesRepository.DeleteInboxMessages(_User.Id);
                    int n = _FacebookAccountRepository.DeleteAllFacebookAccount(_User.Id);
                    int o = _GoogleAnalyticsAccountRepository.DeleteGoogleAnalyticsAccountByUserid(_User.Id);
                    int p = _GooglePlusAccountRepository.DeleteGooglePlusAccountByUserid(_User.Id);
                    int q = _InstagramAccountRepository.DeleteInstagramAccountByUserid(_User.Id);
                    int r = _LinkedInAccountRepository.DeleteLinkedInAccountByUserid(_User.Id);
                    int s = _LinkedinCompanyPageRepository.DeleteLinkedinCompanyPage(_User.Id);
                    int t = _ScheduledMessageRepository.DeleteScheduledMessageByUserid(_User.Id);
                    int u = _SocialProfilesRepository.DeleteSocialProfileByUserid(_User.Id);
                    int v = _TwitterAccountRepository.DeleteTwitterAccountByUserid(_User.Id);
                    int w = _TumblrAccountRepository.DeletetumblraccountByUserid(_User.Id);
                    int x = _YoutubeAccountRepository.DeleteYoutubeAccount(_User.Id);
                    int y = _YoutubeChannelRepository.DeleteYoutubeChannelByUserid(_User.Id);
                    int z = userrepo.DeleteUser(_User.Id);
                }
                else
                {
                    return(Ok(false));
                }
            }
            catch (Exception ex)
            {
                return(BadRequest(ex.StackTrace));
            }
            return(Ok(true));
        }