public HttpResponseMessage UpdateWebsiteTeam(int Id, WebsiteTeamInsertRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } _WebsiteTeamService.WebsiteTeamUpdate(Id, model); return(Request.CreateResponse(HttpStatusCode.OK, "Team Updated Successfully")); }
public HttpResponseMessage AddWebsiteTeam(WebsiteTeamInsertRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } _WebsiteTeamService.WebsiteTeamInsert(model); return(Request.CreateResponse(HttpStatusCode.OK, "Team Successfully Added")); }
public void WebsiteTeamInsert(WebsiteTeamInsertRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.WebsiteTeams_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { 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); 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); SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out id); }); WebsiteTeamInsertRequest bringgTeamCreateRequest = new WebsiteTeamInsertRequest(); bringgTeamCreateRequest.Name = model.Name; bringgTeamCreateRequest.Description = model.Description; bringgTeamCreateRequest.WebsiteTeamId = id; _CreateTeamTask.Execute(bringgTeamCreateRequest); }
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); }