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