public List <DiscussionDataForGraph> GetDiscussionDataForGraph(string type, string CSMember) { List <DiscussionDataForGraph> lstData = new List <DiscussionDataForGraph>(); using (var context = new CommonDBContext()) { var result = context.Database.SqlQuery <DiscussionDataForGraph>("sp_GetUntouchedDiscussionDataForGraph @type, @CSMember", new SqlParameter("@type", type), new SqlParameter("@CSMember", CSMember)).ToList <DiscussionDataForGraph>(); var ACount = result.Where(x => x.CustomerType == "A").Count(); var BCount = result.Where(x => x.CustomerType == "B").Count(); var CCount = result.Where(x => x.CustomerType == "C").Count(); DiscussionDataForGraph objdataA = new DiscussionDataForGraph(); objdataA.CustomerType = "A"; objdataA.count = ACount; lstData.Add(objdataA); DiscussionDataForGraph objdataB = new DiscussionDataForGraph(); objdataB.CustomerType = "B"; objdataB.count = BCount; lstData.Add(objdataB); DiscussionDataForGraph objdataC = new DiscussionDataForGraph(); objdataC.CustomerType = "C"; objdataC.count = CCount; lstData.Add(objdataC); } return(lstData); }
public List <DiscussionDataForGraph> GetDiscussionData() { List <DiscussionDataForGraph> lstData = new List <DiscussionDataForGraph>(); using (var context = new CommonDBContext()) { var groups = context.tblGroupDetails.Where(x => x.IsActive == true && x.IsLive == true).ToList(); foreach (var group in groups) { DiscussionDataForGraph objItem = new DiscussionDataForGraph(); objItem.groupid = group.GroupId; objItem.CustomerType = group.CustomerType; objItem.GroupName = group.GroupName; string grpId = Convert.ToString(group.GroupId); var discussedDate = context.BOTS_TblDiscussion.Where(y => y.GroupId == grpId && (y.CallType == 2 || y.CallType == 3)).OrderByDescending(x => x.UpdatedDate).Select(z => z.UpdatedDate).FirstOrDefault(); if (discussedDate.HasValue) { var days = (DateTime.Today - discussedDate.Value).Days; if (days > 6) { objItem.days = days; lstData.Add(objItem); objItem.RMAssignedName = context.tblRMAssigneds.Where(x => x.RMAssignedId == group.RMAssigned).Select(y => y.RMAssignedName).FirstOrDefault(); objItem.RMLoginId = context.tblRMAssigneds.Where(x => x.RMAssignedId == group.RMAssigned).Select(y => y.LoginId).FirstOrDefault(); } } } } return(lstData); }