public wsSQLResult CreateAccount(Stream JSONdataStream)
{
wsSQLResult result = new wsSQLResult();
try
{
StreamReader reader = new StreamReader(JSONdataStream);
string JSONdata = reader.ReadToEnd();
JavaScriptSerializer jss = new JavaScriptSerializer();
wsAccount acc = jss.Deserialize <wsAccount>(JSONdata);
if (acc == null)
{
result.WasSuccessful = 0;
result.Exception = "Unable to deserialize the JSON data.";
return(result);
}
BankDataContext dc = new BankDataContext();
Account newAccount = new Account()
{
balance = acc.balance,
running_totals = acc.runningTotals,
first_name = acc.firstName,
last_name = acc.lastName,
address = acc.Address,
postcode = acc.postCode,
telephone = acc.telePhone,
pin = acc.pin
};
dc.Accounts.InsertOnSubmit(newAccount);
dc.SubmitChanges();
result.WasSuccessful = 1;
result.Exception = "";
return(result);
}
catch (Exception ex)
{
result.WasSuccessful = 0;
result.Exception = ex.Message;
return(result);
}
}
public wsSQLResult CreateTransaction(Stream JSONdataStream)
{
wsSQLResult result = new wsSQLResult();
try
{
StreamReader reader = new StreamReader(JSONdataStream);
string JSONdata = reader.ReadToEnd();
JavaScriptSerializer jss = new JavaScriptSerializer();
wsTransaction tran = jss.Deserialize <wsTransaction>(JSONdata);
if (tran == null)
{
// Error: Couldn't deserialize our JSON string into a "wsCustomer" object.
result.WasSuccessful = 0;
result.Exception = "Unable to deserialize the JSON data.";
return(result);
}
BankDataContext dc = new BankDataContext();
Transaction newTransaction = new Transaction()
{
amount = tran.amount,
datetime = DateTime.Now,
acc_id = tran.acc_id
};
dc.Transactions.InsertOnSubmit(newTransaction);
dc.SubmitChanges();
result.WasSuccessful = 1;
result.Exception = "";
return(result);
}
catch (Exception ex)
{
result.WasSuccessful = 0;
result.Exception = ex.Message;
return(result);
}
}
