public void GetAccounts()
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
using (SqlCommand cmd = new SqlCommand("spHentKonti", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@kundeID", DashboardViewModel.u.Id);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Accounts.Add(new AccountModel(
AccountNmb = dr[0].ToString(),
AccountType = dr[1].ToString(),
AccountName = dr[2].ToString(),
Balance = Convert.ToDecimal(dr[3])));
}
}
}
}
public void MakePayment()
{
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("spLavBetaling", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@afsender", SelectedAccountNmb);
cmd.Parameters.AddWithValue("@modtager", Receiver);
cmd.Parameters.AddWithValue("@note", Note);
cmd.Parameters.AddWithValue("@beloeb", Amount);
int count = Convert.ToInt32(cmd.ExecuteNonQuery());
if (count == -1)
{
MessageBox.Show("Modtageren findes ikke!");
}
else
{
MessageBox.Show("Jeg tror det lykkedes?");
}
}
}
}
catch (Exception)
{
throw;
}
}
public void GetTransactions()
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
using (SqlCommand cmd = new SqlCommand("spHentAlleTransaktionerAlleKonti", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@kundeID", DashboardViewModel.u.Id);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Transactions.Add(new TransactionModel
{
TransactionID = Convert.ToInt32(dr[0]),
AccountNmb = Convert.ToInt32(dr[1]),
Note = dr[2].ToString(),
Function = Convert.ToChar(dr[3]),
Amount = Convert.ToDecimal(dr[4]),
NewBalance = Convert.ToDecimal(dr[5]),
Date = dr[6].ToString()
});
}
}
}
}
public void Login()
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
try
{
SqlCommand cmd = new SqlCommand("spLogin", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@email", Email);
cmd.Parameters.AddWithValue("@kodeord", Psw);
cmd.ExecuteNonQuery();
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count == 1)
{
using (SqlCommand cmd2 = new SqlCommand("spHentbrugerinfo", conn))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@email", Email);
cmd2.Parameters.AddWithValue("@kodeord", Psw);
using (SqlDataReader reader = cmd2.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
ShellViewModel.u = new UserModel(
reader.GetInt32(0),
reader.GetString(1).ToString(),
reader.GetString(2).ToString());
}
}
};
_events.PublishOnUIThread(new DashboardRequest());
}
else
{
manager.ShowDialog(new LoginErrorViewModel());
Psw = "";
}
}
catch (Exception)
{
manager.ShowDialog(new LoginErrorViewModel());
Psw = "";
}
}
}
public void CreateUserAndAccount()
{
try
{
// Henter KundeTypeID
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spHentKundeTypeID", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@kundeType", SelectedUserType);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
UserTypeID = reader.GetInt32(0);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("1) " + ex.Message);
}
// Opretter Bruger
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spOpretKunde", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@kundeTypeID", UserTypeID);
cmd.Parameters.AddWithValue("@fornavn", SignUpUserViewModel.newUser.FirstName);
cmd.Parameters.AddWithValue("@efternavn", SignUpUserViewModel.newUser.LastName);
cmd.Parameters.AddWithValue("@tlfnr", SignUpUserViewModel.newUser.PhoneNmb);
cmd.Parameters.AddWithValue("@email", SignUpUserViewModel.newUser.Email);
cmd.Parameters.AddWithValue("@kodeord", SignUpUserViewModel.newUser.Psw);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show("2) " + ex.Message);
}
// Henter den nye brugers ID
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
using (SqlCommand cmd2 = new SqlCommand("spHentBrugerID", conn))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@email", SignUpUserViewModel.newUser.Email);
cmd2.Parameters.AddWithValue("@kodeord", SignUpUserViewModel.newUser.Psw);
using (SqlDataReader reader = cmd2.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
ID = reader.GetInt32(0);
}
}
};
}
}
catch (Exception ex)
{
MessageBox.Show("3) " + ex.Message);
}
// Henter KontoTypeID
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("spHentKontoTypeID", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@kontoType", SelectedAccountType);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
adapter.Fill(ds);
if (ds.Rows.Count == 1)
{
AccountTypeID = ds.Rows[0].Field <int>(0);
}
else
{
if (SelectedUserType == "Privat")
{
AccountTypeID = ds.Rows[0].Field <int>(0);
}
else if (SelectedUserType == "Erhverv")
{
AccountTypeID = ds.Rows[1].Field <int>(0);
}
else if (SelectedUserType == "Private Banking")
{
AccountTypeID = ds.Rows[2].Field <int>(0);
}
}
};
}
}
catch (Exception ex)
{
MessageBox.Show("4) " + ex.Message);
}
// Opretter konto
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("spOpretKonto", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@kundeID", ID);
cmd.Parameters.AddWithValue("@kontoTypeID", AccountTypeID);
cmd.Parameters.AddWithValue("@navn", AccountName);
cmd.ExecuteNonQuery();
}
canExecute = true;
}
catch (Exception ex)
{
MessageBox.Show("5) " + ex.Message);
canExecute = false;
}
}
catch (Exception)
{
canExecute = false;
}
if (canExecute == true)
{
manager.ShowDialog(new UserCreatedSuccesViewModel());
ShowLoginPage();
}
}
public void GetTypes()
{
TypesModel type1 = new TypesModel();
TypesModel type2 = new TypesModel();
TypesModel type3 = new TypesModel();
var addNew1 = true;
var addNew2 = true;
var addNew3 = true;
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
using (SqlCommand cmd = new SqlCommand("spHentTyper", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr[0].ToString() == "Privat" && addNew1 == true)
{
type1.UserTypes = dr[0].ToString();
type1.AccountTypes.Add(dr[1].ToString());
addNew1 = false;
}
else if (dr[0].ToString() == "Privat" && addNew1 == false)
{
type1.AccountTypes.Add(dr[1].ToString());
}
else if (dr[0].ToString() == "Erhverv" && addNew2 == true)
{
type2.UserTypes = dr[0].ToString();
type2.AccountTypes.Add(dr[1].ToString());
addNew2 = false;
}
else if (dr[0].ToString() == "Erhverv" && addNew2 == false)
{
type2.AccountTypes.Add(dr[1].ToString());
}
else if (dr[0].ToString() == "Private Banking" && addNew3 == true)
{
type3.UserTypes = dr[0].ToString();
type3.AccountTypes.Add(dr[1].ToString());
addNew3 = false;
}
else if (dr[0].ToString() == "Private Banking" && addNew3 == false)
{
type3.AccountTypes.Add(dr[1].ToString());
}
}
SomeTypes.Add(type1);
SomeTypes.Add(type2);
SomeTypes.Add(type3);
}
}
}
public void ValidateForm()
{
if (string.IsNullOrWhiteSpace(FirstName) ||
string.IsNullOrWhiteSpace(LastName) ||
string.IsNullOrWhiteSpace(PhoneNmb) ||
string.IsNullOrWhiteSpace(Email) ||
string.IsNullOrWhiteSpace(Psw) ||
string.IsNullOrWhiteSpace(PswDup))
{
manager.ShowDialog(new IncompleteFormErrorViewModel());
}
else if (PhoneNmb.Length != 8)
{
manager.ShowDialog(new PhoneNumberLengthErrorViewModel());
}
else if (!int.TryParse(PhoneNmb, out int parsedValue))
{
manager.ShowDialog(new PhoneNumberHasLettersErrorViewModel());
}
else if (Psw != PswDup)
{
manager.ShowDialog(new PasswordsDoesntMatchErrorViewModel());
}
else
{
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
SqlCommand cmd1 = new SqlCommand("spTjekTlfnrDuplikation", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd1.Parameters.AddWithValue("@tlfnr", PhoneNmb);
int count = Convert.ToInt32(cmd1.ExecuteScalar());
if (count == 1)
{
MessageBox.Show("Telefonnummeret er allerede i brug!", "AM Banking - Telefonnummer Fejl!", MessageBoxButton.OK, MessageBoxImage.Warning);
isValidationOkay = false;
}
else
{
SqlCommand cmd2 = new SqlCommand("spTjekEmailDuplikation", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd2.Parameters.AddWithValue("@email", Email);
int count2 = Convert.ToInt32(cmd2.ExecuteScalar());
if (count2 == 1)
{
MessageBox.Show("Emailen er allerede i brug!", "AM Banking - Email Fejl!", MessageBoxButton.OK, MessageBoxImage.Warning);
isValidationOkay = false;
}
else
{
isValidationOkay = true;
}
}
}
}
catch (Exception)
{
isValidationOkay = false;
}
if (isValidationOkay == true)
{
newUser = new UserModel(FirstName, LastName, PhoneNmb, Email, Psw);
ShowSignUpAccountPage();
}
}
}
