private void CbxSelectedInvoice_SelectedValueChanged(object sender, EventArgs e)
{
DBInvoice tempInvoice = (cbxSelectedInvoice.SelectedItem as DBInvoice);
this.txtSearchName.Text = tempInvoice.Collector.FullName;
this.mtxtPhoneNumber.Text = tempInvoice.Collector.PhoneNumber;
}
/// <summary>
/// Gets a list of all the invoices in the database
/// </summary>
/// <returns>A list of all the invoices in the database</returns>
public static BindingList <DBInvoice> GetInvoices()
{
BindingList <DBInvoice> invoices = new BindingList <DBInvoice>();
string query = "SELECT * FROM invoice";
using (var conn = new SqlConnection(Properties.Settings.Default.Britannicus_DBConnectionString))
{
var command = new SqlCommand(query, conn);
conn.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
DBInvoice tempInvoice = new DBInvoice((int)reader["invoiceID"], (int)reader["customerID"], (DateTime)reader["invoiceDate"]);
invoices.Add(tempInvoice);
}
}
return(invoices);
}
public ViewPurchasesByInvoiceScreen(Screen backScreen) : base("View Purchases by Invoice", backScreen, 1)
{
this.tlpSearchBar = new System.Windows.Forms.TableLayoutPanel();
this.lblName = new System.Windows.Forms.Label();
this.lblSelectedInvoicePrompt = new System.Windows.Forms.Label();
this.lblSearchPrompt = new System.Windows.Forms.Label();
this.cbxSelectedInvoice = new System.Windows.Forms.ComboBox();
this.txtSearchName = new System.Windows.Forms.TextBox();
this.mtxtPhoneNumber = new System.Windows.Forms.MaskedTextBox();
this.lblPhoneNumPrompt = new System.Windows.Forms.Label();
this.btnViewCollectorPurchases = new System.Windows.Forms.Button();
this.tlpDatePanel = new System.Windows.Forms.TableLayoutPanel();
this.dtpDateTo = new System.Windows.Forms.DateTimePicker();
this.lblDateFromPrompt = new System.Windows.Forms.Label();
this.dtpDateFrom = new System.Windows.Forms.DateTimePicker();
this.lblDateToPrompt = new System.Windows.Forms.Label();
this.crvPurchasesByInvoice = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
cryRpt = new ViewPurchasesByInvoice();
this.BackColor = System.Drawing.Color.Transparent;
this.ColumnCount = 1;
this.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));
//this.Controls.Add(this.tlpSearchBar, 0, 0);
//this.Controls.Add(this.tlpDatePanel, 0, 1);
this.Controls.Add(this.crvPurchasesByInvoice, 0, 2);
this.Dock = System.Windows.Forms.DockStyle.Fill;
this.RowCount = 1;
//this.RowCount = 3;
//this.RowStyles.Add(new System.Windows.Forms.RowStyle(SizeType.AutoSize));
//this.RowStyles.Add(new System.Windows.Forms.RowStyle(SizeType.AutoSize));
//this.RowStyles.Add(new System.Windows.Forms.RowStyle(SizeType.Percent, 100F));
this.TabIndex = 0;
this.ParentChanged += ViewPurchasesByInvoiceScreen_ParentChanged;
//
// tlpSearchBar
//
//this.tlpSearchBar.AutoSize = true;
this.tlpSearchBar.BackColor = System.Drawing.Color.White;
this.tlpSearchBar.ColumnCount = 6;
this.tlpSearchBar.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.AutoSize));
this.tlpSearchBar.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));
this.tlpSearchBar.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));
this.tlpSearchBar.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.AutoSize));
this.tlpSearchBar.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));
this.tlpSearchBar.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.AutoSize));
this.tlpSearchBar.Controls.Add(this.lblName, 1, 0);
this.tlpSearchBar.Controls.Add(this.lblSelectedInvoicePrompt, 3, 0);
this.tlpSearchBar.Controls.Add(this.lblSearchPrompt, 0, 0);
this.tlpSearchBar.Controls.Add(this.cbxSelectedInvoice, 4, 0);
this.tlpSearchBar.Controls.Add(this.txtSearchName, 1, 1);
this.tlpSearchBar.Controls.Add(this.mtxtPhoneNumber, 2, 1);
this.tlpSearchBar.Controls.Add(this.lblPhoneNumPrompt, 2, 0);
this.tlpSearchBar.Controls.Add(this.btnViewCollectorPurchases, 5, 0);
this.tlpSearchBar.Dock = System.Windows.Forms.DockStyle.Fill;
this.tlpSearchBar.Padding = new System.Windows.Forms.Padding(10);
this.tlpSearchBar.RowCount = 3;
this.tlpSearchBar.RowStyles.Add(new System.Windows.Forms.RowStyle());
this.tlpSearchBar.RowStyles.Add(new System.Windows.Forms.RowStyle());
this.tlpSearchBar.RowStyles.Add(new System.Windows.Forms.RowStyle());
this.tlpSearchBar.TabIndex = 0;
//
// lblName
//
this.lblName.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.lblName.AutoSize = true;
this.lblName.TabIndex = 7;
this.lblName.Text = "Name";
this.lblName.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// lblSelectedInvoicePrompt
//
this.lblSelectedInvoicePrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblSelectedInvoicePrompt.AutoSize = true;
//this.lblSelectedInvoicePrompt.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.tlpSearchBar.SetRowSpan(this.lblSelectedInvoicePrompt, 2);
this.lblSelectedInvoicePrompt.TabIndex = 3;
this.lblSelectedInvoicePrompt.Text = "Selected Invoice:";
//
// lblSearchPrompt
//
this.lblSearchPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblSearchPrompt.AutoSize = true;
//this.lblSearchPrompt.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.tlpSearchBar.SetRowSpan(this.lblSearchPrompt, 2);
this.lblSearchPrompt.TabIndex = 0;
this.lblSearchPrompt.Text = "Search:";
//
// cbxSelectedCollector
//
this.cbxSelectedInvoice.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.cbxSelectedInvoice.FormattingEnabled = true;
this.cbxSelectedInvoice.Margin = new System.Windows.Forms.Padding(10, 3, 10, 3);
this.tlpSearchBar.SetRowSpan(this.cbxSelectedInvoice, 2);
this.cbxSelectedInvoice.TabIndex = 4;
this.cbxSelectedInvoice.DataSource = DBInvoice.GetInvoices();
this.cbxSelectedInvoice.DisplayMember = "ComboBoxDisplay";
this.cbxSelectedInvoice.ValueMember = "ID";
this.cbxSelectedInvoice.DropDownStyle = ComboBoxStyle.DropDownList;
this.cbxSelectedInvoice.SelectedValueChanged += CbxSelectedInvoice_SelectedValueChanged;
//
// txtSearchInput
//
this.txtSearchName.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txtSearchName.Margin = new System.Windows.Forms.Padding(10, 3, 10, 3);
this.txtSearchName.TabIndex = 1;
this.txtSearchName.MaxLength = DBControlHelper.MaximumFullNameLength;
//
// mtxtPhoneNumber
//
this.mtxtPhoneNumber.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.mtxtPhoneNumber.Margin = new System.Windows.Forms.Padding(10, 3, 10, 3);
this.mtxtPhoneNumber.Mask = "(000) 000-0000";
this.mtxtPhoneNumber.TabIndex = 5;
this.mtxtPhoneNumber.TextMaskFormat = MaskFormat.ExcludePromptAndLiterals;
//
// lblPhoneNumPrompt
//
this.lblPhoneNumPrompt.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.lblPhoneNumPrompt.AutoSize = true;
this.lblPhoneNumPrompt.TabIndex = 6;
this.lblPhoneNumPrompt.Text = "Phone Number";
this.lblPhoneNumPrompt.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// btnViewDetails
//
this.btnViewCollectorPurchases.Anchor = System.Windows.Forms.AnchorStyles.Left;
this.btnViewCollectorPurchases.AutoSize = true;
this.btnViewCollectorPurchases.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
this.btnViewCollectorPurchases.BackColor = System.Drawing.SystemColors.Control;
this.tlpSearchBar.SetRowSpan(this.btnViewCollectorPurchases, 2);
this.btnViewCollectorPurchases.TabIndex = 8;
this.btnViewCollectorPurchases.Text = "View Collector Purchases";
this.btnViewCollectorPurchases.UseVisualStyleBackColor = false;
this.btnViewCollectorPurchases.Click += BtnViewDetails_Click;
//
// tlpDatePanel
//
this.tlpDatePanel.AutoSize = true;
this.tlpDatePanel.ColumnCount = 4;
this.tlpDatePanel.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
this.tlpDatePanel.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
this.tlpDatePanel.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
this.tlpDatePanel.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
this.tlpDatePanel.Controls.Add(this.dtpDateTo, 3, 0);
this.tlpDatePanel.Controls.Add(this.lblDateFromPrompt, 0, 0);
this.tlpDatePanel.Controls.Add(this.dtpDateFrom, 1, 0);
this.tlpDatePanel.Controls.Add(this.lblDateToPrompt, 2, 0);
this.tlpDatePanel.Dock = System.Windows.Forms.DockStyle.Fill;
this.tlpDatePanel.RowCount = 1;
this.tlpDatePanel.RowStyles.Add(new System.Windows.Forms.RowStyle());
this.tlpDatePanel.TabIndex = 9;
this.tlpDatePanel.BackColor = this.tlpSearchBar.BackColor;
//
// dtpDateTo
//
//this.dtpDateTo.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.dtpDateTo.TabIndex = 3;
//
// lblDateFromPrompt
//
this.lblDateFromPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblDateFromPrompt.AutoSize = true;
this.lblDateFromPrompt.TabIndex = 0;
this.lblDateFromPrompt.Text = "From";
//
// dtpDateFrom
//
//this.dtpDateFrom.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.dtpDateFrom.TabIndex = 1;
//
// lblDateToPrompt
//
this.lblDateToPrompt.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.lblDateToPrompt.AutoSize = true;
this.lblDateToPrompt.TabIndex = 2;
this.lblDateToPrompt.Text = "to";
//
// crvPurchasesByInvoice
//
this.crvPurchasesByInvoice.ActiveViewIndex = -1;
this.crvPurchasesByInvoice.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.crvPurchasesByInvoice.Cursor = System.Windows.Forms.Cursors.Default;
this.crvPurchasesByInvoice.Dock = System.Windows.Forms.DockStyle.Fill;
this.crvPurchasesByInvoice.TabIndex = 1;
this.crvPurchasesByInvoice.ReuseParameterValuesOnRefresh = true;
this.crvPurchasesByInvoice.ReportRefresh += CrvPurchasesByInvoice_ReportRefresh;
this.SetFontSizes(this.Controls);
}
