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(); } } }