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