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