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