public BatalhaModels ObterBatalha(long id) { SqlConnection conexao = new SqlConnection(); SqlCommand command = new SqlCommand(); conexao.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString(); StringBuilder select = new StringBuilder(); select.AppendLine("select Guilda,LIFE,DATA,PontuacaoOponente,PontuacaoGuild,RankGuild,idGuilda,Id,IdGuildaAtacante "); select.AppendLine(",(select case when count(1) > 1 then 1 else 0 end from dbo.lutas b where b.CodBatalhas = a.ID and b.MomentoVitoria = 'Win') Vitoria "); select.AppendLine("from dbo.Batalhas a"); select.AppendLine("where id = @id "); command.CommandText = select.ToString(); command.CommandType = System.Data.CommandType.Text; command.Parameters.Add(new SqlParameter("@id", System.Data.SqlDbType.Int)); command.Parameters["@id"].Value = id; try { BatalhaModels objBatalha = new BatalhaModels(); conexao.Open(); command.Connection = conexao; SqlDataReader reader = command.ExecuteReader(); Guilda daGuilda = new Guilda(); while (reader.Read()) { objBatalha = new BatalhaModels(); objBatalha.Data = Convert.ToDateTime(reader["Data"].ToString()); objBatalha.GuildaAtacante = daGuilda.ObterGuilda(long.Parse(reader["IdGuildaAtacante"].ToString())); objBatalha.GuildaOponente = reader["Guilda"].ToString(); objBatalha.RankGuild = int.Parse(reader["RankGuild"].ToString()); objBatalha.Vitoria = Convert.ToBoolean(int.Parse(reader["Vitoria"].ToString())); } conexao.Close(); conexao.Dispose(); return(objBatalha); } catch (Exception ex) { throw ex; } }
public List <LutasModels> ListarLutas(int idBatalha, long idGuilda) { SqlConnection conn = new SqlConnection(); SqlCommand sqlCom = new SqlCommand(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString(); StringBuilder select = new StringBuilder(); select.AppendLine("select "); select.AppendLine("a.ID, a.CodBatalhas,a.CodPlayer,a.CodPlayerOponente,a.Vitoria, a.ValorBarra, a.DataHora, a.MomentoVitoria "); select.AppendLine("from dbo.lutas a "); select.AppendLine("where a.CodBatalhas = @idBatalha "); sqlCom.CommandText = select.ToString(); sqlCom.CommandType = System.Data.CommandType.Text; sqlCom.Parameters.Add(new SqlParameter("@idBatalha", System.Data.SqlDbType.Int)); sqlCom.Parameters["@idBatalha"].Value = idBatalha; List <LutasModels> objRetorno = new List <LutasModels>(); try { conn.Open(); sqlCom.Connection = conn; SqlDataReader reader = sqlCom.ExecuteReader(); LutasModels objLuta = null; BatalhaModels objBatalha = new BatalhaModels(); objBatalha = new DataAccess.Batalha().ObterBatalha(idBatalha); //Obter Players List <PlayerModels> lstPlayer = new List <PlayerModels>(); lstPlayer = new Player().ListarPlayers(idGuilda); while (reader.Read()) { objLuta = new LutasModels(); objLuta.Batalhas = objBatalha; objLuta.DataHora = Convert.ToDateTime(reader["DataHora"].ToString()); objLuta.Id = Convert.ToInt32(reader["ID"].ToString()); objLuta.MomentoVitoria = reader["MomentoVitoria"].ToString(); objLuta.Player = lstPlayer.First(x => x.Id == long.Parse(reader["CodPlayer"].ToString())); objLuta.PlayerOponente = new PlayerOponenteModels() { Id = long.Parse(reader["CodPlayerOponente"].ToString()) }; objLuta.ValorBarra = int.Parse(reader["ValorBarra"].ToString()); objLuta.Vitoria = int.Parse(reader["Vitoria"].ToString()); objRetorno.Add(objLuta); } conn.Close(); conn.Dispose(); } catch (Exception) { throw; } return(objRetorno); }