private void AddInvestorForm_Load(object sender, EventArgs e) { //Default values for text boxes AddInvLastInvYearTextBox.Text = DateTime.Now.Year.ToString(); //Setup the columns for the datagridview //Column 0: Date FIFLibrary.CalendarColumn DateColumn = new FIFLibrary.CalendarColumn(); DateColumn.HeaderText = "Investment Date"; //Column 1: Amount DataGridViewTextBoxColumn AmountColumn = new DataGridViewTextBoxColumn(); AmountColumn.HeaderText = "Amount"; //Column 2: Payment Type DataGridViewComboBoxColumn PaymentTypeColumn = new DataGridViewComboBoxColumn(); PaymentTypeColumn.DataSource = new string[] { "check", "cash", "N/A" }; PaymentTypeColumn.HeaderText = "Payment Type"; PaymentTypeColumn.Name = "Payment Type"; //Column 3: Check Number DataGridViewTextBoxColumn CheckNumberColumn = new DataGridViewTextBoxColumn(); CheckNumberColumn.HeaderText = "Check Number"; //Column 4: Credit To DataGridViewComboBoxColumn CreditToColumn = new DataGridViewComboBoxColumn(); CreditToColumn.DataSource = new string[] { "general fund", "youth", "N/A" }; CreditToColumn.HeaderText = "Credit To"; CreditToColumn.Name = "Credit To"; //Column 5: Youth Name DataGridViewComboBoxColumn YouthColumn = new DataGridViewComboBoxColumn(); YouthColumn.DataSource = DBCommunication.GetYouthFullNames(); YouthColumn.HeaderText = "Youth Name"; YouthColumn.Name = "Youth Name"; //Column 6: Reinvest DataGridViewCheckBoxColumn ReinvestColumn = new DataGridViewCheckBoxColumn(); ReinvestColumn.HeaderText = "Reinvest"; //add columns to datagridview InvDataGridView.Columns.Add(DateColumn); InvDataGridView.Columns.Add(AmountColumn); InvDataGridView.Columns.Add(PaymentTypeColumn); InvDataGridView.Columns.Add(CheckNumberColumn); InvDataGridView.Columns.Add(CreditToColumn); InvDataGridView.Columns.Add(YouthColumn); InvDataGridView.Columns.Add(ReinvestColumn); }
private void InvestorForm_Load(object sender, EventArgs e) { //Find the number of investments associated with this investor. If the user adds investments, //user's LastInvestYear will need to be updated startingInvestmentsCount = Globals.GlobalInvestments.Where(i => i.InvestorID == selectedInvestor.InvestorID).Count(); //Databind the textboxes to the investor FirstNameTextBox.DataBindings.Add("Text", selectedInvestor, "FirstName"); LastNameTextBox.DataBindings.Add("Text", selectedInvestor, "LastName"); AddressTextBox.DataBindings.Add("Text", selectedInvestor, "Address"); CityTextBox.DataBindings.Add("Text", selectedInvestor, "City"); StateTextBox.DataBindings.Add("Text", selectedInvestor, "State"); ZipTextBox.DataBindings.Add("Text", selectedInvestor, "Zip"); EmailTextBox.DataBindings.Add("Text", selectedInvestor, "Email"); PhoneMaskedTextBox.DataBindings.Add("Text", selectedInvestor, "Phone"); JoinDateTimePicker.DataBindings.Add("Value", selectedInvestor, "JoinDate"); LastInvYearTextBox.DataBindings.Add("Text", selectedInvestor, "LastInvestYear"); NotesRichTextBox.DataBindings.Add("Text", selectedInvestor, "Notes"); LabelNameTextBox.DataBindings.Add("Text", selectedInvestor, "LabelName"); InvestorDeceasedCheckBox.DataBindings.Add("Checked", selectedInvestor, "Deceased"); //set properties for textboxes LastInvYearTextBox.ReadOnly = true; //Setup the columns for the datagridview //Column 0: Date FIFLibrary.CalendarColumn DateColumn = new FIFLibrary.CalendarColumn(); DateColumn.HeaderText = "Investment Date"; //Column 1: Amount DataGridViewTextBoxColumn AmountColumn = new DataGridViewTextBoxColumn(); AmountColumn.HeaderText = "Amount"; //Column 2: Payment Type DataGridViewComboBoxColumn PaymentTypeColumn = new DataGridViewComboBoxColumn(); PaymentTypeColumn.DataSource = new string[] { "check", "cash", "N/A" }; PaymentTypeColumn.HeaderText = "Payment Type"; PaymentTypeColumn.Name = "Payment Type"; //Column 3: Check Number DataGridViewTextBoxColumn CheckNumberColumn = new DataGridViewTextBoxColumn(); CheckNumberColumn.HeaderText = "Check Number"; //Column 4: Credit To DataGridViewComboBoxColumn CreditToColumn = new DataGridViewComboBoxColumn(); CreditToColumn.DataSource = new string[] { "general fund", "youth", "N/A" }; CreditToColumn.HeaderText = "Credit To"; CreditToColumn.Name = "Credit To"; //Column 5: Youth Name DataGridViewComboBoxColumn YouthColumn = new DataGridViewComboBoxColumn(); YouthColumn.DataSource = DBCommunication.GetYouthFullNames(); YouthColumn.HeaderText = "Youth Name"; YouthColumn.Name = "Youth Name"; //Column 6: Reinvest DataGridViewCheckBoxColumn ReinvestColumn = new DataGridViewCheckBoxColumn(); ReinvestColumn.HeaderText = "Reinvest"; //Column 7: Certificate Number DataGridViewTextBoxColumn CertificateNumberColumn = new DataGridViewTextBoxColumn(); CertificateNumberColumn.HeaderText = "Certificate Number"; CertificateNumberColumn.ReadOnly = true; //Column 8: InvestmentID (display only - used for tracking the investmentID) DataGridViewTextBoxColumn InvestmentIDColumn = new DataGridViewTextBoxColumn(); InvestmentIDColumn.Visible = false; //Column 9: IsNewInvestment (not visible, used for tracking new vs old investments) DataGridViewTextBoxColumn IsNewInvestmentColumn = new DataGridViewTextBoxColumn(); IsNewInvestmentColumn.Visible = false; InvestmentsDataGridView.Columns.Add(DateColumn); InvestmentsDataGridView.Columns.Add(AmountColumn); InvestmentsDataGridView.Columns.Add(PaymentTypeColumn); InvestmentsDataGridView.Columns.Add(CheckNumberColumn); InvestmentsDataGridView.Columns.Add(CreditToColumn); InvestmentsDataGridView.Columns.Add(YouthColumn); InvestmentsDataGridView.Columns.Add(ReinvestColumn); InvestmentsDataGridView.Columns.Add(CertificateNumberColumn); InvestmentsDataGridView.Columns.Add(InvestmentIDColumn); InvestmentsDataGridView.Columns.Add(IsNewInvestmentColumn); foreach (Investment2 i in Globals.GlobalInvestments.Where(i => i.InvestorID == selectedInvestor.InvestorID)) { string YouthName = ""; if(i.YouthID != -1) { YouthName = Globals.GlobalYouth.Where(y => y.YouthID == i.YouthID).Select(y => y.FullName).Single(); } InvestmentsDataGridView.Rows.Add(i.Date, i.Amount, i.PaymentType, i.CheckNumber, i.CreditTo, YouthName, i.Reinvst, i.CertificateNumber, i.InvestmentID, "false"); if(i.YouthID == -1) { InvestmentsDataGridView.Rows[InvestmentsDataGridView.Rows.Count-2].Cells[5].ReadOnly = true; } } }