public async Task <IEnumerable <UserModel> > GetUsers(int userID = 0)
{
DynamicParameters param = new DynamicParameters();
param.Add("@UserID", userID);
return(await DapperORM.ReturListAsync <UserModel>("UserGET", param));
}
public async Task <IEnumerable <PropertyModel> > PropertyValueGet(int itemID)
{
DynamicParameters param = new DynamicParameters();
param.Add("@ItemID", itemID);
return(await DapperORM.ReturListAsync <PropertyModel>("ItemPropertyValueGET", param));
}
public async Task <IEnumerable <PhoneModel> > GetPhonesByUserID(int userID)
{
DynamicParameters param = new DynamicParameters();
param.Add("@UserID", userID);
return(await DapperORM.ReturListAsync <PhoneModel>("PhoneGET", param));
}
public async Task <IEnumerable <CascadingRegionNames> > GetCascadingRegionNames(int neighborhoodID)
{
DynamicParameters param = new DynamicParameters();
param.Add("@NeighborhoodID", neighborhoodID);
return(await DapperORM.ReturListAsync <CascadingRegionNames>("RegionNamesGETByNeighborhoodID", param));
}
public async Task <IEnumerable <CategoryModel> > GetCategories(int parentCategoryID = 0)
{
DynamicParameters param = new DynamicParameters();
param.Add("@ParentCategoryID", parentCategoryID);
return(await DapperORM.ReturListAsync <CategoryModel>("CategoryGET", param));
}
public async Task <IEnumerable <PropertyModel> > PropertyGet(int categoryID = 0, int propertyID = 0)
{
DynamicParameters param = new DynamicParameters();
if (propertyID > 0)
{
param.Add("@PropertyID", propertyID);
}
param.Add("@CategoryID", categoryID);
return(await DapperORM.ReturListAsync <PropertyModel>("PropertyGET", param));
}
