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