public static Models.Project CreateFromServerToClient(this Project source) { Models.Project project=new Models.Project(); project.ProjectId = source.ProjectId; project.NameE = source.NameE; project.NameA = source.NameA; project.CustomerId = source.CustomerId; project.OrderId = source.OrderId; project.SerialNo = source.SerialNo; project.DescriptionE = source.DescriptionE; project.DescriptionA = source.DescriptionA; project.StartDate = Convert.ToDateTime(source.StartDate).ToString("dd/MM/yyyy", new CultureInfo("en")); project.EndDate = Convert.ToDateTime(source.EndDate).ToString("dd/MM/yyyy", new CultureInfo("en")); project.Price = Convert.ToInt64(source.Price); project.OtherCost = Convert.ToInt64(source.OtherCost); project.Status = source.Status; project.NotesE = source.NotesE; project.NotesA = source.NotesA; project.NotesForCustomerE = source.NotesForCustomerE; project.NotesForCustomerA = source.NotesForCustomerA; project.RecCreatedBy = source.RecCreatedBy; project.RecCreatedDate = source.RecCreatedDate; project.RecLastUpdatedBy = source.RecLastUpdatedBy; project.RecLastUpdatedDate = source.RecLastUpdatedDate; if (source.CustomerId > 0) { project.CustomerNameE = source.Customer.CustomerNameE; project.CustomerNameA = source.Customer.CustomerNameA; } return project; }
public AddProjectForm(Models.Project project, AwesomeContext db) { InitializeComponent(); // TODO: Complete member initialization this.project = project; this.db = db; this.projectBindingSource.Add(project); var clientList = db.Clients.OrderBy(x => x.Name); comboBox1.Items.AddRange(clientList.Select(x => x.Name).ToArray()); comboBox1.SelectedIndex = comboBox1.FindStringExact(project.Client.Name); }
protected void reload_JS(object sender, EventArgs e) { using (var db = new Models.Database()) { // Get current user, HitchBOT and Project this.user = (Models.Password)Session["New"]; this.HitchBOT = db.hitchBOTs.First(l => l.ID == this.user.hitchBOT.ID); this.Project = db.Projects.Where(p => p.EndTime == null).ToArray().Last(); // Create new builder to build JS files GoogleMapsBuilder = new Helpers.Location.GoogleMapsBuilder(this.HitchBOT.ID, this.Project.ID, this.user.ID); // Build JS using GoogleMapsBuilder GoogleMapsBuilder.BuildJsAndUpload(); } }
public void TestDeleteProject_NoProjectAsParameter() { var context = new MockProjectManagerEntities(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { Employee_ID = "414942", First_Name = "ankita", Last_Name = "ghosh", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new MockProjectBC(context)); var result = controller.DeleteProjectDetails(testProject) as JSendResponse; }
public string ValidateProject(Models.Project project) { try { ValidateEmail(project); ValidateCategory(project); ValidateStatus(project); _addressValidation.ValidateAddress(project.Address); project.Location = _addressValidation.GetGeopoint(project.Address); return(string.Empty); } catch (Exception e) { return(e.Message); } }
public void TestUpdateProject_NoProjectAsParameter() { var context = new MockProjectManagerEntities(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { Employee_ID = "549815", First_Name = "Naveen", Last_Name = "Sivaraju", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new BC.ProjectBC(context)); var result = controller.UpdateProjectDetails(testProject) as JSendResponse; }
public void TestDeleteProject_NoProjectAsParameter() { var context = new Test_Project_ManagerContext(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { Employee_ID = "375543", First_Name = "Robert", Last_Name = "Morin", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new BC.ProjectBC(context)); var result = controller.DeleteProjectDetails(testProject) as JSendResponse; }
public async Task <List <Models.Project> > GetProjects() { ProjectContainer container = await networkService.GetProjectsAsync(); List <Models.Project> list = new List <Models.Project>(); for (int i = 0; i < container.total_count; i++) { Models.Project tmp = new Models.Project(); tmp.Description = container.projects[i].description; tmp.Name = container.projects[i].name; tmp.ProjectID = container.projects[i].id; list.Add(tmp); } return(list); }
private static void MapMembers(Models.Project modelProject, Project storageProject) { var membersIds = modelProject.MembersIds ?? new string[0]; storageProject.Members ??= new List <ProjectMember>(); var newMembersIds = membersIds.Where(m => storageProject.Members.All(sm => sm.UserId != m)); storageProject.Members.RemoveAll(m => !membersIds.Contains(m.UserId)); foreach (var memberId in newMembersIds) { storageProject.Members.Add(new ProjectMember() { ProjectId = storageProject.Id, UserId = memberId }); } }
public void TestDeleteProject_NoProjectAsParameter() { var context = new MockProjectManagerEntities(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { Employee_ID = "136600", First_Name = "Sachin", Last_Name = "Kumar", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new BusLayer.ProjectBL(context)); var result = controller.DeleteProjectDetails(testProject) as JsonResponse; }
public async Task <IActionResult> OnGetAsync(Guid?id) { if (id == null) { return(NotFound()); } ProjectSprint = await db.ProjectSprint.FirstOrDefaultAsync(m => m.Id == id); if (ProjectSprint == null) { return(NotFound()); } Project = await db.Project.FirstOrDefaultAsync(w => w.Id == ProjectSprint.ProjectId); return(Page()); }
public void TestDeleteProject_NoProjectAsParameter() { var context = new MockProjectManagerEntities(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { Employee_ID = "730496", First_Name = "Subhasis", Last_Name = "Sarkar", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new BC.ProjectBC(context)); var result = controller.DeleteProjectDetails(testProject) as JSONResponseModel; }
public void TestInsertProject_NoProjectAsParameter() { var context = new MockProjectManagerEntities(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { Employee_ID = "469176", First_Name = "Devanjan", Last_Name = "Bhattacharya", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new BC.ProjectBC(context)); var result = controller.InsertProjectDetails(testProject) as JSendResponse; }
public Models.Project SaveProject(Models.Project project) { Models.Project oldProject = GetProject(project.ProjectUId); if (oldProject == null) { _context.Entry <Models.Project>(project).State = EntityState.Added; } else { _context.Projects.Attach(oldProject); _context.Entry <Models.Project>(oldProject).CurrentValues.SetValues(project); } _context.SaveChanges(true); _log.Log($"Projeto {project.Name} foi criado/alterado."); return(project); }
public Project() { _dictionaryById = new Dictionary <string, Models.Project>(); _dictionaryByServer = new Dictionary <string, Models.Project>(); StreamReader sr = new StreamReader(System.Web.HttpContext.Current.Server.MapPath("~/Server.txt"), Encoding.Default); String line; while ((line = sr.ReadLine()) != null) { string[] item = line.Split(','); var server = new Models.Project { Id = item[0], Name = item[2], Server = item[1] }; _dictionaryById.Add(server.Id.ToLower(), server); _dictionaryByServer.Add(server.Server.ToLower(), server); } sr.Close(); sr.Dispose(); }
public async Task <bool> Update(Models.Project project) { if (project == null) { return(false); } if (project.Id == null) { return(false); } if (project.Id == "") { return(false); } TimeSheetContext.Update(project); await TimeSheetContext.SaveChangesAsync(); return(true); }
public static List <Project> GetWinnersCount(int eventID) { List <Project> projectList = new List <Project>(); try { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "luckydrawapplication20200108092548dbserver.database.windows.net"; builder.UserID = "sqladmin"; builder.Password = "******"; builder.InitialCatalog = "luckywheeldb"; using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT project.ProjectID, MAX(project.ProjectName) AS ProjectName, COUNT(DISTINCT(users.PrizeWon)) AS PrizesWon FROM project INNER JOIN users ON project.ProjectID = users.ProjectID WHERE users.PrizeWon != 0 AND users.EventID = " + eventID + " GROUP BY project.ProjectID"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { connection.Open(); using (SqlDataReader rd = command.ExecuteReader()) { while (rd.Read()) { Models.Project project = new Models.Project(); project.ProjectID = Convert.ToInt32(rd["ProjectID"]); project.ProjectName = rd["ProjectName"].ToString(); project.EventID = eventID; project.NoOfProjects = Convert.ToInt32(rd["PrizesWon"]); projectList.Add(project); } } } } } catch (SqlException e) { Console.WriteLine(e.ToString()); } return(projectList); }
public OperationStatus SaveProject(Models.Project project) { using (DataContext) { if (project.ProjectStatus == Status.Add) { DataContext.Entry(project).State = EntityState.Added; } else { if (project.ProjectStatus == Status.Modify) { DataContext.Entry(project).State = EntityState.Modified; } } return(Save <Models.Project>(project)); } }
protected override Task HandleRequirementAsync(AuthorizationHandlerContext context, ManageEditDetailsProjectRequirements requirement) { ProjectSecurity projectSecurity = new ProjectSecurity(_context, _httpContextAccessor, context, "Project"); string loggedInOwnerId = projectSecurity.LoggedInUser; Models.Project editedRecord = (Models.Project)projectSecurity.EditedRecord; string pmId = _context.Users.Where(x => x.UserName == editedRecord.ProjectManager).Select(x => x.Id).FirstOrDefault(); if (context.User.IsInRole("Admin") || (context.User.IsInRole("ProjectManager") && loggedInOwnerId == pmId) ) { context.Succeed(requirement); } return(Task.CompletedTask); }
public ActionResult Login(string project) { Models.Login model = new Models.Login(); ViewBag.ShowServer = true; if (string.IsNullOrEmpty(project)) { Models.Project pjt = Project.GetInstance().GetFirestProject(); model.Server = pjt.Server; } else if (!string.IsNullOrEmpty(project)) { //StreamReader sr = new StreamReader(System.Web.HttpContext.Current.Server.MapPath("~/Server.txt"), Encoding.Default); //String line; //while ((line = sr.ReadLine()) != null) //{ // string[] item = line.Split(','); // if (item[0].ToLower().Equals(project.ToLower())) // { // model.Server = item[1].Replace(":6699",""); // //ViewBag.ShowServer = false; // break; // } //} //sr.Close(); //sr.Dispose(); var server = BLL.Project.GetInstance().GetById(project); if (server != null) { model.Server = server.Server;//.Replace(":6699", ""); } } else { var server = System.Web.HttpContext.Current.Request.Cookies["Server"]; model.Server = server != null ? server.Value : ""; } var userName = System.Web.HttpContext.Current.Request.Cookies["UserName"]; model.UserName = userName != null ? userName.Value : ""; //model.PassWord = "******"; return(View(model)); }
public void btnSubmit_Click(Object sender, EventArgs e) { if (Page.IsValid) { using (var context = new DatabaseContext()) { Models.Project project = new Models.Project() { Title = txtTitle.Text, Description = txtDescription.Text, URL = txtURL.Text, ProjectMembers = new List <ProjectMember>() }; if (fuPoster.HasFile) { try { string filename = Guid.NewGuid().ToString() + Path.GetExtension(fuPoster.FileName); fuPoster.SaveAs(Server.MapPath("/Content/Posters/") + filename); project.Poster = filename; } catch (Exception) { } } project.ProjectMembers.Add(new ProjectMember() { Project = project, Student = context.Student .Single(s => s.ID == CurrentStudent.ID), Role = "Leader", Reflection = txtReflections.Text }); context.Add(project); context.SaveChanges(); Response.Redirect("/Pages/Controls/Student/UpdateProjects.aspx"); } } }
private static IEnumerable <ProjectOwnershipLinkViewModel> ToLinksResolver(Models.Project project) { return(null); //var links = new List<ProjectOwnershipLinkViewModel>(); //foreach (var projectCompany in project.ProjectCompanies) //{ // links.AddRange( // projectCompany.DependentProjectCompanyFactShares // .Where(x => x.ShareFactPart > 0) // .Select( // share => new ProjectOwnershipLinkViewModel() // { // SourceId = share.OwnerProjectCompanyId, // TargetId = share.DependentProjectCompanyId, // Share = share.ShareFactPart // })); //} //return links; }
public ActionResult CreateProject() { if (!permissionService.Authorize(StandardPermissionProvider.ProjectBudgetManage)) { return(AccessDeniedView()); } Models.Project project = new Models.Project(); project.EntityProject = new Project(); _donors = projectService.GetDonors(countryProg.Id); _currencies = orderRequestService.GetCurrencies(); project.Donors = new SelectList(_donors, "Id", "Name"); project.Currencies = new SelectList(_currencies, "Id", "Name", countryProg.Country.CurrencyId); project.StaffList = new SelectList(staffService.GetStaffByCountryProgramme(countryProg.Id), "StaffId", "StaffName"); project.StartDate = project.EndDate = DateTime.Now; ViewBag.FormHeader = Resources.BudgetController_String_NewProject; ViewBag.ButtonText = Resources.BudgetController_String_AddProject; ViewBag.EditMode = 0; return(View(project)); }
public async Task <IActionResult> OnGetAsync(int id) { const string indexPage = "/Index"; Solution = await _db.Solutions.FindAsync(id); if (Solution == null) { return(RedirectToPage(indexPage)); } Project = await _db.Projects.FindAsync(Solution.IdProject); if (Project == null) { return(RedirectToPage(indexPage)); } return(Page()); }
public void TestDeleteProject_NoProjectAsParameter() { var context = new MockProjectManagerEntities(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { Employee_ID = "414942", First_Name = "Raj", Last_Name = "Aryan", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new BC.ProjectBC(context)); var ex = Assert.Throws <ArgumentNullException>(() => controller.DeleteProjectDetails(testProject)); Assert.That(ex.Message, Is.Not.Null); }
public PerformanceMeasuresViewData(Person currentPerson, Models.Project project, ViewDataForAngularEditor viewDataForAngularEditor, ProposalSectionsStatus proposalSectionsStatus) : base(currentPerson, project, ProjectCreateSection.ReportedPerformanceMeasures.ProjectCreateSectionDisplayName, proposalSectionsStatus) { RefreshUrl = SitkaRoute <ProjectUpdateController> .BuildUrlFromExpression(x => x.RefreshPerformanceMeasures(project)); DiffUrl = SitkaRoute <ProjectUpdateController> .BuildUrlFromExpression(x => x.DiffPerformanceMeasures(project)); var performanceMeasureActuals = project.GetReportedPerformanceMeasures(); var performanceMeasureSubcategoriesCalendarYearReportedValues = PerformanceMeasureSubcategoriesCalendarYearReportedValue.CreateFromPerformanceMeasuresAndCalendarYears(new List <IPerformanceMeasureReportedValue>(performanceMeasureActuals)); PerformanceMeasureReportedValuesSummaryViewData = new PerformanceMeasureReportedValuesSummaryViewData(performanceMeasureSubcategoriesCalendarYearReportedValues, project.GetPerformanceMeasuresExemptReportingYears().Select(x => x.CalendarYear).ToList(), project.PerformanceMeasureActualYearsExemptionExplanation, performanceMeasureActuals.Select(x => x.CalendarYear).Distinct().Select(x => new CalendarYearString(x)).ToList()); ViewDataForAngular = viewDataForAngularEditor; IsImplementationStartYearValid = project.GetImplementationStartYear().HasValue&& project.GetImplementationStartYear() < project.GetCompletionYear(); ReportingYearLabel = "Year"; }
public JsonResult Add(object[] data) { string projectName = data[0].ToString(); int userId = Convert.ToInt32(data[1]); var project = new Models.Project { Name = projectName, UserId = userId, User = db.Users.Find(userId) }; db.Projects.Add(project); try { db.SaveChanges(); } catch (DbUpdateException ex) { //TODO } return(Json(Helper.ToJson(project))); }
public async void RefreshList() { Loading = true; var projectList = await Utilities.API.GetProjects(Utilities.User.Token); Projects.Clear(); foreach (Models.JsonModels.JsonProject p in projectList) { var project = new Models.Project() { Progress = new Random().NextDouble() }; Projects.Add(project); } Loading = false; }
public async Task <IActionResult> Get() { List <Project> project_ = new List <Project>(); var Project = await(from data in _context.Project select new { ProjectId = data.ProjectId, ProjectName = data.ProjectName }).ToListAsync(); Project.ForEach(x => { Project pro = new Models.Project(); pro.ProjectId = x.ProjectId; pro.ProjectName = x.ProjectName; project_.Add(pro); }); return(Json(project_)); }
public void TestDeleteProject_NoProjectAsParameter() { var context = new MockProjectManagerEntities(); var users = new TestDbSet <DAC.User>(); users.Add(new DAC.User() { First_Name = "User4FName", Last_Name = "User4LName", Employee_ID = "100001", User_ID = 123, Task_ID = 123 }); context.Users = users; Models.Project testProject = null; var controller = new ProjectController(new BC.ProjectBC(context)); Assert.That(() => controller.DeleteProjectDetails(testProject), Throws.TypeOf <ArgumentNullException>()); }
public ActionResult SaveProject(Models.Project project) { string pdId = ""; project.EntityProject.ProjectNumber = project.ProjectNumber; project.EntityProject.CountryProgrammeId = countryProg.Id; ViewBag.ProjectNumber = project.ProjectNumber; if (project.Id == null || project.Id.Trim() == Guid.Empty.ToString().Trim()) { projectService.CreateProject(project.EntityProject); projectService.CreateProjectDonor(project.EntityProject, project.StartDate, project.EndDate, project.ProjectManagerId, project.DonorId, project.CurrencyId, project.OverrunAdjustment, ref pdId); if (pdId == null) { _donors = projectService.GetDonors(countryProg.Id); _currencies = projectService.GetCurrencies(countryProg.Id); project.Donors = new SelectList(_donors, "Id", "Name"); project.Currencies = new SelectList(_currencies, "Id", "Name"); ViewBag.FormHeader = Resources.BudgetController_String_NewProject; ViewBag.ButtonText = Resources.BudgetController_String_AddProject; ViewBag.EditMode = 0; ViewBag.Status = 0; return(View("CreateProject", project)); } } else { projectService.UpdateProject(project.EntityProject); projectService.UpdateProjectDonor(project.Id, project.EntityProject.ProjectNumber, project.StartDate, project.EndDate, project.ProjectManagerId, project.DonorId, project.CurrencyId, project.OverrunAdjustment, ref pdId); } if (pdId != null) { ViewBag.Status = 1; ViewBag.Id = pdId; } else { ViewBag.Status = 0; return(EditProject(new Guid(project.Id))); } return(EditProject(new Guid(pdId))); }
public async Task AddNewProject_ReturnsCreatedProject() { var username = _fixture.Create <string>(); var project = new Models.Project { Name = _fixture.Create <string>() }; var commandController = new CommandProcessor(); commandController.CiDashboardService = this.ciDashboardService; var result = await commandController.AddNewProject(username, project); A.CallTo(() => this.ciDashboardService.AddProject(username, A <Project> .That.Matches(p => p.Name == project.Name))) .MustHaveHappened(); result.Should() .NotBeNull() .And.BeOfType <Models.Project>(); }
public override int InsertProjectDetails(Models.Project project) { DAC.Project proj = new DAC.Project() { Project1 = project.ProjectName, Start_Date = project.ProjectStartDate, End_Date = project.ProjectEndDate, Priority = project.Priority }; _mockBd.Projects.Add(proj); var editDetails = (from editUser in _mockBd.Users where editUser.User_ID.ToString().Contains(project.User.UserId.ToString()) select editUser).First(); // Modify existing records if (editDetails != null) { editDetails.Project_ID = proj.Project_ID; } return(1); }
public Models.Project createNewProject(Models.User creator, Models.Company company, Models.Project toCreate) { Models.Project newProject = new Models.Project() { ID = Guid.NewGuid(), Name = toCreate.Name, Description = toCreate.Description, CreatedDate = DateTime.UtcNow, CreatedBy = creator, AssignedUsers = new List<Models.User>(), BillableItems = new List<Models.BillingType>(), ProjectFiles = new List<Models.FileRevision>(), ProjectFolders = new List<Models.FileFolder>(), ReleaseList = new List<Models.Release>() }; SQLProject sqlProject = new SQLProject() { CompanyId = company.ID, CreatedByUserId = creator.ID, CreatedDate = newProject.CreatedDate, Description = newProject.Description, Name = newProject.Name, ID = newProject.ID }; db.SQLProjects.Add(sqlProject); db.SaveChanges(); return newProject; }
public Models.Project loadProjectById(Guid projectId) { SQLProject foundSQLProject = db.SQLProjects.FirstOrDefault(x => x.ID == projectId); Models.Project foundProject = new Models.Project() { AssignedUsers = new List<Models.User>(), BillableItems = new List<Models.BillingType>(), CreatedBy = loadUserById(foundSQLProject.CreatedByUserId, false), CreatedDate = foundSQLProject.CreatedDate, Description = foundSQLProject.Description, ID = foundSQLProject.ID, Name = foundSQLProject.Name, ProjectFiles = new List<Models.FileRevision>(), ProjectFolders = new List<Models.FileFolder>(), ReleaseList = loadProjectReleases(projectId) }; return foundProject; }