public IActionResult OnGet()
{
using (PrivacyContext context = new PrivacyContext())
{
OptionsGenero = context.Genero.Select(a =>
new SelectListItem
{
Value = a.IdGenero.ToString(),
Text = a.Descricao
}).ToList();
OptionsEtnia = context.Etnia.Select(a =>
new SelectListItem
{
Value = a.IdEtnia.ToString(),
Text = a.Descricao
}).ToList();
OptionsInteresse = context.Interesse.Select(a =>
new SelectListItem
{
Value = a.IdInteresse.ToString(),
Text = a.Descricao
}).ToList();
}
return(Page());
}
public IActionResult OnPostSalvarSobreMim(string PerfilSobreMim, string PerfilCidadePais, string PerfilCelular)
{
if (HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO") == null)
{
return(RedirectToPage("/Login"));
}
Usuario usuario = HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO");
if (PerfilSobreMim != null)
{
using (PrivacyContext context = new PrivacyContext())
{
var UsuarioBanco = context.Usuario.Where(x => x.IdUsuario == usuario.IdUsuario).FirstOrDefault();
UsuarioBanco.Cidade = PerfilCidadePais.IsNullOrEmpty() ? null : PerfilCidadePais.Split(',')[0].ToString().Trim();
UsuarioBanco.Pais = PerfilCidadePais.IsNullOrEmpty() ? null : PerfilCidadePais.Split(',')[1].ToString().Trim();
UsuarioBanco.Celular = PerfilCelular.IsNullOrEmpty() ? null : PerfilCelular;
UsuarioBanco.SobreMim = PerfilSobreMim;
context.SaveChanges();
}
Mensagem = "Perfil salvo com sucesso!";
}
else
{
Mensagem = "Problema ao salvar!";
}
Entity = UsuarioModel.ObterUsuario(usuario.IdUsuario);
return(Page());
}
//public Valor Valor { get; set; }
#endregion
#region Construtores
#endregion
#region Métodos
public IActionResult OnGet(string Id)
{
if (HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO") == null)
{
return(RedirectToPage("/Login"));
}
#region Verifica se o usuário logado já comprou a mina rs
using (PrivacyContext context = new PrivacyContext())
{
Entity = UsuarioModel.ObterUsuario(long.Parse(WebUtility.HtmlEncode(Criptography.Decrypt(Id))));
var UsuarioLogado = HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO");
var assinado = context.Transacao.Where(a => a.IdUsuario == UsuarioLogado.IdUsuario && a.IdPerfil == Entity.IdUsuario).FirstOrDefault();
if (assinado != null)
{
return(RedirectToPage("/ProfilePhotos", new { Id = Id }));
}
}
#endregion
//Carregar Perfil de Usuário
Entity = UsuarioModel.ObterUsuario(long.Parse(WebUtility.HtmlEncode(Criptography.Decrypt(Id))));
//Valor = Entity.Valor.Where(a => a.IdUsuario == Entity.IdUsuario).FirstOrDefault();
return(Page());
}
public IActionResult OnGetOcultarMostrarComentario(long IdComentario)
{
if (HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO") == null)
{
return(RedirectToPage("/Login"));
}
using (PrivacyContext context = new PrivacyContext())
{
bool ocultou = PostModel.OcultarMostrarComentario(IdComentario);
if (ocultou)
{
return(new JsonResult(new { OK = true }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
else
{
return(new JsonResult(new { OK = false }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
}
}
public IActionResult OnPost()
{
if ((Usuario.IsNullOrEmpty() || Senha.IsNullOrEmpty()))
{
Mensagem = "Login/Senha obrigatórios em branco!";
}
else
{
using (PrivacyContext context = new PrivacyContext())
{
var usuario = context.Usuario.Where(x => x.Login.ToLower() == Usuario.ToLower() && x.Senha == Criptography.Encrypt(Senha)).FirstOrDefault();
if (usuario != null)
{
HttpContext.Session.SetObjectAsJson("USUARIO", usuario);
if (!usuario.Ativo)
{
return(RedirectToPage("/Welcome"));
}
//Mensagem = "Usuário inativo! Verifique a caixa de entrada de seu email!";
else
{
return(RedirectToPage("/Index"));
}
}
else
{
Mensagem = "Login/Senha inválidos!";
}
}
}
return(Page());
}
public IActionResult OnPostSalvarValores(decimal ValorMensal, decimal ValorTrimestral, decimal ValorSemestral)
{
if (HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO") == null)
{
return(RedirectToPage("/Login"));
}
Usuario usuario = HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO");
if (ValorMensal > 0 && ValorTrimestral > 0 && ValorSemestral > 0)
{
using (PrivacyContext context = new PrivacyContext())
{
Valor valor = new Valor();
valor.IdUsuario = usuario.IdUsuario;
valor.ValorMensal = ValorMensal;
valor.ValorTrimestral = ValorTrimestral;
valor.ValorSemestral = ValorSemestral;
context.Valor.Add(valor);
context.SaveChanges();
}
Mensagem = "Valores salvos com sucesso!";
}
else
{
Mensagem = "Problema ao salvar!";
}
Entity = UsuarioModel.ObterUsuario(usuario.IdUsuario);
return(Page());
}
public static List <ResultPesquisaModel> ObterPesquisa(string texto)
{
List <ResultPesquisaModel> ListEntity = null;
using (PrivacyContext context = new PrivacyContext())
{
ListEntity = context.Usuario
.Include(y => y.IdEtniaNavigation)
.Include(y => y.IdGeneroNavigation)
.Where(x => /*x.Ativo &&*/ x.PerfilPublico &&
(
x.Nome.ToLower().Contains(texto.ToLower()) ||
x.IdEtniaNavigation.Descricao.ToLower().Contains(texto.ToLower()) ||
x.IdGeneroNavigation.Descricao.ToLower().Contains(texto.ToLower()) ||
x.Cidade.ToLower().Contains(texto.ToLower()) ||
x.Pais.ToLower().Contains(texto.ToLower()) ||
x.Estado.ToLower().Contains(texto.ToLower())
)).ToList()
.Select(k => new ResultPesquisaModel {
IdUsuario = k.IdUsuario,
IdUsuarioCriptografado = WebUtility.UrlDecode(Criptography.Encrypt(k.IdUsuario.ToString())),
Nome = k.Nome,
Cidade = k.Cidade,
Pais = k.Pais,
FotoPerfil = (k.FotoPerfil.IsNullOrEmpty() ? "/FotoPerfil/default.jpg" : k.FotoPerfil),
Etnia = k.IdEtniaNavigation.Descricao,
Genero = k.IdGeneroNavigation.Descricao
}).ToList();
}
return(ListEntity);
}
public static bool OcultarMostrarComentario(long IdComentario)
{
bool ocultou = false;
using (PrivacyContext context = new PrivacyContext())
{
var objeto = context.Comentario.Where(c => c.IdComentario == IdComentario).FirstOrDefault();
if (objeto != null)
{
if (objeto.Ativo)
{
objeto.Ativo = false;
}
else
{
objeto.Ativo = true;
}
context.Update(objeto);
int salvou = context.SaveChanges();
if (salvou == 1)
{
ocultou = true;
}
}
return(ocultou);
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_updated_and_inserted()
{
using (var context = new PrivacyContext())
{
var one = context.Ones.Include(o => o.ColRel).Single();
one.SetName("Praise You");
one.Info.SetImage(new byte[32]);
one.SetAnEnum(AnEnum.Big);
one.ColRel.Single().SetName("Wonderful Night");
one.SetColRel(
new List <ActualEntity2>
{
one.ColRel.Single(),
new ActualEntity2(748, "Slash Dot Dash", AnEnum.Beat, 0, null)
});
using (context.Database.BeginTransaction())
{
context.SaveChanges();
var twos = context.Twos.AsNoTracking().ToList();
Assert.Equal(new[] { "Slash Dot Dash", "Wonderful Night" }, twos.Select(t => t.Name).OrderBy(n => n));
Assert.Equal(new[] { 747, 748 }, twos.Select(t => t.Id).OrderBy(n => n));
one = context.Ones.AsNoTracking().Single();
Assert.Equal("Praise You", one.Name);
Assert.Equal(AnEnum.Big, one.AnEnum);
Assert.Equal(32, one.Info.Image.Length);
}
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_manipulated()
{
using (var context = new PrivacyContext())
{
var one = context.Ones.Single();
var two = context.Twos.Single();
var nameProperty = context.Entry(one).Property(e => e.Name);
nameProperty.CurrentValue = "Praise You";
nameProperty.OriginalValue = "Right Now, Right Here";
Assert.Equal("Praise You", one.Name);
Assert.Equal("Praise You", nameProperty.CurrentValue);
Assert.Equal("Right Now, Right Here", nameProperty.OriginalValue);
var enumProperty = context.Entry(one).Property(e => e.AnEnum);
enumProperty.CurrentValue = AnEnum.Big;
enumProperty.OriginalValue = AnEnum.Big;
Assert.Equal(AnEnum.Big, one.AnEnum);
Assert.Equal(AnEnum.Big, enumProperty.CurrentValue);
Assert.Equal(AnEnum.Big, enumProperty.OriginalValue);
var imageProperty = context.Entry(one).ComplexProperty(e => e.Info).Property(c => c.Image);
imageProperty.CurrentValue = new byte[8];
imageProperty.OriginalValue = new byte[24];
Assert.Equal(8, one.Info.Image.Length);
Assert.Equal(8, imageProperty.CurrentValue.Length);
Assert.Equal(24, imageProperty.OriginalValue.Length);
var colRel = context.Entry(one).Collection(e => e.ColRel);
var newCol = new List <ActualEntity2>
{
new ActualEntity2(748, "Slash Dot Dash", AnEnum.Beat, 0, null)
};
colRel.CurrentValue = newCol;
Assert.Same(newCol, one.ColRel);
Assert.Same(newCol, colRel.CurrentValue);
var refRel = context.Entry(two).Reference(e => e.RefRel);
var newRef = new ActualEntity1(0, "Slash Dot Dash", AnEnum.Beat, new ActualComplex(new byte[10]), null);
refRel.CurrentValue = newRef;
Assert.Same(newRef, two.RefRel);
Assert.Same(newRef, refRel.CurrentValue);
var fkProperty = context.Entry(two).Property(e => e.RefRelId);
fkProperty.CurrentValue = 678;
fkProperty.OriginalValue = 789;
Assert.Equal(678, two.RefRelId);
Assert.Equal(678, fkProperty.CurrentValue);
Assert.Equal(789, fkProperty.OriginalValue);
}
}
public static int GetLikesDestePost(long IdPost)
{
using (PrivacyContext context = new PrivacyContext())
{
int likes = context.Curtida.Where(c => c.IdPost == IdPost).Count();
return(likes);
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_queried_to_non_entity_type()
{
using (var context = new PrivacyContext())
{
var non = context.Database.SqlQuery <NonEntity>("select * from ActualEntity2").Single();
Assert.Equal(747, non.Id);
Assert.Equal("Sunset", non.Name);
Assert.Equal(AnEnum.Beat, non.AnEnum);
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_queried_with_no_set_raw_SQL()
{
using (var context = new PrivacyContext())
{
var two = context.Database.SqlQuery <ActualEntity2>("select * from ActualEntity2").Single();
Assert.Equal(747, two.Id);
Assert.Equal("Sunset", two.Name);
Assert.Equal(AnEnum.Beat, two.AnEnum);
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_obtained_with_Find()
{
using (var context = new PrivacyContext())
{
var two = context.Twos.Find(747);
Assert.Equal(747, two.Id);
Assert.Equal("Sunset", two.Name);
Assert.Equal(AnEnum.Beat, two.AnEnum);
Assert.Same(two, context.Twos.Find(747));
}
}
public static List <Album> ObterAlbumUsuario(long IdUsuario)
{
List <Album> Entity = null;
using (PrivacyContext context = new PrivacyContext())
{
Entity = context.Album
.Include(y => y.Foto)
.Include(y => y.Video)
.Where(x => x.IdUsuario == IdUsuario).ToList();
}
return(Entity);
}
public static int Postar(Post Postagem)
{
int salvou = 0;
using (PrivacyContext context = new PrivacyContext())
{
var post = context.Post.Add(Postagem);
salvou = context.SaveChanges();
return(salvou);
}
}
public static List <Usuario> ObterSugestoes()
{
List <Usuario> ListEntity = null;
using (PrivacyContext context = new PrivacyContext())
{
ListEntity = context.Usuario
.Include(y => y.IdEtniaNavigation)
.Include(y => y.IdGeneroNavigation)
.Where(x => x.Ativo && x.PerfilPublico).ToList();
}
return(ListEntity);
}
public static bool Comentar(long IdUsuario, long IdPost, string texto, long IdComentario)
{
bool comentou = false;
int salvou = 0;
using (PrivacyContext context = new PrivacyContext())
{
if (IdComentario > 0)
{
var objetoComentario = context.Comentario.Where(c => c.IdComentario == IdComentario).FirstOrDefault();
if (objetoComentario != null)
{
objetoComentario.Texto = texto;
objetoComentario.DataCadastro = DateTime.Now;
objetoComentario.Ativo = true;
context.Update(objetoComentario);
salvou = context.SaveChanges();
if (salvou == 1)
{
comentou = true;
}
return(comentou);
}
}
Comentario comentario = new Comentario();
comentario.IdUsuario = IdUsuario;
comentario.IdPost = IdPost;
comentario.DataCadastro = DateTime.Now;
comentario.Texto = texto;
comentario.Ativo = true;
context.Add(comentario);
salvou = context.SaveChanges();
if (salvou == 1)
{
comentou = true;
}
return(comentou);
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_lazy_loaded_by_reference()
{
using (var context = new PrivacyContext())
{
var two = context.Twos.Single();
var one = two.RefRel;
Assert.NotEqual(0, one.Id);
Assert.Equal("Right Here, Right Now", one.Name);
Assert.Equal(AnEnum.Beat, two.AnEnum);
Assert.Same(one, two.RefRel);
Assert.Equal(one.Id, two.RefRelId);
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_lazy_loaded_by_collection()
{
using (var context = new PrivacyContext())
{
var one = context.Ones.Single();
var two = one.ColRel.Single();
Assert.Equal(747, two.Id);
Assert.Equal("Sunset", two.Name);
Assert.Equal(AnEnum.Beat, two.AnEnum);
Assert.Same(one, two.RefRel);
Assert.Equal(one.Id, two.RefRelId);
}
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_queried_with_set_raw_SQL()
{
using (var context = new PrivacyContext())
{
context.Configuration.LazyLoadingEnabled = false;
var one = context.Ones.Single();
var two = context.Twos.SqlQuery("select * from ActualEntity2").Single();
Assert.Equal(747, two.Id);
Assert.Equal("Sunset", two.Name);
Assert.Same(one, two.RefRel);
Assert.Equal(AnEnum.Beat, two.AnEnum);
Assert.Equal(one.Id, two.RefRelId);
}
}
public IActionResult OnGet(string TokenTransacao, string IdPerfil)
{
if (HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO") == null)
{
return(RedirectToPage("/Login"));
}
UsuarioLogado = HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO");
PagarMeService.DefaultApiKey = "ak_test_1V9G2oIoRaRSMUD6rQZKI9XQgJzYMg";
PagarMeService.DefaultEncryptionKey = "ek_test_YTEFhGJ5f814Q75R3xMKPmTmNKAtK7";
Transaction transaction = PagarMeService.GetDefaultService().Transactions.Find(TokenTransacao);
//transaction.Capture(transaction.Amount);
using (PrivacyContext context = new PrivacyContext())
{
var usuarioPerfil = UsuarioModel.ObterUsuario(long.Parse(WebUtility.HtmlEncode(Criptography.Decrypt(IdPerfil))));
Transacao objetoTransacao = new Transacao();
objetoTransacao.Valor = transaction.Amount;
objetoTransacao.TokenPayPal = TokenTransacao;
objetoTransacao.TransactionIdPayPal = transaction.Tid;
objetoTransacao.Ip = transaction.IP;
objetoTransacao.PaymentStatusPayPal = transaction.Status.ToString();
objetoTransacao.DataTransacao = DateTime.Now;
objetoTransacao.PayerIdPayPal = transaction.Billing.Id;
objetoTransacao.IdUsuario = UsuarioLogado.IdUsuario;
objetoTransacao.IdPerfil = usuarioPerfil.IdUsuario;
context.Transacao.Add(objetoTransacao);
int salvou = context.SaveChanges();
if (salvou == 1)
{
//return RedirectToPage("/ProfilePhotos", new { Id = IdPerfil }); //Redirecionar para as fotos
return(new JsonResult(new { OK = true }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
}
return(null);
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_explicitly_loaded_by_collection()
{
using (var context = new PrivacyContext())
{
context.Configuration.LazyLoadingEnabled = false;
var one = context.Ones.Single();
context.Entry(one).Collection(e => e.ColRel).Load();
var two = one.ColRel.Single();
Assert.Equal(747, two.Id);
Assert.Equal("Sunset", two.Name);
Assert.Equal(AnEnum.Beat, two.AnEnum);
Assert.Same(one, two.RefRel);
Assert.Equal(one.Id, two.RefRelId);
}
}
public static List <Post> ObterPosts()
{
List <Post> ListEntity = null;
using (PrivacyContext context = new PrivacyContext())
{
ListEntity = context.Post
.Include(y => y.IdUsuarioNavigation)
.Include(y => y.IdVideoNavigation)
.Include(y => y.IdFotoNavigation)
.Include(y => y.Curtida)
.Include(y => y.Comentario)
.ThenInclude(z => z.IdUsuarioNavigation)
.Where(x => x.Ativo).ToList().OrderByDescending(k => k.Data).ToList();
}
return(ListEntity);
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_explicitly_loaded_by_reference()
{
using (var context = new PrivacyContext())
{
context.Configuration.LazyLoadingEnabled = false;
var two = context.Twos.Single();
context.Entry(two).Reference(e => e.RefRel).Load();
var one = two.RefRel;
Assert.NotEqual(0, one.Id);
Assert.Equal("Right Here, Right Now", one.Name);
Assert.Equal(AnEnum.Beat, one.AnEnum);
Assert.Same(one, two.RefRel);
Assert.Equal(one.Id, two.RefRelId);
}
}
public IActionResult OnGetLike(long IdUsuario, long IdPost)
{
if (HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO") == null)
{
return(RedirectToPage("/Login"));
}
if (IdPost > 0)
{
int likes = 0;
using (PrivacyContext context = new PrivacyContext())
{
bool curtido = PostModel.IsCurtido(IdUsuario, IdPost);
if (curtido)
{
likes = PostModel.GetLikesDestePost(IdPost);
return(new JsonResult(new { OK = false, Likes = likes }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
else
{
bool curtiu = PostModel.Curtir(IdUsuario, IdPost);
if (curtiu)
{
likes = PostModel.GetLikesDestePost(IdPost);
return(new JsonResult(new { OK = true, Likes = likes }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
}
return(new JsonResult(new { OK = false, Likes = likes }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
}
return(null);
}
//public static Usuario Gravar(Usuario usuario)
//{
//}
public static bool VerificaUsuario(string email)
{
bool achou = false;
if (!email.IsNullOrEmpty())
{
using (PrivacyContext context = new PrivacyContext())
{
//var usuario = context.Usuario.Where(c => c.CPF.PadronizarCPF() == cpf.PadronizarCPF()).FirstOrDefault();
var usuario = context.Usuario.Where(c => c.Email.Trim().ToLower() == email.Trim().ToLower()).FirstOrDefault();
if (usuario != null)
{
achou = true;
}
}
}
return(achou);
}
public IActionResult OnPostSalvarDados()
{
Usuario usuario = HttpContext.Session.GetObjectFromJson <Usuario>("USUARIO");
if (usuario != null)
{
using (PrivacyContext context = new PrivacyContext())
{
usuario.Ativo = false;
usuario.DataCadastro = DateTime.Now;
usuario.Login = usuario.Email;
context.Usuario.Add(usuario);
context.SaveChanges();
}
string html = MailModel.ReturnBodyTemplate();
MailModel.Server = _configuration["Smtp:Server"];
MailModel.User = _configuration["Smtp:User"];
MailModel.Pass = _configuration["Smtp:Pass"];
MailModel.Port = _configuration["Smtp:Port"];
MailModel.EnableSSL = _configuration["Smtp:EnableSSL"];
html = html.Replace("{Titulo}", "Privacy - Ativação de conta");
html = html.Replace("{Subtitulo}", string.Format("Olá, {0} para concluir seu cadastro clique no link abaixo:", usuario.Nome));
html = html.Replace("{Texto}", "<a href=\"" + _configuration["Url"].ToString() + "/ActivateAccount?q=" + HttpUtility.UrlEncode(Criptography.Encrypt(usuario.IdUsuario.ToString())) + "\">Ativar Conta</a>");
MailModel.SendMail(_configuration["Smtp:User"].ToString(), usuario.Email, "Privacy | Ativação de Conta", html);
usuario = null;
return(new JsonResult(new { OK = true, Mensagem = Mensagem }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
else
{
return(new JsonResult(new { OK = false, Mensagem = "Falha ao salvar os dados!" }, new Newtonsoft.Json.JsonSerializerSettings()
{
}));
}
}
public static Usuario ObterUsuario(long IdUsuario)
{
Usuario Entity = null;
using (PrivacyContext context = new PrivacyContext())
{
Entity = context.Usuario
.Include(y => y.Comentario)
.Include(y => y.Post)
.ThenInclude(z => z.Curtida)
.Include(y => y.Post)
.ThenInclude(z => z.IdFotoNavigation)
.Include(y => y.Post)
.ThenInclude(z => z.IdVideoNavigation)
.Include(v => v.Valor)
.Where(x => x.IdUsuario == IdUsuario).FirstOrDefault();
}
return(Entity);
}
[Fact] // CodePlex 137
public void Entities_with_unmapped_base_class_with_private_property_setters_can_be_queried()
{
using (var context = new PrivacyContext())
{
context.Configuration.LazyLoadingEnabled = false;
var one = context.Ones.Include(o => o.ColRel).Single();
Assert.NotEqual(0, one.Id);
Assert.Equal(16, one.Info.Image.Length);
Assert.Equal("Right Here, Right Now", one.Name);
Assert.Equal(AnEnum.Beat, one.AnEnum);
var two = one.ColRel.Single();
Assert.Equal(747, two.Id);
Assert.Equal("Sunset", two.Name);
Assert.Equal(AnEnum.Beat, two.AnEnum);
Assert.Same(one, two.RefRel);
Assert.Equal(one.Id, two.RefRelId);
}
}
