public void InserirSiegePlayer(Models.SiegePlayer obj)
{
SqlConnection conexao = new SqlConnection();
SqlCommand command = new SqlCommand();
conexao.ConnectionString = BLO.Conexao.ObterStringConexao2();
StringBuilder select = new StringBuilder();
select.AppendLine("SET DATEFORMAT dmy;");
select.AppendLine("MERGE DBO.SiegePlayers AS TARGET ");
select.AppendLine("USING(SELECT @IdSiege AS IdSiege, @IdPlayer as IdPlayer) AS SOURCE ");
select.AppendLine("ON TARGET.IdSiege = SOURCE.IdSiege and ");
select.AppendLine("Target.IdPlayer = SOURCE.IdPlayer ");
select.AppendLine("WHEN MATCHED THEN ");
select.AppendLine("UPDATE SET TARGET.UsedUnitCount = @UsedUnits ");
select.AppendLine("WHEN NOT MATCHED BY TARGET THEN ");
select.AppendLine("INSERT(IdSiege, IdPlayer, UsedUnitCount) ");
select.AppendLine("VALUES(@IdSiege, @IdPlayer, @UsedUnits); ");
command.Parameters.Add(new SqlParameter("@IdSiege", System.Data.SqlDbType.BigInt));
command.Parameters["@IdSiege"].Value = obj.IdSiege;
command.Parameters.Add(new SqlParameter("@IdPlayer", System.Data.SqlDbType.BigInt));
command.Parameters["@IdPlayer"].Value = obj.IdPlayer;
command.Parameters.Add(new SqlParameter("@UsedUnits", System.Data.SqlDbType.Int));
command.Parameters["@UsedUnits"].Value = obj.UsedUnits;
command.CommandText = select.ToString();
command.CommandType = System.Data.CommandType.Text;
conexao.Open();
command.Connection = conexao;
command.ExecuteNonQuery();
conexao.Close();
conexao.Dispose();
}
public void InserirSiegePlayer(Models.SiegePlayer obj)
{
new DAO.DAO_SiegePlayer().InserirSiegePlayer(obj);
}
