private void AddGrant(object sender, RoutedEventArgs e) { try { FCS_DBModel db = new FCS_DBModel(); Donation d = new Donation(); if (IsEvent) { d.DonorID = DonorID; d.Restricted = false; d.InKind = false; d.DonationAmount = DonationAmount; d.DonationDate = Convert.ToDateTime(DonationDate.ToString()); d.EventID = EventID; d.DonationAmountRemaining = DonationAmount; db.Donations.Add(d); } else { d.DonorID = DonorID; d.Restricted = false; d.InKind = false; d.DonationAmount = DonationAmount; d.DonationDate = Convert.ToDateTime(DonationDate.ToString()); d.DonationAmountRemaining = DonationAmount; db.Donations.Add(d); } if (restrictedCheckBox.IsChecked == true) { Purpose p = new Purpose(); DonationPurpose dp = new DonationPurpose(); string purposeName = PurposeComboBox.SelectedItem.ToString(); int PurposeID = db.Purposes.Where(x => x.PurposeName == purposeName).Select(x => x.PurposeID).First(); d.Restricted = true; d.DonationExpirationDate = Convert.ToDateTime(DonationExpiration.ToString()); dp.DonationID = d.DonationID; dp.PurposeID = PurposeID; dp.DonationPurposeAmount = DonationAmount; db.DonationPurposes.Add(dp); db.Donations.Remove(d); db.Donations.Add(d); } db.SaveChanges(); this.Close(); } catch { MessageBox.Show("Make sure to input all the correct data."); } }
public UpdateGrant(GrantsDataGrid g) { FCS_DBModel db = new FCS_DBModel(); Donation d = new Donation(); foreach (var item in db.Purposes) { purpose.Add(item.PurposeName); } DataContext = purpose; GrantName = g.GrantName; DonationAmount = g.DonationAmount; DonationAmountRemaining = g.DonationAmountRemaining; PurposeName = g.PurposeName; PurposeDescription = g.PurposeDescription; PurposeID = g.PurposeID; DonationID = g.DonationID; DonorID = g.DonorID; GrantProposalID = g.GrantProposalID; InitializeComponent(); DonAmount.Focus(); var restricted = (from item in db.Donations where item.DonationID == DonationID select item.Restricted).First(); if (restricted == true) { var donationTable = (from don in db.Donations join dp in db.DonationPurposes on don.DonationID equals dp.DonationID join p in db.Purposes on dp.PurposeID equals p.PurposeID where don.DonationID == DonationID select new { don.DonationID, don.DonationExpirationDate, don.Restricted, dp.PurposeID }).First(); DonationDate.IsEnabled = false; DonationExpiration.SelectedDate = donationTable.DonationExpirationDate; restrictedCheckBox.IsChecked = true; PurposeComboBox.SelectedItem = (from p in db.Purposes join dp in db.DonationPurposes on p.PurposeID equals dp.PurposeID join don in db.Donations on dp.DonationID equals don.DonationID where dp.PurposeID == donationTable.PurposeID select p.PurposeName).First(); } }
private void AddGrant(object sender, RoutedEventArgs e) { try { //MessageBox.Show(DonationAmount.ToString() + "\n" + DonationDate + "\n" + // PurposeName + "\n" + PurposeDescription); FCS_DBModel db = new FCS_DBModel(); Donation d = new Donation(); d.DonorID = DonorID; d.Restricted = false; d.InKind = false; d.DonationAmount = DonationAmount; d.DonationDate = Convert.ToDateTime(DonationDate.ToString()); d.DonationAmountRemaining = DonationAmount; d.GrantProposalID = GrantProposalID; db.Donations.Add(d); if (restrictedCheckBox.IsChecked == true) { Purpose p = new Purpose(); DonationPurpose dp = new DonationPurpose(); string purposeName = PurposeComboBox.SelectedValue.ToString(); int PurposeID = db.Purposes.Where(x => x.PurposeName == purposeName).Select(x => x.PurposeID).First(); d.Restricted = true; d.DonationExpirationDate = Convert.ToDateTime(DonationExpiration.ToString()); d.GrantProposalID = GrantProposalID; dp.DonationID = d.DonationID; dp.PurposeID = PurposeID; dp.DonationPurposeAmount = DonationAmount; db.DonationPurposes.Add(dp); db.Donations.Remove(d); db.Donations.Add(d); } db.SaveChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show("Cannot add Grant" + "\n" + ex); } }