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