public IEnumerable <DAplikacija> GetData(string query, int pageIndex, int pageSize, string sortKey, string asceding)
{
try
{
List <DAplikacija> result = new List <DAplikacija>();
SQLiteConnection connection = new SQLiteConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);
using (connection)
{
connection.Open();
SQLiteCommand cmd;
using (cmd = new SQLiteCommand(this.GetSQL(sortKey, asceding), connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@searchParam", "%" + query + "%");
//cmd.Parameters.AddWithValue("@pageSize", pageSize);
//cmd.Parameters.AddWithValue("@pageIndex", pageIndex);
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
result.Add(ReflectPropertyInfo.ReflectType <DAplikacija>(reader));
}
}
}
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
finally
{
//connection.Close(); //tega ne rabimo če uporabimo using
}
}
public static IEnumerable <DSifranti> GetSifranti(string id)
{
try
{
List <DSifranti> result = new List <DSifranti>();
SQLiteConnection connection = new SQLiteConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);
using (connection)
{
connection.Open();
SQLiteCommand cmd;
using (cmd = new SQLiteCommand("Select * from Sifranti where id = @id", connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id", id);
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
result.Add(ReflectPropertyInfo.ReflectType <DSifranti>(reader));
}
}
}
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
finally
{
//connection.Close(); //tega ne rabimo če uporabimo using
}
}
