public void PersistProject() { UserModel user = new UserModel(); user.Name = "admin"; user.Pswd = "admin"; user.Privileges = UserModel.UserPrivileges.ADMIN; user.Id = user.Persist(); ProjectModel project = new ProjectModel(); project.Name = "projectName"; project.Description = "description"; project.Active = true; ActivityModel activity = new ActivityModel(); activity.Name = "name"; activity.Description = "desc"; activity.PlannedStart = new DateTime(); activity.PlannedFinish = new DateTime(); activity.ActualStart = new DateTime(); activity.ActualFinish = new DateTime(); project.Activities.Add(activity); project.Persist(); project.AssignUser(user, Role.LEAD); project.Activities[0].AssignUser(user.Id); project.Activities[0].UpdateProgress(user.Id, 100, "finish"); //project.Activities[0].RemoveUser(user.Id); }
private void button2_Click(object sender, EventArgs e) { this.dataGridView2.DataSource = null; this.dataGridView2.Rows.Clear(); Repository repository4 = new Repository(); List<ProjectUser> project4 = repository4.GetAll<ProjectUser>(); ProjectUser prj4 = new ProjectUser(); Repository repository5 = new Repository(); List<ActivityModel> project5 = repository5.GetAll<ActivityModel>(); ActivityModel prj5 = new ActivityModel(); Repository repository6 = new Repository(); List<ProjectUser> project6 = repository6.GetAll<ProjectUser>(); ProjectUser prj6 = new ProjectUser(); Repository repository7 = new Repository(); List<UserActivity> project7 = repository7.GetAll<UserActivity>(); UserActivity prj7 = new UserActivity(); string idproyecto = comboBox4.SelectedIndex + ""; string role; string usname; string prname; string practive; foreach (ProjectUser pr in project4){ if(pr.Project.Id==(comboBox4.SelectedIndex + 1)){ foreach (ActivityModel am in project5) { if (pr.Project.Id == am.projectid ) { idfinal = am.Id + ""; proact = am.Name + ""; foreach (UserActivity ua in project7) { if ((idfinal.Equals(ua.ActivityId + "")) && pr.Project.Id == ua.ProjectId) { userfinal = ua.UserId + ""; if ((pr.User.Id + "").Equals(userfinal)) { role = pr.Role + ""; usname = pr.User.Name + ""; prname = pr.Project.Name + ""; practive = pr.Project.Active + ""; dataGridView2.Rows.Add(new object[] { prname, usname, role, proact, practive }); } } } } } } } }
private void Form1_Load(object sender, EventArgs e) { Repository repository2 = new Repository(); List<ProjectModel> project2 = repository2.GetAll<ProjectModel>(); ProjectModel prj2 = new ProjectModel(); Repository repositoryallus = new Repository(); List<UserModel> allusers = repositoryallus.GetAll<UserModel>(); UserModel allus = new UserModel(); Repository repository3 = new Repository(); List<ActivityModel> project3 = repository3.GetAll<ActivityModel>(); ActivityModel prj3 = new ActivityModel(); Repository repository4 = new Repository(); List<ProjectUser> project4 = repository4.GetAll<ProjectUser>(); ProjectUser prj4 = new ProjectUser(); if (m_connection == null) { m_connection = new MySqlConnection(string.Format("SERVER={0};DATABASE={1};UID={2};PASSWORD={3}", SERVER, DATABASE, USERNAME, PASSWORD)); } foreach (UserModel usr2 in allusers) { comboBox10.Items.Add(usr2.Name); comboBox10.SelectedItem = usr2.Id; } foreach (ProjectUser pr in project4) { string idchingon = pr.User.Id + "" ; string idchingon2 = pr.Project.Id + ""; string idcurrent = m_currentUser.Id + ""; if (pr.User.Id== m_currentUser.Id) { foreach (ProjectModel pm in project2) { if (pm.Id == pr.Project.Id) { comboBox5.Items.Add(pm.Name); comboBox5.SelectedItem = comboBox5.FindStringExact(pm.Id +""); comboBox11.Items.Add(pm.Name); comboBox11.SelectedItem = comboBox5.FindStringExact(pm.Id + ""); comboBox4.Items.Add(pm.Name); comboBox4.SelectedItem = comboBox4.FindStringExact(pm.Id + ""); } } } } }
private void comboBox7_SelectedIndexChanged(object sender, EventArgs e) { Repository repository9 = new Repository(); List<ActivityModel> project9 = repository9.GetAll<ActivityModel>(); ActivityModel prj9 = new ActivityModel(); foreach (ActivityModel amo in project9) { string ab = comboBox7.SelectedItem + ""; if (ab.Equals(amo.Name)) { idactividadt2 = amo.Id + ""; } } Repository repository6 = new Repository(); List<UserActivity> project6 = repository6.GetAll<UserActivity>(); UserActivity prj6 = new UserActivity(); foreach (UserActivity ua in project6) { if (ua.ActivityId == Convert.ToInt32(idactividadt2)) { textBox7.Text = ua.Progress + ""; } } }
private void comboBox5_SelectedIndexChanged(object sender, EventArgs e) { comboBox7.Items.Clear(); progressBar1.Increment(0); contador = 0; acum = 0; progressBar1.Value = 0; Repository repository2 = new Repository(); List<UserActivity> project2 = repository2.GetAll<UserActivity>(); UserActivity prj2 = new UserActivity(); Repository repository3 = new Repository(); List<ProjectUser> project3 = repository3.GetAll<ProjectUser>(); ProjectUser prj3 = new ProjectUser(); Repository repository4 = new Repository(); List<ActivityModel> project4 = repository4.GetAll<ActivityModel>(); ActivityModel prj4 = new ActivityModel(); Repository repository10 = new Repository(); List<ProjectModel> project10 = repository10.GetAll<ProjectModel>(); ProjectModel prj10 = new ProjectModel(); foreach (ProjectModel amo1 in project10) { string ab = comboBox5.SelectedItem + ""; if (ab.Equals(amo1.Name)) { idactividadt3 = amo1.Id + ""; } } foreach (UserActivity uact in project2) { if (idactividadt3.Equals(uact.ProjectId+"")&&m_currentUser.Id == uact.UserId) { acum = acum + Convert.ToInt32(uact.Progress); contador = contador + 1; } } if (contador == 0) { acum =0; } else { acum /= contador; } progressBar1.Increment(acum); foreach (ProjectUser pm in project3) { if (pm.Project.Name == comboBox5.Text) { foreach (UserActivity ua in project2) { if (m_currentUser.Id == ua.UserId) { foreach (ActivityModel act in project4) { if (ua.ActivityId == act.Id && ua.ProjectId == pm.Project.Id) { comboBox7.Items.Add(act.Name); comboBox7.SelectedItem = act.Id; } } //break; } } break; } } }
private void button7_Click(object sender, EventArgs e) { Repository repository8 = new Repository(); List<ActivityModel> project8 = repository8.GetAll<ActivityModel>(); ActivityModel prj8 = new ActivityModel(); foreach (ActivityModel amo in project8) { string ab = comboBox7.SelectedItem + ""; if (ab.Equals(amo.Name)) { idactividadt = amo.Id + ""; } } string dbConnectionString = "Server=localhost;Database=pmsys_db;Uid=root;Password=MySQL"; int temp = Convert.ToInt32(textBox7.Text); MySqlConnection db = new MySqlConnection(dbConnectionString); MySqlCommand dbCommand = db.CreateCommand(); dbCommand.CommandText = "UPDATE users_has_activities SET usr_act_progress=" + temp + " WHERE activities_act_id=" + idactividadt + " AND users_usr_id=" + m_currentUser.Id; db.Open(); dbCommand.ExecuteNonQuery(); db.Close(); Repository repository4 = new Repository(); List<UserActivity> project4 = repository4.GetAll<UserActivity>(); UserActivity prj4 = new UserActivity(); Repository repository5 = new Repository(); List<ProjectModel> project5 = repository5.GetAll<ProjectModel>(); ProjectModel prj5 = new ProjectModel(); Repository repository6 = new Repository(); List<ActivityModel> project6 = repository6.GetAll<ActivityModel>(); ActivityModel prj6 = new ActivityModel(); foreach(UserActivity ua in project4) { if (ua.ActivityId == (comboBox7.SelectedIndex)+1) { // ua.Progress = Convert.ToInt32(textBox7.Text); prj6.UpdateProgress(ua.UserId,Convert.ToInt32(textBox7.Text),"yeah"); //UpdateProgress(Int32? userId, int progress, string comments) // ua.Activities[0].UpdateProgress(user.Id, 100, "finish"); } } //comboBox7 }
private void button6_Click(object sender, EventArgs e) { bool valid = false; bool exist = false; ProjectModel project = new ProjectModel(); if (comboBox11.Text == "" || label19.Text == "DEVELOPER") { System.Windows.Forms.MessageBox.Show("You must select a project and have the LEAD role"); } else { if (m_currentUser.Privileges.Equals(UserModel.UserPrivileges.ADMIN)) { if (monthCalendar4.SelectionEnd.Date <= monthCalendar3.SelectionEnd.Date) { Repository repository = new Repository(); List<ProjectModel> projects = repository.GetAll<ProjectModel>(); ProjectModel prj7 = new ProjectModel(); Repository repository2 = new Repository(); List<UserModel> userList = repository2.GetAll<UserModel>(); UserModel prj8 = new UserModel(); foreach (ProjectModel pr in projects) { if(pr.Name.Equals(comboBox11.Text)) { ActivityModel activity = new ActivityModel(); activity.Name = textBox6.Text; activity.Description = textBox5.Text; activity.PlannedStart = monthCalendar1.SelectionEnd; activity.PlannedFinish = monthCalendar2.SelectionEnd; pr.Activities.Add(activity); pr.Persist(); foreach (UserModel usr in userList) { if(usr.Name.Equals(comboBox10.Text)) { usr2 = usr; activity.AssignUser(usr.Id); Repository repository3 = new Repository(); List<ProjectUser> users = repository3.GetAll<ProjectUser>(); ProjectUser prj9 = new ProjectUser(); foreach (ProjectUser ex in users) { if (ex.User.Name.Equals(comboBox10.Text)) { if (ex.Project.Id == (1 + comboBox11.SelectedIndex)) { //System.Windows.Forms.MessageBox.Show("User already exists."); valid = true; exist = true; break; } } } break; } } if (exist == false) { pr.AssignUser(usr2, pmsys_sim_engine.models.Role.DEVELOPER); } } } } else { System.Windows.Forms.MessageBox.Show("End date can not be prior to Start date"); } } } }
private void button5_Click(object sender, EventArgs e) { ProjectModel project2 = new ProjectModel(); ActivityModel activity = new ActivityModel(); activity.Name = textBox3.Text; activity.Description = textBox4.Text; activity.PlannedStart = new DateTime(); activity.PlannedFinish = new DateTime(); activity.ActualStart = new DateTime(); activity.ActualFinish = new DateTime(); project2.Activities.Add(activity); //project2.Activities[0].AssignUser(); }
private void button4_Click(object sender, EventArgs e) { if (m_currentUser.Privileges.Equals(UserModel.UserPrivileges.ADMIN)) { if (monthCalendar1.SelectionEnd.Date <= monthCalendar2.SelectionEnd.Date) { ProjectUser user1 = new ProjectUser(); ProjectModel project1 = new ProjectModel(); project1.Name = textBox1.Text; project1.Description = textBox2.Text; project1.Active = true; ActivityModel activity = new ActivityModel(); activity.Name = textBox3.Text; activity.Description = textBox4.Text; activity.PlannedStart = monthCalendar1.SelectionEnd; activity.PlannedFinish = monthCalendar2.SelectionEnd; project1.Activities.Add(activity); project1.Persist(); project1.Activities[0].AssignUser(m_currentUser.Id); project1.AssignUser(m_currentUser, pmsys_sim_engine.models.Role.LEAD); System.Windows.Forms.MessageBox.Show("Project correctly created"); } else { System.Windows.Forms.MessageBox.Show("End date can not be prior to Start date"); } } else { System.Windows.Forms.MessageBox.Show("Just the admin can create projects"); } }
private T CreateModel <T>(MySqlDataReader dataReader) { Type modelType = typeof(T); if (modelType == typeof(UserModel)) { UserModel user = new UserModel(); user.Id = dataReader.GetInt32(0); user.Name = dataReader.GetString(1); user.Pswd = dataReader.GetString(2); user.Privileges = (UserModel.UserPrivileges) Enum.Parse(typeof(UserModel.UserPrivileges), dataReader.GetString(4)); return((T)Convert.ChangeType(user, typeof(T))); } else if (modelType == typeof(ProjectModel)) { ProjectModel projectModel = new ProjectModel(); projectModel.Id = dataReader.GetInt32(0); projectModel.Name = dataReader.GetString(1); projectModel.Description = dataReader.IsDBNull(2) ? null : dataReader.GetString(2); return((T)Convert.ChangeType(projectModel, typeof(T))); } else if (modelType == typeof(ActivityModel)) { ActivityModel activity = new ActivityModel(); activity.Id = dataReader.GetInt32(0); activity.Name = dataReader.GetString(1); activity.Description = dataReader.IsDBNull(2) ? null : dataReader.GetString(2); activity.PlannedStart = dataReader.GetDateTime(3); activity.PlannedFinish = dataReader.GetDateTime(4); activity.ActualStart = dataReader.IsDBNull(5) ? (DateTime?)null : dataReader.GetDateTime(5); activity.ActualFinish = dataReader.IsDBNull(6) ? (DateTime?)null : dataReader.GetDateTime(6); activity.projectid = dataReader.GetInt32(7); return((T)Convert.ChangeType(activity, typeof(T))); } else if (modelType == typeof(ProjectUser)) { ProjectUser projectUser = new ProjectUser(); projectUser.Project.Id = dataReader.GetInt32(0); projectUser.Project.Name = dataReader.GetString(1); projectUser.Project.Description = dataReader.IsDBNull(2) ? null : dataReader.GetString(2); projectUser.Project.Active = dataReader.GetBoolean(3); projectUser.User.Name = dataReader.IsDBNull(5) ? null : dataReader.GetString(5); projectUser.User.Id = dataReader.IsDBNull(4)? (int?)null : dataReader.GetInt32(4); projectUser.User.Privileges = dataReader.IsDBNull(6) ? (UserModel.UserPrivileges?) null: (UserModel.UserPrivileges)Enum.Parse(typeof(UserModel.UserPrivileges), dataReader.GetString(6)); projectUser.Role = dataReader.IsDBNull(7) ?(Role?)null : (Role)Enum.Parse(typeof(Role), dataReader.GetString(7)); projectUser.User.Active = dataReader.IsDBNull(8) ? false : dataReader.GetBoolean(8); return((T)Convert.ChangeType(projectUser, typeof(T))); } else if (modelType == typeof(UserActivity)) { UserActivity userAct = new UserActivity(); userAct.UserId = dataReader.GetInt32(0); userAct.ActivityId = dataReader.GetInt32(1); userAct.ProjectId = dataReader.GetInt32(2); userAct.Progress = dataReader.GetInt32(3); userAct.Comments = dataReader.IsDBNull(4) ? null : dataReader.GetString(4); return((T)Convert.ChangeType(userAct, typeof(T))); } return(default(T)); }