private void PetaPocoObjectController_BuildingQuery1(object sender, UIOMatic.QueryEventArgs e) { if (e.CurrentType == typeof(TestWithDateLimit)) { e.Query.Where("TheDate >= @0", DateTime.Now.AddDays(-1)); } }
private void PetaPocoObjectController_BuildingQuery(object sender, UIOMatic.QueryEventArgs e) { if (e.TableName == "Dogs") { e.Query = Umbraco.Core.Persistence.Sql.Builder .Append("SELECT Dogs.Id, Dogs.Name, Dogs.IsCastrated, Dogs.OwnerId, People.Firstname + ' ' + People.Lastname as OwnerName") .Append("FROM Dogs") .Append("INNER JOIN People ON Dogs.OwnerId = People.Id") .Append("ORDER BY Dogs.Id desc"); } }
private void PetaPocoObjectController_BuildedQuery(object sender, UIOMatic.QueryEventArgs e) { if (e.TableName == "Dogs") { e.Query = Umbraco.Core.Persistence.Sql.Builder .Append("SELECT Dogs.Id, Dogs.Name, Dogs.IsCastrated, Dogs.OwnerId, People.Firstname + ' ' + People.Lastname as OwnerName") .Append("FROM Dogs") .Append("INNER JOIN People ON Dogs.OwnerId = People.Id") .Append(string.IsNullOrEmpty(e.SearhTerm) ? "" : string.Format( @"WHERE Dogs.Name like '%{0}%' or People.Firstname like '%{0}%' or People.Lastname like '%{0}%'", e.SearhTerm)) .Append("ORDER BY " + (string.IsNullOrEmpty(e.SortColumn) ? " Id desc" : e.SortColumn + " " + e.SortOrder)); } }