/// <summary>Obtm todos os scans de um planeta</summary>
public override Scan[] GetScans(Planet scanner)
{
Hashtable parameters = new Hashtable();
parameters.Add("@targetPlanetOwner", scanner.Id);
DataSet ds = SqlServerUtility.getFromDB("OrionsBelt_GetScansByPlanetId", parameters);
return(DataSetToScans(ds));
}
/// <summary>Obtém as notícias existentes por linguagem </summary>
protected override NewsList GetNewsFromDBByLang(string lang)
{
Hashtable parameters = new Hashtable();
parameters.Add("@lang", lang);
DataSet ds = SqlServerUtility.getFromDB("OrionsBelt_GetNewsByLang", parameters);
return(NewsFromDataSet(ds));
}
/// <summary>Obtm um scan dado o seu id</summary>
public override Scan GetScan(int id)
{
Hashtable parameters = new Hashtable();
parameters.Add("@id", id);
DataSet ds = SqlServerUtility.getFromDB("OrionsBelt_GetScansById", parameters);
return(DataSetToScans(ds)[0]);
}
/// <summary>Obtm todos os utilizadores com a role passada</summary>
public override int[] getUsers(int role)
{
Hashtable param = new Hashtable();
param.Add("@role", role);
DataSet ds = SqlServerUtility.getFromDB("OrionsBelt_UsersGetUsersIdByRole", param);
return(fetchUsersIds(ds));
}
public override string checkUser(int id)
{
Hashtable param = new Hashtable();
param.Add("@user_id", id);
DataSet ds = SqlServerUtility.getFromDB("OrionsBelt_UsersGetMailFromId", param);
if (ds.Tables.Count == 0)
{
throw new AlnitakException("O Dataset deveria ter pelo menos 1 resultado @ SqlServerUserUtility::checkUser(int id)");
}
return(ds.Tables[0].Rows[0]["user_mail"].ToString());
}
public override string getAvatar(int rulerId)
{
Hashtable param = new Hashtable();
param.Add("@ruler_id", rulerId);
DataSet ds = SqlServerUtility.getFromDB("OrionsBelt_UsersGetAvatar", param);
if (ds.Tables[0].Rows.Count != 1)
{
return(User.DefaultAvatar);
}
string s = (string)ds.Tables[0].Rows[0]["user_avatar"];
return(s == string.Empty?User.DefaultAvatar:s);
}
public override string[] getAllSectionsRolesFromDB(int section_id)
{
Hashtable parameters = new Hashtable();
parameters.Add("@section_id", section_id.ToString());
DataSet roles = SqlServerUtility.getFromDB("OrionsBelt_SectionsGetAllSectionsRoles", parameters);
int results = roles.Tables[0].Rows.Count;
string[] rolesArray = new string[results];
for (int i = 0; i < results; ++i)
{
DataRow row = roles.Tables[0].Rows[i];
rolesArray[i] = (string)row["roles_roleName"];
}
return(rolesArray);
}
/// <summary>Obtém todos os scans de um jogador em todos os planetas</summary>
public override Scan[] GetScans(Ruler ruler)
{
StringWriter writer = new StringWriter();
writer.Write("scans_sourcePlanetId={0}", ruler.Planets[0].Id);
for (int i = 1; i < ruler.Planets.Length; ++i)
{
writer.Write(" or scans_sourcePlanetId={0} ", ruler.Planets[i].Id);
}
Hashtable parameters = new Hashtable();
parameters.Add("@count", 40);
parameters.Add("@types", writer.ToString( ));
DataSet ds = SqlServerUtility.getFromDB("OrionsBelt_GetScans", parameters);
return(DataSetToScans(ds));
}
/// <summary>Retorna as roles de um User</summary>
public override string[] getRoles(string userMail)
{
Hashtable param = new Hashtable();
param.Add("@user_mail", userMail);
DataSet dataset = SqlServerUtility.getFromDB("OrionsBelt_UsersGetUserRoles", param);
string[] roles = new string[dataset.Tables[0].Rows.Count];
int i = 0;
foreach (DataRow role in dataset.Tables[0].Rows)
{
roles[i++] = (string)role["roles_roleName"];
}
return(roles);
}