public int checkCodeExist(string codeName) // This method checking of code exist { if (appWeb.checkInternetConnection() == 0) // If there is no internet connection { return(0); } else // If there is internet connection { MySqlConnection sqlConnection = new MySqlConnection( // Creating new object of MySqlConnection databaseConnect.returnConnectionString()); // As a connection give connectionString from DatabaseConnect class string commandString = // This variable story MySql command "SELECT `code_name` FROM `codes` WHERE `code_name` = '" + codeName + "'"; // MySql command try // Hold errors while connecting to database { if (sqlConnection.State == ConnectionState.Closed) // If connection is close { sqlConnection.Open(); // Open it } MySqlCommand sqlCommand = // Creating new object of MySqlCommand new MySqlCommand(commandString, sqlConnection); // As parameters give commandString and sqlConnection MySqlDataAdapter sqlAdapter = new MySqlDataAdapter(sqlCommand); // Create new object of MySqlDataAdapter, as parameters give sqlCommand DataSet ds = new DataSet(); // Create new object of DataSet sqlAdapter.Fill(ds); // File sql result into ds sqlConnection.Close(); // Closing connection int value = ds.Tables[0].Rows.Count; // Creating variable with store value of record returned in row 0 if (value == 0) // If this value is 0 { return(3); // Return 3 } else if (value > 0) // If there are some records { return(2); // Return 2 } } catch (Exception) // If some exception catched { return(1); // Return 1 } return(1); // Return 1 } }
public int insertNewCode(string codeName, string codePassword, string codeAdminPassword, // This method inserting new code string charA, string charB, string charC, string charD, string charE, string charF, // Arguments are char codes string charG, string charH, string charI, string charJ, string charK, string charL, // Arguments are char codes string charM, string charN, string charO, string charP, string charQ, string charR, // Arguments are char codes string charS, string charT, string charU, string charV, string charW, string charX, // Arguments are char codes string charY, string charZ, string char1, string char2, string char3, string char4, // Arguments are char codes string char5, string char6, string char7, string char8, string char9, string char0, // Arguments are char codes string charDOT, string charSPACE) // Arguments are char codes { if (appWeb.checkInternetConnection() == 0) // If there is no internet connection { return(0); // Return 0 } else // If there is internet connection { var control = getData.checkCodeExist(codeName); // Setting value of control with value returne by method with checking about same code exist if (control == 0) // If control value is 0 { return(0); // Returne 0 } else if (control == 1) // If control value is 1 { return(1); // Returne 1 } else if (control == 2) // If control value is 2 { return(2); // Returne 2 } else if (control == 3) // If control value is 3 { MySqlConnection sqlConnection = new MySqlConnection( // Creating new object of MySqlConnection databaseConnect.returnConnectionString()); // As a connection give connectionString returned from DatabaseConnect class string commandString = // This variable store sql question "INSERT INTO `codes`(`code_name`, `code_password`, `code_admin_password`," + // Sql question " `charA`, `charB`, `charC`, `charD`, `charE`, `charF`, `charG`, `charH`," + // Sql question " `charI`, `charJ`, `charK`, `charL`, `charM`, `charN`, `charO`, `charP`," + // Sql question " `charQ`, `charR`, `charS`, `charT`, `charU`, `charV`, `charW`, `charX`," + // Sql question " `charY`, `charZ`, `char1`, `char2`, `char3`, `char4`, `char5`, `char6`," + // Sql question " `char7`, `char8`, `char9`, `char0`, `charDOT`, `charSPACE`) VALUES" + // Sql question " ('" + codeName + "','" + codePassword + "','" + codeAdminPassword + "'," + // Sql question " '" + charA + "','" + charB + "','" + charC + "','" + charD + "'," + // Sql question " '" + charE + "','" + charF + "','" + charG + "','" + charH + "'," + // Sql question " '" + charI + "','" + charJ + "','" + charK + "','" + charL + "'," + // Sql question " '" + charM + "','" + charN + "','" + charO + "','" + charP + "'," + // Sql question " '" + charQ + "','" + charR + "','" + charS + "','" + charT + "'," + // Sql question " '" + charU + "','" + charV + "','" + charW + "','" + charX + "'," + // Sql question " '" + charY + "','" + charZ + "','" + char1 + "','" + char2 + "'," + // Sql question " '" + char3 + "','" + char4 + "','" + char5 + "','" + char6 + "'," + // Sql question " '" + char7 + "','" + char8 + "','" + char9 + "','" + char0 + "'," + // Sql question " '" + charDOT + "','" + charSPACE + "');"; // Sql question try // Hold errors while working in database { if (sqlConnection.State == ConnectionState.Closed) // If connection to database is closed { sqlConnection.Open(); // Open connection } MySqlCommand sqlCommand = // Create new object of MySqlCommand new MySqlCommand(commandString, sqlConnection); // As parameters give commadnString and sqlConnection MySqlDataReader myReader; // Create new object of MySqlDataReader myReader = sqlCommand.ExecuteReader(); // Execute sql command sqlConnection.Close(); // Closing connection return(4); // Return 4 } catch (Exception) // If some errors found { return(3); // Return 3 } } else // Else { return(1); // Return 1 } } }