protected void Page_Load(object sender, EventArgs e)
        {
            string ret = string.Empty;
            try
            {
                User objUser = new User();
                UserRepository objUserRepository = new UserRepository();
                scheduling objscheduling = new scheduling();
                ScheduledMessage objScheduledMessage = new ScheduledMessage();
                ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
                List<ScheduledTracker> lstScheduledTracker = objScheduledMessageRepository.GetAllScheduledDetails();
                foreach (ScheduledTracker item in lstScheduledTracker)
                {
                    try
                    {
                        //List<ScheduledMessage> lstScheduledMessage = objScheduledMessageRepository.getAllMessagesOfUser(Guid.Parse(item._Id));
                        List<ScheduledMessage> lstUnsentScheduledMessage = objScheduledMessageRepository.getAllIUnSentMessagesOfUser(Guid.Parse(item._Id));
                        objUser = objUserRepository.getUsersById(Guid.Parse(item._Id));
                        ret += "<tr class=\"gradeX\"><td><a href=\"ScheduledMessageDetail.aspx?id=" + objUser.Id + "\">" + objUser.UserName + "</a></td><td>" + item._count + "</td><td>" + (item._count - lstUnsentScheduledMessage.Count()) + "</td><td>" + lstUnsentScheduledMessage.Count() + "</td></tr>";

                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                     
                    }
                }
            }
            catch (Exception ex)
            {

                Console.WriteLine(ex.Message);
            }

            Response.Write(ret);
        }
        public string GetAllUnSentMessagesOfUser(string UserId)
        {
            try
            {

                Guid userid = Guid.Parse(UserId);
                ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
                List<ScheduledMessage> lstScheduledMessages = new List<ScheduledMessage>();
                lstScheduledMessages = objScheduledMessageRepository.getAllIUnSentMessagesOfUser(userid);

                //FacebookAccountRepository facebookAccountRepo = new FacebookAccountRepository();
                // FacebookAccount facebook = facebookAccountRepo.getFacebookAccountDetailsById(FacebookId, userid);
                return new JavaScriptSerializer().Serialize(lstScheduledMessages);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                return new JavaScriptSerializer().Serialize("Please try Again");
            }

        }