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