/// <summary>
/// Gets a list of all the conditions in the database
/// </summary>
/// <returns>A list of all the conditions in the database</returns>
public static BindingList <DBCondition> GetConditions()
{
BindingList <DBCondition> conditions = new BindingList <DBCondition>();
string query = "SELECT * FROM conditions";
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())
{
DBCondition temp = new DBCondition((int)reader["conditionID"], (string)reader["conditionType"]);
conditions.Add(temp);
}
}
return(conditions);
}
public AddItemScreen(Screen backScreen) : base("Add Item", backScreen, 1, 2)
{
//DB Classes
this.conditions = DBCondition.GetConditions();
this.tags = DBTag.GetTags();
this.tlpForm = new System.Windows.Forms.TableLayoutPanel();
this.lblItemTypePrompt = new System.Windows.Forms.Label();
this.cbxItemType = new System.Windows.Forms.ComboBox();
this.lblQuantityPrompt = new System.Windows.Forms.Label();
this.lblPricePrompt = new System.Windows.Forms.Label();
this.lblConditionPrompt = new System.Windows.Forms.Label();
this.lblPublishDatePrompt = new System.Windows.Forms.Label();
this.lblFormTitle = new System.Windows.Forms.Label();
this.nudQuantity = new System.Windows.Forms.NumericUpDown();
this.nudPrice = new System.Windows.Forms.NumericUpDown();
this.tkbCondition = new System.Windows.Forms.TrackBar();
this.tlpConditionPanel = new System.Windows.Forms.TableLayoutPanel();
this.lblMinCondition = new System.Windows.Forms.Label();
this.lblMaxCondition = new System.Windows.Forms.Label();
this.lblSelectedCondition = new System.Windows.Forms.Label();
this.dtpPublishDate = new System.Windows.Forms.DateTimePicker();
this.tlpTags = new System.Windows.Forms.TableLayoutPanel();
this.lblTagsPrompt = new System.Windows.Forms.Label();
this.tlpTagSelection = new System.Windows.Forms.TableLayoutPanel();
this.btnAdd = new System.Windows.Forms.Button();
this.nudEdition = new NumericUpDown();
this.lblEditionPrompt = new Label();
this.ColumnCount = 1;
this.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));
this.Controls.Add(this.tlpForm, 0, 0);
this.Controls.Add(this.btnAdd, 0, 1);
this.Dock = System.Windows.Forms.DockStyle.Fill;
this.RowCount = 2;
this.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));
this.RowStyles.Add(new System.Windows.Forms.RowStyle());
this.TabIndex = 0;
this.ParentChanged += AddItemScreen_ParentChanged;
//
// tlpForm
//
this.tlpForm.ColumnCount = 7;
this.tlpForm.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 22.52252F));
this.tlpForm.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(SizeType.AutoSize));
this.tlpForm.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 20F));
this.tlpForm.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 5F));
this.tlpForm.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.AutoSize));
this.tlpForm.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 20F));
this.tlpForm.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 22.52252F));
this.tlpForm.Controls.Add(this.lblPublishDatePrompt, 4, 5);
this.tlpForm.Controls.Add(this.lblConditionPrompt, 1, 6);
this.tlpForm.Controls.Add(this.lblPricePrompt, 1, 3);
this.tlpForm.Controls.Add(this.lblQuantityPrompt, 1, 2);
this.tlpForm.Controls.Add(this.lblItemTypePrompt, 1, 1);
this.tlpForm.Controls.Add(this.cbxItemType, 2, 1);
this.tlpForm.Controls.Add(this.lblFormTitle, 0, 0);
this.tlpForm.SetColumnSpan(this.lblFormTitle, 7);
this.tlpForm.Controls.Add(this.nudQuantity, 2, 2);
this.tlpForm.Controls.Add(this.nudPrice, 2, 3);
this.tlpForm.Controls.Add(this.tlpConditionPanel, 2, 6);
this.tlpForm.SetColumnSpan(this.tlpConditionPanel, 4);
this.tlpForm.Controls.Add(this.dtpPublishDate, 5, 5);
this.tlpForm.Controls.Add(this.tlpTags, 1, 7);
this.tlpForm.Controls.Add(this.nudEdition, 2, 4);
this.tlpForm.Controls.Add(this.lblEditionPrompt, 1, 4);
this.tlpForm.Dock = System.Windows.Forms.DockStyle.Fill;
this.tlpForm.RowCount = 8;
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 10F));
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 10F));
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 10F));
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 10F));
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 10F));
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 10F));
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.AutoSize));
this.tlpForm.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 30F));
this.tlpForm.TabIndex = 0;
this.tlpForm.BackColor = System.Drawing.Color.White;
//Book
this.lblTitlePrompt = new System.Windows.Forms.Label();
this.lblTitlePrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblTitlePrompt.AutoSize = true;
this.lblTitlePrompt.TabIndex = 6;
this.lblTitlePrompt.Text = "Title:";
this.lblAuthorFirstPrompt = new System.Windows.Forms.Label();
this.lblAuthorFirstPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblAuthorFirstPrompt.AutoSize = true;
this.lblAuthorFirstPrompt.TabIndex = 7;
this.lblAuthorFirstPrompt.Text = "Author First:";
this.lblAuthorLastPrompt = new System.Windows.Forms.Label();
this.lblAuthorLastPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblAuthorLastPrompt.AutoSize = true;
this.lblAuthorLastPrompt.TabIndex = 7;
this.lblAuthorLastPrompt.Text = "Author Last:";
this.lblPublisherPrompt = new System.Windows.Forms.Label();
this.lblPublisherPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblPublisherPrompt.AutoSize = true;
this.lblPublisherPrompt.TabIndex = 8;
this.lblPublisherPrompt.Text = "Publisher:";
this.lblGenrePrompt = new System.Windows.Forms.Label();
this.lblGenrePrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblGenrePrompt.AutoSize = true;
this.lblGenrePrompt.TabIndex = 9;
this.lblGenrePrompt.Text = "Genre:";
this.txtTitle = new System.Windows.Forms.TextBox();
this.txtTitle.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.txtTitle.TabIndex = 13;
this.txtTitle.MaxLength = DBControlHelper.MaximumTitleLength;
this.txtAuthorFirst = new System.Windows.Forms.TextBox();
this.txtAuthorFirst.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.txtAuthorFirst.TabIndex = 14;
this.txtAuthorFirst.MaxLength = DBControlHelper.MaximumFirstNameLength;
this.txtAuthorLast = new System.Windows.Forms.TextBox();
this.txtAuthorLast.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.txtAuthorLast.TabIndex = 14;
this.txtAuthorLast.MaxLength = DBControlHelper.MaximumLastNameLength;
this.txtPublisher = new System.Windows.Forms.TextBox();
this.txtPublisher.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.txtPublisher.TabIndex = 15;
this.txtPublisher.MaxLength = DBControlHelper.MaximumPublisherLength;
this.cbxGenre = new System.Windows.Forms.ComboBox();
this.cbxGenre.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.cbxGenre.FormattingEnabled = true;
this.cbxGenre.TabIndex = 16;
this.cbxGenre.DataSource = DBGenre.getGenres();
this.cbxGenre.DisplayMember = "Name";
this.cbxGenre.ValueMember = "ID";
this.cbxGenre.DropDownStyle = ComboBoxStyle.DropDownList;
this.tlpForm.Controls.Add(this.txtTitle, 5, 1);
this.tlpForm.Controls.Add(this.txtAuthorFirst, 5, 2);
this.tlpForm.Controls.Add(this.txtAuthorLast, 5, 3);
this.tlpForm.Controls.Add(this.txtPublisher, 5, 4);
this.tlpForm.Controls.Add(this.cbxGenre, 2, 5);
this.tlpForm.Controls.Add(this.lblGenrePrompt, 1, 5);
this.tlpForm.Controls.Add(this.lblPublisherPrompt, 4, 4);
this.tlpForm.Controls.Add(this.lblAuthorFirstPrompt, 4, 2);
this.tlpForm.Controls.Add(this.lblAuthorLastPrompt, 4, 3);
this.tlpForm.Controls.Add(this.lblTitlePrompt, 4, 1);
//Map
this.lblLocationPrompt = new Label();
this.lblLocationPrompt.AutoSize = true;
this.lblLocationPrompt.Text = "Location:";
this.lblLocationPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblLocationPrompt.Visible = false;
this.txtLocation = new TextBox();
this.txtLocation.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.txtLocation.Visible = false;
this.txtLocation.MaxLength = DBControlHelper.MaximumLocationLength;
this.lblYearPrompt = new Label();
this.lblYearPrompt.AutoSize = true;
this.lblYearPrompt.Text = "Year:";
this.lblYearPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblYearPrompt.Visible = false;
this.nudYear = new NumericUpDown();
this.nudYear.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.nudYear.Visible = false;
this.nudYear.Minimum = 1200;
this.nudYear.Maximum = DateTime.Now.Year;
this.tlpForm.Controls.Add(this.lblLocationPrompt, 4, 1);
this.tlpForm.Controls.Add(this.txtLocation, 5, 1);
this.tlpForm.Controls.Add(this.lblYearPrompt, 4, 2);
this.tlpForm.Controls.Add(this.nudYear, 5, 2);
//Periodical
this.lblCompanyNamePrompt = new Label();
this.lblCompanyNamePrompt.AutoSize = true;
this.lblCompanyNamePrompt.Text = "Company Name:";
this.lblCompanyNamePrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblCompanyNamePrompt.Visible = false;
this.txtCompanyName = new TextBox();
this.txtCompanyName.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.txtCompanyName.Visible = false;
this.txtCompanyName.MaxLength = DBControlHelper.MaximumCompanyNameLength;
this.tlpForm.Controls.Add(this.lblCompanyNamePrompt, 4, 1);
this.tlpForm.Controls.Add(this.txtCompanyName, 5, 1);
//lblEditionPrompt
this.lblEditionPrompt.Text = "Edition:";
this.lblEditionPrompt.Anchor = AnchorStyles.Right;
this.lblEditionPrompt.AutoSize = true;
//nudEdition
this.nudEdition.Value = 1;
this.nudEdition.Anchor = AnchorStyles.Left | AnchorStyles.Right;
//
// lblItemTypePrompt
//
this.lblItemTypePrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblItemTypePrompt.AutoSize = true;
this.lblItemTypePrompt.TabIndex = 0;
this.lblItemTypePrompt.Text = "Type:";
//
// cbxItemType
//
this.cbxItemType.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.cbxItemType.FormattingEnabled = true;
this.cbxItemType.TabIndex = 1;
this.cbxItemType.DataSource = DBItemType.GetItemTypes();
this.cbxItemType.ValueMember = "ID";
this.cbxItemType.DisplayMember = "Name";
this.cbxItemType.DropDownStyle = ComboBoxStyle.DropDownList;
this.cbxItemType.SelectedIndexChanged += CbxItemType_SelectedIndexChanged;
//
// lblQuantityPrompt
//
this.lblQuantityPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblQuantityPrompt.AutoSize = true;
this.lblQuantityPrompt.TabIndex = 2;
this.lblQuantityPrompt.Text = "Quantity:";
//
// lblPricePrompt
//
this.lblPricePrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblPricePrompt.AutoSize = true;
this.lblPricePrompt.TabIndex = 3;
this.lblPricePrompt.Text = "Price:";
//
// lblConditionPrompt
//
this.lblConditionPrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblConditionPrompt.AutoSize = true;
this.lblConditionPrompt.TabIndex = 4;
this.lblConditionPrompt.Text = "Condition:";
//
// lblPublishDatePrompt
//
this.lblPublishDatePrompt.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.lblPublishDatePrompt.AutoSize = true;
this.lblPublishDatePrompt.TabIndex = 5;
this.lblPublishDatePrompt.Text = "Publish Date:";
//
// lblFormTitle
//
this.lblFormTitle.Anchor = System.Windows.Forms.AnchorStyles.Left | AnchorStyles.Right;
this.lblFormTitle.TabIndex = 10;
this.lblFormTitle.Text = "Basic Information";
this.lblFormTitle.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.lblFormTitle.BackColor = Screen.PrimaryColor;
//
// nudQuantity
//
this.nudQuantity.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.nudQuantity.TabIndex = 11;
//
// nudPrice
//
this.nudPrice.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.nudPrice.DecimalPlaces = 2;
this.nudPrice.TabIndex = 12;
this.nudPrice.ThousandsSeparator = true;
//
// tkbCondition
//
this.tkbCondition.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.tkbCondition.TabIndex = 17;
this.tkbCondition.ValueChanged += TkbCondition_ValueChanged;
this.tkbCondition.Minimum = 1;
this.tkbCondition.Maximum = this.conditions.Count;
this.tkbCondition.Value = (int)Math.Round((double)((this.conditions.Count - 1) / 2));
//
// tlpConditionPanel
//
this.tlpConditionPanel.ColumnCount = 3;
this.tlpConditionPanel.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 33.33333F));
this.tlpConditionPanel.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 33.33333F));
this.tlpConditionPanel.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 33.33333F));
this.tlpConditionPanel.Controls.Add(this.tkbCondition, 0, 1);
this.tlpConditionPanel.Controls.Add(this.lblMinCondition, 0, 2);
this.tlpConditionPanel.Controls.Add(this.lblMaxCondition, 2, 2);
this.tlpConditionPanel.Controls.Add(this.lblSelectedCondition, 0, 0);
this.tlpConditionPanel.SetColumnSpan(this.tkbCondition, 3);
this.tlpConditionPanel.SetColumnSpan(this.lblSelectedCondition, 3);
this.tlpConditionPanel.Dock = System.Windows.Forms.DockStyle.Fill;
this.tlpConditionPanel.RowCount = 3;
this.tlpConditionPanel.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 50F));
this.tlpConditionPanel.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 50F));
this.tlpConditionPanel.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.AutoSize));
this.tlpConditionPanel.TabIndex = 18;
this.tlpConditionPanel.AutoSize = true;
//
// lblMaxCondition
//
this.lblMinCondition.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.lblMinCondition.AutoSize = true;
this.lblMinCondition.TabIndex = 18;
this.lblMinCondition.Text = this.conditions.First().Type;
this.lblMinCondition.TextAlign = System.Drawing.ContentAlignment.TopLeft;
//
// lblMinCondition
//
this.lblMaxCondition.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.lblMaxCondition.AutoSize = true;
this.lblMaxCondition.TabIndex = 19;
this.lblMaxCondition.Text = this.conditions.Last().Type;
this.lblMaxCondition.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// lblSelectedCondition
//
this.lblSelectedCondition.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.lblSelectedCondition.AutoSize = true;
this.tlpConditionPanel.SetColumnSpan(this.lblSelectedCondition, 3);
this.lblSelectedCondition.TabIndex = 20;
this.lblSelectedCondition.Text = this.conditions[tkbCondition.Value - 1].Type;
this.lblSelectedCondition.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
//
// dtpPublishDate
//
this.dtpPublishDate.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.dtpPublishDate.TabIndex = 19;
//
// tlpTags
//
this.tlpTags.ColumnCount = 1;
this.tlpForm.SetColumnSpan(this.tlpTags, 5);
this.tlpTags.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));
this.tlpTags.Controls.Add(this.lblTagsPrompt, 0, 0);
this.tlpTags.Controls.Add(this.tlpTagSelection, 0, 1);
this.tlpTags.Dock = System.Windows.Forms.DockStyle.Fill;
this.tlpTags.RowCount = 2;
this.tlpTags.RowStyles.Add(new System.Windows.Forms.RowStyle());
this.tlpTags.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));
this.tlpTags.TabIndex = 20;
this.tlpTags.BackColor = Screen.PrimaryColor;
this.tlpTags.Margin = new Padding(0, 5, 0, 15);
//
// lblTagsPrompt
//
this.lblTagsPrompt.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));
this.lblTagsPrompt.AutoSize = true;
this.lblTagsPrompt.TabIndex = 0;
this.lblTagsPrompt.Text = "Tags";
this.lblTagsPrompt.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
//
// pnlTagSelection
//
this.tlpTagSelection.AutoScroll = true;
this.tlpTagSelection.Dock = System.Windows.Forms.DockStyle.Fill;
this.tlpTagSelection.TabIndex = 1;
this.tlpTagSelection.BackColor = System.Drawing.Color.White;
this.tlpTagSelection.ColumnCount = 4;
this.tlpTagSelection.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));
this.tlpTagSelection.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));
this.tlpTagSelection.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));
this.tlpTagSelection.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));
this.tlpTagSelection.HorizontalScroll.Enabled = false;
DBControlHelper.PopulateWithControls <DBTag, CheckBox>(this.tlpTagSelection, DBTag.GetTags(), "Description", "ID");
//
// btnAdd
//
this.btnAdd.Anchor = System.Windows.Forms.AnchorStyles.None;
this.btnAdd.AutoSize = true;
this.btnAdd.Size = new System.Drawing.Size(200, 32);
this.btnAdd.TabIndex = 1;
this.btnAdd.Text = "Add";
this.btnAdd.UseVisualStyleBackColor = true;
this.btnAdd.BackColor = DefaultBackColor;
this.btnAdd.Click += BtnAdd_Click;
this.SetFontSizes(this.Controls);
}