internal bool updateUser(User user)
{
using (OleDbConnection sqlConn = new OleDbConnection(database))
{
try
{
sqlConn.Open();
String insert = "UPDATE [USERS] " +
"SET [first_name] = @firstName," +
"[last_name] = @lastName," +
"[address] = @address," +
"[city] = @city," +
"[state] = @state," +
"[zip_code] = @zipCode," +
"[email] = @email " +
"WHERE ([user_id] = @userId)";
OleDbCommand cmd = new OleDbCommand(insert, sqlConn);
cmd.Parameters.Add("firstName", OleDbType.VarChar, 255).Value = user.getFirstName();
cmd.Parameters.Add("lastName", OleDbType.VarChar, 255).Value = user.getLastName();
cmd.Parameters.Add("address", OleDbType.VarChar, 255).Value = user.getAddress();
cmd.Parameters.Add("city", OleDbType.VarChar, 255).Value = user.getCity();
cmd.Parameters.Add("state", OleDbType.VarChar, 255).Value = user.getState();
cmd.Parameters.Add("zipCode", OleDbType.VarChar, 255).Value = user.getZipCode();
cmd.Parameters.Add("email", OleDbType.VarChar, 255).Value = user.getEamil();
cmd.Parameters.Add("userId", OleDbType.Integer).Value = user.getId();
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (OleDbException ex)
{
return(false);
}
finally
{
sqlConn.Close();
}
}
}
internal List <PaymentInformation> getUserPaymentInfo(User user)
{
List <PaymentInformation> userPaymentInfo = new List <PaymentInformation>();
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
String select = "SELECT * FROM [PAYMENT_INFORMATION] WHERE [user_id] = @userId";
OleDbCommand cmd = new OleDbCommand(select, sqlconn);
cmd.Parameters.Add("userId", OleDbType.Integer).Value = user.getId();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int paymentInformationId = (int)reader["payment_information_id"];
int userId = (int)reader["user_id"];
String creditCartType = reader["credit_card_type"].ToString();
String creditCardNumber = reader["credit_card_number"].ToString();
String cardCity = reader["card_city"].ToString();
String cardState = reader["card_state"].ToString();
DateTime cardExpDate = DateTime.Parse(reader["card_exp_date"].ToString());
String securityCode = reader["security_code"].ToString();
PaymentInformation paymentInfo = new PaymentInformation(paymentInformationId, user, creditCartType,
creditCardNumber, cardCity, cardState, cardExpDate, securityCode);
userPaymentInfo.Add(paymentInfo);
}
return(userPaymentInfo);
}
catch (OleDbException ex)
{
userPaymentInfo = null;
return(userPaymentInfo);
}
finally
{
sqlconn.Close();
}
}
}
internal List<PaymentInformation> getUserPaymentInfo(User user)
{
List<PaymentInformation> userPaymentInfo = new List<PaymentInformation>();
using (OleDbConnection sqlconn = new OleDbConnection(database))
{
try
{
sqlconn.Open();
String select = "SELECT * FROM [PAYMENT_INFORMATION] WHERE [user_id] = @userId";
OleDbCommand cmd = new OleDbCommand(select, sqlconn);
cmd.Parameters.Add("userId", OleDbType.Integer).Value = user.getId();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int paymentInformationId = (int) reader["payment_information_id"];
int userId = (int)reader["user_id"];
String creditCartType = reader["credit_card_type"].ToString();
String creditCardNumber = reader["credit_card_number"].ToString();
String cardCity = reader["card_city"].ToString();
String cardState = reader["card_state"].ToString();
DateTime cardExpDate = DateTime.Parse(reader["card_exp_date"].ToString());
String securityCode = reader["security_code"].ToString();
PaymentInformation paymentInfo = new PaymentInformation(paymentInformationId, user, creditCartType,
creditCardNumber, cardCity, cardState, cardExpDate, securityCode);
userPaymentInfo.Add(paymentInfo);
}
return userPaymentInfo;
}
catch(OleDbException ex)
{
userPaymentInfo = null;
return userPaymentInfo;
}
finally
{
sqlconn.Close();
}
}
}
internal bool updateUser(User user)
{
using (OleDbConnection sqlConn = new OleDbConnection(database))
{
try
{
sqlConn.Open();
String insert = "UPDATE [USERS] " +
"SET [first_name] = @firstName," +
"[last_name] = @lastName," +
"[address] = @address," +
"[city] = @city," +
"[state] = @state," +
"[zip_code] = @zipCode," +
"[email] = @email " +
"WHERE ([user_id] = @userId)";
OleDbCommand cmd = new OleDbCommand(insert, sqlConn);
cmd.Parameters.Add("firstName", OleDbType.VarChar, 255).Value = user.getFirstName();
cmd.Parameters.Add("lastName", OleDbType.VarChar, 255).Value = user.getLastName();
cmd.Parameters.Add("address", OleDbType.VarChar, 255).Value = user.getAddress();
cmd.Parameters.Add("city", OleDbType.VarChar, 255).Value = user.getCity();
cmd.Parameters.Add("state", OleDbType.VarChar, 255).Value = user.getState();
cmd.Parameters.Add("zipCode", OleDbType.VarChar, 255).Value = user.getZipCode();
cmd.Parameters.Add("email", OleDbType.VarChar, 255).Value = user.getEamil();
cmd.Parameters.Add("userId", OleDbType.Integer).Value = user.getId();
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
{
return true;
}
else
{
return false;
}
}
catch (OleDbException ex)
{
return false;
}
finally
{
sqlConn.Close();
}
}
}
private void populatePage(User user)
{
lblUserId.Text = user.getId().ToString();
txtUsername.Text = user.getUsername();
txtFirstName.Text = user.getFirstName();
txtLastName.Text = user.getLastName();
txtEmail.Text = user.getEamil();
txtAddress.Text = user.getAddress();
txtCity.Text = user.getCity();
txtState.Text = user.getState();
txtZipCode.Text = user.getZipCode();
}