Beispiel #1
0
        public IEnumerable <RegionNeighborhoodModel> GetRegionNeighborhoods(int districtID)
        {
            DynamicParameters param = new DynamicParameters();

            param.Add("@DistrictID", districtID);
            return(DapperORM.ReturList <RegionNeighborhoodModel>("RegionNeighborhoodGET", param));
        }
Beispiel #2
0
        public IEnumerable <RegionCountyModel> GetRegionCounties(int cityID)
        {
            DynamicParameters param = new DynamicParameters();

            param.Add("@CityID", cityID);
            return(DapperORM.ReturList <RegionCountyModel>("RegionCountyGET", param));
        }
Beispiel #3
0
        public IEnumerable <RegionDistrictModel> GetRegionDistricts(int countyID)
        {
            DynamicParameters param = new DynamicParameters();

            param.Add("@CountyID", countyID);
            return(DapperORM.ReturList <RegionDistrictModel>("RegionDistrictGET", param));
        }
Beispiel #4
0
        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>());
        }
Beispiel #5
0
 public IEnumerable <RegionCityModel> GetRegionCities()
 {
     return(DapperORM.ReturList <RegionCityModel>("RegionCityGET"));
 }