public TeamListDTO GetById(int id)
{
var teams = _teamRepository.GetById(id);
var team = new TeamListDTO()
{
Name = teams.Name,
Modality = teams.Modality,
QtdPlayers = teams.QtdPlayers
};
return(team);
}
public TeamListDTO GetById(string id)
{
var team = _teams.GetById(id);
if (team != null)
{
var result = new TeamListDTO
{
TeamID = team.TeamID,
TeamLeadID = team.TeamLeadID,
TeamName = team.TeamName,
AmountOfEmployees = team.Employees.Count
};
return(result);
}
return(new TeamListDTO());
}
public List <TeamListDTO> GetTeamsList()
{
List <TeamListDTO> retVal = new List <TeamListDTO>();
string tName = "";
byte[] tLogo = new byte[0];
string[] dNames = new string[2];
List <byte[]> dImages = new List <byte[]>();
byte[] carImage = new byte[0];
int i = 0;
using (SqlConnection dbConn = new SqlConnection())
{
dbConn.ConnectionString = CONNECTION_STRING;
dbConn.Open();
string sql = "SELECT t.TeamName, t.TeamLogo, d.Name, d.Image, t.CarImage FROM Team t, Driver d WHERE d.TeamID = t.ID ORDER BY t.TeamName";
SqlCommand cmd = new SqlCommand(sql, dbConn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (i % 2 == 0)
{
tName = reader.GetString(0);
tLogo = reader["TeamLogo"] as byte[];
dNames = new string[2];
dNames[0] = reader.GetString(2);
dImages = new List <byte[]>();
dImages.Add(reader["Image"] as byte[]);
carImage = reader["CarImage"] as byte[];
}
else
{
dNames[1] = reader.GetString(2);
dImages.Add(reader["Image"] as byte[]);
TeamListDTO team = new TeamListDTO(tName, tLogo, dNames, dImages, carImage);
retVal.Add(team);
}
i++;
}
}
return(retVal);
}
public IHttpActionResult GetAllTeams()
{
team[] _teams = null;
using (var context = new escorcenterdbEntities())
{
_teams = (from t in context.teams where t.Enabled select t).OrderBy(x => x.Name).ToArray <team>();
}
if (_teams == null)
{
return(Ok());
}
TeamDTO[] _teamsDTO = AutoMapper.Mapper.Map <team[], TeamDTO[]>(_teams);
TeamListDTO teamList = new TeamListDTO()
{
PageNumber = 1, PageTotal = 1
};
teamList.items.AddRange(_teamsDTO);
return(Ok(teamList));
}
public IHttpActionResult CreateNotification([FromBody] NotificationDTO _notification, TeamListDTO _teamList, LeagueDTO _league)
{
String teamsId = "";
List <TeamDTO> teams = _teamList.items;
foreach (TeamDTO t in teams)
{
teamsId = teamsId + "<" + t.Id + ">";
}
notification n = new notification {
Content = _notification.Content, Date = DateTime.Parse(_notification.Date), Enabled = true, Title = _notification.Title, TeamsId = teamsId, LeagueId = (int)_league.Id
};
using (var context = new escorcenterdbEntities())
{
context.notifications.Add(n);
context.SaveChanges();
}
return(Ok());
}
