public IntegrationTestComplexType()
{
driverMock = new Mock <IDatabaseDriver>();
driverMock.Setup(x => x.GetSqlType(It.IsAny <PropertyMapping>(), It.IsAny <bool>())).Returns("TEST");
driverMock.Setup(x => x.CreateSqlStringBuilder()).Returns(new SqlStringBuilder());
select = FluentBaseBuilder <TestComposed, FolkeTuple> .Select(driverMock.Object, new Mapper());
}
public Paging <R> GetPaging <R>(ISelectResult <R> query)
{
var lst = GetList(GetConn(null).Query <R>(sql: query.SqlCmd, param: query.Param, commandTimeout: CommandTimeout));
var count = GetConn(null).QuerySingleOrDefault <long>(sql: query.CountSqlCmd, param: query.Param, commandTimeout: CommandTimeout);
return(new Paging <R>(count, lst));
}
public Paging <R> GetPaging <R>(ISelectResult <R> query)
{
var lst = GetList(query);
var conn = GetConn(null);
var count = conn.QuerySingleOrDefault <long>(sql: query.CountSqlCmd, param: query.Param, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn));
return(new Paging <R>(count, lst));
}
public TestFluentGenericQueryBuilder()
{
var mySqlDriver = new MySqlDriver();
var mapper = new Mapper();
fluentSelectBuilder = FluentBaseBuilder <FakeClass, FolkeTuple> .Select(mySqlDriver, mapper);
queryBuilder = fluentSelectBuilder.QueryBuilder;
}
public async override void Navigated(NavigatedParameter parameter)
{
base.Navigated(parameter);
this.Item = parameter.Data as Property;
this.Item.Specification = this.Item.BedroomNumber + " bedroom, " + this.Item.BathroomNumber + " bathroom " + this.Item.PropertyType;
ISelectResult favoriteList = await this.LocalRepository.GetAllAsync(typeof(Property), new SelectParameter());
if (favoriteList.Items.OfType <Property>().FirstOrDefault(o => o.Guid == this.Item.Guid) != null)
{
this.Item.IsFavorite = true;
}
}
public List <R> GetList <R>(ISelectResult <R> query)
{
Type typeFromHandle = typeof(R);
ConstructorInfo right = typeFromHandle.GetConstructors(BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic).FirstOrDefault((ConstructorInfo x) => x.GetParameters().Length == 0);
if (null == right && typeFromHandle.FullName.Contains("AnonymousType"))
{
using (IDataReader reader = GetConn(query.DBModel as T).ExecuteReader(sql: query.SqlCmd, param: query.Param, commandTimeout: CommandTimeout))
{
return(GetList(reader.Parse <R>().ToList()));
}
}
return(GetList(GetConn(query.DBModel as T).Query <R>(sql: query.SqlCmd, param: query.Param, commandTimeout: CommandTimeout)));
}
public async void GetFavouriteList()
{
ISelectResult searchResult = await this.LocalRepository.GetAllAsync(typeof(Property), new SelectParameter());
ObservableCollection <Property> favouritelistings = new ObservableCollection <Property>();
foreach (object item in searchResult.Items)
{
Property listing = item as Property;
if (favouritelistings != null)
{
favouritelistings.Add(listing);
}
}
this.SourceItems = favouritelistings;
}
protected virtual async void LoadData()
{
try
{
this.ActivityPresenter.Show("Searching...", ActivityStyle.SmallIndicatorWithText);
QueryDescriptor queryDescriptor = new QueryDescriptor();
queryDescriptor.FilterDescriptors.Add(new FilterDescriptor("Location", FilterOperator.IsEqualTo, this.Item.Location));
queryDescriptor.PageDescriptor.PageIndex = 0;
SelectParameter selectParameter = new SelectParameter();
selectParameter.QueryDescriptor = queryDescriptor;
ISelectResult <Property> selectResult = await this.Repository.GetAllAsync(selectParameter);
SearchResult searchResult = new SearchResult();
searchResult.Items = selectResult;
searchResult.Location = this.Item.Location;
if (selectResult.ItemCount == 0)
{
this.MessagePresenter.Show("No listing found near " + this.Item.Location);
}
else
{
this.Item.ItemCount = selectResult.ItemCount;
this.SaveRecentSearch();
this.ShowSearchResult(searchResult);
}
}
catch (Exception ex)
{
this.MessagePresenter.Show(ex.Message, "Search Failed");
}
finally
{
this.ActivityPresenter.Hide();
}
}
public List <R> GetList <R>(ISelectResult <R> query)
{
return(GetList(GetConn(null).Query <R>(sql: query.SqlCmd, param: query.Param, commandTimeout: CommandTimeout)));
}
public IntegrationTest()
{
driverMock = new Mock <IDatabaseDriver>();
select = FluentBaseBuilder <TestLinkTable, FolkeTuple> .Select(driverMock.Object, mapper);
}
