/* -------------------------------- Get Data -------------------------------- */
public List <LoginDetailsTable> getData(string Username)
{
/// <summary> Returns Username, UserPassword, Email, PhoneNumber as a list for the matching Username
string executeString = string.Format("EXEC SearchForUsername @Username = '******'", Username);
var query = LoginDetailsTable.SendAndGetQuery(executeString);
return(query.ToList());
}
/* --------------------------------- Search --------------------------------- */
public int GetIDNonUser(string Name)
{ /// <summary> Returns the ID from users without accounts of the matching Username combination
string executeString = string.Format("EXEC GetID @PersonName = '{0}'", Name);
var query = LoginDetailsTable.SendAndGetQuery(executeString);
foreach (var item in query)
{
return(item.PersonID);
}
return(0);
}
public int GetIDExistingUser(string Username)
{ /// <summary> Returns the ID from users with accounts of the matching Username combination
string executeString = string.Format("EXEC GetIDFromLogin @Username = '******'", Username);
var query = LoginDetailsTable.SendAndGetQuery(executeString);
Debug.WriteLine(query);
foreach (var item in query)
{
return(item.PersonID);
}
return(0);
}
public bool LoginEmail(string Email, string Password)
{
/// <summary> Allows login with Email/Password combination
string executeString = string.Format(
"SELECT PersonID FROM Student29.dbo.LoginDetails WHERE Email = '{0}' AND Password = '{1}",
Email,
Password);
var query = LoginDetailsTable.SendAndGetQuery(executeString);
LoginDetailsTable[] queryArray = query.ToArray();
return(isCorrectCredentials(queryArray));
}
/* ---------------------------------- Login --------------------------------- */
public bool LoginUsername(string Username, string Password)//return bool pls
{
/// <summary> Allows login with Username/Password combination
string executeString = string.Format(
"SELECT PersonID FROM Student29.dbo.LoginDetails WHERE Username = '******' AND UserPassword = '******'",
Username,
Password);
var query = LoginDetailsTable.SendAndGetQuery(executeString);
LoginDetailsTable[] queryArray = query.ToArray();
return(isCorrectCredentials(queryArray));
}
