public Liga Map(LigaApiModel apiModel) { var result = new Liga { SaisonId = apiModel.SaisonId, TabellenId = apiModel.TableId, LigaId = apiModel.LigaId, Bezeichnung = $"{apiModel.LigaId}{(!string.IsNullOrEmpty(apiModel.TableId) ? $" {apiModel.TableId}" : string.Empty)} {apiModel.SaisonId}" }; switch (apiModel.Type.ToLower()) { case "utable": result.Austragungsmodus = Austragungsmodus.HinRueckRunde; break; case "wtable": result.Austragungsmodus = Austragungsmodus.Doppelrunde; break; case "amorphous": result.Austragungsmodus = Austragungsmodus.KOSystem; break; case "notable": result.Austragungsmodus = Austragungsmodus.NoTable; break; default: throw new ArgumentException($"Austragungsmodus {apiModel.Type} konnte nicht ermittelt werden"); } return(result); }
public ShowSudijaViewModel() { string role = (string)Application.Current.Properties["Role"]; if (role != "Admin") { Visibility = Visibility.Hidden; } else { Visibility = Visibility.Visible; } DeleteCommand = new MyICommand(onDelete); IspisCommand = new MyICommand(Stampaj); sudije = new ObservableCollection <Sudija>(); using (var db = new BazaZaLiguEntities()) { foreach (Sudija sud in db.Sudijas.ToList()) { Sudija pomSudija = sud; Liga pomLiga = new Liga(); if (sud.Liga != null) { pomLiga.naziv_lige = sud.Liga.naziv_lige; } pomSudija.Liga = pomLiga; sudije.Add(pomSudija); } } OnPropertyChanged("sudije"); }
public IHttpActionResult PutLiga(int id, Liga liga) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != liga.Id) { return(BadRequest()); } db.Entry(liga).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!LigaExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
//9.2 public static int Update(Liga liga, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = pDb; } using (db) using (SqlCommand command = db.CreateCommand(SQL_UPDATE)) { command.Parameters.AddWithValue("@idLiga", liga.IdLiga); PrepareCommand(command, liga); int status = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(status); } }
private static Collection <Liga> Read(SqlDataReader reader) { var ligy = new Collection <Liga>(); while (reader.Read()) { int i = -1; Liga liga = new Liga() { IdLiga = reader.GetInt32(++i), Nazev = reader.GetString(++i), }; if (!reader.IsDBNull(++i)) { liga.Zacatek = reader.GetDateTime(i); } if (!reader.IsDBNull(++i)) { liga.Konec = reader.GetDateTime(i); } ligy.Add(liga); } return(ligy); }
//9.1 public static int Insert(Liga liga, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = pDb; } using (db) using (SqlCommand command = db.CreateCommand(SQL_INSERT)) { PrepareCommand(command, liga); int status = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(status); } }
public async Task <IActionResult> PutLiga(int id, Liga liga) { if (id != liga.LigaId) { return(BadRequest()); } _context.Entry(liga).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LigaExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Offene_Saison_erwarte_korrekte_Ligen() { List <Liga> ligen = _apiSaisonInformationen.Get_Ligen_Async("2020").Result; Liga oberliga = ligen.FirstOrDefault(li => li.LigaId.Equals("Oberliga")); oberliga.LigaId.Should().Be("Oberliga"); oberliga.Bezeichnung.Should().Be("Oberliga 2020"); oberliga.Austragungsmodus.Should().Be(Austragungsmodus.HinRueckRunde); Liga landesliga = ligen.FirstOrDefault(li => li.LigaId.Equals("Landesliga")); landesliga.LigaId.Should().Be("Landesliga"); landesliga.Bezeichnung.Should().Be("Landesliga 2020"); landesliga.Austragungsmodus.Should().Be(Austragungsmodus.HinRueckRunde); Liga bezirksliga = ligen.FirstOrDefault(li => li.LigaId.Equals("Bezirksliga")); bezirksliga.LigaId.Should().Be("Bezirksliga"); bezirksliga.Bezeichnung.Should().Be("Bezirksliga 2020"); bezirksliga.Austragungsmodus.Should().Be(Austragungsmodus.Doppelrunde); }
public async Task <IActionResult> Edit(int id, [Bind("LigaID,Navn,Logo,LandID")] Liga liga) { if (id != liga.LigaID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(liga); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LigaExists(liga.LigaID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["LandID"] = new SelectList(_context.Land, "LandID", "Landenavn", liga.LandID); return(View(liga)); }
public void UcitajNatjecanje(Natjecanje n) { if (n as PrijateljskaUtakmica != null) { ListViewItem lvt = new ListViewItem(n.Id.ToString()); lvt.SubItems.Add(n.Naziv); lvt.SubItems.Add(n.Godiste.ToString()); listViewNatjecanje.Items.Add(lvt); } else if (n as Liga != null) { Liga l = (Liga)n; ListViewItem lvt = new ListViewItem(n.Id.ToString()); lvt.SubItems.Add(n.Naziv); lvt.SubItems.Add(n.Godiste.ToString()); lvt.SubItems.Add(l.Rang.ToString()); lvt.SubItems.Add(l.BrojKlubova.ToString()); lvt.SubItems.Add(l.BrojBodova.ToString()); listViewLige.Items.Add(lvt); } else if (n as Turnir != null) { Turnir l = (Turnir)n; ListViewItem lvt = new ListViewItem(n.Id.ToString()); lvt.SubItems.Add(n.Naziv); lvt.SubItems.Add(n.Godiste.ToString()); lvt.SubItems.Add(l.Rang.ToString()); lvt.SubItems.Add(l.BrojKlubova.ToString()); listViewTurniri.Items.Add(lvt); } }
public bool AddUserToleague(Invitacion invitacion) { try { Task <Persona> tp = Task.Factory.StartNew(() => { return(GetDatosUsuarioByMail(invitacion.Mail)); }); Liga l = GetLigaById(invitacion.Id); Persona p = tp.Result; var a = p.Cuentas.Where(x => x.Value == invitacion.Mail).Select(x => x.Key).First(); if (l.Usuarios == null) { l.Usuarios = new Dictionary <string, string>(); } l.Usuarios.Add(a, invitacion.Mail); WriteConcernResult wcr = GetCollection <Liga>(Settings.Default.ColeccionLiga).Update( Query.EQ("_id", new ObjectId(l.Id)), Update.Replace(l)); if (wcr.Ok) { return(true); } return(false); } catch (Exception ex) { return(false); } }
public async Task <ActionResult <Liga> > PostLiga(Liga liga) { _context.Ligas.Add(liga); await _context.SaveChangesAsync(); return(CreatedAtAction("GetLiga", new { id = liga.LigaId }, liga)); }
public void EliminarLiga(int id) { Liga lig = this.GetLigaId(id); this.context.Ligas.Remove(lig); this.context.SaveChanges(); }
public void onDelete() { using (var db = new BazaZaLiguEntities()) { List <Sudija> provera_sudije = db.Sudijas.Where(x => x.liga_id_lige == Selektovana_liga.L.id_lige).ToList(); //vrati sve sudije koje sude u ligi foreach (Sudija item in provera_sudije) { db.Sudijas.Find(item.id_sudije).liga_id_lige = null; //FK db.SaveChanges(); } List <Klub> provera_klkubova = db.Klubs.Where(x => x.liga_id_lige == Selektovana_liga.L.id_lige).ToList(); //klubovi foreach (Klub item in provera_klkubova) { Klub klub = db.Klubs.Find(item.naziv); klub.liga_id_lige = null; //FK klub.Liga = null; db.Entry(klub).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } var liga_Sponzor = db.Ligas.Find(Selektovana_liga.L.id_lige); List <Sponzor> sponzori = liga_Sponzor.Sponzors.ToList(); foreach (Sponzor item in sponzori) { Sponzor s = db.Sponzors.Find(item.id_sponzora); if (s != null) { Liga l = s.Ligas.Where(x => x.id_lige == liga_Sponzor.id_lige).FirstOrDefault(); s.Ligas.Remove(l); } db.Entry(s).State = System.Data.Entity.EntityState.Modified; } Liga ligaZaBrisanje = db.Ligas.Find(Selektovana_liga.L.id_lige); if (ligaZaBrisanje != null) { db.Entry(ligaZaBrisanje).State = System.Data.Entity.EntityState.Deleted; //brise iz baze } var liga_brisi = lige.Where(x => x.L.id_lige == ligaZaBrisanje.id_lige).First(); if (liga_brisi != null) { lige.Remove(liga_brisi); } OnPropertyChanged("lige"); try { db.SaveChanges(); MessageBox.Show("Liga je obrisana", "Uspesno", MessageBoxButton.OK, MessageBoxImage.Asterisk); LogReport(ligaZaBrisanje); } catch (Exception) { MessageBox.Show("Od lige zavise drugi entiteti, prvo njih obrisati", "Oprez", MessageBoxButton.OK, MessageBoxImage.Warning); } } }
/* * Autor: Johan Sebastian Piza Acosta * Método que devuelve una lista de camisetas según la liga seleccionada */ public List <Camiseta> GetCamisetas(Liga liga) { var consulta = from c in db.Camisetas where c.LigaId == liga.Id select c; return(consulta.ToList()); }
public void ModificarLiga(int id, String Nombre, String descripcion) { Liga lig = GetLigaId(id); lig.Nombre = Nombre; lig.Descripcion = descripcion; this.context.SaveChanges(); }
public void Test_OpretLiga_Ok() { Liga var = new Liga(); var.Navn = "3F Superligaen"; Assert.Equal("3F Superligaen", var.Navn); }
public ActionResult DeleteConfirmed(int id) { Liga liga = db.Ligas.Find(id); db.Ligas.Remove(liga); db.SaveChanges(); return(RedirectToAction("Index")); }
protected void btnNuevoCamp_Click(object sender, EventArgs e) { Liga lig = new Liga(); lig.setUltimoCampeon(Convert.ToInt32(DropDownList1.SelectedItem.Value)); lig.setId(Convert.ToInt32(txbxUpdate.Text)); sq.UpdateLiga(lig); }
//Actualizar liga private void button2_Click(object sender, EventArgs e) { Liga lig = new Liga(); lig.setUltimoCampeon(Convert.ToInt32((cmbxCampeon.SelectedItem as ComboboxItem).Value)); lig.setId(Convert.ToInt32(txbxUpId.Text)); sq.UpdateLiga(lig); cleanTexts(); }
public async Task <ActionResult> DeleteConfirmed(int id) { Liga liga = await db.Liga.FindAsync(id); db.Liga.Remove(liga); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public void OnDodajLigu() { if (validate()) { //ShowLigaViewModel.dodajLigu(Liga_prop); using (var db = new BazaZaLiguEntities()) { Liga l1 = new Liga() { naziv_lige = Liga_prop.naziv_lige, drzava_lige = Liga_prop.drzava_lige, broj_klubova = 0 }; //generise sledeci ID: List <Liga> lige = db.Ligas.ToList(); //id logic int nextID = 0; Liga proveraID = null; do { proveraID = db.Ligas.Where(x => x.id_lige == nextID + 1).FirstOrDefault(); nextID++; }while (proveraID != null); l1.id_lige = nextID; foreach (Sudija sud in Liga_prop.Sudijas) //dodavanje sudija u ligu { Sudija sudijaUpdate = db.Sudijas.Find(sud.id_sudije); l1.Sudijas.Add(sudijaUpdate); } foreach (Sponzor_Selektovan sponzor in sponzori) // dodavanje sponzora { if (sponzor.SelectedItem) { Sponzor selektovanSponzor = db.Sponzors.Find(sponzor.S.id_sponzora); l1.Sponzors.Add(selektovanSponzor); //ovo funkcionise } } db.Ligas.Add(l1); db.SaveChanges(); LogReport(l1); } MessageBox.Show("Liga je uspesno dodata", "Uspesno", MessageBoxButton.OK, MessageBoxImage.Asterisk); //vrati na prazno : Liga_prop.drzava_lige = ""; Liga_prop.naziv_lige = ""; Liga_prop.id_lige = 0; foreach (Sudija_Selektovan item in sudije) //smisli nesto za ovo { item.IsSelected = false; } OnPropertyChanged("Liga_prop"); OnPropertyChanged("sudije"); } }
public bool DeleteLiga(Liga liga) { WriteConcernResult wr = GetCollection <Liga>(Settings.Default.ColeccionLiga).Remove(Query.EQ("_id", new ObjectId(liga.Id))); if (wr.Ok) { return(true); } return(false); }
public ActionResult Edit([Bind(Include = "Id,Equipo,DirectorTecnico,Estadio,Capacidad,Fundacion,Campeonatos")] Liga liga) { if (ModelState.IsValid) { db.Entry(liga).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(liga)); }
// GET: Liga/Edit/5 public ActionResult EditName() { Liga liga = _ligaNegocio.GetLiga(); if (liga == null) { return(NotFound()); } return(View(liga)); }
public LigaInfo(Amigo[] amigos, Liga liga, bool membro, int pagina, Time_Dono timeDono, Time_Usuario timeUsuario, Time[] times) { this.amigos = amigos; this.liga = liga; this.membro = membro; this.pagina = pagina; time_dono = timeDono; time_usuario = timeUsuario; this.times = times; }
public void NuevaLiga(String nombre, String descripcion) { Liga lig = new Liga(); lig.IdLiga = this.GetMaxIdLiga() + 1; lig.Nombre = nombre; lig.Descripcion = descripcion; this.context.Add(lig); this.context.SaveChanges(); }
public async Task <ActionResult> Edit([Bind(Include = "lig_codigo,lig_descripcion")] Liga liga) { if (ModelState.IsValid) { db.Entry(liga).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(liga)); }
public ActionResult Create([Bind(Include = "Id,Equipo,DirectorTecnico,Estadio,Capacidad,Fundacion,Campeonatos")] Liga liga) { if (ModelState.IsValid) { db.Ligas.Add(liga); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(liga)); }
public ActionResult Create(Liga liga) { if (ModelState.IsValid) { db.Liga.Add(liga); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(liga)); }
public void Execute(ICommandContext context) { var liga = new Liga(); liga.Apply(new LigaCreated { Id = Id, Name = Name }); context.Repository.Save(liga); }