private void DeleteDonation(object sender, RoutedEventArgs e) { System.Windows.Forms.DialogResult result = System.Windows.Forms.MessageBox.Show("Delete this Donation?", "Confirmation", System.Windows.Forms.MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.Yes) { FCS_Funding.Models.FCS_DBModel db = new FCS_Funding.Models.FCS_DBModel(); DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); //var purpose = (from p in db.Purposes // where p.PurposeID == PurposeID // select p).First(); var donation = (from d in db.Donations where d.DonationID == DonationID select d).First(); //db.Purposes.Remove(purpose); db.Donations.Remove(donation); db.SaveChanges(); MessageBox.Show("Donation Deleted."); this.Close(); } }
private void Delete_Grant(object sender, RoutedEventArgs e) { FCS_DBModel db = new FCS_DBModel(); System.Windows.Forms.DialogResult result = System.Windows.Forms.MessageBox.Show("Delete this Grant?", "Confirmation", System.Windows.Forms.MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.Yes) { var donationPurposes = (from p in db.DonationPurposes where p.PurposeID == PurposeID select p); DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); } //var purpose = (from p in db.Purposes // where p.PurposeID == PurposeID // select p).First(); var donation = (from d in db.Donations where d.DonationID == DonationID select d).First(); //try { // var donationPurpose = (from dp in db.DonationPurposes // where dp.DonationID == donation.DonationID // select dp); // foreach (var item in donationPurpose) // { // db.DonationPurposes.Remove(item); // db.SaveChanges(); // } //} //catch //{ //} var grantProposal = (from d in db.GrantProposals where d.GrantProposalID == GrantProposalID select d).First(); grantProposal.GrantStatus = "Pending"; db.Donations.Remove(donation); db.SaveChanges(); MessageBox.Show("This grant has been deleted and its associated proposal has been set to Pending."); this.Close(); }
private void Update_Grant(object sender, RoutedEventArgs e) { FCS_Funding.Models.FCS_DBModel db = new FCS_Funding.Models.FCS_DBModel(); //var purpose = (from p in db.Purposes // where p.PurposeID == PurposeID // select p).First(); //purpose.PurposeName = PurposeName; //purpose.PurposeDescription = PurposeDescription; var donation = (from d in db.Donations where d.DonationID == DonationID select d).First(); donation.DonationDate = Convert.ToDateTime(DonationDate.ToString()); if (DonationAmount - donation.DonationAmount < 0) { MessageBox.Show("This change would result in a\nnegative balance for this donation"); } else { if (restrictedCheckBox.IsChecked == true) { if (PurposeComboBox.Text != "" && PurposeComboBox.Text != null) { DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); 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(); donation.Restricted = true; if (DonationExpiration != null && DonationExpiration.ToString() != "") { donation.DonationExpirationDate = Convert.ToDateTime(DonationExpiration.ToString()); } else { donation.DonationExpirationDate = null; } dp.DonationID = donation.DonationID; dp.PurposeID = PurposeID; dp.DonationPurposeAmount = DonationAmount; db.DonationPurposes.Add(dp); decimal donationDiff = donation.DonationAmount - DonationAmount; donation.GrantProposalID = GrantProposalID; donation.DonationAmount = DonationAmount; donation.DonationAmountRemaining = donation.DonationAmountRemaining - donationDiff; db.Entry(donation); db.SaveChanges(); db.Entry(dp); db.SaveChanges(); } else { MessageBox.Show("Please enter a purpose if the donation is restrcted"); } } else { DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); donation.Restricted = false; donation.DonationExpirationDate = null; donation.GrantProposalID = GrantProposalID; decimal donationDiff = donation.DonationAmount - DonationAmount; donation.DonationAmount = DonationAmount; donation.DonationAmountRemaining = donation.DonationAmountRemaining - donationDiff; db.Entry(donation); db.SaveChanges(); } this.Close(); } }
private void Delete_Grant(object sender, RoutedEventArgs e) { FCS_DBModel db = new FCS_DBModel(); System.Windows.Forms.DialogResult result = System.Windows.Forms.MessageBox.Show("Delete this Grant?", "Confirmation", System.Windows.Forms.MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.Yes) { var donationPurposes = (from p in db.DonationPurposes where p.PurposeID == PurposeID select p); DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); } //var purpose = (from p in db.Purposes // where p.PurposeID == PurposeID // select p).First(); var donation = (from d in db.Donations where d.DonationID == DonationID select d).First(); //try { // var donationPurpose = (from dp in db.DonationPurposes // where dp.DonationID == donation.DonationID // select dp); // foreach (var item in donationPurpose) // { // db.DonationPurposes.Remove(item); // db.SaveChanges(); // } //} //catch //{ //} var grantProposal = (from d in db.GrantProposals where d.GrantProposalID == GrantProposalID select d).First(); grantProposal.GrantStatus = "Pending"; db.Donations.Remove(donation); db.SaveChanges(); MessageBox.Show("This grant has been deleted and its associated proposal has been set to Pending."); this.Close(); }
private void Update_Grant(object sender, RoutedEventArgs e) { FCS_Funding.Models.FCS_DBModel db = new FCS_Funding.Models.FCS_DBModel(); //var purpose = (from p in db.Purposes // where p.PurposeID == PurposeID // select p).First(); //purpose.PurposeName = PurposeName; //purpose.PurposeDescription = PurposeDescription; var donation = (from d in db.Donations where d.DonationID == DonationID select d).First(); donation.DonationDate = Convert.ToDateTime(DonationDate.ToString()); if (DonationAmount - donation.DonationAmount < 0) { MessageBox.Show("This change would result in a\nnegative balance for this donation"); } else { if (restrictedCheckBox.IsChecked == true) { if (PurposeComboBox.Text != "" && PurposeComboBox.Text != null) { DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); 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(); donation.Restricted = true; if (DonationExpiration != null && DonationExpiration.ToString() != "") { donation.DonationExpirationDate = Convert.ToDateTime(DonationExpiration.ToString()); } else { donation.DonationExpirationDate = null; } dp.DonationID = donation.DonationID; dp.PurposeID = PurposeID; dp.DonationPurposeAmount = DonationAmount; db.DonationPurposes.Add(dp); decimal donationDiff = donation.DonationAmount - DonationAmount; donation.GrantProposalID = GrantProposalID; donation.DonationAmount = DonationAmount; donation.DonationAmountRemaining = donation.DonationAmountRemaining - donationDiff; db.Entry(donation); db.SaveChanges(); db.Entry(dp); db.SaveChanges(); } else { MessageBox.Show("Please enter a purpose if the donation is restrcted"); } } else { DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); donation.Restricted = false; donation.DonationExpirationDate = null; donation.GrantProposalID = GrantProposalID; decimal donationDiff = donation.DonationAmount - DonationAmount; donation.DonationAmount = DonationAmount; donation.DonationAmountRemaining = donation.DonationAmountRemaining - donationDiff; db.Entry(donation); db.SaveChanges(); } this.Close(); } }
private void DeleteDonation(object sender, RoutedEventArgs e) { System.Windows.Forms.DialogResult result = System.Windows.Forms.MessageBox.Show("Delete this Donation?", "Confirmation", System.Windows.Forms.MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.Yes) { FCS_Funding.Models.FCS_DBModel db = new FCS_Funding.Models.FCS_DBModel(); DeletePurposes delPurp = new DeletePurposes(); delPurp.deletePurpose(DonationID); //var purpose = (from p in db.Purposes // where p.PurposeID == PurposeID // select p).First(); var donation = (from d in db.Donations where d.DonationID == DonationID select d).First(); //db.Purposes.Remove(purpose); db.Donations.Remove(donation); db.SaveChanges(); MessageBox.Show("Donation Deleted."); this.Close(); } }