public async Task <IActionResult> PutZipCity(string id, ZipCity zipCity)
{
if (id != zipCity.Id)
{
return(BadRequest());
}
_context.Entry(zipCity).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ZipCityExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void UpdateCustomer()
{
try
{
CustomerController cCtrl = new CustomerController();
ZipCityController zcCtrl = new ZipCityController();
ZipCity zipCity = zcCtrl.ReadByZipCode("9000");
Customer newCustomer = new Customer
{
_fName = "Lars",
_lName = "Jensen",
_email = "*****@*****.**",
_address = "broen 20",
_phone = "55667788",
_zipCity = zipCity
};
cCtrl.Update(newCustomer, "55667788");
Customer commitedCustomer = cCtrl.ReadByPhone("55667788");
Assert.IsTrue(newCustomer._fName == commitedCustomer._fName);
}
catch (FaultException <CustomerNotExistException> cEx)
{
Console.WriteLine(cEx.Message);
}
}
public async Task <ActionResult <ZipCity> > PostZipCity(ZipCity zipCity)
{
_context.ZipCity.Add(zipCity);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetZipCity", new { id = zipCity.Id }, zipCity));
}
/// <summary>
/// Returns all zipcities in database
/// </summary>
/// <returns>IEnumerable<ZipCity> zipCity</returns>
public IEnumerable <ZipCity> GetAll()
{
List <ZipCity> zipCities = new List <ZipCity>();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "select id, zipcode, city from ZipCity";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ZipCity zipCity = new ZipCity {
_id = reader.GetInt32(reader.GetOrdinal("id")),
_zipCode = reader.GetInt32(reader.GetOrdinal("zipCode")),
_city = reader.GetString(reader.GetOrdinal("city"))
};
if (zipCity is ZipCity)
{
zipCities.Add(zipCity);
}
}
if (zipCities.Count == 0)
{
throw new FaultException <ZipCodeNotInDbException>(new ZipCodeNotInDbException(""));
}
}
}
return(zipCities);
}
/// <summary>
/// Returns an zipCity based on its zipcode
/// </summary>
/// <param name="zipCode"></param>
/// <returns>Zipcity zipCity</returns>
public ZipCity ReadByZipCode(string zipCode)
{
ZipCity zipCity = null;
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT * FROM ZipCity WHERE zipCode = @zipCode";
cmd.Parameters.AddWithValue("zipCode", zipCode);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
zipCity = new ZipCity
{
_id = reader.GetInt32(reader.GetOrdinal("id")),
_city = reader.GetString(reader.GetOrdinal("city")),
_zipCode = int.Parse(zipCode)
};
}
if (!(zipCity is ZipCity))
{
throw new FaultException <ZipCodeNotInDbException>(new ZipCodeNotInDbException(zipCode));
}
}
}
return(zipCity);
}
private void ListViewZipCities_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
ListView lv = (ListView)sender;
ZipCity zipCity = (ZipCity)lv.SelectedItem;
textBoxZipCity.Text = zipCity.ToString();
lv.Visibility = Visibility.Collapsed;
}
/// <summary>
/// Gets a city based on its zipCode
/// </summary>
/// <param name="zipCode">int zipCode</param>
/// <returns>IHttpActionResult</returns>
public IHttpActionResult GetByZipCode(int zipCode)
{
ZipCity zipCity = myProxy.ReadByZipCode(zipCode.ToString());
if (zipCity == null || zipCity._id == 0)
{
return(NotFound());
}
return(Ok(zipCity));
}
public void CheckZipcodeIsIllegal()
{
ZipCityController zcCtrl = new ZipCityController();
try
{
ZipCity zipCity = zcCtrl.ReadByZipCode("34512");
Assert.IsTrue(zipCity._zipCode == 3451);
}
catch (FaultException <ZipCodeLengthException> zipEx)
{
Console.WriteLine(zipEx.Message);
}
}
