/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public City Get(CityKey key)
{
if (key == null || (key.CountryId == 0 && string.IsNullOrWhiteSpace(key.ZipCode) && key.Id == 0))
{
return(null);
}
var rowList = _dbContext.City.Where(m => 1 == 1);
if (key.CountryId > 0)
{
rowList = rowList.Where(m => m.CountryId == key.CountryId);
}
if (!string.IsNullOrWhiteSpace(key.ZipCode))
{
rowList = rowList.Where(m => m.ZipCode == key.ZipCode);
}
if (key.Id > 0)
{
rowList = rowList.Where(m => m.Id == key.Id);
}
var row = rowList.FirstOrDefault();
if (row != null)
{
return(CityTransformer.ToBean(row));
}
return(null);
}
/// <summary>
/// Find data in database
/// </summary>
/// <returns></returns>
public List <City> Find(CityCriteria cityCriteria = null)
{
List <City> resultList = null;
IQueryable <CityRow> rowList = _dbContext.City;
CriteriaTransformer.CompleteQuery(ref rowList, cityCriteria);
if (rowList != null)
{
foreach (var row in rowList)
{
if (resultList == null)
{
resultList = new List <City>();
}
resultList.Add(CityTransformer.ToBean(row));
}
}
return(resultList);
}