public static List <TurnirModel> ConvertToTurnirModels(
this List <string> lines,
string EkipaFileNaziv,
string osobaFileName,
string NagradaFileNaziv
)
{
List <TurnirModel> output = new List <TurnirModel>();
List <EkipaModel> ekipe = EkipaFileNaziv.FullFilePath().LoadFile().ConvertToEkipaModels(osobaFileName);
List <NagradaModel> nagrade = NagradaFileNaziv.FullFilePath().LoadFile().ConvertToNagradaModels();
foreach (string line in lines)
{
string[] cols = line.Split(',');
TurnirModel tm = new TurnirModel();
tm.ID = int.Parse(cols[0]);
tm.NazivTurnira = cols[1];
tm.Kotizacija = decimal.Parse(cols[2]);
string[] EkipaIDs = cols[3].Split('|');
foreach (string ID in EkipaIDs)
{
tm.PrijavljeniTimovi.Add(ekipe.Where(x => x.ID == int.Parse(ID)).First());
}
string[] NagradaIDs = cols[4].Split('|');
foreach (string ID in NagradaIDs)
{
tm.Nagrade.Add(nagrade.Where(x => x.ID == int.Parse(ID)).First());
}
output.Add(tm);
}
return(output);
}
private void buttonStvori_turnir_Click(object sender, EventArgs e)
{
decimal fee;
bool feeAcceptable = decimal.TryParse(textBoxNagrada.Text, out fee);
if (!feeAcceptable)
{
MessageBox.Show("Moraš upisati pravilnu kotizaciju", "Netočna kotizacija", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
TurnirModel tm = new TurnirModel();
tm.TournamentName = ime_turn.Text;
tm.EntryFee = fee;
tm.EntredTeams = selectedTeams;
foreach (NagradaModel prize in selectedPrizes)
{
tm.Prizes.Add(prize);
}
TournamentLogic.CreateRounds(tm);
GlobalConfig.Connection.CreateTournament(tm);
DashboardForm frm = new DashboardForm(tm);
frm.Show();
this.Close();
}
private void Zapocni_Click(object sender, EventArgs e)
{
TurnirModel tm = (TurnirModel)Izaberi.SelectedItem;
DashboardForm frm = new DashboardForm(tm);
frm.Show();
}
public DashboardForm(TurnirModel tournamentModel)
{
InitializeComponent();
tournament = tournamentModel;
WireUpList();
LoadFormData();
LoadRounds();
}
private void SpremiTurnirPrijavljeni(IDbConnection connection, TurnirModel model)
{
foreach (EkipaModel tm in model.PrijavljeniTimovi)
{
var p = new DynamicParameters();
p.Add("@TournamentId", model.ID);
p.Add("@TeamId", tm.ID);
p.Add("@ID", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spTournamentPrizes_Insert", p, commandType: CommandType.StoredProcedure);
}
}
private void SpremiTurnirNagrade(IDbConnection connection, TurnirModel model)
{
foreach (NagradaModel pz in model.Nagrade)
{
var p = new DynamicParameters();
p.Add("@TournamentId", model.ID);
p.Add("@PrizeId", pz.ID);
p.Add("@ID", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spTournamentPrizes_Insert", p, commandType: CommandType.StoredProcedure);
}
}
private void SpremiTurnir(IDbConnection connection, TurnirModel model)
{
var p = new DynamicParameters();
p.Add("@TurnirModel", model.NazivTurnira);
p.Add("@Kotizacija", model.Kotizacija);
p.Add("@ID", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spTournaments_Insert", p, commandType: CommandType.StoredProcedure);
model.ID = p.Get <int>("@id");
}
public TurnirModel KreiranjeTurnira(TurnirModel model)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(db)))
{
SpremiTurnir(connection, model);
SpremiTurnirNagrade(connection, model);
SpremiTurnirPrijavljeni(connection, model);
return(model);
}
}
public TurnirModel KreiranjeTurnira(TurnirModel model)
{
List <TurnirModel> turniri = TurnirFile
.FullFilePath()
.LoadFile()
.ConvertToTurnirModels(EkipaFile, OsobaFile, NagradaFile);
int currentID = 1;
if (turniri.Count > 0)
{
currentID = turniri.OrderByDescending(x => x.ID).First().ID + 1;
}
model.ID = currentID;
turniri.Add(model);
turniri.SaveToTurnirFile();
}
private void btnKreirajTurnir_Click(object sender, EventArgs e)
{
decimal kotizacija = 0;
bool dobraKotizacija = decimal.TryParse(txtKotizacija.Text, out kotizacija);
if (!dobraKotizacija)
{
MessageBox.Show("Morate upisati dobru kotizaciju!",
"Netočna kotizacija!",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
TurnirModel tm = new TurnirModel();
tm.NazivTurnira = txtNazivTurnira.Text;
tm.Kotizacija = kotizacija;
tm.Nagrade = izabraneNagrade;
tm.PrijavljeniTimovi = izabraneEkipe;
GlobalConfig.Connection.KreiranjeTurnira(tm);
}
