public ReservationInfo GetReservationByBrand(ReservationRequestByBrand request) { if (request.LicenseKey != "SuperSecret123") { throw new WebFaultException <string>( "Wrong license key", HttpStatusCode.Forbidden); } else { Reservation reservation = new Reservation(); string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetReservationByBrand", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Brand"; parameterId.Value = request.CarBrand; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { reservation.Car.Model = reader["Model"].ToString(); reservation.Car.Regnumber = reader["Regnumber"].ToString(); reservation.StartDate = Convert.ToDateTime(reader["StartDate"]); reservation.EndDate = Convert.ToDateTime(reader["EndDate"]); reservation.CustomerId = Convert.ToInt32(reader["CustomerId"]); reservation.Returned = Convert.ToBoolean(reader["Returned"]); } reservation.Customer = customerMethods.GetCustomerById(reservation.CustomerId); } return(new ReservationInfo(reservation)); } }
public Customer GetCustomerById(int id) { return(castomerMethods.GetCustomerById(id)); }