private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (lblName.Content == "?" || lblDesc.Content == "?" || String.IsNullOrWhiteSpace(txtName.Text)) { System.Windows.MessageBox.Show("Please input correct format and/or fill all required fields", "Error", MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } if (status == "Add") { using (var ctx = new finalContext()) { var num = ctx.Banks.Where(x => x.BankName == txtName.Text).Count(); if (num > 0) { return; } Bank bank = new Bank { BankName = txtName.Text, Description = txtDesc.Text, Active = true }; var add = from ad in ctx.TempAdresses select ad; int ctr = 1; foreach (var item in add) { BankAddress bAd = new BankAddress { BankNum = ctr, City = item.City, Province = item.Province, Street = item.Street }; ctx.BankAdresses.Add(bAd); ctr++; } AuditTrail at = new AuditTrail { EmployeeID = UserID, DateAndTime = DateTime.Now, Action = "Added new Bank " + txtName.Text }; ctx.AuditTrails.Add(at); ctx.Banks.Add(bank); ctx.SaveChanges(); System.Windows.MessageBox.Show("New Bank Added", "Information", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } else { using (var ctx = new finalContext()) { var bank = ctx.Banks.Find(bId); bank.BankName = txtName.Text; bank.Description = txtDesc.Text; AuditTrail at = new AuditTrail { EmployeeID = UserID, DateAndTime = DateTime.Now, Action = "Updated Bank " + txtName.Text }; ctx.AuditTrails.Add(at); ctx.SaveChanges(); System.Windows.MessageBox.Show("Bank Successfully Updated", "Information", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } } catch (Exception ex) { System.Windows.MessageBox.Show("Runtime Error: " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } }
private void btnAddAddress_Click(object sender, RoutedEventArgs e) { try { if (btnAddAddress.Content.ToString() != "Add") { if (lblStreet.Content == "?" || lblProvince.Content == "?" || lblCity.Content == "?" || String.IsNullOrWhiteSpace(txtStreet.Text) || String.IsNullOrWhiteSpace(txtProvince.Text) || String.IsNullOrWhiteSpace(txtCity.Text)) { System.Windows.MessageBox.Show("Please input correct format and/or fill all required fields"); return; } } if (btnAddAddress.Content.ToString() == "Add") { grpAddress.Visibility = Visibility.Visible; btnAddAddress.Content = "Save"; btnEdtAddress.Content = "Cancel"; btnEdtAddress.IsEnabled = true; btnDelAddress.Visibility = Visibility.Hidden; tbAddress.IsEnabled = false; tbInfo.IsEnabled = false; } else if (btnAddAddress.Content.ToString() == "Save") { if (txtCity.Text == "" || txtProvince.Text == "" || txtStreet.Text == "") { System.Windows.MessageBox.Show("Please complete the required information", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } //for view if (status == "View") { using (var ctx = new finalContext()) { var add = ctx.BankAdresses.Where(x => x.BankID == bId).Count(); int ctr = add + 1; BankAddress adds = new BankAddress { BankID = bId, BankNum = ctr, Street = txtStreet.Text, Province = txtProvince.Text, City = txtCity.Text }; ctx.BankAdresses.Add(adds); ctx.SaveChanges(); var adds1 = from ad in ctx.BankAdresses where ad.BankID == bId select new { BankNumber = ad.BankNum, Street = ad.Street, Province = ad.Province, City = ad.City }; dgAddress.ItemsSource = adds1.ToList(); } reset(); return; } using (var ctx = new finalContext()) { TempAddress add = new TempAddress { Street = txtStreet.Text, Province = txtProvince.Text, City = txtCity.Text }; ctx.TempAdresses.Add(add); ctx.SaveChanges(); dgAddress.ItemsSource = ctx.TempAdresses.ToList(); } reset(); } else { //for view if (status == "View") { using (var ctx = new finalContext()) { int bankNum = Convert.ToInt32(getRow(dgAddress, 0)); var add = ctx.BankAdresses.Where(x => x.BankID == bId && x.BankNum == bankNum).First(); add.City = txtCity.Text; add.Province = txtProvince.Text; add.Street = txtStreet.Text; ctx.SaveChanges(); var adds = from ad in ctx.BankAdresses where ad.BankID == bId select new { BankNumber = ad.BankNum, Street = ad.Street, Province = ad.Province, City = ad.City }; dgAddress.ItemsSource = adds.ToList(); } reset(); return; } using (var ctx = new finalContext()) { var add = ctx.TempAdresses.Find(Convert.ToInt32(getRow(dgAddress, 0))); add.City = txtCity.Text; add.Province = txtProvince.Text; add.Street = txtStreet.Text; ctx.SaveChanges(); dgAddress.ItemsSource = ctx.TempAdresses.ToList(); reset(); } } } catch (Exception ex) { System.Windows.MessageBox.Show("Runtime Error: " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } }