Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
        }