public void Create_Update_Delete_Team() { var team_name = testData.NewTeamName + _rand.Next(99999); var team = new teaminfo { team_name = team_name }; var newTeam = _repo.CreateTeam(team); var user = new LoginAccount { first_name = testData.NewFirstName, last_name = testData.NewLastName, email_address = testData.NewUserEmail, teams = team_name }; var role = testData.NewUserRoles .Select(x => (Roles)x).ToArray(); var newUser = _repo.CreateUser(user, role); var retrievedTeam = _repo.GetTeamInfo(newTeam.team_id, true, false); Assert.IsNotNull(retrievedTeam); team_name = testData.UpdatedTeamName + _rand.Next(99999); retrievedTeam.team_name = team_name; var teaminfo = new teaminfo { team_id = newTeam.team_id, team_name = retrievedTeam.team_name }; var checkTeam = _repo.UpdateTeam(teaminfo); Assert.AreEqual(checkTeam.team_name, team_name); _repo.DeleteTeam(checkTeam.team_id); _repo.DeleteUser(newUser.email_address); var teams = _repo.GetTeams() .SingleOrDefault(x => x.team_name.Equals(team_name)); Assert.IsNull(teams); }
/// <summary> /// 查询combox /// </summary> /// <returns></returns> public List <teaminfo> GetCBO() { string sql = "SELECT* FROM teaminfo"; DataTable dt = DBHelper.ExcuteDateSet(sql); List <teaminfo> list = new List <teaminfo>(); foreach (DataRow item in dt.Rows) { teaminfo info = new teaminfo(); info.id = Convert.ToInt32(item["id"].ToString()); info.teamname = item["teamname"].ToString(); list.Add(info); } return(list); }
public teaminfo UpdateTeam(teaminfo team) { var xml = _wrapper.UpdateTeam(team.team_id, team.team_name); return(XmlParseHelper.Parse <teaminfo>(xml)); }