public void setMural(Mural mural)
{
if (!muralRepositorio.Alterar(mural))
{
this.muralRepositorio.Inserir(mural);
}
}
public ActionResult EditarAvisos(string Texto, string id, string titulo)
{
string str = ConfigurationManager.ConnectionStrings["conexao"].ToString();
MuralRepositorio muralRepositorio = new MuralRepositorio(str);
MuralAplicacao muralApicacao = new MuralAplicacao(muralRepositorio);
DateTime today = DateTime.Now;
if (id.Equals("Novo"))
{
id = Guid.NewGuid().ToString();
}
Mural mural = new Mural
{
id = Guid.Parse(id),
id_condominio = (Guid)Session["Condominio"],
id_pessoa = (Guid)Session["usuario"],
texto = Texto,
data = today,
titulo = titulo
};
muralApicacao.setMural(mural);
//object Permisao = Session["Permission"];
//ViewBag.Tipo = Permisao.ToString();
return(RedirectToAction("Index"));
}
public Mural Procurar(Guid id)
{
using (NpgsqlConnection conexao = new NpgsqlConnection(this.connectionString))
{
conexao.Open();
NpgsqlCommand comando = new NpgsqlCommand();
comando.CommandText = "SELECT * FROM mural " +
"WHERE id = @id;";
comando.Connection = conexao;
comando.Parameters.AddWithValue("id", id.ToString());
Mural Mural = new Mural();
using (NpgsqlDataReader SqlData = comando.ExecuteReader())
{
if (SqlData.Read())
{
Mural.id = Guid.Parse(String.Format("{0}", SqlData["id"]));
Mural.texto = String.Format("{0}", SqlData["texto"]);
Mural.data = (DateTime)SqlData["data"];
Mural.titulo = String.Format("{0}", SqlData["titulo"]);
Mural.id_pessoa = Guid.Parse(String.Format("{0}", SqlData["id_pessoa"]));
Mural.id_condominio = Guid.Parse(String.Format("{0}", SqlData["id_condominio"]));
}
}
return(Mural);
}
}
public bool Alterar(Mural Mural)
{
using (NpgsqlConnection conexao = new NpgsqlConnection(this.connectionString))
{
conexao.Open();
NpgsqlCommand comando = new NpgsqlCommand();
comando.CommandText = "UPDATE mural " +
"SET texto = @texto," +
"data = @data," +
"titulo = @titulo," +
"id_pessoa = @id_pessoa, " +
"id_condominio = @id_condominio " +
"WHERE id = @id;";
comando.Connection = conexao;
comando.Parameters.AddWithValue("id", Mural.id.ToString());
comando.Parameters.AddWithValue("texto", Mural.texto);
comando.Parameters.AddWithValue("data", Mural.data);
comando.Parameters.AddWithValue("titulo", Mural.titulo);
comando.Parameters.AddWithValue("id_pessoa", Mural.id_pessoa);
comando.Parameters.AddWithValue("id_condominio", Mural.id_condominio);
return(comando.ExecuteNonQuery() > 0);
}
}
public async Task <IActionResult> PutMural(int id, Mural mural)
{
if (id != mural.Id)
{
return(BadRequest());
}
_context.Entry(mural).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MuralExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Edit([Bind(Include = "MuralId,MuralName,MuralDescription,MuralLocation,ArtistID")] Mural mural)
{
muralManager.SaveEditMural(mural);
var muralList = muralManager.GetAllMurals();
return(RedirectToAction("Index", muralList));
}
public MuralViewModel(Mural entidade)
{
Id = entidade?.Id ?? 0;
Titulo = entidade?.Titulo;
DataPublicacao = entidade.DataPublicacao.ToString("dd/MM/yyyy");
FotoCapa = entidade?.FotoCapa;
Descricao = entidade?.Descricao;
//this.Comentarios = ComentarioMuralViewModel.ComentariosMuralViewModelList(mural?.Comentarios.Select(x => x.Comentario).ToList() ?? new List<Comentarios>());
FaceBook = entidade?.Facebook;
}
private void BtnExcluir_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
var notas = StaticKeys.Notas.Where(x => x.Content == NotaContent.Text);
List <Nota> notasList = notas.ToList();
foreach (Nota nota in notasList)
{
new NotaController().removeNota(nota);
}
Mural.renderNotas();
}
public MuralModelView(Mural mural)
{
Titulo = mural.Titulo;
DataPublicacao = mural.DataPublicacao;
FotoCapa = mural.FotoCapa;
Descricao = mural.Descricao;
Facebook = mural.Facebook;
Comentarios = new List <ComentarioModelView>();
foreach (var comentario in mural.Comentarios)
{
Comentarios.Add(new ComentarioModelView(comentario.Comentario));
}
}
private void BtnExcluir_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
var posts = StaticKeys.Postagens.Where(postagem => postagem.Content == content.Text);
if (posts.Count() == 0)
{
return;
}
Postagem post = posts.First();
new PostagemController().deletePostagem(post);
StaticKeys.Postagens = new PostagemController().getPostagens();
Mural.renderPosts();
}
public void Procurar()
{
Guid Id = Guid.Parse("7edafe64-f996-4ba9-8f8c-2eb1367a6ca6");
try
{
MuralRepositorio muralRepositorio = new MuralRepositorio(str);
Mural Mural = muralRepositorio.Procurar(Id);
Assert.IsTrue(true);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
private void BtnNovoPost_Click(object sender, RoutedEventArgs e)
{
String text = new TextRange(txtPost.Document.ContentStart, txtPost.Document.ContentEnd).Text;
if (text.Trim() == "")
{
return;
}
new PostagemController().addPostagem(new DAL.models.Postagem()
{
AuthorId = StaticKeys.id_func,
AuthorName = StaticKeys.Usuario,
Content = text
});
txtPost.Document.Blocks.Clear();
Mural.renderPosts();
}
private void BtnNovaNota_Click(object sender, RoutedEventArgs e)
{
String text = new TextRange(txtNota.Document.ContentStart, txtNota.Document.ContentEnd).Text;
if (text.Trim() == "")
{
return;
}
new NotaController().addNota(new Nota()
{
Content = text,
IdFunc = StaticKeys.id_func
});
txtNota.Document.Blocks.Clear();
Mural.renderNotas();
}
public void Inserir(Mural Mural)
{
using (NpgsqlConnection conexao = new NpgsqlConnection(this.connectionString))
{
conexao.Open();
NpgsqlCommand comando = new NpgsqlCommand();
comando.CommandText = "INSERT INTO mural (id, texto, data, titulo, id_pessoa, id_condominio) " +
" VALUES(@id, @texto, @data, @titulo, @id_pessoa, @id_condominio);";
comando.Connection = conexao;
comando.Parameters.AddWithValue("id", Mural.id.ToString());
comando.Parameters.AddWithValue("texto", Mural.texto);
comando.Parameters.AddWithValue("data", Mural.data);
comando.Parameters.AddWithValue("titulo", Mural.titulo);
comando.Parameters.AddWithValue("id_pessoa", Mural.id_pessoa);
comando.Parameters.AddWithValue("id_condominio", Mural.id_condominio);
comando.ExecuteNonQuery();
}
}
public async Task <ActionResult <Mural> > PostMural(Mural mural)
{
var client = new HttpClient();
var resp = await client.GetAsync($"https://api.mapbox.com/geocoding/v5/mapbox.places/{mural.FullAddress}.json?access_token={this._MAPBOX_TOKEN}");
var json = await JsonDocument.ParseAsync(await resp.Content.ReadAsStreamAsync());
var root = json.RootElement;
var feature = root.GetProperty("features").EnumerateArray().First();
var center = feature.GetProperty("center").EnumerateArray();
var lng = center.First();
var lat = center.Skip(1).First();
Console.WriteLine($"{lat},{lng}");
mural.Latitude = lat.GetDouble();
mural.Longitude = lng.GetDouble();
_context.Murals.Add(mural);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMural", new { id = mural.Id }, mural));
}
public void AlterarMural()
{
Mural Mural = new Mural()
{
id = Guid.Parse("7edafe64-f996-4ba9-8f8c-2eb1367a6ca6"),
id_pessoa = Guid.Parse("7edafe64-f996-4ba9-8f8c-2eb1367a6ca6"),
id_condominio = Guid.Parse("7edafe64-f996-4ba9-8f8c-2eb1367a6ca6"),
data = DateTime.Parse("01/01/2118"),
titulo = "Teste Titulo - Altera",
texto = "Teste Texto - Altera"
};
try
{
MuralRepositorio muralRepositorio = new MuralRepositorio(str);
muralRepositorio.Alterar(Mural);
Assert.IsTrue(true);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public ActionResult Create([Bind(Include = "MuralName, MuralDescription, MuralLocation")] Mural model)
{
MuralBuilderInterface muralBuilder = new MuralBuilder();
Mural mural = new Mural();
var claimsIdentity = (ClaimsIdentity)this.User.Identity;
var claim = claimsIdentity.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier);
string userId = claim.Value;
model.ArtistID = Int32.Parse(userId);
muralBuilder.buildArtistAccountWithRequiredParameters(model.MuralName, model.MuralDescription);
muralBuilder.buildArtistWithOptionalParameters(model.MuralLocation);
mural = muralBuilder.GetBuildedMural();
mural.ArtistID = model.ArtistID;
muralRepository.InsertMural(mural);
IEnumerable <Mural> murallist = muralManager.GetAllMurals();
return(View("Index", murallist));
}
public void SaveEditMural(Mural m)
{
muralRepository.SaveEditMural(m);
}
public ActionResult Edit(int id)
{
Mural muraltoedit = muralManager.GetMuralWithId(id);
return(View("Edit", muraltoedit));
}
public void Add(Mural state)
{
mementoList.Add(state);
}
public ActionResult Delete(int id)
{
Mural muraltodelete = muralManager.GetMuralWithId(id);
return(View(muraltodelete));
}
