//İ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);
}
