/// <summary>
/// Get Payment Type
/// </summary>
/// <param name="paymentTypeID"></param>
/// <returns></returns>
public PaymentType GetPaymentType(Guid paymentTypeID)
{
PaymentType paymentType = new PaymentType();
string sql = "SELECT * FROM PaymentTypes WHERE PaymentTypeID = '" + paymentTypeID.ToString() + "'";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = dbConnection;
sqlCommand.CommandText = sql;
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.Read())
{
DataReader dataReader = new DataReader(reader);
paymentType.PaymentTypeID = dataReader.GetGuid("PaymentTypeID");
paymentType.Description = dataReader.GetString("Description");
paymentType.RequiresCreditCard = dataReader.GetInt32("RequiresCreditCard");
}
reader.Close();
return(paymentType);
}
/// <summary>
/// Get Customer By Customer ID
/// </summary>
/// <param name="customerID"></param>
/// <returns></returns>
public Customer GetCustomerByCustomerID(Guid customerID)
{
Customer customer = new Customer();
string sql = "SELECT * FROM CUSTOMERS WHERE CustomerID = '" + customerID.ToString() + "'";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = dbConnection;
sqlCommand.CommandText = sql;
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.Read())
{
DataReader dataReader = new DataReader(reader);
customer.CustomerID = dataReader.GetGuid("CustomerID");
customer.FirstName = dataReader.GetString("FirstName");
customer.LastName = dataReader.GetString("LastName");
customer.EmailAddress = dataReader.GetString("EmailAddress");
customer.Address = dataReader.GetString("Address");
customer.City = dataReader.GetString("City");
customer.Region = dataReader.GetString("Region");
customer.PostalCode = dataReader.GetString("PostalCode");
customer.Country = dataReader.GetString("Country");
customer.PhoneNumber = dataReader.GetString("PhoneNumber");
customer.CreditCardNumber = dataReader.GetString("CreditCardNumber");
customer.PaymentTypeID = dataReader.GetGuid("PaymentTypeID");
if (dataReader.GetDateTime("CreditCardExpirationDate") != DateTime.MinValue)
{
customer.CreditCardExpirationDate = dataReader.GetDateTime("CreditCardExpirationDate");
}
customer.CreditCardSecurityCode = dataReader.GetString("CreditCardSecurityCode");
customer.CreditLimit = dataReader.GetDecimal("CreditLimit");
customer.DateApproved = dataReader.GetDateTime("DateApproved");
customer.ApprovalStatus = dataReader.GetInt32("ApprovalStatus");
customer.DateCreated = dataReader.GetDateTime("DateCreated");
customer.DateUpdated = dataReader.GetDateTime("DateUpdated");
}
reader.Close();
return(customer);
}
/// <summary>
/// Get Payment Type
/// </summary>
/// <param name="paymentTypeID"></param>
/// <returns></returns>
public PaymentType GetPaymentType(Guid paymentTypeID)
{
PaymentType paymentType = new PaymentType();
string sql = "SELECT * FROM PaymentTypes WHERE PaymentTypeID = '" + paymentTypeID.ToString() + "'";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = dbConnection;
sqlCommand.CommandText = sql;
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.Read())
{
DataReader dataReader = new DataReader(reader);
paymentType.PaymentTypeID = dataReader.GetGuid("PaymentTypeID");
paymentType.Description = dataReader.GetString("Description");
paymentType.RequiresCreditCard = dataReader.GetInt32("RequiresCreditCard");
}
reader.Close();
return paymentType;
}
/// <summary>
/// Get Customer By Customer ID
/// </summary>
/// <param name="customerID"></param>
/// <returns></returns>
public Customer GetCustomerByCustomerID(Guid customerID)
{
Customer customer = new Customer();
string sql = "SELECT * FROM CUSTOMERS WHERE CustomerID = '" + customerID.ToString() + "'";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = dbConnection;
sqlCommand.CommandText = sql;
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.Read())
{
DataReader dataReader = new DataReader(reader);
customer.CustomerID = dataReader.GetGuid("CustomerID");
customer.FirstName = dataReader.GetString("FirstName");
customer.LastName = dataReader.GetString("LastName");
customer.EmailAddress = dataReader.GetString("EmailAddress");
customer.Address = dataReader.GetString("Address");
customer.City = dataReader.GetString("City");
customer.Region = dataReader.GetString("Region");
customer.PostalCode = dataReader.GetString("PostalCode");
customer.Country = dataReader.GetString("Country");
customer.PhoneNumber = dataReader.GetString("PhoneNumber");
customer.CreditCardNumber = dataReader.GetString("CreditCardNumber");
customer.PaymentTypeID = dataReader.GetGuid("PaymentTypeID");
if (dataReader.GetDateTime("CreditCardExpirationDate") != DateTime.MinValue)
customer.CreditCardExpirationDate = dataReader.GetDateTime("CreditCardExpirationDate");
customer.CreditCardSecurityCode = dataReader.GetString("CreditCardSecurityCode");
customer.CreditLimit = dataReader.GetDecimal("CreditLimit");
customer.DateApproved = dataReader.GetDateTime("DateApproved");
customer.ApprovalStatus = dataReader.GetInt32("ApprovalStatus");
customer.DateCreated = dataReader.GetDateTime("DateCreated");
customer.DateUpdated = dataReader.GetDateTime("DateUpdated");
}
reader.Close();
return customer;
}