public chartViewModel GetContactBylabel(int adminId) { chartViewModel _item = new chartViewModel(); List <chartItem> item = new List <chartItem>(); Global _global = new Database.Global(); CRMClassDataContext _idc = new Database.CRMClassDataContext(_global.con); try { var query = (from post in _idc.tblcontacts.Where(a => a.AdminId == adminId && a.IsActive == true) join t in _idc.tbllabels on post.LabelId equals t.Id select new { Post = post, t = t }).GroupBy(a => a.t.LableName). Select(o => new { name = o.Key, Count = o.Count() }).ToList(); foreach (var items in query) { chartItem chrt = new chartItem(); chrt.name = items.name; chrt.value = items.Count; item.Add(chrt); } _item.data = item; } catch (Exception ex) { } finally { _idc.Dispose(); } return(_item); }
public chartWeekModel GetJobByWeek(int adminId) { chartWeekModel _item = new chartWeekModel(); List <chartItem> pending = new List <chartItem>(); List <chartItem> closed = new List <chartItem>(); List <chartItem> problem = new List <chartItem>(); List <chartItem> newList = new List <chartItem>(); Global _global = new Database.Global(); DateTime mondayDate = DateTime .Today .AddDays(((int)(DateTime.Today.DayOfWeek) * -1) + 1); int monthcount = 7; CRMClassDataContext _idc = new Database.CRMClassDataContext(_global.con); try { var pjobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 2).ToList(); var cjobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 4).ToList(); var njobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 1).ToList(); var prjobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 3).ToList(); for (int i = 0; i < monthcount; i++) { chartItem pdata = new chartItem(); chartItem cdata = new chartItem(); chartItem ndata = new chartItem(); chartItem prdata = new chartItem(); pdata.value = pjobs.Where(a => a.CreatedDate.Value.Date == mondayDate.Date).Count(); cdata.value = cjobs.Where(a => a.CreatedDate.Value.Date == mondayDate.Date).Count(); ndata.value = njobs.Where(a => a.CreatedDate.Value.Date == mondayDate.Date).Count(); prdata.value = prjobs.Where(a => a.CreatedDate.Value.Date == mondayDate.Date).Count(); mondayDate = mondayDate.AddDays(1); pending.Add(pdata); closed.Add(cdata); problem.Add(prdata); newList.Add(ndata); } _item.Problem = problem; _item.New = newList; _item.pending = pending; _item.Completed = closed; } catch (Exception ex) { } finally { _idc.Dispose(); } return(_item); }
public chartWeekModel GetJobByMonth(int adminId) { chartWeekModel _item = new chartWeekModel(); List <chartItem> pending = new List <chartItem>(); List <chartItem> closed = new List <chartItem>(); List <chartItem> problem = new List <chartItem>(); List <chartItem> newList = new List <chartItem>(); Global _global = new Database.Global(); CRMClassDataContext _idc = new Database.CRMClassDataContext(_global.con); try { var pjobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 2).ToList(); var cjobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 4).ToList(); var njobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 1).ToList(); var prjobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 3).ToList(); int currentYear = DateTime.Now.Year; for (int i = 1; i <= 12; i++) { chartItem pdata = new chartItem(); chartItem cdata = new chartItem(); chartItem ndata = new chartItem(); chartItem prdata = new chartItem(); pdata.value = pjobs.Where(a => a.CreatedDate.Value.Month == i && a.CreatedDate.Value.Year == currentYear).Count(); cdata.value = cjobs.Where(a => a.CreatedDate.Value.Month == i && a.CreatedDate.Value.Year == currentYear).Count(); ndata.value = njobs.Where(a => a.CreatedDate.Value.Month == i && a.CreatedDate.Value.Year == currentYear).Count(); prdata.value = prjobs.Where(a => a.CreatedDate.Value.Month == i && a.CreatedDate.Value.Year == currentYear).Count(); pending.Add(pdata); closed.Add(cdata); problem.Add(prdata); newList.Add(ndata); } _item.Problem = problem; _item.New = newList; _item.pending = pending; _item.Completed = closed; } catch (Exception ex) { } finally { _idc.Dispose(); } return(_item); }
public chartViewModel GetJobByStatus(int adminId) { chartViewModel _item = new chartViewModel(); List <chartItem> item = new List <chartItem>(); Global _global = new Database.Global(); CRMClassDataContext _idc = new Database.CRMClassDataContext(_global.con); try { var pending = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 2).Count(); var NewJobs = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 1).Count(); var problem = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 3).Count(); var Completed = _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.IsActive == true && a.StatusId == 4).Count(); chartItem i = new chartItem(); i.name = "Pending"; i.value = pending; item.Add(i); chartItem i1 = new chartItem(); i1.name = "New"; i1.value = NewJobs; chartItem i2 = new chartItem(); i2.name = "Problem"; i2.value = problem; chartItem i3 = new chartItem(); i3.name = "Completed"; i3.value = Completed; item.Add(i1); item.Add(i2); item.Add(i3); _item.data = item; } catch (Exception ex) { } finally { _idc.Dispose(); } return(_item); }