/// <summary>
/// Get list of Groups
/// </summary>
/// <returns></returns>
public static DataTable LoadGroupOptions()
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
DataTable dt = sql.QueryDataTable("SELECT * FROM [tblCOM_Groups] WHERE ClientID = @ClientId", new SqlParameter("@ClientId", Config.clientId));
if (!sql.HasError)
{
return(dt);
}
return(null);
}
/// <summary>
/// Checks the email is already in use
/// </summary>
/// <param name="password"></param>
/// <param name="message"></param>
/// <returns></returns>
public static bool IsExistingEmail(string email, out string message)
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
DataTable dtEmail = sql.QueryDataTable("SELECT UserID FROM [tblCOM_Users] WHERE Email = @Email",
new SQLParamList().Add("@Email", email));
if (sql.HasError)
{
message = UserResource.Error_DBEmailValidationError;
return(false);
}
else if (dtEmail.Rows.Count > 0)
{
message = UserResource.Error_EmailInUse;
return(false);
}
else
{
message = UserResource.Success_Email;
return(true);
}
}