public static bool Update(Setting setting)
{
try
{
String update_sql = "UPDATE " + TABLE_NAME + " SET NAME=@name ,VALUE=@value WHERE ID=@id";
//Sql command
sql_command = new MySqlCommand();
sql_command.Connection = (MySqlConnection)database.OpenConnection();
sql_command.CommandText = update_sql;
sql_command.Parameters.AddWithValue("@name", setting.name);
sql_command.Parameters.AddWithValue("@value", setting.value);
sql_command.Parameters.AddWithValue("@id", setting.id);
sql_command.Prepare();
//execute command
database.Update(sql_command);
return true;
}
catch (Exception)
{
return false;
}
finally
{
CloseDatabaseConnection();
}
}
public static bool Save(Setting setting)
{
try
{
//sql statement
String insert_sql = "INSERT INTO " + TABLE_NAME + " (NAME,VALUE) values(@name,@value)";
//Sql command
sql_command = new MySqlCommand();
sql_command.CommandText = insert_sql;
sql_command.Connection = (MySqlConnection)database.OpenConnection();
sql_command.Parameters.AddWithValue("@name", setting.name);
sql_command.Parameters.AddWithValue("@value", setting.value);
sql_command.Prepare();
//execute command
database.Insert(sql_command);
setting.id = Convert.ToInt32(sql_command.LastInsertedId);
return true;
}
catch (Exception)
{
return false;
}
finally
{
CloseDatabaseConnection();
}
}
public static bool PopulateTable()
{
try
{
Setting similarity_threshold = new Setting("similarity_threshold", "70");
Setting theme = new Setting("theme", "Dark");
SettingsManager.Save(similarity_threshold);
SettingsManager.Save(theme);
return true;
}
catch (Exception)
{
return false;
}
}
public static Setting GetSetting(SETTINGS settings_name)
{
String setting_name = GetSettingsName(settings_name);
//resultant object
Setting setting = null;
try
{
//sql
String select_sql = "SELECT * FROM " + TABLE_NAME + " WHERE NAME=@name";
//Sql command
sql_command = new MySqlCommand();
sql_command.Connection = (MySqlConnection)database.OpenConnection();
sql_command.CommandText = select_sql;
sql_command.Parameters.AddWithValue("@name", setting_name);
sql_command.Prepare();
//execute command
data_reader = database.Select(sql_command);
//while there are results
if (data_reader.Read())
{
//create object
String value = data_reader.GetString(VALUE);
int id = data_reader.GetInt32(ID);
setting = new Setting(id,setting_name,value);
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
finally
{
//close reader
CloseDatabaseConnection();
}
return setting;
}
public static Setting[] GetAllSettings()
{
//resultant object
List<Setting> settings = new List<Setting>();
try
{
//sql
String select_sql = "SELECT * FROM " + TABLE_NAME;
//Sql command
sql_command = new MySqlCommand();
sql_command.CommandText = select_sql;
sql_command.Prepare();
//execute command
data_reader = database.Select(sql_command);
//while there are results
if (data_reader.Read())
{
//create object
String name = data_reader.GetString(NAME);
String value = data_reader.GetString(VALUE);
int id = data_reader.GetInt32(ID);
Setting setting = new Setting(id,name, value);
//add to list
settings.Add(setting);
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
finally
{
//close reader
CloseDatabaseConnection();
}
return settings.ToArray();
}
private void user_login_Click(object sender, EventArgs e)
{
//ENABLE SOME STUFF
timer1.Start();
progressBar.Visible = true;
//GET USER INPUT
String username = txtbox_username.Text;
String email = email_textbox.Text;
String phone_number = phone_textbox.Text;
String password = txtbox_password.Text;
String confirmed_password = txtbox_confirmedPassword.Text;
String images_folder = txtbox_saveImagesPath.Text;
//IF SOME FIELDS ARE EMPTY
if (String.IsNullOrEmpty(username) || String.IsNullOrEmpty(password) || String.IsNullOrEmpty(confirmed_password))
{
//disable some stuff
timer1.Stop();
progressBar.Enabled = false;
progressBar.Visible = false;
progressBar.Value = 0;
label5.Visible = true;
label5.Text = "Please Enter A Valid Username/Password ";
return;
}
//IF THE PASSWORDS DONT MATCH
if (!password.Equals(confirmed_password))
{
//disable some stuff
timer1.Stop();
progressBar.Enabled = false;
progressBar.Visible = false;
progressBar.Value = 0;
label5.Visible = true;
label5.Text = "Sorry!! Your Password Entries Dont Match ";
return;
}
//CREATE OBJECTS
Setting setting = new Setting("images_folder", images_folder);
Admin admin = new Admin(username, password, email, phone_number, "Admin");
//DROP ALL TABLES IN DATABASE
DatabaseManager.DropTables();
//CREATE NEW TABLES
DatabaseManager.CreateTables();
//POPULATE THEM WITH INITIAL DATA
DatabaseManager.PopulateTables();
//SAVE HIS IMAGES FOLDER AS A SETTING
SettingsManager.Save(setting);
AdminManager.Save(admin);
}