private void showAll() { cardDAL DAL = new cardDAL(); List <Card> cardList = new List <Card>(); cardList = DAL.getAllCards(); try { collectionDataGridView.Rows.Clear(); for (int i = 0; i < cardList.Count; i++) { collectionDataGridView.Rows.Add(); collectionDataGridView.Rows[i].Cells["IDColumn"].Value = cardList[i].Id; collectionDataGridView.Rows[i].Cells["NameColumn"].Value = cardList[i].Nome; collectionDataGridView.Rows[i].Cells["QuantityColumn"].Value = cardList[i].Quantidade; collectionDataGridView.Rows[i].Cells["ColorColumn"].Value = cardList[i].Cor; collectionDataGridView.Rows[i].Cells["CardTypeColumn"].Value = cardList[i].Tipo; } } catch (Exception ex) { MessageBox.Show("Error: " + ex); } }
private bool checkCardExistence(Card card) { cardDAL DAL = new cardDAL(); if (DAL.getCardByName(card.Nome) != null) { return(true); } else { return(false); } }
private void confirmRemoveButton_Click(object sender, EventArgs e) { cardDAL DAL = new cardDAL(); if (DAL.getCardByID(_id) != null) { DAL.removeAmountFromID(_id, _amount); this.Close(); } else { MessageBox.Show("This card ID don't exist."); this.Close(); } }
public RemoveConfirmationForm(int id, int amount) { InitializeComponent(); _id = id; _amount = amount; cardDAL DAL = new cardDAL(); if (DAL.getCardByID(_id) == null) { MessageBox.Show("This card ID don't exist."); this.Close(); } else { this.Show(); confirmRemoveLabel.Text = string.Format("REMOVE {0}x ID = {1}?", _amount, DAL.getCardByID(_id).Nome); } }
private void makeSearchButton_Click(object sender, EventArgs e) { #region filters int _id; string _name, _color; string _type; int.TryParse(collectionIDTxtBox.Text, out _id); _name = cardNameTxtBox.Text; _color = ""; _type = ""; CheckBox[] colorBoxes = new CheckBox[] { whiteCheckBox, greenCheckBox, redCheckBox, blackCheckBox, blueCheckBox, colorlessCheckBox }; CheckBox[] typeBoxes = new CheckBox[] { landCheckBox, creatureCheckBox, artifactCheckBox, enchantmentCheckBox, planeswalkerCheckBox, instantCheckBox, spellCheckBox, otherTypeCheckBox }; foreach (CheckBox colorBox in colorBoxes) { if (colorBox.Checked) { switch (colorBox.Name) { case "whiteCheckBox": _color += "W"; break; case "greenCheckBox": _color += "G"; break; case "redCheckBox": _color += "R"; break; case "blackCheckBox": _color += "B"; break; case "blueCheckBox": _color += "U"; break; case "colorlessCheckBox": _color += "C"; break; default: break; } } } // MessageBox.Show(_color); foreach (CheckBox typeBox in typeBoxes) { if (typeBox.Checked) { _type += typeBox.Text + "|"; } } #endregion //MessageBox.Show(buildConnectionStringToSearch(_id, _name, _color, _type)); #region connection cardDAL DAL = new cardDAL(); List <Card> ret = DAL.getAllCardsFiltered(_id, _name, _color, _type); mf.showData(ret); this.Close(); #endregion }
private void AddCard(Card newCard) { cardDAL DAL = new cardDAL(); DAL.addCard(newCard); }