public BLLResponse <Usuario> Update(UsuarioViewModel userVM)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
Usuario user = new Usuario();
if (userVM.Frase != null && userVM.Frase.Length > 100)
{
response.Mensagem = "Frase de apresentação deve possuir até 100 caracteres";
return(response);
}
if (userVM.Descricao != null && userVM.Descricao.Length > 300)
{
response.Mensagem = "Descrição deve possuir até 300 caracteres";
return(response);
}
using (LTContext ctx = new LTContext())
{
user = ctx.Usuarios.Find(userVM.ID);
if (user != null)
{
response.Sucesso = true;
CopiarInformacoes(userVM, user);
ctx.SaveChanges();
response.Sucesso = true;
response.Mensagem = "Dados atualizados com sucesso!";
return(response);
}
response.Mensagem = "Algo de errado ocorreu";
return(response);
}
}
public List <TubeLine> GetTubeLineToMore(List <TubeLine> tlInput)
{
LTContext dc = new LTContext(ConfigurationManager.ConnectionStrings["LondonTube"].ConnectionString);
List <TubeLine> tsE = new List <TubeLine>();
List <TubeLine> tsTot = new List <TubeLine>();
string ToStation = "";
string FromStation = "";
if (tlInput.Count > 0)
{
List <StationModel> smlD = new List <StationModel>();
for (int d = 0; d < tlInput.Count; d++)
{
StationModel smD = new StationModel();
smD.FromStation = tlInput[d].FromStation;
smD.ToStation = tlInput[d].ToStation;
smlD.Add(smD);
ToStation = tlInput[d].ToStation;
FromStation = tlInput[d].FromStation;
tsE = (from tls in dc.TubeLines
where tls.ToStation == FromStation &&
tls.FromStation != ToStation
select tls).ToList();
foreach (var t in tsE)
{
tsTot.Add(t);
}
}
}
return(tsTot);
}
public List <StationModel> GetStationModelFrom(string StationName, int NoOfStation)
{
List <StationModel> newsm = new List <StationModel>();
LTContext dc = new LTContext(ConfigurationManager.ConnectionStrings["LondonTube"].ConnectionString);
List <TubeLine> tsA = (from tls in dc.TubeLines
where tls.FromStation == StationName
select tls).ToList();
int iCount = 1;
List <TubeLine> tsA_Ex = new List <TubeLine>();
while (iCount < NoOfStation)
{
List <StationModel> smlA = new List <StationModel>();
List <TubeLine> tsB = GetTubeLineFromMore(tsA);
if (tsB.Count > 0)
{
tsA = tsB;
}
iCount += 1;
}
if (iCount == NoOfStation)
{
if (tsA.Count > 0)
{
foreach (var s in GetTubeLineEnd(tsA))
{
newsm.Add(s);
}
}
}
return(newsm);
}
public BLLResponse <Usuario> UpdateProfilePic(int id, string folder, byte[] imagem, string pathRelativo)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
using (LTContext ctx = new LTContext())
{
Usuario user = ctx.Usuarios.Find(id);
if (user != null)
{
response.Sucesso = true;
string nomeFoto = Guid.NewGuid() + ".png";
string path = Path.Combine(folder, nomeFoto);
FileStream stream = new FileStream(path, FileMode.Create);
stream.Write(imagem, 0, imagem.Length);
stream.Flush();
if (user.PathFotoPerfil != PATH_IMAGEM_PADRAO)
{
ApagarProfilePicAnterior(folder, user.PathFotoPerfil);
}
user.PathFotoPerfil = Path.Combine(pathRelativo, nomeFoto);
ctx.SaveChanges();
response.Data = user;
}
}
return(response);
}
public BLLResponse <Usuario> UpdatePassword(Usuario usuario, string senhaAntiga)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
using (LTContext ctx = new LTContext())
{
Usuario userDoDb = ctx.Usuarios.Find(usuario.ID);
bool EhSenhaAntiga = Criptografia.Verificar(senhaAntiga, userDoDb.Salt, userDoDb.Hash);
if (!EhSenhaAntiga)
{
response.Mensagem = "Senha atual incorreta.";
return(response);
}
if (userDoDb == null)
{
response.Mensagem = "Algo de errado ocorreu.";
return(response);
}
else
{
userDoDb.Senha = usuario.Senha;
Criptografia.EncriptografarEGuardarSalt(userDoDb);
ctx.SaveChanges();
response.Sucesso = true;
response.Mensagem = "Senha atualizada com sucesso!";
response.Data = userDoDb;
return(response);
}
}
}
public List <TubeLine> GetTubeLineExpress(TubeLine tlInput)
{
LTContext dc = new LTContext(ConfigurationManager.ConnectionStrings["LondonTube"].ConnectionString);
TubeLine tsTo = new TubeLine();
TubeLine tsFrom = new TubeLine();
List <TubeLine> tsRegsFrom = new List <TubeLine>();
List <TubeLine> tsRegsTo = new List <TubeLine>();
List <TubeLine> tsTot = new List <TubeLine>();
string ToStation = "";
string FromStation = "";
string TubeLineName = "";
ToStation = tlInput.ToStation;
FromStation = tlInput.FromStation;
TubeLineName = tlInput.TubeLineName;
tsTo = (from tls in dc.TubeLines
where (tls.ToStation == ToStation) &&
tls.TubeLineName != TubeLineName &&
tls.Express == true
select tls).FirstOrDefault();
tsFrom = (from tls in dc.TubeLines
where (tls.FromStation == ToStation) &&
tls.TubeLineName != TubeLineName &&
tls.Express == true
select tls).FirstOrDefault();
tsRegsTo = (from tls in dc.TubeLines
where (tls.ToStation == ToStation) &&
tls.TubeLineName != TubeLineName &&
tls.Express == false
select tls).ToList();
tsRegsFrom = (from tls in dc.TubeLines
where (tls.FromStation == ToStation) &&
tls.TubeLineName != TubeLineName &&
tls.Express == false
select tls).ToList();
if (tsFrom != null)
{
tsTot.Add(tsFrom);
}
if (tsTo != null)
{
tsTot.Add(new TubeLine {
FromStation = tsTo.ToStation, ToStation = tsTo.FromStation, TubeLineName = tsTo.TubeLineName, Express = tsTo.Express
});
}
foreach (var tf in tsRegsFrom)
{
tsTot.Add(tf);
}
foreach (var tt in tsRegsTo)
{
tsTot.Add(new TubeLine {
FromStation = tt.ToStation, ToStation = tt.FromStation, TubeLineName = tt.TubeLineName, Express = tt.Express
});
}
return(tsTot);
}
public void BuscarDiretorios(UsuarioViewModel usuarioVM)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
using (LTContext ctx = new LTContext())
{
List <Diretorio> diretorios = ctx.Diretorios.ToList();
}
}
public BLLResponse <Usuario> LerTodos()
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
using (LTContext ctx = new LTContext())
{
response.DataList = ctx.Usuarios.ToList();
}
return(response);
}
//implementar filtro da coordenada
public BLLResponse <Usuario> GetUsuariosComFiltro
(byte minTags = 1, byte idadeMin = 18, byte idadeMax = 80, Genero generos = Genero.Masculino | Genero.Feminino | Genero.Indeterminado)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
using (LTContext ctx = new LTContext())
{
var filtroIdade = ctx.Usuarios.Where(u => u.DataNascimento == DateTime.Now);
}
return(response);
}
private bool EmailJaExiste(Usuario item, List <ErrorField> errors)
{
using (LTContext context = new LTContext())
{
Usuario usuario = context.Usuarios.FirstOrDefault(u => u.Email == item.Email);
if (usuario == null)
{
return(false);
}
return(true);
}
}
public BLLResponse <Usuario> LerPorId(int id)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
Usuario user = new Usuario();
using (LTContext ctx = new LTContext())
{
user = ctx.Usuarios.Include(u => u.DiretoriosImagens).FirstOrDefault(u => u.ID == id);
}
response.Sucesso = user != null;
response.Data = user;
return(response);
}
public List <Usuario> GetUsersComFiltro(int idadeMin, int idadeMax, int tagsComum, int userID)
{
using (LTContext ctx = new LTContext())
{
Usuario userDb = ctx.Usuarios.Find(userID);
DateTime menor = new DateTime(DateTime.Now.Year - idadeMin, DateTime.Now.Month, DateTime.Now.Day);
DateTime maior = new DateTime(DateTime.Now.Year - idadeMax, DateTime.Now.Month, DateTime.Now.Day);
var filtroEunao = ctx.Usuarios.Where(u => u.ID != userID);
var filtroIdade = filtroEunao.Where(u => u.DataNascimento <menor && u.DataNascimento> maior);
var filtroTags = filtroIdade.AsEnumerable().Where(u => TagsEmComum(u.Tags, userDb.Tags, tagsComum)).ToList();
return(filtroTags);
}
}
public BLLResponse <Usuario> GetUsuariosSemFiltro()
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
using (LTContext ctx = new LTContext())
{
var users = ctx.Usuarios.ToList();
if (users.Any())
{
response.DataList = users;
response.Sucesso = true;
return(response);
}
}
return(response);
}
public List <CustomListItem> GetStations()
{
LTContext dc = new LTContext(ConfigurationManager.ConnectionStrings["LondonTube"].ConnectionString);
IEnumerable <Station> ss = new List <Station>();
ss = (from sts in dc.Stations
select sts).ToList();
List <CustomListItem> cli = new List <CustomListItem>();
foreach (var e in ss)
{
CustomListItem c = new CustomListItem();
c.text = e.StationName;
c.value = e.StationId;
cli.Add(c);
}
return(cli.OrderBy(cl => cl.text).ToList());
}
public List <CustomListItem> GetTubeLines()
{
LTContext dc = new LTContext(ConfigurationManager.ConnectionStrings["LondonTube"].ConnectionString);
IEnumerable <TubeLine> ts = new List <TubeLine>();
ts = (from tls in dc.TubeLines
orderby tls.TubeLineName
select tls).ToList();
List <CustomListItem> cli = new List <CustomListItem>();
foreach (var e in ts)
{
CustomListItem c = new CustomListItem();
c.text = e.TubeLineName;
c.value = e.TubeLineId;
cli.Add(c);
}
return(cli.OrderBy(cl => cl.text).ToList());
}
public ActionResult Index(LondonTubeModel model)
{
LondonTubeModel ltm = new LondonTubeModel();
if (ModelState.IsValid)
{
LTContext dc = new LTContext(ConfigurationManager.ConnectionStrings["LondonTube"].ConnectionString);
Station s = (from ss in dc.Stations
where ss.StationId == model.StationId
select ss).FirstOrDefault();
List <TubeLine> tbls = new List <TubeLine>();
List <StationModel> smFrom = GetStationModelFrom(s.StationName, model.NoOfStation);
List <StationModel> smTo = GetStationModelTo(s.StationName, model.NoOfStation);
ltm.StationModelList = new List <StationModel>();
for (int i = 0; i < smFrom.Count; i++)
{
string ToStation = smFrom[i].ToStation;
if (!ltm.StationModelList.Any(l => l.ToStation == ToStation))
{
ltm.StationModelList.Add(smFrom[i]);
}
}
for (int j = 0; j < smTo.Count; j++)
{
StationModel smToj = new StationModel();
smToj.FromStation = smTo[j].ToStation;
smToj.ToStation = smTo[j].FromStation;
if (!ltm.StationModelList.Any(l => l.ToStation == smToj.ToStation))
{
ltm.StationModelList.Add(smToj);
}
}
ltm.StationModelList = ltm.StationModelList.OrderBy(l => l.ToStation).ToList();
}
return(View(ltm));
}
public BLLResponse <Coordenada> SalvarCoordenadas(Coordenada coordenada, int id)
{
BLLResponse <Coordenada> response = new BLLResponse <Coordenada>();
using (LTContext ctx = new LTContext())
{
Usuario userDoDb = ctx.Usuarios.Find(id);
if (userDoDb != null)
{
userDoDb.Latitude = coordenada.Latitude;
userDoDb.Longitude = coordenada.Longitude;
ctx.SaveChanges();
response.Mensagem = "Local salvo com sucesso";
response.Sucesso = true;
return(response);
}
}
response.Mensagem = "Algo de errado ocorreu";
return(response);
}
public BLLResponse <Usuario> IsLoginValido(Usuario item)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
response.Erros = new List <ErrorField>();
using (LTContext ctx = new LTContext())
{
Usuario userDoBanco = ctx.Usuarios.FirstOrDefault(u => u.Email == item.Email);
if (userDoBanco == null)
{
response.Erros.Add(new ErrorField(fieldName: nameof(userDoBanco.Email),
message: MensagensPadrao.UserOuSenhaInvalidosMessage()));
return(response);
}
response.Sucesso = Criptografia.Verificar(item.Senha, userDoBanco.Salt, userDoBanco.Hash);
if (response.Sucesso)
{
response.Data = userDoBanco;
}
}
return(response);
}
//fazer trocar a foto direito
public BLLResponse <Usuario> AtualizarFotosAlbum(int id, string pathRelativo)
{
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
Usuario user = new Usuario();
using (LTContext ctx = new LTContext())
{
user = ctx.Usuarios.Find(id);
if (user != null)
{
response.Sucesso = true;
Diretorio diretorio = new Diretorio();
diretorio.PathRelativo = pathRelativo;
diretorio.Usuario = user;
List <Diretorio> diretorios = new List <Diretorio>();
diretorios.Add(diretorio);
user.DiretoriosImagens = diretorios;
ctx.SaveChanges();
}
return(response);
}
}
public BLLResponse <Usuario> Registrar(Usuario item, string senhaRepetida)
{
List <ErrorField> erros = ValidarUsuarioParaRegistro(item, senhaRepetida);
BLLResponse <Usuario> response = new BLLResponse <Usuario>();
response.Erros = erros;
if (response.HasErros)
{
response.Sucesso = false;
return(response);
}
Criptografia.EncriptografarEGuardarSalt(item);
using (LTContext ctx = new LTContext())
{
item.PathFotoPerfil = "/UserImages/DefaultCropped.png";
ctx.Usuarios.Add(item);
ctx.SaveChanges();
}
response.Sucesso = true;
response.Data = item;
return(response);
}
