public List <WebsiteTeam> WebsiteTeamGet(int websiteId)
{
List <WebsiteTeam> WebsiteTeams = new List <WebsiteTeam>();
DataProvider.ExecuteCmd(GetConnection, "dbo.WebsiteTeams_SelectAll"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@WebsiteId", websiteId);
}
, map : delegate(IDataReader reader, short set)
{
WebsiteTeam w = new WebsiteTeam();
int startingIndex = 0;
w.Id = reader.GetSafeInt32(startingIndex++);
w.Name = reader.GetSafeString(startingIndex++);
w.WebsiteId = reader.GetSafeInt32(startingIndex++);
w.Description = reader.GetSafeString(startingIndex++);
w.Parent_Team_Id = reader.GetSafeInt32(startingIndex++);
w.ExternalTeamId = reader.GetSafeInt32(startingIndex++);
w.AddressId = reader.GetSafeString(startingIndex++);
WebsiteTeams.Add(w);
}
);
return(WebsiteTeams);
}
public HttpResponseMessage DeleteWebsiteTeam(int Id)
{
WebsiteTeam Team = new WebsiteTeam();
Team = _WebsiteTeamService.WebsiteTeamGetById(Id);
_WebsiteTeamService.WebsiteTeamDelete(Id, Team.ExternalTeamId);
return(Request.CreateResponse(HttpStatusCode.OK, "Team Deleted Successfully"));
}
public WebsiteTeam WebsiteTeamGetById(int id)
{
WebsiteTeam w = null;
List <int> Websites = new List <int>();
List <string> ZipCodes = new List <string>();
DataProvider.ExecuteCmd(GetConnection, "dbo.WebsiteTeams_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, map : delegate(IDataReader reader, short set)
{
if (set == 0)
{
w = new WebsiteTeam();
int startingIndex = 0;
w.Id = reader.GetSafeInt32(startingIndex++);
w.Name = reader.GetSafeString(startingIndex++);
w.WebsiteId = reader.GetSafeInt32(startingIndex++);
w.Description = reader.GetSafeString(startingIndex++);
w.Parent_Team_Id = reader.GetSafeInt32(startingIndex++);
w.ExternalTeamId = reader.GetSafeInt32(startingIndex++);
w.AddressId = reader.GetSafeString(startingIndex++);
}
else if (set == 1)
{
int startingIndex = 0;
Websites.Add(reader.GetSafeInt32(startingIndex++));
}
else if (set == 2)
{
int startingIndex = 0;
ZipCodes.Add(reader.GetSafeString(startingIndex++));
}
}
);
w.WebsiteIds = Websites.ToArray();
w.ZipCodes = ZipCodes.ToArray();
return(w);
}
public List <WebsiteTeam> GetAllTeams()
{
List <WebsiteTeam> TeamList = new List <WebsiteTeam>();
DataProvider.ExecuteCmd(GetConnection, "dbo.WebsiteTeams_SelectAllTeams"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
}, map : delegate(IDataReader reader, short set)
{
WebsiteTeam w = new WebsiteTeam();
int startingIndex = 0;
w.Id = reader.GetSafeInt32(startingIndex++);
w.Name = reader.GetSafeString(startingIndex++);
w.WebsiteId = reader.GetSafeInt32(startingIndex++);
w.Description = reader.GetSafeString(startingIndex++);
w.Parent_Team_Id = reader.GetSafeInt32(startingIndex++);
w.ExternalTeamId = reader.GetSafeInt32(startingIndex++);
TeamList.Add(w);
});
return(TeamList);
}
