public ActionResult Index() { string role = roledb.GetUserRolesByUser(User.Identity.Name.ToString().ToUpper().Replace("CT\\", ""))[0]; ViewData["Role"] = role; DateTime myDate = DateTime.Now; DateTime firstDayOfThisMonth = myDate.Subtract(TimeSpan.FromDays(myDate.Day - 1)); DateTime firstDayOfNextMonth = firstDayOfThisMonth.AddMonths(1); DateTime lastDayOfThisMonth = firstDayOfNextMonth.Subtract(TimeSpan.FromDays(1)); string User_CAI = ""; User_CAI = User.Identity.Name.ToUpper().Replace("CT\\", ""); //User_CAI = "PALX"; ViewData["Users"] = new SelectList(userdb.GetUserItems(), "cai", "detail", User_CAI); ViewData["MonthDays"] = MonthDays(myDate); return(View(timedb.GetReportByUser(User_CAI, firstDayOfThisMonth, lastDayOfThisMonth))); }