private void Create_Grant_Proposal(object sender, RoutedEventArgs e) { if (SubmissionDueDate.ToString() != "" && Organization.SelectedValue != null && GrantName != null && GrantName != "") { string organiz = Organization.SelectedValue.ToString(); DateTime datet = Convert.ToDateTime(SubmissionDueDate.ToString()); //MessageBox.Show(organiz + "\n" + datet + "\n" + GrantName + "\n" + "Status is Pending"); Models.FCS_DBModel db = new Models.FCS_DBModel(); int DonorID = (from d in db.Donors where d.OrganizationName == organiz select d.DonorID).Distinct().First(); Models.GrantProposal gp = new Models.GrantProposal(); gp.DonorID = DonorID; gp.GrantName = GrantName; gp.SubmissionDueDate = datet; gp.GrantStatus = "Pending"; db.GrantProposals.Add(gp); db.SaveChanges(); this.Close(); } else { MessageBox.Show("Select a date"); } }