//İle göre ilçe getir public List <TownDTO> GetTownsByCity(int cityId) { using (UnitOfWork uow = new UnitOfWork()) { var result = uow.Towns.Search(x => x.CityID == cityId); if (result.Count == 0) { return(null); } // throw new System.Exception("Hata oluştu"); List <TownDTO> list = new List <TownDTO>(); foreach (var item in result) { TownDTO obj = new TownDTO { TownID = item.TownID, TownName = item.TownName }; list.Add(obj); } return(list); } }
public static TownViewModel MapFrom(this TownDTO dto) { return(new TownViewModel() { Id = dto.Id, Name = dto.Name }); }
public static void ImportTown(TownDTO townDto) { string townName = townDto.Name; InputDataValidator.ValidateStringMaxLength(townName, Constants.MaxTownNameLength); TownValidator.ValidateTownDoesNotExist(townName); TownService.AddTown(townName); Console.WriteLine(string.Format(Constants.ImportSuccessMessages.TownAddedSuccess, townName)); }
public List <TownDTO> GetTown(int cityId) { using (UnitOfWork uow = new UnitOfWork()) { var towns = uow.Towns.List(); List <TownDTO> townList = new List <TownDTO>(); foreach (var item in towns) { TownDTO town = Mapper.Map <Town, TownDTO>(item); town.CityName = item.City.CityName; townList.Add(town); } return(townList); } }
public async Task <TownDTO> GetTown([FromBody] TownDTO townDTO) { if (townDTO == null) { townDTO = new TownDTO(); } var town = new Town { Id = townDTO.Id }; town = await TownService.Get(town.Id); return(town == null ? null : new TownDTO { Id = town.Id, Code = town.Code, Name = town.Name, DistrictId = town.DistrictId, }); }
public List <TownDTO> GetAllTowns() { SqlConnection dbCon = GetSqlConnection(); DataTable dt = new DataTable("Towns"); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand selectCommand = new SqlCommand(); selectCommand.Connection = dbCon; selectCommand.CommandText = "SELECT TownName FROM Towns"; da.SelectCommand = selectCommand; da.Fill(dt); List <TownDTO> townsList = new List <TownDTO>(); foreach (DataRow row in dt.Rows) { TownDTO currentTown = new TownDTO() { TownName = row["TownName"].ToString(), }; townsList.Add(currentTown); } return(townsList); }