public void WebsiteTeamDelete(int id, int externalTeamId) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.WebsiteTeams_Delete" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); } ); BringgTeamRequest TeamDelete = new BringgTeamRequest(); TeamDelete.Parent_Team_Id = externalTeamId; _DeleteTeamTask.Execute(TeamDelete); }
public void WebsiteTeamUpdate(int id, WebsiteTeamInsertRequest model) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.WebsiteTeams_Update" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); paramCollection.AddWithValue("@Name", model.Name); paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@WebsiteId", model.WebsiteId); paramCollection.AddWithValue("@ParentTeamId", model.Parent_Team_Id); paramCollection.AddWithValue("@AddressId", model.AddressId); paramCollection.AddWithValue("@OldAddressId", model.OldAddressId); SqlParameter s = new SqlParameter("@WebsiteIds", SqlDbType.Structured); if (model.WebsiteIds != null && model.WebsiteIds.Any()) { s.Value = new IntIdTable(model.WebsiteIds); } paramCollection.Add(s); SqlParameter z = new SqlParameter("@ZipCodes", SqlDbType.Structured); if (model.ZipCodes != null && model.ZipCodes.Any()) { z.Value = new NVarcharTable(model.ZipCodes); } paramCollection.Add(z); } ); BringgTeamRequest TeamUpdate = new BringgTeamRequest(); TeamUpdate.Name = model.Name; TeamUpdate.Description = model.Description; TeamUpdate.Parent_Team_Id = model.ExternalTeamId; _UpdateTeamTask.Execute(TeamUpdate); }