private void BtnAdd_Click(object sender, EventArgs e) { MasterForm master = (this.Parent.Parent as MasterForm); try { //Input data gathered here to improve readability and centralize any processing //that needs to be done before insertion string firstName = this.txtFirstNameInput.Text.Trim(); string lastName = this.txtLastNameInput.Text.Trim(); string phoneNumber = this.mtxtPhoneNumberInput.Text.Trim(); int collectorTypeID = (int)this.cbxTypeInput.SelectedValue; string status = ""; if (String.IsNullOrEmpty(status = DBCollector.Validate(firstName, lastName, phoneNumber))) { object insertedID = DBCollector.InsertCollector(collectorTypeID, firstName, lastName, phoneNumber); if (insertedID != null) { status = "Collector " + firstName + " " + lastName + " has been added." + Environment.NewLine; List <int> bookTagValues = DBControlHelper.GetValuesFromCheckedControls(this.tlpBookTagsSelection); if (bookTagValues.Count > 0 && DBCollector.InsertInterests((int)insertedID, 1, bookTagValues)) { status += "Book interests added." + Environment.NewLine; } List <int> mapTagValues = DBControlHelper.GetValuesFromCheckedControls(this.tlpMapTagsSelection); if (mapTagValues.Count > 0 && DBCollector.InsertInterests((int)insertedID, 2, mapTagValues)) { status += "Map interests added." + Environment.NewLine; } List <int> periodicalTagValues = DBControlHelper.GetValuesFromCheckedControls(this.tlpPeriodicalTagsSelection); if (periodicalTagValues.Count > 0 && DBCollector.InsertInterests((int)insertedID, 3, periodicalTagValues)) { status += "Periodical interests added." + Environment.NewLine; } } } master.SetStatus(status); } catch (Exception ex) { master.SetStatus("Error! Add failed: " + ex.Message); } }
private void BtnUpdate_Click(object sender, EventArgs e) { MasterForm master = (this.Parent.Parent as MasterForm); try { //Input data gathered here to improve readability and centralize any processing //that needs to be done before insertion int collectorID = (int)nudCollectorId.Value; string firstName = txtFirstName.Text.Trim(); string lastName = txtLastName.Text.Trim(); int collectorTypeID = (int)cbxType.SelectedValue; string phoneNumber = mtxtPhoneNumber.Text.Trim(); string status = ""; if (String.IsNullOrEmpty(status = DBCollector.Validate(firstName, lastName, phoneNumber))) { if (DBCollector.UpdateCollector(collectorID, collectorTypeID, firstName, lastName, phoneNumber)) { status = "Collector " + firstName + " " + lastName + " has been saved." + Environment.NewLine; } } if (DBCollector.UpdateInterests(collectorID, 1, DBControlHelper.GetValuesFromCheckedControls(this.tlpTagsBookSelection))) { status += "Book interests have been updated." + Environment.NewLine; } if (DBCollector.UpdateInterests(collectorID, 2, DBControlHelper.GetValuesFromCheckedControls(this.tlpTagsMapSelection))) { status += "Map interests have been updated." + Environment.NewLine; } if (DBCollector.UpdateInterests(collectorID, 3, DBControlHelper.GetValuesFromCheckedControls(this.tlpTagsPeriodicalSelection))) { status += "Periodical interests have been updated." + Environment.NewLine; } master.SetStatus(status); } catch (Exception ex) { master.SetStatus("Error! Save failed: " + ex.Message); } }
private void BtnAdd_Click(object sender, EventArgs e) { MasterForm master = (this.Parent.Parent as MasterForm); try { //Input data gathered here to improve readability and centralize any processing //that needs to be done before insertion decimal price = this.nudPrice.Value; string publisher = this.txtPublisher.Text.Trim(); string title = this.txtTitle.Text.Trim(); string authorFirst = this.txtAuthorFirst.Text.Trim(); string authorLast = this.txtAuthorLast.Text.Trim(); string location = this.txtLocation.Text.Trim(); string companyName = this.txtCompanyName.Text.Trim(); DateTime publishDate = this.dtpPublishDate.Value; int year = (int)this.nudYear.Value; int genreID = (int)this.cbxGenre.SelectedValue; int conditionID = this.tkbCondition.Value; int quantity = (int)this.nudQuantity.Value; int edition = (int)this.nudEdition.Value; object insertedID = null; string status = ""; switch (this.cbxItemType.SelectedValue) { case 1: if (String.IsNullOrEmpty(status = DBBook.Validate(price, title, authorFirst, authorLast, publisher, publishDate))) { insertedID = DBBook.InsertBook(title, price, edition, genreID, authorFirst, authorLast, publisher, publishDate, conditionID, quantity); if (insertedID != null) { status = "Book " + title + " has been added successfully"; } } break; case 2: if (String.IsNullOrEmpty(status = DBMap.Validate(price, location, year, publisher))) { insertedID = DBMap.InsertMap(location, price, edition, publisher, year, conditionID, quantity); if (insertedID != null) { status = "Map " + location + " has been added successfully"; } } break; case 3: if (String.IsNullOrEmpty(status = DBPeriodical.Validate(price, title, companyName, publishDate))) { insertedID = DBPeriodical.InsertPeriodical(title, price, edition, companyName, genreID, publishDate, conditionID, quantity); if (insertedID != null) { status = "Periodical " + title + " has been added successfully"; } } break; } if (insertedID != null) { List <int> tagValues = DBControlHelper.GetValuesFromCheckedControls(this.tlpTagSelection); if (tagValues.Count > 0 && DBItem.InsertItemTags((int)insertedID, tagValues)) { status += Environment.NewLine + "Item tags added."; } } master.SetStatus(status); } catch (Exception ex) { master.SetStatus("Error! Failed to add item: " + ex.Message); } }
private void BtnUpdate_Click(object sender, EventArgs e) { MasterForm master = (this.Parent.Parent as MasterForm); try { //Input data gathered here to improve readability and centralize any processing //that needs to be done before insertion int itemID = (int)this.nudItemID.Value; decimal price = this.nudPrice.Value; string publisher = this.txtPublisher.Text.Trim(); string title = this.txtTitle.Text.Trim(); string authorFirst = this.txtAuthorFirst.Text.Trim(); string authorLast = this.txtAuthorLast.Text.Trim(); string location = this.txtLocation.Text.Trim(); string companyName = this.txtCompanyName.Text.Trim(); DateTime publishDate = this.dtpPublishDate.Value; int year = (int)this.nudYear.Value; int genreID = (int)this.cbxGenre.SelectedValue; int conditionID = this.tkbCondition.Value; int quantity = (int)this.nudQuantity.Value; int edition = (int)this.nudEdition.Value; decimal discountPrice = this.nudDiscountPrice.Value; DateTime discountFrom = this.dtpDiscountFrom.Value; DateTime discountTo = this.dtpDiscountTo.Value; string status = ""; switch (cbxItemType.SelectedValue) { case 1: if (String.IsNullOrEmpty(status = DBBook.Validate(price, title, authorFirst, authorLast, publisher, publishDate))) { if (DBBook.UpdateBook(itemID, title, price, edition, genreID, authorFirst, authorLast, publisher, publishDate, conditionID, quantity)) { status = "Book " + title + " has been saved." + Environment.NewLine; } } break; case 2: if (String.IsNullOrEmpty(status = DBMap.Validate(price, location, year, publisher))) { if (DBMap.UpdateMap(itemID, location, price, edition, publisher, year, conditionID, quantity)) { status = "Map " + location + " has been saved." + Environment.NewLine; } } break; case 3: if (String.IsNullOrEmpty(status = DBPeriodical.Validate(price, title, companyName, publishDate))) { if (DBPeriodical.UpdatePeriodical(itemID, title, price, edition, companyName, genreID, publishDate, conditionID, quantity)) { status = "Periodical " + title + " has been saved." + Environment.NewLine; } } break; } if (quantity < Cart.Invoice.GetQuantityBeingSold(itemID)) { status += "Quantity cannot be less than the amount of the item currently being sold" + Environment.NewLine; } else { for (var i = 0; i < Cart.Invoice.Transactions.Count; i++) { if (Cart.Invoice.Transactions[i].ItemID == itemID) { Cart.Invoice.Transactions[i].SetItemStock(quantity); } } } if (DBItem.UpdateItemTags(itemID, DBControlHelper.GetValuesFromCheckedControls(this.tlpTagSelection))) { status += "Item tags have been saved." + Environment.NewLine; } if (this.chkSetupDiscountTitle.Checked) { string discountError = DBItemDiscount.Validate(discountPrice, discountFrom, discountTo); if (String.IsNullOrEmpty(discountError)) { if (DBItem.SaveDiscount(itemID, discountPrice, discountFrom, discountTo)) { status += "Discount has been saved." + Environment.NewLine; } } else { status += discountError; } } master.SetStatus(status); } catch (Exception ex) { master.SetStatus("Error! Update failed: " + ex.Message); } }
private void ShowItems() { if (rbnBook.Checked) { try { BindingList <DBBook> filteredBooks = DBControlHelper.GetFilteredItems(this.books, this.txtSearch.Text, DBControlHelper.GetValuesFromCheckedControls(this.tlpTagSelection)); this.dgvItems.DataSource = filteredBooks; this.cbxSelectedItem.DataSource = filteredBooks; //Setup combobox this.cbxSelectedItem.DisplayMember = "ComboBoxDisplay"; this.cbxSelectedItem.ValueMember = "BookID"; //Setup datagridview this.dgvItems.Columns["BookID"].HeaderText = "Book ID"; this.dgvItems.Columns["GenreName"].HeaderText = "Genre"; this.dgvItems.Columns["PublishDate"].HeaderText = "Publish Date"; this.dgvItems.Columns["ConditionType"].HeaderText = "Condition"; this.dgvItems.Columns["ComboBoxDisplay"].Visible = false; this.dgvItems.Columns["ShowDiscount"].Visible = false; this.lblSearchByTitlePrompt.Text = "Search by Title:"; } catch (Exception ex) { (this.Parent.Parent as MasterForm).SetStatus("Failed to show books: " + ex.Message); } } else if (rbnMap.Checked) { try { BindingList <DBMap> filteredMaps = DBControlHelper.GetFilteredItems(this.maps, this.txtSearch.Text, DBControlHelper.GetValuesFromCheckedControls(this.tlpTagSelection)); this.dgvItems.DataSource = filteredMaps; this.cbxSelectedItem.DataSource = filteredMaps; //Setup combobox this.cbxSelectedItem.DisplayMember = "ComboBoxDisplay"; this.cbxSelectedItem.ValueMember = "MapID"; //Setup datagridview this.dgvItems.Columns["MapID"].HeaderText = "Map ID"; this.dgvItems.Columns["ConditionType"].HeaderText = "Condition"; this.dgvItems.Columns["ComboBoxDisplay"].Visible = false; this.dgvItems.Columns["ShowDiscount"].Visible = false; this.lblSearchByTitlePrompt.Text = "Search by Location:"; } catch (Exception ex) { (this.Parent.Parent as MasterForm).SetStatus("Failed to show maps: " + ex.Message); } } else if (rbnPeriodical.Checked) { try { BindingList <DBPeriodical> filteredPeriodicals = DBControlHelper.GetFilteredItems(this.periodicals, this.txtSearch.Text, DBControlHelper.GetValuesFromCheckedControls(this.tlpTagSelection)); this.dgvItems.DataSource = filteredPeriodicals; this.cbxSelectedItem.DataSource = filteredPeriodicals; //Setup datagridview this.dgvItems.Columns["PeriodicalID"].HeaderText = "Periodical ID"; this.dgvItems.Columns["ConditionType"].HeaderText = "Condition"; this.dgvItems.Columns["GenreName"].HeaderText = "Genre"; this.dgvItems.Columns["CompanyName"].HeaderText = "Company"; this.dgvItems.Columns["PublishDate"].HeaderText = "Publish Date"; this.dgvItems.Columns["ComboBoxDisplay"].Visible = false; this.dgvItems.Columns["ShowDiscount"].Visible = false; this.lblSearchByTitlePrompt.Text = "Search by Title:"; //Setup combobox this.cbxSelectedItem.DisplayMember = "ComboBoxDisplay"; this.cbxSelectedItem.ValueMember = "PeriodicalID"; } catch (Exception ex) { (this.Parent.Parent as MasterForm).SetStatus("Failed to show periodicals: " + ex.Message); } } }