| public undoCinderellaPairFromFGID ( int fgID ) : void | ||
| fgID | int | Fairy Godmother's ID |
| return | void | |
private void pairButton_Click(object sender, EventArgs e)
{
DataGridViewSelectedRowCollection personalShopper = psDGVPairing.SelectedRows;
DataGridViewSelectedRowCollection cinderella = cinderellaDGVPairing.SelectedRows;
if ((psDGVPairing.SelectedRows.Count != 1) || (cinderellaDGVPairing.SelectedRows.Count != 1))
{
MessageBox.Show("You must select someone.");
return;
}
SQL_Queries dbMagic = new SQL_Queries();
//bool isPaired = false;
//string query = dbMagic.getCinderellaStats(Convert.ToInt32(cinderella[0].Cells[0].Value));
if (dbMagic.CinderellaCurrentStatus(Convert.ToInt32(cinderella[0].Cells[0].Value)) == 3)
{
dbMagic.undoFGPairFromCinderellaID(Convert.ToInt32(cinderella[0].Cells[0].Value));
}
if (dbMagic.CinderellaCurrentStatus(Convert.ToInt32(cinderella[0].Cells[0].Value)) != 3)
{
dbMagic.setCinderellaStatus(cinderella[0].Cells[0].Value.ToString(), 3);
}
if (dbMagic.FGCurrentStatus(Convert.ToInt32(personalShopper[0].Cells[0].Value)) == 2)
{
dbMagic.undoCinderellaPairFromFGID(Convert.ToInt32(personalShopper[0].Cells[0].Value));
}
if (dbMagic.FGCurrentStatus(Convert.ToInt32(personalShopper[0].Cells[0].Value)) != 2)
{
dbMagic.setFGStatus(personalShopper[0].Cells[0].Value.ToString(), 2);
}
dbMagic.pairCinderella(Convert.ToInt32(cinderella[0].Cells[0].Value),Convert.ToInt32(personalShopper[0].Cells[0].Value));
/*
string query = dbMagic.getFgPaired(Convert.ToInt32(Convert.ToInt32(cinderella[0].Cells[0].Value)));
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
SqlCommand command = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader.FieldCount < 1)
{
break;
}
dbMagic.setFGStatus(reader.GetInt32(0).ToString(), 4);
//Thread.Sleep(1000);
}
string query2 = dbMagic.getCinderellaPaired(Convert.ToInt32(personalShopper[0].Cells[0].Value));
SqlCommand command2 = new SqlCommand(query2, conn);
reader.Close();
dbMagic.setFGStatus(personalShopper[0].Cells[0].Value.ToString(), 4);
dbMagic.setCinderellaStatus(Convert.ToInt32(cinderella[0].Cells[0].Value).ToString(), 2);
dbMagic.clearCinderellaFairyGodmotherID(Convert.ToInt32(cinderella[0].Cells[0].Value));
//Thread.Sleep(1000);
SqlDataReader reader2 = command2.ExecuteReader();
while (reader2.Read())
{
if (reader2.FieldCount < 1)
{
break;
}
int id = reader2.GetInt32(0);
dbMagic.setCinderellaStatus(id.ToString(), 2);
dbMagic.clearCinderellaFairyGodmotherID(id);
// Thread.Sleep(1000);
}
reader2.Close();
dbMagic.pairCinderella(Convert.ToInt32(cinderella[0].Cells[0].Value), Convert.ToInt32(personalShopper[0].Cells[0].Value));
dbMagic.setCinderellaStatus(cinderella[0].Cells[0].Value.ToString(), 3);
dbMagic.setFGStatus(personalShopper[0].Cells[0].Value.ToString(), 2);
// Thread.Sleep(1000);
conn.Close();*/
MessageBox.Show("Pairing Complete");
guiupdate();
}
