public PlayerUsuarioModels ObterPlayerUsuario(int idPlayer)
{
SqlConnection conn = new SqlConnection();
SqlCommand sqlCom = new SqlCommand();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString();
StringBuilder cmd = new StringBuilder();
cmd.Append("select b.Ativo,b.IdGuilda,a.ID idPlayer,d.Id IdUsuario from dbo.Player a ");
cmd.Append("left join dbo.Guilda_Player b on b.IdPlayer = a.ID ");
cmd.Append("left join dbo.Guilda c on c.Id = b.IdGuilda ");
cmd.Append("left join dbo.AspNetUsers d on d.Id = b.IdUsuario ");
cmd.Append("where a.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 = idPlayer;
try
{
Models.PlayerUsuarioModels objRetorno = new PlayerUsuarioModels();
conn.Open();
sqlCom.Connection = conn;
SqlDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
objRetorno = new Models.PlayerUsuarioModels();
if (reader["Ativo"].ToString() != string.Empty)
{
objRetorno.Ativo = bool.Parse(reader["Ativo"].ToString());
}
if (reader["IdGuilda"].ToString() != string.Empty)
{
objRetorno.Guilda = new Guilda().ObterGuilda(long.Parse(reader["IdGuilda"].ToString()));
}
objRetorno.Player = new Player().ObterPlayer(int.Parse(reader["idPlayer"].ToString()));;
if (reader["IdUsuario"].ToString() != string.Empty)
{
objRetorno.Usuario = new Usuario().ObterUsario(reader["IdUsuario"].ToString());
}
}
conn.Close();
conn.Dispose();
return(objRetorno);
}
catch (Exception ex)
{
throw ex;
}
}
public void AtualizarPlayerUsuario(Models.PlayerUsuarioModels objPlayerUsuario)
{
SqlConnection conexao = new SqlConnection();
SqlCommand command = new SqlCommand();
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString();
StringBuilder select = new StringBuilder();
select.AppendLine("update dbo.Guilda_Player set ativo = @ativo,idUsuario=@idUsuario where idGuilda = @idGuilda and idPlayer=@idPlayer");
command.Parameters.Add(new SqlParameter("@idGuilda", System.Data.SqlDbType.BigInt));
command.Parameters["@idGuilda"].Value = objPlayerUsuario.Guilda.Id;
command.Parameters.Add(new SqlParameter("@idPlayer", System.Data.SqlDbType.BigInt));
command.Parameters["@idPlayer"].Value = objPlayerUsuario.Player.Id;
command.Parameters.Add(new SqlParameter("@ativo", System.Data.SqlDbType.Bit));
command.Parameters["@ativo"].Value = objPlayerUsuario.Ativo;
command.Parameters.Add(new SqlParameter("@idUsuario", System.Data.SqlDbType.VarChar));
command.Parameters["@idUsuario"].Value = objPlayerUsuario.UsuarioCombo.SelectedOption;
command.CommandText = select.ToString();
command.CommandType = System.Data.CommandType.Text;
conexao.Open();
command.Connection = conexao;
command.ExecuteNonQuery();
conexao.Close();
conexao.Dispose();
}