public IEnumerable <RegionNeighborhoodModel> GetRegionNeighborhoods(int districtID)
{
DynamicParameters param = new DynamicParameters();
param.Add("@DistrictID", districtID);
return(DapperORM.ReturList <RegionNeighborhoodModel>("RegionNeighborhoodGET", param));
}
public IEnumerable <RegionCountyModel> GetRegionCounties(int cityID)
{
DynamicParameters param = new DynamicParameters();
param.Add("@CityID", cityID);
return(DapperORM.ReturList <RegionCountyModel>("RegionCountyGET", param));
}
public IEnumerable <RegionDistrictModel> GetRegionDistricts(int countyID)
{
DynamicParameters param = new DynamicParameters();
param.Add("@CountyID", countyID);
return(DapperORM.ReturList <RegionDistrictModel>("RegionDistrictGET", param));
}
public LoginResultModel UserLogin(AuthenticateModel user)
{
DynamicParameters param = new DynamicParameters();
param.Add("@Mail", user.Mail);
param.Add("@Password", user.Password);
var result = DapperORM.ReturList <LoginResultModel>("UserLOGIN", param);
if (result.Count <LoginResultModel>() == 0)
{
return(null);
}
return(result.First <LoginResultModel>());
}
public IEnumerable <RegionCityModel> GetRegionCities()
{
return(DapperORM.ReturList <RegionCityModel>("RegionCityGET"));
}