public List <IDomenskiObjekat> Pretrazi(IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand("", connection, transaction);
command.CommandText = $"{objekat.Get} {objekat.FullTable} {objekat.Join} {objekat.SearchWhere(objekat.Kriterijum)} {objekat.GroupBy}";
SqlDataReader reader = command.ExecuteReader();
return(objekat.GetReaderResult(reader));
}
public List <IDomenskiObjekat> vratiBez(IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand("", connection, transaction);
command.CommandText = $"{objekat.Get} {objekat.Table} {objekat.Join}";
SqlDataReader reader = command.ExecuteReader();
return(objekat.GetReaderResult(reader));
}
public List <IDomenskiObjekat> VratiSvePoKriterijumu(IDomenskiObjekat objekat, Automobil automobil)
{
SqlCommand command = new SqlCommand("", connection);
command.CommandText = $"{objekat.Get} {objekat.FullTable} {objekat.SearchWhere(automobil.AutomobilID.ToString())}";
SqlDataReader reader = command.ExecuteReader();
return(objekat.GetReaderResult(reader));
}
public List <IDomenskiObjekat> Search(string criteria, IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand();
command.Transaction = transaction;
command.Connection = connection;
command.CommandText = $"select * from {objekat.Table} {objekat.Join} {objekat.SearchWhere(criteria)}";
SqlDataReader reader = command.ExecuteReader();
return(objekat.GetReaderResult(reader));
}
public List <IDomenskiObjekat> Login(IDomenskiObjekat objekat)
{
Radnik radnik = (Radnik)objekat;
SqlCommand command = new SqlCommand("", connection);
command.CommandText = $"{objekat.Get} {objekat.Table} " +
$"{objekat.SearchWhere(radnik.KorisnickoIme, radnik.Sifra)} ";
SqlDataReader reader = command.ExecuteReader();
return(objekat.GetReaderResult(reader));
}
public List <IDomenskiObjekat> SearchJoin(string criteria, IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand();
command.Transaction = transaction;
command.Connection = connection;
command.CommandText = $"select distinct {objekat.SearchColumns} from {objekat.Table} {objekat.Join} {criteria}";
SqlDataReader reader = command.ExecuteReader();
List <IDomenskiObjekat> result = objekat.GetReaderResult(reader);
reader.Close();
return(result);
}
public List <IDomenskiObjekat> VratiSve(IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand();
command.Transaction = transaction;
command.Connection = connection;
command.CommandText = $"select * from {objekat.Table} {objekat.Join}";
SqlDataReader reader = command.ExecuteReader();
List <IDomenskiObjekat> result = objekat.GetReaderResult(reader);
reader.Close();
return(result);
}
public IDomenskiObjekat SearchSlozeniObjekat(string criteria, IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand();
command.Transaction = transaction;
command.Connection = connection;
command.CommandText = $"select distinct {objekat.SearchColumns} from {objekat.Table} {objekat.Join} {criteria}";
SqlDataReader reader = command.ExecuteReader();
List <IDomenskiObjekat> result = objekat.GetReaderResult(reader);
reader.Close();
if (result.Count != 1)
{
throw new Exception("Razlicito od jednog sloga!!!!");
}
foreach (var item in objekat.WeakObjects)
{
IDomenskiObjekat weakObject = item[0];
List <IDomenskiObjekat> weakObjectList = SearchMod($"where {weakObject.DependentObjectID} = {objekat.ColumnId}", weakObject);
result[0].FillWeakObjects(weakObjectList);
}
foreach (var item in objekat.AssociativeObjects)
{
IDomenskiObjekat associativeObject = item[0];
List <IDomenskiObjekat> associativeObjectList = SearchJoin(criteria, associativeObject);
result[0].FillAssociativeObjects(associativeObjectList);
}
return(result[0]);
}
public IDomenskiObjekat SearchById(IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand();
command.Transaction = transaction;
command.Connection = connection;
command.CommandText = $"select * from {objekat.Table} WHERE {objekat.SearchById()}";
SqlDataReader reader = command.ExecuteReader();
List <IDomenskiObjekat> result = objekat.GetReaderResult(reader);
if (result.Count > 1)
{
throw new Exception("Object is not unique");
}
if (result.Count == 0)
{
return(null);
}
reader.Close();
return(result[0]);
}