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