public void AddStudent() { switch (gameState) { case -1: return; case 0: ItemStruct getItem = new ItemStruct(); Form2 addItem = new Form2(gameState); if (addItem.ShowDialog() == DialogResult.OK) { getItem = addItem.itmcapsule; ++totalitems; getItem.id = totalitems; string insertinto = (itinsert + "( '" + getItem.objecttype + "' , '" + getItem.weirdness + "' , '" + getItem.ability + "' , '" + getItem.name + "' )"); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(insertinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); ItemData.Add(getItem); isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } break; case 1: ReceiptStruct getReceipt = new ReceiptStruct(); Form2 addReceipt = new Form2(gameState); if (addReceipt.ShowDialog() == DialogResult.OK) { getReceipt = addReceipt.rcpcapsule; ++totalreceipts; getReceipt.id = totalreceipts; string insertinto = (rcpinsert + "( '" + getReceipt.type + "' , '" + getReceipt.name + "' )"); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(insertinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); ReceiptData.Add(getReceipt); isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } break; case 2: AccountStruct getAccount = new AccountStruct(); Form2 addEntry = new Form2(gameState); if (addEntry.ShowDialog() == DialogResult.OK) { getAccount = addEntry.acccapsule; ++totalaccounts; getAccount.id = totalaccounts; string insertinto = (accinsert + "( '" + getAccount.email + "' , '" + getAccount.password + "' )"); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(insertinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); AccountData.Add(getAccount); isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } break; default: return; } }
public void EditStudent() { if (gameState == -1) { return; } int editat = -1; for (int index = 0; index < Tables[gameState].Count; ++index) { if (Tables[gameState][index].SelectedIndex != -1) { editat = Tables[gameState][index].SelectedIndex; break; } } if (editat != -1) { switch (gameState) { case 0: ItemStruct getItem = new ItemStruct(); Form2 EditItem = new Form2(ItemData[editat], gameState); if (EditItem.ShowDialog() == DialogResult.OK) { getItem = EditItem.itmcapsule; getItem.id = editat + 1; string editinto = (itupdate + "object_type = '" + getItem.objecttype + "' , weirdness = '" + getItem.weirdness + "' , ability = '" + getItem.ability + "' , name = '" + getItem.name + "' where id = '" + getItem.id + "'"); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(editinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); ItemData[editat] = getItem; isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); isadding = false; } } break; case 1: ReceiptStruct getReceipt = new ReceiptStruct(); Form2 EditReceipt = new Form2(ReceiptData[editat], gameState); if (EditReceipt.ShowDialog() == DialogResult.OK) { getReceipt = EditReceipt.rcpcapsule; getReceipt.id = editat + 1; string editinto = (rcpupdate + "type = '" + getReceipt.type + "' , name = '" + getReceipt.name + "' where id = '" + getReceipt.id + "'"); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(editinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); ReceiptData[editat] = getReceipt; isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); isadding = false; } } break; case 2: AccountStruct getAccount = new AccountStruct(); Form2 EditAccount = new Form2(AccountData[editat], gameState); if (EditAccount.ShowDialog() == DialogResult.OK) { getAccount = EditAccount.acccapsule; getAccount.id = editat + 1; string editinto = (accupdate + "email = '" + getAccount.email + "' , password = '******' where id = '" + getAccount.id + "'"); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(editinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); AccountData[editat] = getAccount; isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); isadding = false; } } break; } } else { MessageBox.Show("Seleccione una fila para editar"); } }
private void DeleteStudent() { if (gameState == -1) { return; } int deleteat = -1; for (int index = 0; index < Tables[gameState].Count; ++index) { if (Tables[gameState][index].SelectedIndex != -1) { deleteat = Tables[gameState][index].SelectedIndex; break; } } if (deleteat != -1) { switch (gameState) { case -1: return; case 0: if (MessageBox.Show("Estas seguro que quieres borrar el item " + ItemData[deleteat].name + "?", "Advertencia", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { ItemStruct todelete = new ItemStruct(); todelete = ItemData[deleteat]; string deleteinto = (itdelete + " '" + todelete.name + "' "); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(deleteinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); ItemData.RemoveAt(deleteat); isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } break; case 1: if (MessageBox.Show("Estas seguro que quieres borrar la receta " + ReceiptData[deleteat].name + "?", "Advertencia", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { ReceiptStruct todelete = new ReceiptStruct(); todelete = ReceiptData[deleteat]; string deleteinto = (rcpdelete + " '" + todelete.name + "' "); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(deleteinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); ReceiptData.RemoveAt(deleteat); isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } break; case 2: if (MessageBox.Show("Estas seguro que quieres borrar la cuenta de " + AccountData[deleteat].email + "?", "Advertencia", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { AccountStruct todelete = new AccountStruct(); todelete = AccountData[deleteat]; string deleteinto = (accdelete + " '" + todelete.email + "' "); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(deleteinto, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); AccountData.RemoveAt(deleteat); isadding = true; UpdateData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } break; } } else { MessageBox.Show("Seleccione una fila para eliminar"); } }
private void MySQLFetch() { List <ItemStruct> ItemList = new List <ItemStruct>(); List <ReceiptStruct> ReceiptList = new List <ReceiptStruct>(); List <AccountStruct> AccountList = new List <AccountStruct>(); MySqlConnection conn = new MySqlConnection(builder.ToString()); MySqlCommand cmd = new MySqlCommand(itselect, conn); try { conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ItemStruct data = new ItemStruct(); data.id = int.Parse(reader.GetString("id")); data.objecttype = int.Parse(reader.GetString("object_type")); data.weirdness = int.Parse(reader.GetString("weirdness")); data.ability = int.Parse(reader.GetString("ability")); data.name = reader.GetString("name"); ItemList.Add(data); if (totalitems < data.id) { totalitems = data.id; } } reader.Close(); cmd = new MySqlCommand(rcpselect, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { ReceiptStruct data = new ReceiptStruct(); data.id = int.Parse(reader.GetString("id")); data.type = int.Parse(reader.GetString("type")); data.name = reader.GetString("name"); ReceiptList.Add(data); if (totalreceipts < data.id) { totalreceipts = data.id; } } reader.Close(); cmd = new MySqlCommand(accselect, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { AccountStruct data = new AccountStruct(); data.id = int.Parse(reader.GetString("id")); data.email = reader.GetString("email"); data.password = reader.GetString("password"); AccountList.Add(data); if (totalaccounts < data.id) { totalaccounts = data.id; } } reader.Close(); ItemData = ItemList; ReceiptData = ReceiptList; AccountData = AccountList; conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } isadding = true; UpdateData(); }