public PaymentMethod ConvertFromServicePaymentMethodToClient(ServicePaymentMethod servicePaymentMethod) { PaymentMethod paymentMethod = new PaymentMethod(); paymentMethod.PaymentMethodValue = servicePaymentMethod.PaymentMethodValue; paymentMethod.PMethodId = servicePaymentMethod.PMethodId; return(paymentMethod); }
public IEnumerable <ServicePaymentMethod> GetPaymentMethods() { List <ServicePaymentMethod> paymentMethods = new List <ServicePaymentMethod>(); using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); using (SqlCommand cmdGetPaymentMethods = connection.CreateCommand()) { cmdGetPaymentMethods.CommandText = "SELECT pMethodId, paymentMethod FROM PaymentMethods"; SqlDataReader paymentMethodReader = cmdGetPaymentMethods.ExecuteReader(); while (paymentMethodReader.Read()) { ServicePaymentMethod pMethod = new ServicePaymentMethod(); pMethod.PMethodId = paymentMethodReader.GetInt32(paymentMethodReader.GetOrdinal("pMethodId")); pMethod.PaymentMethodValue = paymentMethodReader.GetString(paymentMethodReader.GetOrdinal("paymentMethod")); paymentMethods.Add(pMethod); } } } return(paymentMethods); }