public async Task <ActionResult> SearchBy(string keyWord, int?page, FormCollection collection)
{
if (!keyWord.IsNullOrEmptyOrWhiteSpace())
{
keyWord = collection["Keyword"];
}
else
{
keyWord = string.Empty;
}
ViewBag.Keyword = keyWord;
var _objects = _unitOfWorkAsync.RepositoryAsync <WorkIssue>()
.Query().Select().Where(t => t.Contains(keyWord))
.OrderByDescending(t => t.CreatedDate)
.ThenByDescending(t => t.UpdatedDate)
.ToList();
var _views = IssueMappers.IssuesToViews(_objects);
if (Request.IsAjaxRequest())
{
return(PartialView("Issues/_RelatedIssues",
_views.ToPagedList(pageNumber: page ?? 1, pageSize: PageSize)));
}
return(View("_SearchResults", _views.ToPagedList(pageNumber: page ?? 1, pageSize: PageSize)));
}
public ActionResult GetSubIssues(Guid id)
{
var _objects = IssueManager.GetSubIssues(id).ToList();
var _views = IssueMappers.IssuesToViews(_objects);
if (Request.IsAjaxRequest())
{
return(PartialView("Issues/_Issues", _views));
}
return(RedirectToAction("Index"));
}
public ActionResult GetLastest(string userName)
{
var _objects = IssueManager.GetLastest(userName).ToList();
var _views = IssueMappers.IssuesToViews(_objects);
if (Request.IsAjaxRequest())
{
return(PartialView("Issues/_Issues", _views));
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Index()
{
var _objects = IssueManager.GetAllOf(User.Identity.Name);
var _views = IssueMappers.IssuesToViews(_objects);
if (User.Identity.IsAuthenticated)
{
return(View("Index", _views.Where(t => t.CreatedBy == User.Identity.Name).ToList()));
}
return(View("Index", _views));
}
public static GeneralCIOViewModel GetGeneralCIOViewModel()
{
List <ApplicationUser> _users = db.Users.Where(m => m.BugNetUserId != null).ToList();
List <Project> _projects = db.Projects.ToList();
List <Issue> _issuesThisWeekAllProject = IssueRepositories.GetIssuesProjectIdFromDateToDate(_firstDayOfWeek, _lastDayOfWeek);
List <Issue> _issuesLastWorkingDayTemp = IssueRepositories.GetIssuesEQDate(_lastWorkingDay).Where(m => m.IsClosed == true).ToList();
List <Issue> _issuesTodayTemp = IssueRepositories.GetIssuesEQDate(_today);
List <Issue> _issuesNextWorkingDayTemp = IssueRepositories.GetIssuesEQDate(_nextWorkingDay);
List <Issue> _issuesNotFinishedTemp = IssueRepositories.GetIssuesNotFinishedByDate(_today);
List <Issue> _issuesFutureTemp = IssueRepositories.GetIssuesFutureByDate(_today);
List <Issue> _issuesThisWeek = new List <Issue>();
List <Issue> _issuesLastWorkingDay = new List <Issue>();
List <Issue> _issuesToday = new List <Issue>();
List <Issue> _issuesNextWorkingDay = new List <Issue>();
List <Issue> _issuesNotFinished = new List <Issue>();
List <Issue> _issuesFuture = new List <Issue>();
foreach (var project in _projects)
{
_issuesThisWeek.AddRange(_issuesThisWeekAllProject.Where(m => m.ProjectId == project.Id).ToList());
_issuesLastWorkingDay.AddRange(_issuesLastWorkingDayTemp.Where(m => m.ProjectId == project.Id).ToList());
_issuesNextWorkingDay.AddRange(_issuesNextWorkingDayTemp.Where(m => m.ProjectId == project.Id).ToList());
_issuesToday.AddRange(_issuesTodayTemp.Where(m => m.ProjectId == project.Id).ToList());
_issuesNotFinished.AddRange(_issuesNotFinishedTemp.Where(m => m.ProjectId == project.Id).ToList());
_issuesFuture.AddRange(_issuesFutureTemp.Where(m => m.ProjectId == project.Id).ToList());
}
GeneralCIOViewModel _generalCIO = new GeneralCIOViewModel();
_generalCIO.PerfomanceAverageToday = PerformanceHelpers.GetPerformanceAverageByIssues(_issuesToday, _users.Count);
_generalCIO.PerfomanceAverageLastWorkingDay = PerformanceHelpers.GetPerformanceAverageByIssues(_issuesLastWorkingDay, _users.Count);
_generalCIO.PerfomanceAverageNextWorkingDay = PerformanceHelpers.GetPerformanceAverageByIssues(_issuesNextWorkingDay, _users.Count);
_generalCIO.PerfomanceAverageThisWeek = PerformanceHelpers.GetPerformanceAverageByIssuesInWeek(_issuesThisWeek, _users.Count);
_generalCIO.PerformancesLastWorkingDate = PerformanceHelpers.GetPerformanceUserByIssuesDate(_issuesLastWorkingDay).OrderByDescending(m => m.y).ToList();
_generalCIO.PerformancesToday = PerformanceHelpers.GetPerformanceUserByIssuesDate(_issuesToday).OrderByDescending(m => m.y).ToList();
_generalCIO.PerformancesNextWorkingDate = PerformanceHelpers.GetPerformanceUserByIssuesDate(_issuesNextWorkingDay).OrderByDescending(m => m.y).ToList();
_generalCIO.IssuesNotFinished = IssueMappers.IssueToViewModels(_issuesNotFinished);
_generalCIO.IssuesFuture = IssueMappers.IssueToViewModels(_issuesFuture);
return(_generalCIO);
}
public static StaffTimesViewModel GetPerformanceInDateViewModel(DateTime fromDate, DateTime toDate)
{
string user = "******";
List <Issue> _issuesInTimes = IssueRepositories.GetIssuesProjectIdFromDateToDate(fromDate, toDate);
List <Project> _projects = db.Projects.ToList();
List <Issue> _issuesNotFinishedTemp = IssueRepositories.GetIssuesNotFinishedByDate(_today);
List <Issue> _issuesFutureTemp = IssueRepositories.GetIssuesFutureByDate(_today);
List <Issue> _issuesNotFinished = new List <Issue>();
List <Issue> _issuesFuture = new List <Issue>();
List <Issue> issuesInTimes = new List <Issue>();
foreach (var project in _projects)
{
issuesInTimes.AddRange(_issuesInTimes.Where(m => m.ProjectId == project.Id).ToList());
_issuesNotFinished.AddRange(_issuesNotFinishedTemp.Where(m => m.ProjectId == project.Id).ToList());
_issuesFuture.AddRange(_issuesFutureTemp.Where(m => m.ProjectId == project.Id).ToList());
}
StaffTimesViewModel staffTimes = new StaffTimesViewModel();
List <GraphItem> issues = new List <GraphItem>();
staffTimes.FromDate = fromDate;
staffTimes.ToDate = toDate;
DateTime _dateTemp = staffTimes.FromDate;
while (_dateTemp <= staffTimes.ToDate)
{
GraphItem _issue = new GraphItem();
_issue.x = _dateTemp.ToShortDateString();
_issue.y = PerformanceHelpers.GetPerformanceByIssues(issuesInTimes.Where(m => DateHelpers.IsEquals(m.IssueDueDate, _dateTemp) && m.AssignedUserName == user).ToList());
_dateTemp = _dateTemp.AddDays(1);
issues.Add(_issue);
}
staffTimes.Performances = issues;
staffTimes.UserName = user;
staffTimes.IssuesNotFinished = IssueMappers.IssueToViewModels(_issuesNotFinished.Where(m => m.AssignedUserName == user).ToList());
staffTimes.IssuesFuture = IssueMappers.IssueToViewModels(_issuesFuture.Where(m => m.AssignedUserName == user).ToList());
staffTimes.IssuesAll = IssueMappers.IssueToViewModels(issuesInTimes.Where(m => m.AssignedUserName == user).ToList());
return(staffTimes);
}
public static CIOListIssuesForDateViewModel GetListIssuesForDateViewModel(DateTime fromDate, DateTime toDate)
{
List <Issue> _issuesInTimes = IssueRepositories.GetIssuesProjectIdFromDateToDate(fromDate, toDate);
List <ApplicationUser> _users = db.Users.Where(m => m.BugNetUserId != null).ToList();
List <Project> _projects = db.Projects.ToList();
List <Issue> _issuesThisWeek = new List <Issue>();
foreach (var project in _projects)
{
_issuesThisWeek.AddRange(_issuesInTimes.Where(m => m.ProjectId == project.Id).ToList());
}
CIOListIssuesForDateViewModel issuesForDate = new CIOListIssuesForDateViewModel();
List <ListIssuesForDateViewModel> issues = new List <ListIssuesForDateViewModel>();
issuesForDate.FromDate = fromDate;
issuesForDate.ToDate = toDate;
DateTime _dateTemp = issuesForDate.FromDate;
while (_dateTemp <= issuesForDate.ToDate)
{
ListIssuesForDateViewModel _issue = new ListIssuesForDateViewModel();
_issue.Date = _dateTemp;
if (_issue.Date < DateTime.Today)
{
_issue.Issues = IssueMappers.IssueToViewModels(_issuesThisWeek.Where(m => DateHelpers.IsEquals(m.IssueDueDate, _dateTemp)).ToList()).OrderByDescending(m => m.IssueDueDate).ToList();
}
else
{
_issue.Issues = IssueMappers.IssueToViewModels(_issuesThisWeek.Where(m => DateHelpers.IsEquals(m.IssueDueDate, _dateTemp)).ToList()).OrderByDescending(m => m.IssueDueDate).ToList();
}
_dateTemp = _dateTemp.AddDays(1);
issues.Add(_issue);
}
issuesForDate.ListIssuesForDate = issues;
return(issuesForDate);
}
public async Task <ActionResult> GetToVerifyIssues(int?page)
{
if (page == null)
{
page = 1;
}
var _objects = IssueManager.GetAllOf(User.Identity.Name);
_objects = _objects.Where(t => !t.IsVerified)
.OrderByDescending(t => t.UpdatedDate)
.ThenByDescending(t => t.CreatedDate)
.ToList();
var _views = IssueMappers.IssuesToViews(_objects);
ViewBag.VerifyIssues = _views;
if (Request.IsAjaxRequest())
{
return(PartialView("Issues/_IssuesToVerify",
_views.ToPagedList(pageNumber: page ?? 1, pageSize: PageSize)));
}
return(View("Index", _views));
}
public async Task <ActionResult> GetIssuesOf(string email)
{
//if (page == null) page = 1;
var _objects = IssueManager.GetAllExtendOf(email);
_objects = _objects
//.Where(t => t.IsVerified && t.IsExpired())
.OrderByDescending(t => t.UpdatedDate)
.ThenByDescending(t => t.CreatedDate)
.ToList();
var _views = IssueMappers.IssuesToViews(_objects);
ViewBag.ExpiredIssues = _views;
if (Request.IsAjaxRequest())
{
return(PartialView("Issues/_Issues",
_views
//.ToPagedList(pageNumber: page ?? 1, pageSize: PageSize)
));
}
return(View("Index", _views));
}
public static GeneralStaffViewModel GetGeneralStaffViewModel(string userName)
{
List <Project> _projects = db.Projects.ToList();
List <Issue> _issuesForUserAllProject = IssueRepositories.GetIssuesByUser(userName);
List <Issue> _issuesForUser = new List <Issue>();
foreach (var project in _projects)
{
_issuesForUser.AddRange(_issuesForUserAllProject.Where(m => m.ProjectId == project.Id).ToList());
}
GeneralStaffViewModel _generalStaff = new GeneralStaffViewModel();
_generalStaff.PerfomanceLastWorkingDay = PerformanceHelpers.GetPerformanceUserByIssues(_issuesForUser.Where(m => m.IssueDueDate == _lastWorkingDay).ToList());
_generalStaff.PerfomanceToday = PerformanceHelpers.GetPerformanceUserByIssues(_issuesForUser.Where(m => m.IssueDueDate == _today).ToList());
_generalStaff.PerfomanceNextWorkingDay = PerformanceHelpers.GetPerformanceUserByIssues(_issuesForUser.Where(m => m.IssueDueDate == _nextWorkingDay).ToList());
_generalStaff.IssuesNotFinished = IssueMappers.IssueToViewModels(_issuesForUser.Where(m => m.IsClosed == false).ToList());
_generalStaff.IssuesFuture = IssueMappers.IssueToViewModels(_issuesForUser.Where(m => m.IssueDueDate >= _today).ToList());
return(_generalStaff);
}
