public List <DML.MatchAttacks> PositionsAttacked(int pMatchId, int pTarget)
{
StringBuilder query = new StringBuilder();
query.AppendLine("DECLARE @MATCH INTEGER, @TARGET INTEGER");
query.AppendLine($"SET @MATCH = { pMatchId }");
query.AppendLine($"SET @TARGET = { pTarget }");
query.AppendLine("SELECT MatchId,");
query.AppendLine(" PosX,");
query.AppendLine(" PosY,");
query.AppendLine(" Target");
query.AppendLine("FROM MatchAttacks WITH(NOLOCK)");
query.AppendLine("WHERE MATCHID = @MATCH AND TARGET = @TARGET");
DataSet ds = IUnitOfWork.Consulta(query.ToString());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
var retorno = new List <DML.MatchAttacks>();
foreach (DataRow row in ds.Tables[0].Rows)
{
DML.MatchAttacks attacks = new DML.MatchAttacks()
{
MatchId = Convert.ToInt32(row["MatchId"]),
PosX = Convert.ToInt32(row["PosX"]),
PosY = Convert.ToInt32(row["PosY"]),
Target = Convert.ToInt32(row["Target"])
};
retorno.Add(attacks);
}
return(retorno);
}
return(new List <DML.MatchAttacks>());
}
public void RegisterMatchAttacks(DML.MatchAttacks pMatchAttack)
{
IUnitOfWork.Executar(IUnitOfWork.MontaInsertPorAttributo(pMatchAttack).ToString());
}
