public Rental(Customer customer, RentalLocation location, Car car, int daysRented) { Customer = customer; Car = car; DaysRented = daysRented; Location = location; }
public RentalLocation GetRentalLocation(int id) { using (var con = GetConnection()) { var cmd = con.CreateCommand(); cmd.CommandText = "RentalLocations_SelectById"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", id); using (var reader = cmd.ExecuteReader()) { if (!reader.Read()) { return(null); } RentalLocation location = new RentalLocation(); location.Id = (int)reader["Id"]; location.LocationName = (string)reader["LocationName"]; location.City = (string)reader["City"]; location.DateCreated = (DateTime)reader["DateCreated"]; object streetValue = reader["Street"]; if (streetValue != DBNull.Value) { location.Street = (string)streetValue; } object stateValue = reader["State"]; if (stateValue != DBNull.Value) { location.State = (string)stateValue; } object zipValue = reader["Zip"]; if (zipValue != DBNull.Value) { location.Zip = (string)zipValue; } object phoneValue = reader["Phone"]; if (phoneValue != DBNull.Value) { location.Phone = (string)phoneValue; } object countryValue = reader["Country"]; if (countryValue != DBNull.Value) { location.Country = (string)countryValue; } object latValue = reader["Lat"]; if (latValue != DBNull.Value) { location.Lat = (double)latValue; } object longValue = reader["Long"]; if (longValue != DBNull.Value) { location.Long = (double)longValue; } object dateModifiedValue = reader["DateModified"]; if (dateModifiedValue != DBNull.Value) { location.DateModified = (DateTime)dateModifiedValue; } return(location); } } }
public List <RentalLocation> GetRentalLocations() { using (var con = GetConnection()) { var cmd = con.CreateCommand(); cmd.CommandText = "RentalLocations_SelectAll"; cmd.CommandType = CommandType.StoredProcedure; using (var reader = cmd.ExecuteReader()) { List <RentalLocation> rentalLocations = new List <RentalLocation>(); while (reader.Read()) { RentalLocation location = new RentalLocation(); location.Id = (int)reader["Id"]; location.LocationName = (string)reader["LocationName"]; location.City = (string)reader["City"]; location.DateCreated = (DateTime)reader["DateCreated"]; object streetValue = reader["Street"]; if (streetValue != DBNull.Value) { location.Street = (string)streetValue; } object stateValue = reader["State"]; if (stateValue != DBNull.Value) { location.State = (string)stateValue; } object zipValue = reader["Zip"]; if (zipValue != DBNull.Value) { location.Zip = (string)zipValue; } object phoneValue = reader["Phone"]; if (phoneValue != DBNull.Value) { location.Phone = (string)phoneValue; } object countryValue = reader["Country"]; if (countryValue != DBNull.Value) { location.Country = (string)countryValue; } object latValue = reader["Lat"]; if (latValue != DBNull.Value) { location.Lat = (double)latValue; } object longValue = reader["Long"]; if (longValue != DBNull.Value) { location.Long = (double)longValue; } object dateModifiedValue = reader["DateModified"]; if (dateModifiedValue != DBNull.Value) { location.DateModified = (DateTime)dateModifiedValue; } rentalLocations.Add(location); } return(rentalLocations); } } }
public HttpResponseMessage GetRentalLocation(int id) { RentalLocation location = rentalLocationService.GetRentalLocation(id); return(Request.CreateResponse(HttpStatusCode.OK, location)); }