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));
}
