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); }