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();
}
