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);
}
