/// <summary>
/// Checking if is user already registered with given e-mail address
/// </summary>
/// <param name="email"></param>
/// <returns>True/False</returns>
private static bool isAlreadyregistered(string email)
{
string comm = "SELECT * FROM Users WHERE email = '" + email + "'";
User u = new User(-1);
String s = "";
SqlDataReader reader = u.ExecuteReader(comm, ref s);
bool isRegistered = false;
while (reader.Read())
{
isRegistered = true;
}
reader.Close();
return isRegistered;
}
/// <summary>
/// Get user group id
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
private static string getUsertype(string p)
{
string comm = "SELECT UTypeID FROM UserTypes WHERE Usertypename = '" + p + "'";
User u = new User(-1);
String s = "";
SqlDataReader reader = u.ExecuteReader(comm, ref s);
while (reader.Read())
{
s = reader["UTypeID"].ToString();
}
reader.Close();
return s;
}
