public void CreateTeam(GroupDisplayModel team) => InTransaction(c =>
{
var sql = @"insert into team (name) values (@Name);";
using (var cmd = c.CreateCommand(sql))
{
cmd.AddParameter("Name", team.Name);
cmd.ExecuteNonQuery();
}
team.Id = GetLastId(c);
});
public void CreatePickupRound(GroupDisplayModel pickup) => InTransaction(c =>
{
var sql = @"insert into pickup_round (name) values (@Name);";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("Name", pickup.Name);
cmd.ExecuteNonQuery();
}
pickup.Id = GetLastId(c);
});
public static void Write(GroupDisplayModel model)
{
Console.ForegroundColor = ConsoleColor.DarkBlue;
Console.Write(" Team: ");
Console.ResetColor();
if (model == null)
{
Console.WriteLine("NULL");
}
else
{
Console.WriteLine($"[{model.Id}] {model.Name}");
}
}
public static IEnumerable <GroupDisplayModel> AsTeamDisplayModel(this IDataReader reader)
{
var result = new List <GroupDisplayModel>();
while (reader.Read())
{
var team = new GroupDisplayModel
{
Id = (reader.HasColumn("Id")) ? (long)reader["Id"] : default(long),
Name = (reader.HasColumn("Name")) ? reader["Name"] as string : null,
};
result.Add(team);
}
return(result);
}
public void UpdatePickupRound(GroupDisplayModel pickup)
{
using (var c = NewConnection())
{
var sql = @"
update pickup_round
set name = @Name
where id = @Id";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("Id", pickup.Id);
cmd.AddParameter("Name", pickup.Name);
cmd.ExecuteNonQuery();
}
}
}
public void UpdateTeam(GroupDisplayModel team)
{
using (var c = NewConnection())
{
var sql = @"
update team
set name = @Name
where id = @Id";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("Id", team.Id);
cmd.AddParameter("Name", team.Name);
cmd.ExecuteNonQuery();
}
}
}
public void RemovePickup(GroupDisplayModel pickup) => InTransaction(c =>
{
var sql = @"
update person
set
pickup_round_id = null
where pickup_round_id = @prid";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("prid", pickup.Id);
cmd.ExecuteNonQuery();
}
sql = @"
delete from pickup_round
where id = @id";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("id", pickup.Id);
cmd.ExecuteNonQuery();
}
});
public void Remove(GroupDisplayModel team) => InTransaction(c =>
{
var sql = @"
update person
set
team_id = null
where team_id = @tid";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("tid", team.Id);
cmd.ExecuteNonQuery();
}
sql = @"
delete from team
where id = @id";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("id", team.Id);
cmd.ExecuteNonQuery();
}
});
public void Execute()
{
Output.WriteTitle("Get teams");
DisplayTeams();
var team = new GroupDisplayModel()
{
Name = Guid.NewGuid().ToString()
};
Output.WriteTitle("Add new team");
_service.CreatePickupRound(team);
DisplayTeams();
Output.WriteTitle("Update team name");
team.Name += "zzzz";
_service.UpdateTeam(team);
DisplayTeams();
Output.WriteTitle("Delete team");
_service.Remove(team);
DisplayTeams();
}
public void Execute()
{
Output.WriteTitle("Get pickup rounds");
DisplayCategories();
var pickup = new GroupDisplayModel()
{
Name = Guid.NewGuid().ToString()
};
Output.WriteTitle("Add new pickup round");
_service.CreatePickupRound(pickup);
DisplayCategories();
Output.WriteTitle("Update pickup round name");
pickup.Name += "zzzz";
_service.UpdateTeam(pickup);
DisplayCategories();
Output.WriteTitle("Delete pickup rounds");
_service.Remove(pickup);
DisplayCategories();
}
