public List <Models.PlayerModels> ListarPlayersSemUsuarios(long idGuilda)
{
SqlConnection conn = new SqlConnection();
SqlCommand sqlCom = new SqlCommand();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString();
StringBuilder cmd = new StringBuilder();
cmd.Append("SELECT A.*FROM DBO.PLAYER A ");
cmd.Append("INNER JOIN DBO.GUILDA_PLAYER B ON B.IDPLAYER = A.ID ");
cmd.Append("WHERE ");
cmd.Append("A.STATUS = 'S' ");
cmd.Append("AND B.IDGUILDA = @idGuilda ");
cmd.Append("AND B.IdUsuario IS NULL ");
cmd.Append("ORDER BY NOME ");
sqlCom.Parameters.Add(new SqlParameter("@idGuilda", System.Data.SqlDbType.BigInt));
sqlCom.Parameters["@idGuilda"].Value = idGuilda;
sqlCom.CommandText = cmd.ToString();
sqlCom.CommandType = System.Data.CommandType.Text;
try
{
Models.PlayerModels objPlayer;
List <Models.PlayerModels> objRetorno = new List <PlayerModels>();
conn.Open();
sqlCom.Connection = conn;
SqlDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
objPlayer = new Models.PlayerModels();
objPlayer.Id = Convert.ToInt32(reader["ID"].ToString());
objPlayer.Nome = reader["Nome"].ToString();
objPlayer.Level = Convert.ToInt32(reader["Level"].ToString());
objPlayer.PontoArena = Convert.ToInt32(reader["PontoArena"].ToString());
objPlayer.Ativo = (reader["Status"].ToString() == "S") ? true : false;
objRetorno.Add(objPlayer);
}
conn.Close();
conn.Dispose();
return(objRetorno);
}
catch (Exception ex)
{
throw ex;
}
}
public List <Models.PlayerModels> ListarPlayersSemGuild()
{
SqlConnection conn = new SqlConnection();
SqlCommand sqlCom = new SqlCommand();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString();
StringBuilder cmd = new StringBuilder();
cmd.Append("SELECT a.* FROM dbo.Player a ");
cmd.Append("WHERE Status = 'S' ");
cmd.Append("and not exists(select 0 from dbo.Guilda_Player b where b.IdPlayer = a.ID) ");
cmd.Append("order by a.Nome");
sqlCom.CommandText = cmd.ToString();
sqlCom.CommandType = System.Data.CommandType.Text;
try
{
Models.PlayerModels objPlayer;
List <Models.PlayerModels> objRetorno = new List <PlayerModels>();
conn.Open();
sqlCom.Connection = conn;
SqlDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
objPlayer = new Models.PlayerModels();
objPlayer.Id = Convert.ToInt32(reader["ID"].ToString());
objPlayer.Nome = reader["Nome"].ToString();
objPlayer.Level = Convert.ToInt32(reader["Level"].ToString());
objPlayer.PontoArena = Convert.ToInt32(reader["PontoArena"].ToString());
objPlayer.Ativo = (reader["Status"].ToString() == "S") ? true : false;
objRetorno.Add(objPlayer);
}
conn.Close();
conn.Dispose();
return(objRetorno);
}
catch (Exception ex)
{
throw ex;
}
}
public Models.PlayerModels ObterPlayer(int id)
{
SqlConnection conn = new SqlConnection();
SqlCommand sqlCom = new SqlCommand();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString();
StringBuilder cmd = new StringBuilder();
cmd.Append("SELECT * FROM DB_SW.dbo.Player WHERE ID = @ID");
sqlCom.CommandText = cmd.ToString();
sqlCom.CommandType = System.Data.CommandType.Text;
sqlCom.Parameters.Add(new SqlParameter("@ID", System.Data.SqlDbType.Int));
sqlCom.Parameters["@ID"].Value = id;
try
{
Models.PlayerModels objPlayer = new PlayerModels();
conn.Open();
sqlCom.Connection = conn;
SqlDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
objPlayer = new Models.PlayerModels();
objPlayer.Id = Convert.ToInt32(reader["ID"].ToString());
objPlayer.Nome = reader["Nome"].ToString();
objPlayer.Level = Convert.ToInt32(reader["Level"].ToString());
objPlayer.PontoArena = Convert.ToInt32(reader["PontoArena"].ToString());
objPlayer.Ativo = (reader["Status"].ToString() == "S") ? true : false;
}
conn.Close();
conn.Dispose();
return(objPlayer);
}
catch (Exception ex)
{
throw ex;
}
}