private void button1_Click(object sender, EventArgs e)
{
using (SADIT3Entities pishravi = new SADIT3Entities())
{
try
{
var recipient = from a in pishravi.Customers
where a.cAlternativePhone == recipientTextBox.Text
select a.cAlternativePhone;
var initiator = from a in pishravi.Accounts
where a.Customer.cAlternativePhone == AccountStatus.LoggedInId
select a.AccountID;
pishravi.AccTransactions.Add(new AccTransaction
{
AccountID = initiator.Single(),
Status = "Request to " + recipient.Single() + " for " + amountTextbox.Text + " " + serviceCombobox.SelectedItem,
tTime = DateTime.Now
});
pishravi.SaveChanges();
MessageBox.Show("Request sent!");
this.Close();
}
catch
{
MessageBox.Show("No such user!");
}
}
AccountStatus.recipientNumber = "";
}
private void removeButton_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("Are you sure you want to remove this transaction?", "Remove Transaction", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
using (SADIT3Entities pishravi = new SADIT3Entities())
{
AccTransaction toDelete =
(from a in pishravi.AccTransactions
where a.Status == transactionList.SelectedItem.ToString()
select a).Single();
pishravi.AccTransactions.Remove(toDelete);
pishravi.SaveChanges();
var selected = transactionList.SelectedItem;
transactionList.Items.Remove(selected);
}
}
}
public Transactions()
{
InitializeComponent();
accountName.Text = AccountStatus.userName;
accountNumber.Text = AccountStatus.accountNumber;
using (SADIT3Entities pishravi = new SADIT3Entities())
{
var allTrans = from a in pishravi.AccTransactions
where a.Account.Customer.cAlternativePhone == AccountStatus.LoggedInId
select a.Status;
foreach (var trans in pishravi.AccTransactions.Where(x=>x.Account.Customer.cAlternativePhone == AccountStatus.LoggedInId))
{
//var singleTrans = trans.Single();
transactionList.Items.Add(trans.Status);
}
}
}
public AccountDetails()
{
InitializeComponent();
using (SADIT3Entities pishravi = new SADIT3Entities())
{
var address = from a in pishravi.Customers
where a.cAlternativePhone == AccountStatus.LoggedInId
select a.cStreetAddress + Environment.NewLine + a.cSuburbAddress + Environment.NewLine + a.cCity;
var postcode = from a in pishravi.Customers
where a.cAlternativePhone == AccountStatus.LoggedInId
select a.cPostCode;
accountNumber.Text = AccountStatus.accountNumber;
accountName.Text = AccountStatus.userName;
accountAddress.Text = address.Single();
accountPostcode.Text = postcode.Single().ToString();
}
}
private void registerButton_Click(object sender, EventArgs e)
{
if (nameTextBox.Text != null && emailTextBox.Text != null && addressTextBox.Text != null &&
cityTextBox.Text != null && passwordTextBox.Text != null && phoneTextBox.Text != null &&
postcodeTextBox.Text != null && suburbTextBox.Text != null)
{
using (SADIT3Entities pishravi = new SADIT3Entities())
{
var user = from a in pishravi.Customers
where a.cAlternativePhone == phoneTextBox.Text
select a.cAlternativePhone;
try
{
if (user.Single() == phoneTextBox.Text)
{
MessageBox.Show("Sorry, there is already an account with that phone number");
numberDoesntExist = false;
}
else
{
numberDoesntExist = true;
}
}
catch
{
}
}
if (!numberDoesntExist) return;
using (SADIT3Entities pishravi = new SADIT3Entities())
{
if (address2TextBox.Text == "")
{
address2TextBox.Text = "None";
}
Customer newCustomer = new Customer
{
cAlternativePhone = phoneTextBox.Text,
cCity = cityTextBox.Text,
cEmail = emailTextBox.Text,
cFirstName = (nameTextBox.Text.Split(char.Parse(" "))[0].ToString()),
cLastName = (nameTextBox.Text.Split(char.Parse(" "))[1].ToString()),
cPassword = passwordTextBox.Text,
cPostCode = int.Parse(postcodeTextBox.Text),
cStreetAddress = addressTextBox.Text,
cStreetAddress2 = address2TextBox.Text,
cSuburbAddress = suburbTextBox.Text
};
Account newAccount = new Account {
aDateOpened = DateTime.Now,
aIsActive = true,
aPhoneNumber = phoneTextBox.Text,
Customer = newCustomer
};
pishravi.Accounts.Add(newAccount);
pishravi.Customers.Add(newCustomer);
pishravi.SaveChanges();
}
this.Close();
new Login().Show();
}
}