public ActionResult Post([FromBody] AddCondominiumRequestModel model)
{
try
{
var condominium = new Condominium()
{
CreatedAt = today,
Status = model.Status,
UpdatedAt = today,
Name = model.Name,
Address = model.Address,
PhotoUrl = model.PhotoUrl,
SecretCode = model.SecretCode,
};
_condominiumService.Add(condominium);
response.StatusCode = StatusCodes.Status200OK;
response.Status = "OK";
response.Message = "Condominio agregado";
return(Ok(response));
}
catch (Exception e)
{
response.StatusCode = StatusCodes.Status400BadRequest;
response.Status = "BAD REQUEST";
response.Message = e.Message;
return(BadRequest(response));
}
}
public ICommandResult Handle(CreateCondominiumCommand command)
{
// Fail Fast Validation
command.Validate();
if (command.Invalid)
{
return(new GenericCommandResult(false, "Ops, erro ao cadastrar condomínio.", command.Notifications));
}
// Cria condomínio
var condominium = new Condominium(command.Name, command.Street, command.Number, command.Neighborhood, command.City, command.State, command.Country, command.ZipCode, command.User);
try
{
// Salva condomínio
_repository.Create(condominium);
}
catch (Exception ex)
{
return(new GenericCommandResult(false, "Erro inesperado!", ex.Message));
}
var condominiumResult = new CondominiumCommandResult
{
City = condominium.City,
Country = condominium.Country,
Name = condominium.Name,
Neighborhood = condominium.Neighborhood,
Number = condominium.Number,
State = condominium.State,
Street = condominium.Street
};
return(new GenericCommandResult(true, "Condomínio salvo com sucesso!", condominiumResult));
}
public async Task <IActionResult> Put(int condominiumId, Condominium model)
{
try
{
//verifica se o registro existe para realizar atualização
var condominium = await _repo.GetCondominiumAsyncById(condominiumId);
if (condominium == null)
{
return(NotFound());
}
_repositoryContext.Update(model);
if (await _repositoryContext.SaveChanges())
{
return(Created($"/api/condominium/{model.Id}", model));
}
}
catch (System.Exception ex)
{
return(this.StatusCode(StatusCodes.Status500InternalServerError,
$"Banco de dados sem acesso. {ex.Message}"));
}
return(BadRequest());
}
public FakeApartmentRepository()
{
_items = new List <Apartment>();
var condominium = new Condominium("Condomínio 1", "Rua do condominio", 1925, "Bairro do condominio", "Cidade do Condominio", "MG", "Brasil", "31035560", "Pedro Ivo");
_items.Add(new Apartment(condominium, 101, "Bloco 1", "Pedro Ivo"));
_items.Add(new Apartment(condominium, 102, "Bloco 1", "Pedro Ivo"));
_items.Add(new Apartment(condominium, 103, "Bloco 1", "Pedro Ivo"));
_items.Add(new Apartment(null, 101, "Bloco 1", "Pedro Ivo"));
}
public Condominium Update(Condominium condominium)
{
var entity = Condominiums
.First(x => x.Id == condominium.Id);
entity.Address = Entities.Address.FromModel(condominium.Address);
entity.Name = condominium.Name;
DbContext.SaveChanges();
return(entity.ToModel());
}
public ActionResult <ObjectResult> UpdateCondominium([FromBody] Condominium condominium)
{
try
{
CondominiumService condominiumService = new CondominiumService(Startup.BeePlaceDataBaseConnectionString);
condominiumService.UpdateCondominium(condominium);
return(StatusCode((int)HttpStatusCode.OK, condominium));
}
catch (Exception e)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, e.Message));
}
}
public Condominium Create(Condominium condominium)
{
var entity = new Entities.Condominium()
{
Address = Entities.Address.FromModel(condominium.Address),
Name = condominium.Name,
Owner = User
};
DbContext.Add(entity);
DbContext.SaveChanges();
return(entity.ToModel());
}
// GET: Condominiums/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Condominium condominiumDomainModel = _condominiumRepo.Read(new int[] { id.Value }).FirstOrDefault();
if (condominiumDomainModel == null)
{
return(HttpNotFound());
}
return(View(_mapCondominium2CondominiumMV.Run(condominiumDomainModel)));
}
// GET: Condominiums/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Condominium condominiumDomainModel = _condominiumRepo.Delete(new int[] { id.Value }).FirstOrDefault();
if (condominiumDomainModel == null)
{
return(HttpNotFound());
}
return(RedirectToAction("Index"));
}
public void InsertCondominium(Condominium condominium)
{
using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
try
{
StandartPersistence standartPersistence =
new StandartPersistence(this.Connection);
// Aceitou os termos
if (condominium.CondominiumManager.AcceptedTerms)
{
standartPersistence.Insert <Condominium>(condominium);
condominium.CondominiumManager.IdCondominium = condominium.Id;
standartPersistence.Insert <CondominiumManager>(condominium.CondominiumManager);
if (condominium.Address != null)
{
condominium.Address.DateCreated = DateTime.Now;
condominium.Address.DateUpdated = DateTime.Now;
standartPersistence.Insert <Address>(condominium.Address);
standartPersistence.Execute(CommandType.Text,
"INSERT INTO CondominiumAddress Values (@Id, @IdAddress)",
new
{
Id = condominium.Id,
IdAddress = condominium.Address.Id
});
}
transactionScope.Complete();
}
else
{
throw new System.Exception("Não aceitou os termos.");
}
}
catch (SqlException e)
{
throw e;
}
catch (TransactionException e)
{
throw e;
}
}
}
public async Task <IActionResult> Post(Condominium condominium)
{
try
{
_repositoryContext.Add(condominium);
if (await _repositoryContext.SaveChanges())
{
return(Created($"/api/condominium/{condominium.Id}", condominium));
}
}
catch (System.Exception ex)
{
return(this.StatusCode(StatusCodes.Status500InternalServerError,
$"Banco de dados sem acesso. {ex.Message}"));
}
return(BadRequest());
}
public Condominium Validate(string cnpj)
{
try
{
var condominium = new Condominium();
ReceitaWS receitaWS = new ReceitaWS();
ReceitaWSRoot receitaWSRoot = ReceitaWS.Validate(cnpj);
condominium.Name = receitaWSRoot.nome.ToUpper();
condominium.Phone = receitaWSRoot.telefone;
condominium.CNPJ = receitaWSRoot.cnpj.Replace("/", "").Replace(".", "").Replace("-", "");
// Localização
ViaCEPRoot viaCEPRoot = new ViaCEPRoot();
viaCEPRoot = ViaCEP.Validate(receitaWSRoot.cep.Replace("/", "").Replace(".", "").Replace("-", ""));
if (viaCEPRoot != null)
{
condominium.Address = new Address();
condominium.Address.Zip = viaCEPRoot.cep.Replace("-", "").Replace(".", "");
condominium.Address.Street = viaCEPRoot.logradouro;
condominium.Address.District = viaCEPRoot.bairro;
StandartPersistence standartPersistence =
new StandartPersistence(this.Connection);
condominium.Address.State = standartPersistence.GetEntities <State>(CommandType.Text,
"SELECT IdEstate, UPPER(Name) AS Name, UF FROM State WHERE UF = @UF",
new { UF = viaCEPRoot.uf.ToUpper() }).SingleOrDefault();
var city = standartPersistence.GetEntities <City>(CommandType.Text,
"SELECT IdCity, Name, IdEstate FROM City WHERE Name = @Name", new { Name = TextFormat.RemoveAccentuation(viaCEPRoot.localidade.ToUpper()) }).SingleOrDefault();
condominium.Address.State.Cities = new List <City>();
condominium.Address.State.Cities.Add(city);
condominium.Address.IdEstate = condominium.Address.State.IdEstate;
condominium.Address.IdCity = condominium.Address.State.Cities[0].IdCity;
}
return(condominium);
}
catch (Exception e)
{
throw e;
}
}
public List <CondominiumInternalTower> ListTowers(Condominium condominium)
{
try
{
StandartPersistence standartPersistence =
new StandartPersistence(this.Connection);
var condominiumInternalTowers = standartPersistence.GetEntities <CondominiumInternalTower>(CommandType.Text,
"SELECT * FROM CondominiumInternalTower WHERE IdCondominium = @Id",
new { condominium.Id }).ToList();
return(condominiumInternalTowers);
}
catch (SqlException e)
{
throw e;
}
}
public CondominiumSecurityCompany GetSecurityCompany(Condominium condominium)
{
try
{
StandartPersistence standartPersistence =
new StandartPersistence(this.Connection);
var condominiumSecurityCompany = standartPersistence.GetEntities <CondominiumSecurityCompany>(CommandType.Text,
"SELECT * FROM CondominiumSecurityCompany WHERE IdCondominium = @Id",
new { Id = condominium.Id }).SingleOrDefault();
return(condominiumSecurityCompany);
}
catch (SqlException e)
{
throw e;
}
}
public void UpdateCondominium(Condominium condominium)
{
try
{
StandartPersistence standartPersistence =
new StandartPersistence(this.Connection);
standartPersistence.Update <Condominium>(condominium);
if (condominium.Address != null)
{
standartPersistence.Update <Address>(condominium.Address);
}
}
catch (SqlException e)
{
throw e;
}
}
public CondominiumDbSeed(SgConContext context) : base(context)
{
if (!context.Condominiums.Any())
{
List <Condominium> condominiuns = new List <Condominium>();
Condominium condominiumOne = new Condominium
{
Id = 1,
Name = "Condomínio 1",
Cnpj = "85351161000182",
Email = "*****@*****.**",
DDDComercialPhone = "11",
ComercialPhone = "12345678",
TowerNumber = 2,
Address = context.Addresses.Find(1),
CreatedBy = "Sistema",
CreatedAt = DateTime.Now
};
condominiuns.Add(condominiumOne);
Condominium condominiumTwo = new Condominium
{
Id = 2,
Name = "Condomínio 2",
Cnpj = "85351161000182",
Email = "*****@*****.**",
DDDComercialPhone = "11",
ComercialPhone = "12345678",
TowerNumber = 2,
Address = context.Addresses.Find(2),
CreatedBy = "Sistema",
CreatedAt = DateTime.Now
};
condominiuns.Add(condominiumTwo);
context.Condominiums.AddRange(condominiuns);
context.SaveChanges();
}
}
public IActionResult Put([FromBody] Condominium condominium, [FromRoute] int id)
{
if (condominium == null)
{
return(StatusCode(400, "Dados não encontrados"));
}
ModelState.Clear();
TryValidateModel(condominium);
if (ModelState.IsValid)
{
var result = _condominiumBusinessService.UpdateCondominium(condominium, id);
return(Ok(result));
}
else
{
return(StatusCode(400, ModelState));
}
}
public List <CardData> ListCardDatas(Condominium condominium)
{
try
{
StandartPersistence standartPersistence =
new StandartPersistence(this.Connection);
var cardDatas = standartPersistence.GetEntities <CardData>(CommandType.Text,
"SELECT * FROM CardData WHERE IdCardOwner = @IdCardOwner AND IdCardOwnerType = @IdCardOwnerType ",
new
{
IdCardOwner = condominium.Id,
IdCardOwnerType = (int)PaymentEnums.CardOwnerType.Condominium
}).ToList();
return(cardDatas);
}
catch (SqlException e)
{
throw e;
}
}
public Condominium GetCondominium(Condominium condominium)
{
try
{
StandartPersistence standartPersistence =
new StandartPersistence(this.Connection);
condominium = standartPersistence.GetEntities <Condominium>(CommandType.Text,
"SELECT * FROM Condominium WHERE Id = @Id",
new { Id = condominium.Id }).SingleOrDefault();
StringBuilder selectAddress = new StringBuilder();
selectAddress.Append(" SELECT a.* FROM Address a ");
selectAddress.Append(" INNER JOIN CondominiumAddress ca ON a.Id = ca.IdAddress ");
selectAddress.Append(" INNER JOIN Condominium c ON c.Id = ca.IdCondominium ");
selectAddress.Append(" WHERE c.Id = @IdCondominium ");
condominium.Address = new Address();
condominium.Address = standartPersistence.GetEntities <Address>(CommandType.Text, selectAddress.ToString(), new { IdCondominium = condominium.Id }).SingleOrDefault();
condominium.Address.State = new State();
condominium.Address.State = standartPersistence.GetEntities <State>(CommandType.Text,
"SELECT IdEstate, UPPER(Name) AS Name, UF FROM State WHERE IdEstate = @IdEstate",
new { IdEstate = condominium.Address.IdEstate }).SingleOrDefault();
City city = new City();
city = standartPersistence.GetEntities <City>(CommandType.Text,
"SELECT IdCity, Name, IdEstate FROM City WHERE IdCity = @IdCity",
new { IdCity = condominium.Address.IdCity }).SingleOrDefault();
condominium.Address.State.Cities = new List <City>();
condominium.Address.State.Cities.Add(city);
return(condominium);
}
catch (SqlException e)
{
throw e;
}
}
public Condominium Create(Condominium c)
{
c.Id = Collection.Count() + 1;
Collection.Add(c);
return(c);
}
public async Task <IActionResult> AddCondominium([FromHeader] string Authorization, [FromBody] Condominium request)
{
try
{
var admin = await _administratorService.AuthToken(Authorization);
if (admin == null)
{
UnauthorizedResponse();
return(new ObjectResult(response));
}
request.AdministratorId = admin.AdministratorId;
var condominiumSaved = await _condominiumService.Insert(request);
OkResponse(condominiumSaved);
return(new ObjectResult(response));
}
catch (Exception e)
{
InternalServerErrorResponse(e.Message);
return(new ObjectResult(response));
}
}
public async Task <IActionResult> UpdateCondominium(int condominiumId, [FromHeader] string Authotization, [FromBody] Condominium request)
{
try
{
request.CondominiumId = condominiumId;
var condominiumSaved = await _condominiumService.Update(request);
OkResponse(condominiumSaved);
return(new ObjectResult(response));
}
catch (Exception e)
{
InternalServerErrorResponse(e.Message);
return(new ObjectResult(response));
}
}
public async Task <Condominium> Insert(Condominium entity)
{
return(await _condominiumRepository.Insert(entity));
}
public async Task <Condominium> Update(Condominium entity)
{
return(await _condominiumRepository.Update(entity));
}
public void Add(Condominium entity)
{
_condominiumRepository.Add(entity);
}
public void Update(Condominium condominium)
{
_context.Entry(condominium).State = EntityState.Modified;
_context.SaveChanges();
}
public void Update(Condominium entity)
{
_condominiumRepository.Update(entity);
}
public void Update(Condominium c)
{
Collection.Where(cItem => cItem.Id == c.Id).ToList().ForEach(cItem => Collection[Collection.IndexOf(cItem)] = c);
}
public bool Update(Condominium entity)
{
throw new System.NotImplementedException();
}
public void Create(Condominium condominium)
{
_context.Condominiums.Add(condominium);
_context.SaveChanges();
}
