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