public SListResponse <SSlike> List(SListRequest data)
{
SListResponse <SSlike> result = null;
using (IDbCommand cmd = database.sqlConnection.GenerateCommand()) {
cmd.CommandType = CommandType.Text;
cmd.CommandText = CommandList();
// TODO : query parameters have to be added manually
DataTable dtt = database.sqlConnection.ExecDataTable(cmd);
result = GListHelper.ListResponse <SSlike>(dtt, data);
}
return(result);
}
public SListResponse <SCRMStrankeOpcije> List(SListRequest data, Dictionary <string, string> WhereClauses)
{
SListResponse <SCRMStrankeOpcije> result = null;
using (IDbCommand cmd = database.sqlConnection.GenerateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = CommandList(WhereClauses);
// TODO : query parameters have to be added manually
DataTable dtt = database.sqlConnection.ExecDataTable(cmd);
result = GListHelper.ListResponse <SCRMStrankeOpcije>(dtt, data);
}
return(result);
}