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

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