protected override object Execute(DomenskiObjekat domenskiObjekat) { Predmet predmet = (Predmet)domenskiObjekat; List <Predmet> predmeti = broker.VratiSveJoinWhere(domenskiObjekat).OfType <Predmet>().ToList(); return(predmeti); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Klijent klijent = (Klijent)domenskiObjekat; List <Klijent> klijenti = broker.Filtriraj(domenskiObjekat).OfType <Klijent>().ToList(); return(klijenti); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Clan clan = (Clan)domenskiObjekat; List <Clan> clanovi = broker.Pronadji(domenskiObjekat).OfType <Clan>().ToList(); return(clanovi); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Termin termin = (Termin)domenskiObjekat; List <Termin> termini = broker.Pronadji(domenskiObjekat).OfType <Termin>().ToList(); return(termini); }
protected override void Validate(DomenskiObjekat domenskiObjekat) { if (!(domenskiObjekat is Clan)) { throw new ArgumentException(); } }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Advokat advokat = (Advokat)domenskiObjekat; List <Advokat> advokati = broker.VratiSve(domenskiObjekat).OfType <Advokat>().ToList(); return(advokati); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Sekretar sekretar = (Sekretar)domenskiObjekat; List <Sekretar> sekretari = broker.VratiSve(domenskiObjekat).OfType <Sekretar>().ToList(); return(sekretari); }
public int Sacuvaj(DomenskiObjekat objekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"INSERT INTO {objekat.TableName} VALUES ({objekat.InsertValues})"; return(command.ExecuteNonQuery()); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { GrupaZaTrening grupa = (GrupaZaTrening)domenskiObjekat; List <GrupaZaTrening> grupe = broker.Pronadji(domenskiObjekat).OfType <GrupaZaTrening>().ToList(); return(grupe); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Trener trener = (Trener)domenskiObjekat; List <Trener> treneri = broker.VratiSve(domenskiObjekat).OfType <Trener>().ToList(); return(treneri); }
public int Obrisi(DomenskiObjekat objekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"DELETE FROM {objekat.TableName} WHERE {objekat.KriterijumPretrage}"; return(command.ExecuteNonQuery()); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Sastanak sastanak = (Sastanak)domenskiObjekat; List <Sastanak> sastanci = broker.VratiSveJoinWhere(domenskiObjekat).OfType <Sastanak>().ToList(); return(sastanci); }
public object ExecuteSO(DomenskiObjekat domenskiObjekat) { object res = null; try { Validate(domenskiObjekat); broker.OpenConnection(); broker.BeginTransaction(); res = Execute(domenskiObjekat); broker.Commit(); } catch (Exception e) { MessageBox.Show(e.Message); broker.Rollback(); } finally { broker.CloseConnection(); } return(res); }
protected override void Validate(DomenskiObjekat domenskiObjekat) { if (!(domenskiObjekat is GrupaZaTrening)) { throw new ArgumentException(); } }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Predmet predmet = (Predmet)domenskiObjekat; bool odgovor = true; if (broker.Sacuvaj(predmet) <= 0) { odgovor = false; } //List<DomenskiObjekat> p = broker.VratiSve(new Predmet()); //foreach(Predmet p1 in p) //{ // Console.WriteLine(p1.PredmetID + " " + p1.Klijent.KlijentID); //} foreach (Angazovanje a in angazovanja) { a.Predmet.PredmetID = broker.VratiMaxID(predmet); if (broker.Sacuvaj(a) <= 0) { odgovor = false; } } return(odgovor); }
public int Sacuvaj(DomenskiObjekat domenskiObjekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"Insert into {domenskiObjekat.TableName} values ({domenskiObjekat.InsertValues})"; Console.WriteLine(command.CommandText); return(command.ExecuteNonQuery()); }
public object Azuriraj(DomenskiObjekat objekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"UPDATE {objekat.TableName} SET {objekat.UpdateValues} WHERE {objekat.KriterijumPretrage}"; object rezultat = command.ExecuteNonQuery(); return(rezultat); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Predmet predmet = (Predmet)domenskiObjekat; if (broker.Arhiviraj(predmet) > 0) { return(true); } return(false); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Klijent klijent = (Klijent)domenskiObjekat; if (broker.Azuriraj(klijent) == 1) { return(true); } return(false); }
public int Arhiviraj(DomenskiObjekat domenskiObjekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"Update {domenskiObjekat.TableName} set {domenskiObjekat.Arhiviranje} where {domenskiObjekat.KriterijumPretrage}"; Console.WriteLine(command.CommandText); int rez = command.ExecuteNonQuery(); return(rez); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Clan clan = (Clan)domenskiObjekat; if (broker.Obrisi(clan) > 0) { return(true); } return(false); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { GrupaZaTrening grupa = (GrupaZaTrening)domenskiObjekat; if (broker.Sacuvaj(grupa) > 0) { return(true); } return(false); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { Termin termin = (Termin)domenskiObjekat; if (broker.Obrisi(termin) > 0) { return(true); } return(false); }
public List <DomenskiObjekat> Filtriraj(DomenskiObjekat domenskiObjekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"SELECT * FROM {domenskiObjekat.TableName} where {domenskiObjekat.UslovZaFiltriranje}"; SqlDataReader reader = command.ExecuteReader(); List <DomenskiObjekat> rezultat = domenskiObjekat.GetEntities(reader); reader.Close(); return(rezultat); }
public DomenskiObjekat Pronadji(DomenskiObjekat domenskiObjekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"SELECT * FROM {domenskiObjekat.TableName} where {domenskiObjekat.KriterijumPretrage}"; SqlDataReader reader = command.ExecuteReader(); DomenskiObjekat rezultat = domenskiObjekat.GetEntity(reader); reader.Close(); return(rezultat); }
public List <DomenskiObjekat> Pronadji(DomenskiObjekat objekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"SELECT * FROM {objekat.TableName} WHERE {objekat.KriterijumPretrage}"; SqlDataReader reader = command.ExecuteReader(); List <DomenskiObjekat> rezultat = objekat.GetEntities(reader); reader.Close(); return(rezultat); }
public List <DomenskiObjekat> VratiSveJoin(DomenskiObjekat objekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"SELECT * FROM {objekat.TableName} {objekat.JoinFull}"; Console.WriteLine(command.CommandText); SqlDataReader reader = command.ExecuteReader(); List <DomenskiObjekat> rezultat = objekat.GetEntities(reader); reader.Close(); return(rezultat); }
public DomenskiObjekat VratiJedanJoin(DomenskiObjekat domenskiObjekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"SELECT {domenskiObjekat.PovratneVrednosti} FROM {domenskiObjekat.TableName} {domenskiObjekat.JoinFull} where {domenskiObjekat.JoinCondition}"; Console.Write(command.CommandText); SqlDataReader reader = command.ExecuteReader(); DomenskiObjekat rezultat = domenskiObjekat.GetEntity(reader); reader.Close(); return(rezultat); }
public List <DomenskiObjekat> VratiSve(DomenskiObjekat domenskiObjekat) { SqlCommand command = new SqlCommand("", connection, transaction); command.CommandText = $"SELECT {domenskiObjekat.PovratneVrednosti} FROM {domenskiObjekat.TableName}"; Console.WriteLine(command.CommandText); SqlDataReader reader = command.ExecuteReader(); List <DomenskiObjekat> rezultat = domenskiObjekat.GetEntities(reader); reader.Close(); return(rezultat); }
protected override object Execute(DomenskiObjekat domenskiObjekat) { bool signal = true; foreach (Sastanak s in sastanci) { if (!(broker.Sacuvaj(s) > 0)) { signal = false; } } return(signal); }