private void AuthtokenLogin()
{
using (var db = new retrospyContext())
{
var info = from u in db.Users
join p in db.Profiles on u.Userid equals p.Userid
join n in db.Subprofiles on p.Profileid equals n.Profileid
where n.Authtoken == _session.UserData.AuthToken &&
n.Partnerid == _session.UserData.PartnerID &&
n.Namespaceid == _session.UserData.NamespaceID
select new LoginDBResult
{
Email = u.Email,
UserID = u.Userid,
ProfileID = p.Profileid,
SubProfileID = n.Subprofileid,
Nick = p.Nick,
UniqueNick = n.Uniquenick,
PasswordHash = u.Password,
NamespaceID = n.Namespaceid,
EmailVerifiedFlag = (bool)u.Emailverified,
BannedFlag = u.Banned
};
if (info.Count() != 1)
{
_errorCode = GPError.LoginBadPreAuth;
return;
}
_result = info.First();
}
}
private void NickEmailLogin()
{
//Check email existence
using (var db = new retrospyContext())
{
var email = from u in db.Users
where u.Email == _session.UserData.Email
select u.Userid;
if (email.Count() == 0)
{
_errorCode = GPError.LoginBadEmail;
return;
}
//Grab information from database
// default namespace id = 0
var info = from u in db.Users
join p in db.Profiles on u.Userid equals p.Userid
join n in db.Subprofiles on p.Profileid equals n.Profileid
where u.Email == _session.UserData.Email &&
p.Nick == _session.UserData.Nick &&
n.Namespaceid == _request.NamespaceID
select new LoginDBResult
{
Email = u.Email,
UserID = u.Userid,
ProfileID = p.Profileid,
SubProfileID = n.Subprofileid,
Nick = p.Nick,
UniqueNick = n.Uniquenick,
PasswordHash = u.Password,
NamespaceID = n.Namespaceid,
EmailVerifiedFlag = (bool)u.Emailverified,
BannedFlag = u.Banned
};
if (info.Count() != 1)
{
_errorCode = GPError.LoginBadProfile;
return;
}
_result = info.First();
}
}