private bool DoesRunnerSponsorExists(RunnerSponsor runnerSponsor)
{
var connection = new SqlConnection(ConnectionString);
connection.Open();
var command =
new SqlCommand(
string.Format(
"SELECT runnerid FROM runnersponsor WHERE runnerid = {0} AND sponsorid = {1}",
runnerSponsor.RunnerId,
runnerSponsor.SponsorId),
connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
connection.Close();
return(true);
}
connection.Close();
return(false);
}
}
private void UpdateRunnerSponsor(RunnerSponsor runnerSponsor)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var command =
new SqlCommand(
string.Format(
"UPDATE runnersponsor SET betrag = {0} where runnerid = {1} and sponsorid = {2}",
runnerSponsor.Betrag,
runnerSponsor.RunnerId,
runnerSponsor.SponsorId),
connection);
command.ExecuteNonQuery();
}
}
private void CreateRunnerSponsor(RunnerSponsor runnerSponsor)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var command =
new SqlCommand(
string.Format(
"INSERT INTO runnersponsor (runnerid, sponsorid, betrag) VALUES ({0}, {1}, {2})",
runnerSponsor.RunnerId,
runnerSponsor.SponsorId,
runnerSponsor.Betrag),
connection);
command.ExecuteNonQuery();
}
}
private void CreateRunnerSponsor(RunnerSponsor runnerSponsor)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var command =
new SqlCommand(
string.Format(
"INSERT INTO runnersponsor (runnerid, sponsorid, betrag) VALUES ({0}, {1}, {2})",
runnerSponsor.RunnerId,
runnerSponsor.SponsorId,
runnerSponsor.Betrag),
connection);
command.ExecuteNonQuery();
}
}
private void UpdateRunnerSponsor(RunnerSponsor runnerSponsor)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var command =
new SqlCommand(
string.Format(
"UPDATE runnersponsor SET betrag = {0} where runnerid = {1} and sponsorid = {2}",
runnerSponsor.Betrag,
runnerSponsor.RunnerId,
runnerSponsor.SponsorId),
connection);
command.ExecuteNonQuery();
}
}
private bool DoesRunnerSponsorExists(RunnerSponsor runnerSponsor)
{
var connection = new SqlConnection(ConnectionString);
connection.Open();
var command =
new SqlCommand(
string.Format(
"SELECT runnerid FROM runnersponsor WHERE runnerid = {0} AND sponsorid = {1}",
runnerSponsor.RunnerId,
runnerSponsor.SponsorId),
connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
connection.Close();
return true;
}
connection.Close();
return false;
}
}