internal void InsertPaymentInfo(BankingInfo pinfo)
{
MySqlConnection conn = new MySqlConnection(connStr);
try
{
if (conn.State == ConnectionState.Closed)
{
Console.WriteLine("Connecting to MySQL...");
conn.Open();
string sql = "INSERT INTO PaymentInfo(AccountNumber,CName,ExDate,CVV,Zip,Uid) VALUES(@para1, @para2, @para3, @para4, @para5, @para6) ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("para1", pinfo.AccountNo);
cmd.Parameters.AddWithValue("para2", pinfo.CName);
cmd.Parameters.AddWithValue("para3", pinfo.ExDate);
cmd.Parameters.AddWithValue("para4", pinfo.CVV);
cmd.Parameters.AddWithValue("para5", pinfo.Zipcode);
cmd.Parameters.AddWithValue("para6", pinfo.Uid);
cmd.ExecuteNonQuery();
Console.WriteLine("Connecting to MySQL success");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
Console.WriteLine("Connection failed");
}
finally
{
conn.Close();
}
}
private void AddCustomer(string name, double cash)
{
var customer = new Customer(this._customers.Count + 1, name);
var banking = new BankingInfo(customer, cash);
this._customers.Add(customer);
this._bankingDatabase.Add(customer.Id, banking);
}
public EditBankPage(BankingInfo ptmp)
{
_pinfo = ptmp;
CardNumber = ptmp.AccountNo;
ExDate = ptmp.ExDate;
CName = ptmp.CName;
CVV = ptmp.CVV;
Zip = ptmp.Zipcode;
InitializeComponent();
BindingContext = this;
}
public BankPage()
{
InitializeComponent();
bankInfo = wmh.GetBankingInfoByID(Settings.UserId);
//if(bankInfo.CVV != "")
//BankCell.Title = "Add your Banking Account";
//else
//BankCell.Title = bankInfo.AccountNo;
BindingContext = this;
}
internal BankingInfo GetBankingInfoByID(string uid)
{
//建立数据库连接
MySqlConnection conn = new MySqlConnection(connStr);
try
{ //建立连接，打开数据库
conn.Open();
string sqlstr =
"SELECT Pid,AccountNumber,CName,ExDate,CVV,Zip FROM PaymentInfo WHERE Uid = @para1";
MySqlCommand cmd = new MySqlCommand(sqlstr, conn);
//通过设置参数的形式给SQL 语句串值
cmd.Parameters.AddWithValue("para1", uid);
//cmd.Parameters.AddWithValue("para2", password);
var btmp = new BankingInfo();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string PaymentID = reader.GetString(0);
string AccountNo = reader.GetString(1);
string CName = reader.GetString(2);
DateTime ExDate = reader.GetDateTime(3);
string CVV = reader.GetString(4);
string Zipcode = reader.GetString(5);
BankingInfo ptmp = new BankingInfo()
{
Uid = uid, PaymentID = PaymentID, AccountNo = AccountNo, CName = CName, ExDate = ExDate, CVV = CVV, Zipcode = Zipcode
};
btmp = ptmp;
}
return(btmp);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
return(null);
}
finally
{
conn.Close(); //关闭连接
}
}
internal void UpdateBankingInfo(BankingInfo paymentinfo)
{
//建立数据库连接
MySqlConnection conn = new MySqlConnection(connStr);
try
{ //建立连接，打开数据库
conn.Open();
string sqlstr =
"UPDATE PaymentInfo SET " +
"AccountNumber = @para1, " +
"CName = @para2, " +
"ExDate = @para3, " +
"CVV = @para4, " +
"Zip = @para5" +
" WHERE Pid = @para6";
MySqlCommand cmd = new MySqlCommand(sqlstr, conn);
//通过设置参数的形式给SQL 语句串值
cmd.Parameters.AddWithValue("para1", paymentinfo.AccountNo);
cmd.Parameters.AddWithValue("para2", paymentinfo.CName);
cmd.Parameters.AddWithValue("para3", paymentinfo.ExDate);
cmd.Parameters.AddWithValue("para4", paymentinfo.CVV);
cmd.Parameters.AddWithValue("para5", paymentinfo.Zipcode);
cmd.Parameters.AddWithValue("para6", paymentinfo.PaymentID);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
conn.Close(); //关闭连接
}
}
private void OnSelectedCustomerChanged(Customer newCustomer)
{
this.OnPropertyChanged("SelectedCustomer");
if (null == newCustomer)
{
this._selectedBankingInfo = null;
}
else
{
this._selectedBankingInfo = this.LookupBankingInfo(newCustomer);
}
this.OnPropertyChanged("SelectedBankingInfo");
}
