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