public async Task <IActionResult> Index() { ProjectListModel model = new ProjectListModel(); var result = await _crudService.GetAll <ProjectModel>(Token, ProjectService.ProjectEntity, false); if (result.Success) { model.Projects = result.Values.Select(p => new ProjectViewModel { Id = p.Id, Name = p.Name, CreateDate = p.CreateDate, Description = p.Description, ProjectUsersCount = p.ProjectUsers.Count, ProjectMetricsCount = p.ProjectMetrics.Count }).ToList(); } else { AddMessageToModel(model, result.Message); } return(View(model)); }
public ActionResult List() { IEnumerable <ProjectDetails> projects = this.projectService.GetProjectsDetails(); var model = new ProjectListModel(projects); return(this.View(model)); }
public ActionResult ProjectList() { var result = _postservice.GetAll(); var result3 = _postservice.GetAll(); //var a = result.Where(d => d.Flag == 0); var result2 = _skillservice.GetAll(); ProjectListModel projectListModel = new ProjectListModel(); if (result != null) { foreach (var p in result.Data) { var select = _selectedWorkerService.GetAll().Data.Where(d => d.PostId == p.PostId).ToList(); if (select.Count == p.Members) { result3.Data.Remove(p); } } } result = result3; projectListModel.PostAProjects = result.Data.OrderByDescending(m => m.PostId).ToList(); projectListModel.Skills = result2.Data; return(View(projectListModel)); }
public ActionResult Index(int? page) { ProjectListModel model = new ProjectListModel(); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; //ListAccess la = new ListAccess(); //model.MostViewed = la.MostViewed(11, 20); string url = HttpContext.Request.RawUrl; //int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url); //model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix); using (var db = new DIYFE.EF.DIYFEEntities()) { //model.ProjectList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 2).OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1)).ToList(); model.PagedArticle = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1).OrderBy(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize); } //model.ArticleList = la.ArticleList(catigoryId, 1); return View(model); }
public ActionResult FirstLevCategoryList(string categoryUrl, string subCategoryUrl, string subSubCategoryUrl, int? page) { ProjectListModel model = new ProjectListModel(); //model.MostViewed = la.MostViewed(11, 20); //model.CrumbLinkList = new List<CustomHtmlLink>(); //AppStatic.Categories.Where(c => c.CategoryUrl == categoryUrl); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; string url = HttpContext.Request.RawUrl; Category cat = DIYFEHelper.GetCatigory(categoryUrl, subCategoryUrl, subSubCategoryUrl); //int categoryRowId = DIYFEHelper.GetCatigoryRowId(categoryUrl, "", ""); model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(cat, linkPrefix); model.RelatedTreeView = DIYFEHelper.GenerateRelatedTreeView(cat, linkPrefix); using (var db = new DIYFE.EF.DIYFEEntities()) { model.PagedArticle = db.Articles.Include("ArticleComments") .Include("ArticleStatus.StatusType") .Where(a => a.ArticleTypeId == 2 && a.Category.CategoryId == cat.CategoryId) .OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1)) .ToPagedList(page ?? 1, pageSize); } return View(model); }
public void TestProjectController_UpdateProjectsDeleteItem(string httpMethod) { SetUpProjectControllerForTesting(httpMethod); projectController.CurrentUser = user; ProjectsModel model = new ProjectsModel(); model.ProjectId = projectId; FormCollection form = new FormCollection(); ProjectListModel projectListModel = new ProjectListModel(); long _projectId = this.db.Context.Projects.Where(p => p.OwnerId == user.UserId && p.ProjectStatusTypeId == ProjectStatusTypeEnum.Inactive).OrderByDescending(p => p.ProjectId).Select(p => p.ProjectId).FirstOrDefault(); projectListModel.ProjectId = _projectId; model.Items.Add(projectListModel); System.Collections.Specialized.NameValueCollection nameValueCollection = new System.Collections.Specialized.NameValueCollection(); nameValueCollection.Add(_projectId.ToString(), _projectId.ToString()); form.Add(nameValueCollection); ViewResult result = projectController.UpdateProjectsDeleteItem(model, form) as ViewResult; Assert.That(result, Is.Not.EqualTo(null)); Assert.That(result.ViewName, Is.EqualTo("Projects")); Assert.That(result.Model, Is.Not.EqualTo(null)); Assert.That((result.Model as ProjectsModel).DeleteProjects.First().ProjectId, Is.EqualTo(_projectId)); }
public ActionResult Index(int?page) { ProjectListModel model = new ProjectListModel(); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; //ListAccess la = new ListAccess(); //model.MostViewed = la.MostViewed(11, 20); string url = HttpContext.Request.RawUrl; //int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url); //model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix); using (var db = new DIYFE.EF.DIYFEEntities()) { //model.ProjectList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 2).OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1)).ToList(); model.PagedArticle = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1).OrderBy(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize); } //model.ArticleList = la.ArticleList(catigoryId, 1); return(View(model)); }
//GET : /api/ProjectBoard/GetCurrentProjects public ProjectListModel GetCurrentProjects(int id) { Project project = new Project(); if (id == 0) { project = _context.Projects.FirstOrDefault(); } else { project = _context.Projects.Find(id); } if (project != null) { ProjectListModel currProject = new ProjectListModel { Id = project.Id, ProjectTitle = project.ProjectTitle }; return(currProject); } else { return(new ProjectListModel { Id = 0, ProjectTitle = "No project in database." }); } }
public ActionResult FirstLevCategoryList(string categoryUrl, string subCategoryUrl, string subSubCategoryUrl, int?page) { ProjectListModel model = new ProjectListModel(); //model.MostViewed = la.MostViewed(11, 20); //model.CrumbLinkList = new List<CustomHtmlLink>(); //AppStatic.Categories.Where(c => c.CategoryUrl == categoryUrl); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; string url = HttpContext.Request.RawUrl; //int categoryRowId = DIYFEHelper.GetCatigoryRowId(categoryUrl, "", ""); Category cat = DIYFEHelper.GetCatigory(categoryUrl, subCategoryUrl, subSubCategoryUrl); model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(cat, linkPrefix); model.RelatedTreeView = DIYFEHelper.GenerateRelatedTreeView(cat, linkPrefix); using (var db = new DIYFE.EF.DIYFEEntities()) { //BASED ON CAT model.ArticleList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1 && a.Category.CategoryId == cat.CategoryId).OrderBy(a => a.CreatedDate); model.PagedArticle = model.ArticleList.Concat(db.Articles.Include("ArticleComments").Include("ArticleStatus.StatusType").Where(a => a.ArticleTypeId == 2 && a.Category.CategoryId == cat.CategoryId).OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1))).OrderByDescending(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize); //CHECK PAGING //model.ArticleList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1); //model.PagedArticle = model.ArticleList.Concat(db.Articles.Include("ArticleComments").Include("ArticleStatus.StatusType").Where(a => a.ArticleTypeId == 2)).OrderBy(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize); } //model.PagedArticle = model.ArticleList.ToPagedList(page ?? 1, pageSize); return(View(model)); }
public ActionResult Index() { HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName]; if (authCookie != null) { FormsAuthenticationTicket authTicket = FormsAuthentication.Decrypt(authCookie.Value); var user = _readOnlyRepository.FirstOrDefault <User>(x => x.Email == authTicket.UserData); if (user != null) { var model = new ProjectListModel(); var typelist = from ProjectEntity ute in _readOnlyRepository.GetAll <ProjectEntity>() where ute.UserId == user.Id && !ute.Archived select ute; var typeList = new List <ProjectEntity>(typelist); model.ProjectList = new List <ProjectListModel>(); foreach (var tL in typeList) { model.ProjectList.Add(new ProjectListModel { ProjectId = tL.Id, ProjectName = tL.ProjectName, ProjectDescription = tL.ProjectDescription }); } return(View(model)); } } return(RedirectToAction("Logout", "User")); }
public ProjectListModel GetProjects() { ProjectListModel model = new ProjectListModel(); using (var db = new ProjectEntities()) { var query = db.UserProjects.Select(x => x); var projectList = query.ToList(); projectList.ForEach(project => { model.Projects.Add( new ProjectModel { ProjectID = project.ID, Name = project.ProjectName, Owner = project.ProjectOwner, Details = project.ProjectDetails, Image = project.ProjectImage, Success = project.Successful } ); }); } return(model); }
public List <ProjectListModel> Get(string email) { var filter = Builders <ProjectModel> .Filter.Where(x => x.Members.Any(y => y.Email == email)); List <ProjectModel> projects = _database.FindAll(filter); List <ProjectListModel> listing = new List <ProjectListModel>(); foreach (ProjectModel project in projects) { ProjectListModel p = new ProjectListModel { Id = project.Id, Title = project.Title, Members = new List <ProjectMembersModel>() }; foreach (var member in project.Members) { p.Members.Add(new ProjectMembersModel { Email = member.Email, Name = member.Name, }); } listing.Add(p); } return(listing); }
public ActionResult Index() { ProjectListModel model = new ProjectListModel(); model.Projects = _projectService.GetAll(); return(View(model)); }
public string projectList(int page, int rows) { ProjectListModel pl = new ProjectListModel(page, rows); string json = JsonConvert.SerializeObject(pl); return(json); }
public ActionResult ProjectList() { var result = postProjectDao.GetAll(); var result2 = skillsDao.GetAll(); ProjectListModel projectListModel = new ProjectListModel(); projectListModel.PostAProjects = result; projectListModel.Skills = result2; return(View(projectListModel)); }
//GET : /api/ProjectBoard/GetProjects public List <ProjectListModel> GetProjects() { List <ProjectListModel> projectList = new List <ProjectListModel>(); foreach (Project project in _context.Projects.ToList()) { ProjectListModel addProject = new ProjectListModel { Id = project.Id, ProjectTitle = project.ProjectTitle }; projectList.Add(addProject); } return(projectList); }
public ActionResult ProjectList(ProjectSkills skill) { ProjectListModel projectListModel = new ProjectListModel(); var result = projectSkillDao.GetAllskill(skill.SkillID); foreach (var projectSkillse in result) { var result2 = postProjectDao.GetByID(projectSkillse.PostID); projectListModel.PostAProjects.Add(result2.Data); } var result3 = skillsDao.GetAll(); projectListModel.Skills = result3; return(View(projectListModel)); }
public ActionResult Index(int?projectStatus, int?page) { ProjectListModel model = new ProjectListModel(); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; //ListAccess la = new ListAccess(); //NOTE: THIS QUERY IS TAKING FOREVER FOR SOME REASON //model.MostViewed = la.MostViewed(11, 20); //model.MostViewed = new List<CustomHtmlLink>(); //string url = HttpContext.Request.RawUrl; //int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url); //model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix); using (var db = new DIYFE.EF.DIYFEEntities()) { model.PagedArticle = db.Articles .Include("ArticleComments") .Include("ArticleStatus.StatusType") .Where(a => a.ArticleTypeId == 2) .OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1)) .ToPagedList(page ?? 1, pageSize); } if (projectStatus != null) { using (var db = new DIYFE.EF.DIYFEEntities()) { model.PagedArticle = db.Articles .Include("ArticleComments") .Include("ArticleStatus.StatusType") .Where(a => a.ArticleTypeId == 2 && a.ArticleStatus.Any(aStat => aStat.StatusId == projectStatus)) .OrderByDescending(a => a.CreatedDate) .ToPagedList(page ?? 1, pageSize); } //List<DIYFE.EF.Article> tempList = model.ProjectList.ToList(); //model.ProjectList = tempList.Where(a => a.ArticleStatus.Any(arts => arts.StatusId == projectStatus)).ToList(); //model.ProjectList.Concat(tempList.Where(a => !model.ProjectList.Contains(a))); } //model.ArticleList = la.ArticleList(catigoryId, 1); return(View(model)); }
public ActionResult Index(int? projectStatus, int? page) { ProjectListModel model = new ProjectListModel(); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; //ListAccess la = new ListAccess(); //NOTE: THIS QUERY IS TAKING FOREVER FOR SOME REASON //model.MostViewed = la.MostViewed(11, 20); //model.MostViewed = new List<CustomHtmlLink>(); //string url = HttpContext.Request.RawUrl; //int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url); //model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix); using (var db = new DIYFE.EF.DIYFEEntities()) { model.PagedArticle = db.Articles .Include("ArticleComments") .Include("ArticleStatus.StatusType") .Where(a => a.ArticleTypeId == 2) .OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1)) .ToPagedList(page ?? 1, pageSize); } if (projectStatus != null) { using (var db = new DIYFE.EF.DIYFEEntities()) { model.PagedArticle = db.Articles .Include("ArticleComments") .Include("ArticleStatus.StatusType") .Where(a => a.ArticleTypeId == 2 && a.ArticleStatus.Any(aStat => aStat.StatusId == projectStatus)) .OrderByDescending(a => a.CreatedDate) .ToPagedList(page ?? 1, pageSize); } //List<DIYFE.EF.Article> tempList = model.ProjectList.ToList(); //model.ProjectList = tempList.Where(a => a.ArticleStatus.Any(arts => arts.StatusId == projectStatus)).ToList(); //model.ProjectList.Concat(tempList.Where(a => !model.ProjectList.Contains(a))); } //model.ArticleList = la.ArticleList(catigoryId, 1); return View(model); }
/// <summary> /// Prepare paged project list model /// </summary> /// <param name="searchModel">Project search model</param> /// <returns>Project list model</returns> public ProjectListModel PrepareProjectListModel(ProjectSearchModel searchModel) { if (searchModel == null) { throw new ArgumentNullException(nameof(searchModel)); } string userName = string.Empty; if (_workContext.CurrentUser.UserTypeId == 2) //Researchers Role will see only owner projects { userName = _workContext.CurrentUser.UserName; } var projects = _projectService.GetAllProjects(projectNameTH: searchModel.SearchProjectName, fiscalYear: searchModel.FiscalScheduleId, projectStatusId: searchModel.ProjectStatusId, agencyId: searchModel.AgencyId, progressStatusId: searchModel.ProgressStatusId, createdBy: userName, pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize); //prepare list model var model = new ProjectListModel { Data = projects.Select(project => { // fill in model values from the entity var projectModel = new ProjectModel { Id = project.Id, FiscalYear = project.FiscalYear, ProjectCode = project.ProjectCode, ProjectNameTh = project.ProjectNameTh, ProjectStartDateName = CommonHelper.ConvertToThaiDate(project.ProjectStartDate), ProgressStatusName = project.ProjectProgresses.LastOrDefault() != null ? project.ProjectProgresses.LastOrDefault().ProgressStatus.GetAttributeOfType <EnumMemberAttribute>().Value : string.Empty, ProjectStatusName = (int)project.ProjectStatus != 0 ? project.ProjectStatus.GetAttributeOfType <EnumMemberAttribute>().Value : string.Empty, }; return(projectModel); }), Total = projects.TotalCount }; return(model); }
public ActionResult ProjectList(ProjectSkills skill) { ProjectListModel projectListModel = new ProjectListModel(); var result = _proskillservice.GetAll().Data.Where(d => d.SkillName.Contains(skill.SkillName)).ToList(); foreach (var projectSkillse in result) { var result2 = _postservice.GetByID(projectSkillse.PostId); var select = _selectedWorkerService.GetAll().Data.Where(d => d.PostId == result2.Data.PostId).ToList(); if (select.Count != result2.Data.Members) { projectListModel.PostAProjects.Add(result2.Data); } } var result3 = _skillservice.GetAll(); projectListModel.Skills = result3.Data; return(View(projectListModel)); }
public ProjectListModel PreaperProjectListModel(ProjectSearchModel projectSearchModel) { var projects = _projectService.SearchProjects(published: projectSearchModel.PublishId, name: projectSearchModel.Name, shortDescription: projectSearchModel.ShortDescription); var model = new ProjectListModel().PrepareToGrid(projectSearchModel, projects, () => { return(projects.Select(p => { var projectModel = GetModelFromProject(p); projectModel.FullDescription = null; projectModel.SeName = _urlRecordService.GetSeName(p); return projectModel; })); }); return(model); }
public ActionResult Index( string createdDate, string isActive, string isArchived, string modifiedDate, string projectName) { var model = new ProjectListModel(); var criteria = new ProjectDataCriteria { CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate), IsActive = CriteriaHelper.ToBoolean(isActive), IsArchived = CriteriaHelper.ToBoolean(isArchived), Name = projectName, ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate) }; var projects = ProjectRepository.ProjectFetchInfoList(criteria); model.Projects = projects; var stories = StoryRepository.StoryFetchInfoList(projects.ToArray(), false); model.Stories = stories; var timelines = TimelineRepository.TimelineFetchInfoList( projects.Select(row => row.ProjectId).Distinct().ToArray(), SourceType.Project); model.Timelines = timelines; var sprints = SprintRepository.SprintFetchInfoList(projects.ToArray(), false); model.Sprints = sprints; model.Actions.Add("Add a project", Url.Action("Create"), "primary"); return(this.View(model)); }
public void TestProjectController_ProjectsDelete(string httpMethod) { SetUpProjectControllerForTesting(httpMethod); projectController.CurrentUser = user; List <long> _projectIds = this.db.Context.Projects.Where(p => p.OwnerId == user.UserId && p.Name.Contains("AA")).Select(p => p.ProjectId).Take(3).ToList(); ProjectsModel model = new ProjectsModel(); PagedList <ProjectListModel> items = new PagedList <ProjectListModel>(); foreach (long projectId in _projectIds) { ProjectListModel item = new ProjectListModel(); item.ProjectId = projectId; items.Add(item); } model.Items = items; projectController.ViewData["PageMessages"] = new Messages(); projectController.ViewData["KeyMessages"] = new Messages(); FormCollection collection = new FormCollection(); for (int i = 0; i < model.Items.Count; i++) { collection[model.Items[i].ProjectId.ToString()] = model.Items[i].ProjectId.ToString(); } ViewResult result = projectController.ProjectsDelete(model, collection) as ViewResult; Assert.That(this.response.HasError, Is.EqualTo(false)); Assert.That(result, Is.Not.EqualTo(null)); Assert.That(result.ViewName, Is.EqualTo("Projects")); }
public ActionResult List(GridCommand command, ProjectListModel model) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageNews)) return AccessDeniedView(); var projects = _projectService.GetAllProjects(model.SearchProjectName,pageIndex: command.Page - 1,pageSize: command.PageSize); var gridModel = new GridModel<ProjectModel> { Data = projects.Select(x => { var m = x.ToModel(); m.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc); return m; }), Total = projects.TotalCount }; return new JsonResult { Data = gridModel }; }
public ActionResult List() { var model = new ProjectListModel(); return View(model); }
public ActionResult SuccessfulProjects() { ProjectListModel model = service.GetProjects(); return(View(model)); }
public int CreateNewProject(ProjectListModel project) { string sQuery = "INSERT INTO dbo.ProjectList VALUES (@ProjectName); "; return(_data.SaveData(sQuery, project, _connection.ConnectionStringName)); }
public IActionResult CreateProject(ProjectListModel project) { return(Ok(_project.CreateNewProject(project))); }
public ActionResult ProjectList(ProjectSearchModel searchModel) { var data = _projectService.GetGridAll().ToList(); var model = new ProjectListModel(); model.Data = data; model.Total = data.Count; model.Errors = ""; return(Json(model)); //try //{ // // Initialization. // string search = Request.Form["search[value]"][0]; // string draw = Request.Form["draw"][0]; // string order = Request.Form["order[0][column]"][0]; // string orderDir = Request.Form["order[0][dir]"][0]; // int startRec = Convert.ToInt32(Request.Form["start"][0]); // int pageSize = Convert.ToInt32(Request.Form["length"][0]); // _logger.LogInformation("Call GetGridAll()"); // // Loading. // List<ProjectGridViewModel> data = _projectService.GetGridAll().ToList(); // // Total record count. // int totalRecords = data.Count; // // Verification. // //if (!string.IsNullOrEmpty(search) && // // !string.IsNullOrWhiteSpace(search)) // //{ // // // Apply search // // data = data.Where(p => p.sr.ToString().ToLower().Contains(search.ToLower()) || // // p.ordertracknumber.ToLower().Contains(search.ToLower()) || // // p.quantity.ToString().ToLower().Contains(search.ToLower()) || // // p.productname.ToLower().Contains(search.ToLower()) || // // p.specialoffer.ToLower().Contains(search.ToLower()) || // // p.unitprice.ToString().ToLower().Contains(search.ToLower()) || // // p.unitpricediscount.ToString().ToLower().Contains(search.ToLower())).ToList(); // //} // // Sorting. // //data = this.SortByColumnWithOrder(order, orderDir, data); // // Filter record count. // int recFilter = data.Count; // // Apply pagination. // data = data.Skip(startRec).Take(pageSize).ToList(); // // Loading drop down lists. // var result = this.Json(new { draw = Convert.ToInt32(draw), recordsTotal = totalRecords, recordsFiltered = recFilter, data = data }); // return result; //} //catch (Exception ex) //{ // // Info // Console.Write(ex); // return null; //} }