public ActionResult index()
{
AdminDashBoardModel adbm = new AdminDashBoardModel();
using (context = new BPOContext())
{
int totalemployee = adbm.NewUsers = context.Employee.Count();
adbm.leads = context.Leads.Count();
adbm.Products = context.Products.Count();
adbm.expense = context.Expenses.Count();
adbm.salariespadithismonth = ((context.Salaries.ToList().Where(x => x.Date.Value.Month == DateTime.Now.Month).Count()) * 100) / totalemployee;
adbm.salariespadilastmonth = ((context.Salaries.ToList().Where(x => x.Date.Value.Month == DateTime.Now.AddMonths(-1).Month).Count()) * 100) / totalemployee;
var obj = adbm._recentLeads = context.Leads.OrderByDescending(x => x.ID).Take(3).ToList();
adbm._last3leads = (from t1 in obj
join t2 in context.Employee on t1.Emp_ID equals t2.ID
select new LeadJoinModel()
{
No_Of_Leads = t1.No_Of_Leads.Value,
Emp_Name = t2.Emp_Name
}).ToList();
adbm._employees = context.Employee.OrderByDescending(x => x.ID).Take(5).ToList();
adbm.totalexpenselastmonth = context.Expenses.ToList().Where(x => x.Date.Value.Month == DateTime.Now.AddMonths(-1).Month).Select(x => x.Amount.Value).Sum();
adbm.totalexpensethismonth = context.Expenses.ToList().Where(x => x.Date.Value.Month == DateTime.Now.Month).Select(x => x.Amount.Value).Sum();
return(View(adbm));
}
}
private List <AdminDashBoardModel> GetAdminDataAsList(DataTable dt)
{
List <AdminDashBoardModel> objList = new List <AdminDashBoardModel>();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
AdminDashBoardModel objAdmin = new AdminDashBoardModel();
objAdmin.BranchName = dt.Rows[i]["Name"].ToString();
objAdmin.BranchCode = dt.Rows[i]["Name"].ToString();
// objAdmin.AmountPending = "000";
objAdmin.EnquiryCount = dt.Rows[i]["TotalEnquiry"].ToString();
objAdmin.StudentCount = dt.Rows[i]["TotalStudents"].ToString();
objList.Add(objAdmin);
}
}
return(objList);
}
