public void AddCard(MyAccountPageObject obj)
{
global.OpenConnection(obj.MyAccountPageConnectionString);
global.startTransaction();
try
{
sql = "INSERT INTO \"Group2DB\".\"CustomerCardInfo\" (\"CustomerID\",\"CardNumber\",\"SecurityCode\",\"Balance\")" +
" VALUES (" + obj.MyAccountPageCustomerID + ", " + obj.MyAccountPageCardNumber + "," + obj.MyAccountPageSecurityCode + " ," + obj.MyAccountPageBalance + ") ";
global.Datasource(sql);
global.commitQuery();
global.closeTransaction();
}
catch (Exception e)
{
global.rollBackQuery();
MessageBox.Show(e.Message + "CardNumber is already taken");
}
}
public void RemoveCard(MyAccountPageObject obj)
{
global.OpenConnection(obj.MyAccountPageConnectionString);
global.startTransaction();
try
{
sql = "Delete from \"Group2DB\".\"CustomerCardInfo\" where \"Group2DB\".\"CustomerCardInfo\".\"CardID\" =" + "" + obj.MyAccountPageRemoveCardSelectedID + "";
global.Datasource(sql);
global.commitQuery();
global.closeTransaction();
MessageBox.Show("Card Deleted");
}
catch (Exception e)
{
global.rollBackQuery();
MessageBox.Show(e.Message + "CardNumber is already taken");
}
}
public void UpdateAccountInfo(MyAccountPageObject obj)
{
global.OpenConnection(obj.MyAccountPageConnectionString);
global.startTransaction();
try
{
sql = "UPDATE \"Group2DB\".\"AccountInfo\"SET \"FirstName\" = '" + obj.MyAccountPageFirstName + "',\"LastName\" = '" + obj.MyAccountPageLastName + "',\"DateOfBirth\" = '" + obj.MyAccountPageDateOfBirth.Date + " ' " +
" " + "WHERE \"AccountID\" = " + "" + obj.MyAccountPageAccountID + "";
global.Datasource(sql);
sql = "UPDATE \"Group2DB\".\"Account\" SET \"Username\" = '" + obj.MyAccountPageUsername + "'," +
" \"Password\"='" + obj.MyAccountPagePassword + "' WHERE(\"AccountID\" = " + obj.MyAccountPageAccountID + ")";
global.Datasource(sql);
global.commitQuery();
global.closeTransaction();
MessageBox.Show("Sucessfully Updated Profile");
}
catch (Exception e)
{
global.rollBackQuery();
MessageBox.Show(e.Message);
}
}