public Korisnik FindUserByEmail(string email)
{
Korisnik korisnik = null;
using (var ctx = new RestBizContext())
{
korisnik = (from k in ctx.Korisnici where k.Email == email select k).FirstOrDefault<Korisnik>();
}
return korisnik;
}
public List<Korisnik> GetFriends(int userId)
{
List<Korisnik> friends = null;
using(var ctx = new RestBizContext())
{
var korisnik = (from k in ctx.Korisnici where k.KorisnikId == userId select k).FirstOrDefault();
friends = korisnik.Prijatelji.ToList<Korisnik>();
}
return friends;
}
public bool IsActivated(string email)
{
bool activated = false;
using(var ctx = new RestBizContext())
{
var korisnik = (from k in ctx.Korisnici where k.Email == email select k).FirstOrDefault<Korisnik>();
if (ctx.AktivacijeKorisnika.Select(k => k.KorisnikId).Contains(korisnik.KorisnikId))
activated = false;
else
activated = true;
}
return activated;
}
public override bool ValidateUser(string username, string password)
{
using (RestBizContext ctx = new RestBizContext())
{
var menadzerSistema = (from k in ctx.MenadzeriSistema where k.Email == username select k).FirstOrDefault<MenadzerSistema>();
if (menadzerSistema != null)
{
if (menadzerSistema.Lozinka == password)
return true;
}
else
{
var menadzerRestorana = (from k in ctx.MenadzeriRestorana where k.Email == username select k).FirstOrDefault<MenadzerRestorana>();
if(menadzerRestorana != null)
{
if (menadzerRestorana.Lozinka == password)
return true;
}
else
{
var korisnik = (from k in ctx.Korisnici where k.Email == username select k).FirstOrDefault<Korisnik>();
if (korisnik != null)
{
if (korisnik.Lozinka == password)
return true;
}
}
}
}
return false;
}
