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