public int iExecuteNonQuery(string FileData, string sSql, int where)
{
int n = 0;
//try
//{
using (SQLiteConnection con = new SQLiteConnection())
{
if (where == 0)
{
con.ConnectionString = @"Data Source=" + FileData + "; Version=3; New=True;";
}
else
{
con.ConnectionString = @"Data Source=" + FileData + "; Version=3; New=False;";
}
con.Open();
using (SQLiteCommand sqlCommand = con.CreateCommand())
{
sqlCommand.CommandText = sSql;
n = sqlCommand.ExecuteNonQuery();
}
con.Close();
}
//}
//catch
//{
// n = 0;
//}
return n;
}
public MainWindow()
{
InitializeComponent();
AddDinValues();
AddPCBValues();
AddRKValues();
// create a new database connection:
sqlite_conn = new SQLiteConnection("Data Source=ICTSupportInventory.db;Version=3;New=False;Compress=True;");
// open the table for connection
sqlite_conn.Open();
// create a new SQL command:
sqlite_cmd = sqlite_conn.CreateCommand();
// create a new table to work with
sqlite_cmd.CommandText = "CREATE TABLE Items (ProductType varchar(100), SerialNumber varchar(100), Location varchar(100), Availability varchar(50), Owner varchar(100), ETR varchar(100), Comments varchar(100));";
// close the connection
sqlite_conn.Close();
// get values to populate all items
PopulateAllLists();
}
// Functie pentru a sterge un capitol din baza de date
public static void delete_capitole(string decizie, string title)
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
string database_title = get_databaseName_tableName.get_databaseName(decizie, "capitole");
string table_title = get_databaseName_tableName.get_tableName(decizie, "capitole");
/* if (decizie == "info") { database_title = "Capitole.db"; table_title = "capitole";}
if (decizie == "mate") { database_title = "Capitole_mate.db"; table_title = "capitole_mate"; }
if (decizie == "bio") { database_title = "Capitole_bio.db"; table_title = "capitole_bio"; }*/
try
{
sqlite_conn = new SQLiteConnection("Data Source=" + database_title + ";Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "delete from " + table_title + " where titlu = @titlu_capitol";
SQLiteParameter parameter = new SQLiteParameter("@titlu_capitol", DbType.String);
parameter.Value = title;
sqlite_cmd.Parameters.Add(parameter);
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Lectia a fost stearsa cu succes!");
sqlite_conn.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DataRow[] drExecute(string FileData, string sSql)
{
DataRow[] datarows = null;
SQLiteDataAdapter dataadapter = null;
DataSet dataset = new DataSet();
DataTable datatable = new DataTable();
try
{
using (SQLiteConnection con = new SQLiteConnection())
{
con.ConnectionString = @"Data Source=" + FileData + "; Version=3; New=False;";
con.Open();
using (SQLiteCommand sqlCommand = con.CreateCommand())
{
dataadapter = new SQLiteDataAdapter(sSql, con);
dataset.Reset();
dataadapter.Fill(dataset);
datatable = dataset.Tables[0];
datarows = datatable.Select();
k = datarows.Count();
}
con.Close();
}
}
catch(Exception ex)
{
// throw ex;
datarows = null;
}
return datarows;
}
/// <summary>
/// OnDelDir delete dir from DB if its there
/// </summary>
/// <param name="args">input arguments</param>
/// <returns><c>true</c> if dir was deleted</returns>
public static bool CheckDupeDelDir(string[] args)
{
Log.Info("DelDir.CheckDupeDelDir");
if (!SkipDupe.CheckSkipDupe(args))
{
Log.Info("DelDir.CheckDupeDelDir");
return true;
}
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
string dbName = ConfigReader.GetConfig("dbDupeDir");
string db = String.Format(CultureInfo.InvariantCulture,
@"Data Source={0};Version=3;New=False;Compress=True;", dbName);
sqlite_conn = new SQLiteConnection(db);
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
string dbCommand = String.Format(CultureInfo.InvariantCulture,
@"DELETE FROM dirDupe WHERE ReleaseName = '{0}'", Global.dupe_name);
Log.InfoFormat("{0}", dbCommand);
sqlite_cmd.CommandText = dbCommand;
sqlite_cmd.ExecuteNonQuery();
sqlite_conn.Close();
Log.Info("DelDir.CheckDupeDelDir");
return true;
}
public static void UnDupeDir(string[] args)
{
Log.Info("UnDupe.UnDupeDir");
Global.undupe_dir = args[1];
Log.InfoFormat("Un Dupe String = '{0}'", Global.undupe_dir);
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
string dbName = ConfigReader.GetConfig("dbDupeDir");
string db = String.Format(CultureInfo.InvariantCulture,
@"Data Source={0};Version=3;New=False;Compress=True;", dbName);
sqlite_conn = new SQLiteConnection(db);
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
string cmdText =
String.Format(CultureInfo.InvariantCulture,
"SELECT COUNT(*) FROM dirDupe WHERE ReleaseName = '{0}'", Global.undupe_dir);
sqlite_cmd.CommandText = cmdText;
sqlite_datareader=sqlite_cmd.ExecuteReader();
int count = 0;
while (sqlite_datareader.Read())
{
count = Int32.Parse(sqlite_datareader.GetValue(0).ToString());
}
sqlite_datareader.Close();
if ( count > 0 )
{
string deleteCommand =
String.Format(CultureInfo.InvariantCulture,
@"DELETE FROM dirDupe WHERE ReleaseName = '{0}'", Global.undupe_dir);
Log.InfoFormat("{0}", deleteCommand);
sqlite_cmd.CommandText = deleteCommand;
sqlite_cmd.ExecuteNonQuery();
Console.WriteLine(
Format.FormatStr1ng(ConfigReader.GetConfig("msgUnDupes_ok"), 0, null));
}
else
{
Console.WriteLine(
Format.FormatStr1ng(ConfigReader.GetConfig("msgUnDupes_fail"), 0, null));
}
sqlite_conn.Close();
Log.Info("UnDupe.UnDupeDir");
}
private void Adaugare_Intrebare_Load(object sender, EventArgs e)
{
btn_home = home.Size;
btn_adauga_intrebarea = adauga_intrebarea.Size;
if (decizie == "info")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Capitole.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM capitole";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String myr = sqlite_datareader.GetString(0);
checkedListBox1.Items.Add(myr);
}
sqlite_conn.Close();
}
if (decizie == "mate")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Capitole_mate.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM capitole_mate";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String myr = sqlite_datareader.GetString(1);
checkedListBox1.Items.Add(myr);
}
sqlite_conn.Close();
}
if (decizie == "bio")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Capitole_bio.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM capitole_bio";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String myr = sqlite_datareader.GetString(1);
checkedListBox1.Items.Add(myr);
}
sqlite_conn.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
// [snip] - As C# is purely object-oriented the following lines must be put into a class:
// We use these three SQLite objects:
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
// create a new database connection:
sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;");
// open the connection:
sqlite_conn.Open();
// create a new SQL command:
sqlite_cmd = sqlite_conn.CreateCommand();
// Let the SQLiteCommand object know our SQL-Query:
sqlite_cmd.CommandText = "CREATE TABLE test (id integer primary key, text varchar(100));";
// Now lets execute the SQL ;D
sqlite_cmd.ExecuteNonQuery();
// Lets insert something into our new table:
sqlite_cmd.CommandText = "INSERT INTO test (id, text) VALUES (1, 'Test Text 1');";
// And execute this again ;D
sqlite_cmd.ExecuteNonQuery();
// ...and inserting another line:
sqlite_cmd.CommandText = "INSERT INTO test (id, text) VALUES (2, 'Test Text 2');";
// And execute this again ;D
sqlite_cmd.ExecuteNonQuery();
// But how do we read something out of our table ?
// First lets build a SQL-Query again:
sqlite_cmd.CommandText = "SELECT * FROM test";
// Now the SQLiteCommand object can give us a DataReader-Object:
sqlite_datareader = sqlite_cmd.ExecuteReader();
// The SQLiteDataReader allows us to run through the result lines:
while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read
{
// Print out the content of the text field:
// System.Console.WriteLine(sqlite_datareader["text"]);
string a = sqlite_datareader.GetString(0);
MessageBox.Show(a);
}
// We are ready, now lets cleanup and close our connection:
sqlite_conn.Close();
}
private void pictureBox2_Click(object sender, EventArgs e)
{
if (nume.Text == "" || prenume.Text == "" || repass.Text == "" || password.Text == "" || username.Text == "")
MessageBox.Show("Trebuie sa completati toate campurile!");
else
if (cross.Visible == true)
MessageBox.Show("Parolele nu corespund!");
else
{
string parola_criptata;
parola_criptata = RC4Class.RC4_Class.RC4(password.Text, "38577af7-379f-421d-ad29-cd1994521704");
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
FileStream fstream;
sqlite_conn = new SQLiteConnection("Data Source=LOGIN.db;Version=3;New=False;Compress=True;");
try
{
sqlite_conn.Open();
byte[] imageBt = null;
fstream = new FileStream(this.image_path.Text, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fstream);
imageBt = br.ReadBytes((int)fstream.Length);
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO utilizatori(nume, prenume, username, password,avatar) " +
"Values('" + nume.Text + "', '" + prenume.Text + "', '" + username.Text + "', '" + parola_criptata + "', @IMG);";
SQLiteParameter parameter = new SQLiteParameter("@IMG", System.Data.DbType.Binary);
SQLiteParameter parameter1 = new SQLiteParameter("@nume", System.Data.DbType.String);
SQLiteParameter parameter2 = new SQLiteParameter("@prenume", System.Data.DbType.String);
SQLiteParameter parameter3 = new SQLiteParameter("@username", System.Data.DbType.String);
SQLiteParameter parameter4 = new SQLiteParameter("@parola", System.Data.DbType.String);
parameter.Value = imageBt;
parameter1.Value = nume.Text;
parameter2.Value = prenume.Text;
parameter3.Value = username.Text;
parameter4.Value = parola_criptata;
sqlite_cmd.Parameters.Add(parameter);
sqlite_cmd.Parameters.Add(parameter1);
sqlite_cmd.Parameters.Add(parameter2);
sqlite_cmd.Parameters.Add(parameter3);
sqlite_cmd.Parameters.Add(parameter4);
sqlite_cmd.ExecuteNonQuery();
sqlite_conn.Close();
MessageBox.Show("Tocmai te-ai inscris in baza noastra de date!");
Login lg = new Login();
this.Hide();
lg.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
//clean history
SQLiteConnection sql_con;
SQLiteCommand sql_cmd;
{
sql_con = new SQLiteConnection("Data Source=History.db;Version=3;New=False;Compress=True;");
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = "delete from mains";
sql_cmd.ExecuteNonQuery();
sql_con.Close();
MessageBox.Show("操作成功！");
}
}
/** private void ButtonYes_Click(object sender, System.Windows.RoutedEventArgs e)
* delete reminder
*/
private void ButtonYes_Click(object sender, System.Windows.RoutedEventArgs e)
{
SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString());
new_con.Open();
if (delete_status == 1)
{
SQLiteCommand get = new SQLiteCommand("DELETE FROM reminder WHERE rid ='" + Convert.ToInt32(id) + "'", new_con);
get.ExecuteNonQuery();
MainWindowStart mainWindow = MainWindowStart.Instance;
mainWindow.mainWindowUpdate();
}
else
{
SQLiteCommand get = new SQLiteCommand("DELETE FROM contact_detail WHERE cid ='" + Convert.ToInt32(id) + "'", new_con);
get.ExecuteNonQuery();
MainWindowStart mainWindow = MainWindowStart.Instance;
mainWindow.mainWindowUpdateContact();
}
new_con.Close();
this.Close();
}
internal void DelMnuUserItem(string user)
{
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = "DELETE from myusers WHERE user='******'";
C.ExecuteNonQuery();
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
}
private void ButtonOk_Click(object sender, RoutedEventArgs e)
{
int index = 0, n = 0;
int[] array = new int[10000];
string firstname = ReplaceApostrophe(TextBoxFirstName.Text);
string lastname = ReplaceApostrophe(TextBoxLastName.Text);
string mail = ReplaceApostrophe(TextBoxMail.Text);
string address = ReplaceApostrophe(TextBoxAddress.Text);
try
{
int number= Convert.ToInt32(TextBoxPhone.Text);
SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString());
new_con.Open();
SQLiteCommand new_cnt = new SQLiteCommand("SELECT cid FROM contact_detail", new_con);
SQLiteDataReader reader;
reader = new_cnt.ExecuteReader();
while (reader.Read())
{
array[index] = Convert.ToInt32(reader[0].ToString());
index++;
}
if (!(index == 0))
{
n = index;
insertionSort(array, n);
index = 0;
while (index < n)
{
if (!(array[index] == index))
break;
index++;
}
}
SQLiteCommand get = new SQLiteCommand("INSERT INTO contact_detail VALUES ('" + index + "', '" + firstname + "', '" + lastname + "', '" + Convert.ToInt32(number) + "', '" + address + "', '" + mail + "','','')", new_con);
get.ExecuteNonQuery();
new_con.Close();
this.Close();
MainWindowStart mainWindow = MainWindowStart.Instance;
mainWindow.mainWindowUpdateContact();
}
catch
{
MessageBox.Show("Phone number is invalid!");
}
}
public static void tbox_to_default(SQLiteConnection sql_con)
{
sql_con.Open();
SQLiteCommand sql_cmd = sql_con.CreateCommand();
string CommandText = "SELECT * FROM settings";
SQLiteDataAdapter DB = new SQLiteDataAdapter(CommandText, sql_con);
GlobalVar.DS.Reset();
DB.Fill(DS);
DataTable DT = DS.Tables[0];
for (int i = 0; i < 16; i++)
{
GlobalVar.defCars[i] = Convert.ToInt32(DT.Rows[i][0]);
GlobalVar.defCoeff[i] = Convert.ToInt32(DT.Rows[i][1]);
GlobalVar.defRebate[i] = Convert.ToInt32(DT.Rows[i][2]);
}
sql_con.Close();
}
public static bool CheckDupeDB(string dbName)
{
Log.Info("SQLiteCheck.CheckDupeDB");
string fileName = ConfigReader.GetConfig(dbName);
if ( File.Exists(fileName) )
{
Log.DebugFormat("DirDupe DB File '{0}/{1}' Is There.", dbName, fileName);
}
else
{
Log.DebugFormat("DirDupe DB File '{0}/{1}' Is Not There. Creating It...", dbName, fileName);
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
string db = String.Format(CultureInfo.InvariantCulture,
@"Data Source={0};Version=3;New=True;Compress=True;", fileName);
sqlite_conn = new SQLiteConnection(db);
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = @"CREATE TABLE dirDupe (
Id integer primary key,
ReleaseTime int(10),
ReleaseDateTime varchar(19),
ReleaseName varchar(256),
Pwd varchar(256),
Section varchar(32),
UserName varchar(64),
GroupName varchar(64),
Wiped integer(1),
Nuked integer(1),
NukeReason varchar(64)
);";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = @"CREATE INDEX DirDupeIndex ON dirDupe (ReleaseName);";
sqlite_cmd.ExecuteNonQuery();
Log.InfoFormat("Created Table dirDupe '{0}/{1}'", dbName, fileName);
sqlite_cmd.CommandText = @"INSERT INTO dirDupe
(ReleaseTime, ReleaseName, Pwd, Section, UserName, GroupName)
VALUES (0, 'ReleaseName', '/test/ReleaseName', 'test', 'jcScripts', 'NoGroup');";
sqlite_cmd.ExecuteNonQuery();
Log.DebugFormat("SELECT * FROM dirDupe =");
sqlite_cmd.CommandText = "SELECT * FROM dirDupe";
sqlite_datareader=sqlite_cmd.ExecuteReader();
// The SQLiteDataReader allows us to run through the result lines:
while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read
{
Log.DebugFormat("{1} {0}", sqlite_datareader["ReleaseName"], sqlite_datareader["Id"] );
}
sqlite_conn.Close();
}
Log.Info("SQLiteCheck.CheckDupeDB");
return true;
}
/** private void ButtonOk_Click(object sender, RoutedEventArgs e)
* update reminder
*/
private void ButtonOk_Click(object sender, RoutedEventArgs e)
{
string date = ReplaceApostrophe(DatePicker1.SelectedDate.Value.ToShortDateString());
string name = ReplaceApostrophe(ReminderName.Text);
string note = ReplaceApostrophe(Note.Text);
string snooze = ReplaceApostrophe(NumericUpDown1.Value.ToString());
string time = ReplaceApostrophe(TimePicker.SelectedTime.Value.ToString());
SQLiteConnection new_up = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString());
new_up.Open();
SQLiteCommand get = new SQLiteCommand("Update reminder set date='" + date + "',name='" + name + "', note='" + note + "',snooze='" + snooze + "',time='" + time + "' where rid='" + Convert.ToInt32(cnt) + "'", new_up);
get.ExecuteNonQuery();
new_up.Close();
this.Close();
MainWindowStart mainWindow = MainWindowStart.Instance;
mainWindow.mainWindowUpdate();
}
private void pictureBox1_Click(object sender, EventArgs e)
{
if(decizie == "info")
{
current_number++;
panel1.Visible = true;
panel2.Visible = true;
panel3.Visible = true;
question.Text = current_number.ToString();
continua.Visible = true;
start.Visible = false;
random_id = rand.Next(0, maximum);
while (search(random_id) == false)
random_id = rand.Next(0, maximum);
passed_questions[current_number] = random_id;
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String string_id = sqlite_datareader.GetString(0);
int id = Int32.Parse(string_id);
String text_intrebare = sqlite_datareader.GetString(1);
String var_1 = sqlite_datareader.GetString(2);
String var_2 = sqlite_datareader.GetString(3);
String var_3 = sqlite_datareader.GetString(4);
String var_corecta = sqlite_datareader.GetString(5);
if (id == random_id)
{
richTextBox1.Text = text_intrebare;
varianta_1.Text = var_1;
varianta_2.Text = var_2;
varianta_3.Text = var_3;
write_answer = var_corecta;
cap_parental = sqlite_datareader.GetString(6);
}
}
sqlite_conn.Close();
}
if(decizie == "mate")
{
current_number++;
panel1.Visible = true;
panel2.Visible = true;
panel3.Visible = true;
question.Text = current_number.ToString();
continua.Visible = true;
start.Visible = false;
random_id = rand.Next(0, maximum);
while (search(random_id) == false)
random_id = rand.Next(0, maximum);
passed_questions[current_number] = random_id;
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari_mate.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari_mate";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String string_id = sqlite_datareader.GetString(0);
int id = Int32.Parse(string_id);
String text_intrebare = sqlite_datareader.GetString(1);
String var_1 = sqlite_datareader.GetString(2);
String var_2 = sqlite_datareader.GetString(3);
String var_3 = sqlite_datareader.GetString(4);
String var_corecta = sqlite_datareader.GetString(5);
if (id == random_id)
{
richTextBox1.Text = text_intrebare;
varianta_1.Text = var_1;
varianta_2.Text = var_2;
varianta_3.Text = var_3;
write_answer = var_corecta;
cap_parental = sqlite_datareader.GetString(6);
}
}
sqlite_conn.Close();
}
if(decizie == "bio")
{
current_number++;
panel1.Visible = true;
panel2.Visible = true;
panel3.Visible = true;
question.Text = current_number.ToString();
continua.Visible = true;
start.Visible = false;
random_id = rand.Next(0, maximum);
while (search(random_id) == false)
random_id = rand.Next(0, maximum);
passed_questions[current_number] = random_id;
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari_bio.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari_bio";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String string_id = sqlite_datareader.GetString(0);
int id = Int32.Parse(string_id);
String text_intrebare = sqlite_datareader.GetString(1);
String var_1 = sqlite_datareader.GetString(2);
String var_2 = sqlite_datareader.GetString(3);
String var_3 = sqlite_datareader.GetString(4);
String var_corecta = sqlite_datareader.GetString(5);
if (id == random_id)
{
richTextBox1.Text = text_intrebare;
varianta_1.Text = var_1;
varianta_2.Text = var_2;
varianta_3.Text = var_3;
write_answer = var_corecta;
}
}
sqlite_conn.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
int temp_rows=0;
String update_value = "";
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
DataTable dt = new DataTable();
// create a new database connection:
sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;New=False;Compress=True;");
// open the connection:
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "DELETE FROM EMPLOYEE;";
sqlite_cmd.ExecuteNonQuery();
dataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit);
for (temp_rows = 0; temp_rows < dataGridView1.Rows.Count-1;temp_rows++)
{
DataGridViewRow dr = dataGridView1.Rows[temp_rows];
DataRow de = (dr.DataBoundItem as DataRowView).Row;
foreach (object obj in de.ItemArray)
{
update_value = update_value +"'"+obj.ToString()+"'" + ",";
}
sqlite_cmd.CommandText = "INSERT INTO EMPLOYEE VALUES(" + update_value.Remove(update_value.Length - 1).Trim() + ");";
sqlite_cmd.ExecuteNonQuery();
update_value = "";
}
MessageBox.Show("DATA UPDATED SUCCESFULLY", "UPDATE", MessageBoxButtons.OK, MessageBoxIcon.Information);
sqlite_conn.Close();
}
/// <summary>
/// update table config channel used and por
/// </summary>
internal void UpdateServerUsedAndPort()
{
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = "UPDATE config SET port='" + MainWindow.Configuration.StConfiguration.Port + "'," +
"server='" + MainWindow.Configuration.StConfiguration.Server + "'";
C.ExecuteNonQuery();
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
}
/// <summary>
/// metodo atualiza table users
/// </summary>
/// <param name="user"></param>
public void UpdateSaved()
{
// delete users and new insert
DeleteAllUser();
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = "INSERT INTO users VALUES('" + MainWindow.Configuration.StConfiguration.Nick + "','" +
MainWindow.Configuration.StConfiguration.Password +"','"+
MainWindow.Configuration.StConfiguration.AuthSsl + "','" +
MainWindow.Configuration.StConfiguration.Owner + "','" +
MainWindow.Configuration.StConfiguration.Port + "','"+
MainWindow.Configuration.StConfiguration.Channel +"')";
C.ExecuteNonQuery();
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
}
private void button1_Click(object sender, EventArgs e)
{
button2.Visible = true;
// We use these three SQLite objects:
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
// create a new database connection:
sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;New=False;Compress=True;");
// open the connection:
sqlite_conn.Open();
// create a new SQL command:
sqlite_cmd = sqlite_conn.CreateCommand();
try
{
// Let the SQLiteCommand object know our SQL-Query:
sqlite_cmd.CommandText = "CREATE TABLE EMPLOYEE (EMP_ID varchar(20) PRIMARY KEY, EMP_NAME varchar(20) NOT NULL, JOB_TITLE varchar(20) NOT NULL);";
// Now lets execute the SQL ;D
//try
sqlite_cmd.ExecuteNonQuery();
}
catch (SQLiteException e1)
{
sqlite_cmd.CommandText = "DELETE FROM EMPLOYEE";
sqlite_cmd.ExecuteNonQuery();
}
finally
{
try
{
// Lets insert something into our new table:
sqlite_cmd.CommandText = "INSERT INTO EMPLOYEE VALUES (2210311146, 'MONISH', 'DBA');";
// And execute this again ;D
sqlite_cmd.ExecuteNonQuery();
// ...and inserting another line:
sqlite_cmd.CommandText = "INSERT INTO EMPLOYEE VALUES (2210311130, 'VARSHA', 'DBA');";
// And execute this again ;D
sqlite_cmd.ExecuteNonQuery();
// But how do we read something out of our table ?
// First lets build a SQL-Query again:
sqlite_cmd.CommandText = "SELECT * FROM EMPLOYEE;";
// Now the SQLiteCommand object can give us a DataReader-Object:
sqlite_datareader = sqlite_cmd.ExecuteReader();
DataTable dt = new DataTable(); //CODE TO DISPLAY DATA ON A GRIDVIEW.
SQLiteDataAdapter adp = new SQLiteDataAdapter(sqlite_cmd);
adp.Fill(dt);
dataGridView1.DataSource = dt;
adp.Update(dt);
sqlite_conn.Close();
}
catch (SQLiteException se)
{
MessageBox.Show((se.ToString()));
}
}
}
/// <summary>
/// retorna o usuario para ser editado ou deletado
/// </summary>
/// <returns></returns>
/// <param name="user">user nick</param>
internal TemplateMyUsersDataBase GetUserEdit(string user)
{
TemplateMyUsersDataBase t = new TemplateMyUsersDataBase();
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = @"SELECT user, password , owner FROM myusers WHERE user ='******'";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
t.User = DataReader["user"].ToString();
t.Password = DataReader["password"].ToString();
t.Owner = DataReader["owner"].ToString();
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
return null;
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
return t;
}
/// <summary>
/// check OnNewDir if dir is a dupe
/// </summary>
/// <param name="args">input arguments</param>
/// <returns><c>true</c> if dir is a dupe</returns>
public static bool CheckDupeNewDir(string[] args)
{
Log.Info("->");
if (!SkipDupe.CheckSkipDupe(args))
{
return false;
}
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
string dbName = ConfigReader.GetConfig("dbDupeDir");
string db = String.Format(CultureInfo.InvariantCulture,
@"Data Source={0};Version=3;New=False;Compress=True;", dbName);
sqlite_conn = new SQLiteConnection(db);
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
string dbCommand = String.Format(CultureInfo.InvariantCulture,
@"SELECT DISTINCT ReleaseDateTime, UserName, ReleaseName FROM dirDupe WHERE ReleaseName = '{0}'", Global.dupe_name);
Log.InfoFormat("{0}", dbCommand);
sqlite_cmd.CommandText = dbCommand;
//sqlite_cmd.CommandText = "SELECT * FROM dirDupe";
sqlite_datareader=sqlite_cmd.ExecuteReader();
bool found = false;
DateTime CurrTime = DateTime.Now;
string skipDateFormat = ConfigReader.GetConfig("skipDateFormat");
while (sqlite_datareader.Read())
{
Global.dupe_creator = sqlite_datareader["UserName"].ToString();
Global.dupe_datetime = sqlite_datareader["ReleaseDateTime"].ToString();
Global.dupe_name = sqlite_datareader["ReleaseName"].ToString();
Global.dupe_tryer = Global.user;
Console.WriteLine(
Format.FormatStr1ng(
ConfigReader.GetConfig("msgDirIsDupe"), 0, null
));
string anounceDirIsDupe = ConfigReader.GetConfig("anounceDirIsDupe");
if ( (anounceDirIsDupe != null) && (anounceDirIsDupe == "true") )
{
Console.WriteLine(
Format.FormatStr1ng(ConfigReader.GetConfig("mircDirIsDupe"), 0, null));
}
Log.InfoFormat("Dir Is A Dupe! It Was Created By {0} On {1}",
sqlite_datareader["UserName"], sqlite_datareader["ReleaseDateTime"]);
found = true;
}
sqlite_datareader.Close();
if ( !found )
{
string what = "(ReleaseTime, ReleaseDateTime, ReleaseName, Pwd, UserName, GroupName)";
string values = String.Format(CultureInfo.InvariantCulture,
"({4}, '{5}', '{0}', '{1}', '{2}', '{3}')",
Global.dupe_name,
Global.dupe_pwd,
Environment.GetEnvironmentVariable("USER"),
Environment.GetEnvironmentVariable("GROUP"),
CurrTime.Ticks,
CurrTime.ToString(skipDateFormat));
string insertCommand =
String.Format(CultureInfo.InvariantCulture,
@"INSERT INTO dirDupe {0} VALUES {1};", what, values);
Log.InfoFormat("{0}", insertCommand);
sqlite_cmd.CommandText = insertCommand;
sqlite_cmd.ExecuteNonQuery();
}
sqlite_conn.Close();
Log.Info("<-");
if ( !found )
return false;
else
return true;
}
/// <summary>
/// update user
/// </summary>
/// <param name="user"></param>
/// <param name="password"></param>
/// <param name="owner"></param>
/// <param name="oldnick"></param>
internal void UpdateUserIn(string user, string password, string owner ,string oldnick)
{
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = "UPDATE myusers SET user ='******',"+
"password='******'," +
"owner='" + owner + "'" +
" WHERE user='******'";
C.ExecuteNonQuery();
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
}
private void continua_Click(object sender, EventArgs e)
{
if (decizie == "info")
{
panel1.Enabled = true;
panel2.Enabled = true;
panel3.Enabled = true;
current_number++;
if (current_number <= number_of_questions)
{
question.Text = current_number.ToString();
random_id = rand.Next(0, maximum);
while (search(random_id) == false)
random_id = rand.Next(0, maximum);
passed_questions[current_number] = random_id;
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String string_id = sqlite_datareader.GetString(0);
int id = Int32.Parse(string_id);
String text_intrebare = sqlite_datareader.GetString(1);
String var_1 = sqlite_datareader.GetString(2);
String var_2 = sqlite_datareader.GetString(3);
String var_3 = sqlite_datareader.GetString(4);
String var_corecta = sqlite_datareader.GetString(5);
if (id == random_id)
{
richTextBox1.Text = text_intrebare;
varianta_1.Text = var_1;
varianta_2.Text = var_2;
varianta_3.Text = var_3;
write_answer = var_corecta;
cap_parental = sqlite_datareader.GetString(6);
}
}
sqlite_conn.Close();
}
else
{
MessageBox.Show("Intrebarile s-au terminat, te rugam sa astepti rezultatul...");
float procentaj;
procentaj = write_questions * 100 / number_of_questions;
Procentaj = procentaj;
Debug.WriteLine("---------------------------");
Debug.WriteLine(write_questions);
Debug.WriteLine("---------------------------");
Debug.WriteLine(procentaj);
MessageBox.Show("Procentrajul tau este de " + procentaj.ToString() + "%");
for (int i = 1; i <= j; i++)
{
// MessageBox.Show(capitole[i].ToString());
down.capitole_revizuit[i] = capitole[i];
}
/*bck inc = new bck();
this.Hide();
inc.ShowDialog();*/
string procent = Procentaj.ToString();
procent = procent + "%";
SQLiteConnection conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
conn = new SQLiteConnection("Data Source=LOGIN.db;Version=3;New=False;Compress=True;");
conn.Open();
sqlite_cmd = conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM utilizatori where username='******'";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
punctaj1 = sqlite_datareader.GetString(5);
punctaj2 = sqlite_datareader.GetString(6);
punctaj3 = sqlite_datareader.GetString(7);
punctaj4 = sqlite_datareader.GetString(8);
punctaj5 = sqlite_datareader.GetString(9);
}
if (punctaj1 == "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct1 ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj2 == "" && punctaj1 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct2 ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj3 == "" && punctaj1 != "" && punctaj2 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct3 ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj4 == "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct4 ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj5 == "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "" && punctaj4 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct5 ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj5 != "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "" && punctaj4 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct1 ='" + punctaj2 + "', pct2 ='" + punctaj3 + "', pct3 ='" + punctaj4 + "', pct4 ='" + punctaj5 + "', pct5 ='" + procent + "'where username ='******'");
sql_command.ExecuteNonQuery();
}
conn.Close();
down rt = new down();
this.Hide();
rt.ShowDialog();
}
}
if(decizie == "mate")
{
panel1.Enabled = true;
panel2.Enabled = true;
panel3.Enabled = true;
current_number++;
if (current_number <= number_of_questions)
{
question.Text = current_number.ToString();
random_id = rand.Next(0, maximum);
while (search(random_id) == false)
random_id = rand.Next(0, maximum);
passed_questions[current_number] = random_id;
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari_mate.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari_mate";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String string_id = sqlite_datareader.GetString(0);
int id = Int32.Parse(string_id);
String text_intrebare = sqlite_datareader.GetString(1);
String var_1 = sqlite_datareader.GetString(2);
String var_2 = sqlite_datareader.GetString(3);
String var_3 = sqlite_datareader.GetString(4);
String var_corecta = sqlite_datareader.GetString(5);
if (id == random_id)
{
richTextBox1.Text = text_intrebare;
varianta_1.Text = var_1;
varianta_2.Text = var_2;
varianta_3.Text = var_3;
write_answer = var_corecta;
cap_parental = sqlite_datareader.GetString(6);
}
}
sqlite_conn.Close();
}
else
{
MessageBox.Show("Intrebarile s-au terminat, te rugam sa astepti rezultatul...");
float procentaj;
procentaj = write_questions * 100 / number_of_questions;
Procentaj = procentaj;
Debug.WriteLine("---------------------------");
Debug.WriteLine(write_questions);
Debug.WriteLine("---------------------------");
Debug.WriteLine(procentaj);
MessageBox.Show("Procentrajul tau este de " + procentaj.ToString() + "%");
for (int i = 1; i <= j; i++)
{
// MessageBox.Show(capitole[i].ToString());
down.capitole_revizuit[i] = capitole[i];
}
/*bck inc = new bck();
this.Hide();
inc.ShowDialog();*/
string procent = Procentaj.ToString();
procent = procent + "%";
SQLiteConnection conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
conn = new SQLiteConnection("Data Source=LOGIN.db;Version=3;New=False;Compress=True;");
conn.Open();
sqlite_cmd = conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM utilizatori where username='******'";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
punctaj1 = sqlite_datareader.GetString(10);
punctaj2 = sqlite_datareader.GetString(11);
punctaj3 = sqlite_datareader.GetString(12);
punctaj4 = sqlite_datareader.GetString(13);
punctaj5 = sqlite_datareader.GetString(14);
}
if (punctaj1 == "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct1_mate ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj2 == "" && punctaj1 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct2_mate ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj3 == "" && punctaj1 != "" && punctaj2 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct3_mate ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj4 == "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct4_mate ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj5 == "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "" && punctaj4 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct5_mate ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj5 != "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "" && punctaj4 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct1_mate ='" + punctaj2 + "', pct2_mate ='" + punctaj3 + "', pct3_mate ='" + punctaj4 + "', pct4_mate ='" + punctaj5 + "', pct5_mate ='" + procent + "'where username ='******'");
sql_command.ExecuteNonQuery();
}
conn.Close();
down rt = new down();
this.Hide();
rt.ShowDialog();
}
}
if (decizie == "bio")
{
panel1.Enabled = true;
panel2.Enabled = true;
panel3.Enabled = true;
current_number++;
if (current_number <= number_of_questions)
{
question.Text = current_number.ToString();
random_id = rand.Next(0, maximum);
while (search(random_id) == false)
random_id = rand.Next(0, maximum);
passed_questions[current_number] = random_id;
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari_bio.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari_bio";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String string_id = sqlite_datareader.GetString(0);
int id = Int32.Parse(string_id);
String text_intrebare = sqlite_datareader.GetString(1);
String var_1 = sqlite_datareader.GetString(2);
String var_2 = sqlite_datareader.GetString(3);
String var_3 = sqlite_datareader.GetString(4);
String var_corecta = sqlite_datareader.GetString(5);
if (id == random_id)
{
richTextBox1.Text = text_intrebare;
varianta_1.Text = var_1;
varianta_2.Text = var_2;
varianta_3.Text = var_3;
write_answer = var_corecta;
cap_parental = sqlite_datareader.GetString(6);
}
}
sqlite_conn.Close();
}
else
{
MessageBox.Show("Intrebarile s-au terminat, te rugam sa astepti rezultatul...");
float procentaj;
procentaj = write_questions * 100 / number_of_questions;
Procentaj = procentaj;
Debug.WriteLine("---------------------------");
Debug.WriteLine(write_questions);
Debug.WriteLine("---------------------------");
Debug.WriteLine(procentaj);
MessageBox.Show("Procentrajul tau este de " + procentaj.ToString() + "%");
for (int i = 1; i <= j; i++)
{
// MessageBox.Show(capitole[i].ToString());
down.capitole_revizuit[i] = capitole[i];
}
/*bck inc = new bck();
this.Hide();
inc.ShowDialog();*/
string procent = Procentaj.ToString();
procent = procent + "%";
SQLiteConnection conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
conn = new SQLiteConnection("Data Source=LOGIN.db;Version=3;New=False;Compress=True;");
conn.Open();
sqlite_cmd = conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM utilizatori where username='******'";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
punctaj1 = sqlite_datareader.GetString(15);
punctaj2 = sqlite_datareader.GetString(16);
punctaj3 = sqlite_datareader.GetString(17);
punctaj4 = sqlite_datareader.GetString(18);
punctaj5 = sqlite_datareader.GetString(19);
}
if (punctaj1 == "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct1_bio ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj2 == "" && punctaj1 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct2_bio ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj3 == "" && punctaj1 != "" && punctaj2 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct3_bio ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj4 == "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct4_bio ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj5 == "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "" && punctaj4 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct5_bio ='" + procent.ToString() + "' where username ='******'");
sql_command.ExecuteNonQuery();
}
if (punctaj5 != "" && punctaj1 != "" && punctaj2 != "" && punctaj3 != "" && punctaj4 != "")
{
SQLiteCommand sql_command;
sql_command = conn.CreateCommand();
sql_command.CommandText = ("update utilizatori set pct1_bio ='" + punctaj2 + "', pct2_bio ='" + punctaj3 + "', pct3_bio ='" + punctaj4 + "', pct4_bio ='" + punctaj5 + "', pct5_bio ='" + procent + "'where username ='******'");
sql_command.ExecuteNonQuery();
}
conn.Close();
down rt = new down();
this.Hide();
rt.ShowDialog();
}
}
}
private void creeaza_Click(object sender, EventArgs e)
{
if (checkBox1.Checked == true && textBox1.Text != null && richTextBox1.Text != null)
{
if(decizie=="info")
{
try
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
sqlite_conn = new SQLiteConnection("Data Source=Capitole.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO capitole(titlu, teorie, id_html) " +
"Values(@titlu, @teorie, @fd)";
SQLiteParameter param1 = new SQLiteParameter("@titlu", DbType.String);
SQLiteParameter param2 = new SQLiteParameter("@teorie", DbType.String);
SQLiteParameter param3 = new SQLiteParameter("@fd", DbType.String);
param1.Value = textBox1.Text;
param2.Value = richTextBox1.Text;
param3.Value = folder_guid.ToString();
sqlite_cmd.Parameters.Add(param1);
sqlite_cmd.Parameters.Add(param2);
sqlite_cmd.Parameters.Add(param3);
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Capitolul a fost adaugat cu succes!");
sqlite_conn.Close();
textBox1.Clear();
richTextBox1.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if(decizie=="mate")
{
try
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
sqlite_conn = new SQLiteConnection("Data Source=Capitole_mate.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO capitole_mate(titlu, teorie, id_html) values (@titlu, @teorie, @fd)";
SQLiteParameter param4 = new SQLiteParameter("@titlu", DbType.String);
SQLiteParameter param5 = new SQLiteParameter("@teorie", DbType.String);
SQLiteParameter param6 = new SQLiteParameter("@fd", DbType.String);
param4.Value = textBox1.Text;
param5.Value = richTextBox1.Text;
param6.Value = folder_guid.ToString();
sqlite_cmd.Parameters.Add(param4);
sqlite_cmd.Parameters.Add(param5);
sqlite_cmd.Parameters.Add(param6);
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Capitolul a fost adaugat cu succes!");
sqlite_conn.Close();
textBox1.Clear();
richTextBox1.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (decizie == "bio")
{
try
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
sqlite_conn = new SQLiteConnection("Data Source=Capitole_bio.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO capitole_bio(titlu, teorie, id_html) " +
"Values(@titlu, @teorie, @fd)";
SQLiteParameter param1 = new SQLiteParameter("@titlu", DbType.String);
SQLiteParameter param2 = new SQLiteParameter("@teorie", DbType.String);
SQLiteParameter param3 = new SQLiteParameter("@fd", DbType.String);
param1.Value = textBox1.Text;
param2.Value = richTextBox1.Text;
param3.Value = folder_guid.ToString();
sqlite_cmd.Parameters.Add(param1);
sqlite_cmd.Parameters.Add(param2);
sqlite_cmd.Parameters.Add(param3);
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Capitolul a fost adaugat cu succes!");
sqlite_conn.Close();
textBox1.Clear();
richTextBox1.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else if (checkBox2.Checked == true && textBox1.Text != null && richTextBox1.Text != null)
{
if (decizie == "info")
{
try
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
sqlite_conn = new SQLiteConnection("Data Source=Subcapitole.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO subcapitole(nume_subcapitol,text_subcapitol,nume_capitol,id_animatie, id_html) " +
"Values(@ns,@ts,@nc,@ida,@idh)";
SQLiteParameter param1 = new SQLiteParameter("@ns", DbType.String);
SQLiteParameter param2 = new SQLiteParameter("@ts", DbType.String);
SQLiteParameter param3 = new SQLiteParameter("@nc", DbType.String);
SQLiteParameter param4 = new SQLiteParameter("@ida", DbType.String);
SQLiteParameter param5 = new SQLiteParameter("@idh", DbType.String);
param1.Value = textBox1.Text;
param2.Value = richTextBox1.Text;
param3.Value = capitol_parental;
param4.Value = cod_guid;
param5.Value = folder_guid.ToString();
sqlite_cmd.Parameters.Add(param1);
sqlite_cmd.Parameters.Add(param2);
sqlite_cmd.Parameters.Add(param3);
sqlite_cmd.Parameters.Add(param4);
sqlite_cmd.Parameters.Add(param5);
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Subcapitolul a fost adaugat cu succes!");
sqlite_conn.Close();
textBox1.Clear();
richTextBox1.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (decizie == "bio")
{
try
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
sqlite_conn = new SQLiteConnection("Data Source=Subcapitole_bio.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO subcapitole_bio(nume_subcapitol,text_subcapitol,nume_capitol,id_animatie, id_html) " +
"Values(@ns,@ts,@nc,@ida,@idh)";
SQLiteParameter param1 = new SQLiteParameter("@ns", DbType.String);
SQLiteParameter param2 = new SQLiteParameter("@ts", DbType.String);
SQLiteParameter param3 = new SQLiteParameter("@nc", DbType.String);
SQLiteParameter param4 = new SQLiteParameter("@ida", DbType.String);
SQLiteParameter param5 = new SQLiteParameter("@idh", DbType.String);
param1.Value = textBox1.Text;
param2.Value = richTextBox1.Text;
param3.Value = capitol_parental;
param4.Value = cod_guid;
param5.Value = folder_guid.ToString();
sqlite_cmd.Parameters.Add(param1);
sqlite_cmd.Parameters.Add(param2);
sqlite_cmd.Parameters.Add(param3);
sqlite_cmd.Parameters.Add(param4);
sqlite_cmd.Parameters.Add(param5);
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Subcapitolul a fost adaugat cu succes!");
sqlite_conn.Close();
textBox1.Clear();
richTextBox1.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (decizie == "mate")
{
try
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
sqlite_conn = new SQLiteConnection("Data Source=Subcapitole_mate.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO subcapitole_mate(nume_subcapitol,text_subcapitol,nume_capitol,id_animatie, id_html) " +
"Values(@ns,@ts,@nc,@ida,@idh)";
SQLiteParameter param1 = new SQLiteParameter("@ns", DbType.String);
SQLiteParameter param2 = new SQLiteParameter("@ts", DbType.String);
SQLiteParameter param3 = new SQLiteParameter("@nc", DbType.String);
SQLiteParameter param4 = new SQLiteParameter("@ida", DbType.String);
SQLiteParameter param5 = new SQLiteParameter("@idh", DbType.String);
param1.Value = textBox1.Text;
param2.Value = richTextBox1.Text;
param3.Value = capitol_parental;
param4.Value = cod_guid;
param5.Value = folder_guid.ToString();
sqlite_cmd.Parameters.Add(param1);
sqlite_cmd.Parameters.Add(param2);
sqlite_cmd.Parameters.Add(param3);
sqlite_cmd.Parameters.Add(param4);
sqlite_cmd.Parameters.Add(param5);
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Subcapitolul a fost adaugat cu succes!");
sqlite_conn.Close();
textBox1.Clear();
richTextBox1.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
MessageBox.Show("Toate campurile trebuie sa fie completate iar un checkBox selectat!");
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString());
new_con.Open();
SQLiteCommand addAr = new SQLiteCommand("Select * from reminder where rid='" + Convert.ToInt32(cnt) + "'", new_con);
SQLiteDataReader reader;
reader = addAr.ExecuteReader();
while (reader.Read())
{
ReminderName.Text = reader[2].ToString();
DatePicker1.Text = reader[1].ToString();
TimePicker.DateTimeText = Convert.ToDateTime(reader[5].ToString()).ToShortTimeString();
Note.Text = reader[3].ToString();
NumericUpDown1.Value = Convert.ToDouble(reader[4].ToString());
}
new_con.Close();
}
private void checkBox2_CheckedChanged(object sender, EventArgs e)
{
adauga_animatie.Visible = true;
var items = checkedListBox1.Items;
richTextBox1.Enabled = true;
if (checkBox2.Checked == true)
{
checkBox1.Checked = false;
label3.Visible = true;
checkedListBox1.Visible = true;
foreach (var item in checkedListBox1.Items.OfType<string>().ToList())
{
checkedListBox1.Items.Remove(item);
}
}
else
{
checkBox2.Checked = false;
label3.Visible = false;
checkedListBox1.Visible = false;
foreach (var item in checkedListBox1.Items.OfType<string>().ToList())
{
checkedListBox1.Items.Remove(item);
}
}
if (decizie == "info")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Capitole.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM capitole";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String myr = sqlite_datareader.GetString(0);
items.Add(myr);
}
sqlite_conn.Close();
}
if (decizie == "mate")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Capitole_mate.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM capitole_mate";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String myr = sqlite_datareader.GetString(1);
items.Add(myr);
}
sqlite_conn.Close();
}
if (decizie == "bio")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Capitole_bio.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM capitole_bio";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
String myr = sqlite_datareader.GetString(1);
items.Add(myr);
}
sqlite_conn.Close();
}
}
private bool verific_numarul(int number_of_questions)
{
int max = 0;
String current_number;
if (decizie == "info")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
current_number = sqlite_datareader.GetString(0);
Debug.WriteLine(current_number);
max = Int32.Parse(current_number);
}
sqlite_conn.Close();
}
else
if(decizie == "bio")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari_bio.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari_bio";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
current_number = sqlite_datareader.GetString(0);
Debug.WriteLine(current_number);
max = Int32.Parse(current_number);
}
sqlite_conn.Close();
}
else
if(decizie == "mate")
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
sqlite_conn = new SQLiteConnection("Data Source=Intrebari_mate.db;Version=3;New=False;Compress=True;");
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM intrebari_mate";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
current_number = sqlite_datareader.GetString(0);
Debug.WriteLine(current_number);
max = Int32.Parse(current_number);
}
sqlite_conn.Close();
}
Debug.WriteLine("---------------------------");
maximum = max;
if (max <= number_of_questions)
return false;
else
return true;
}
/** private void MenuViewContacts_Click(object sender, System.Windows.RoutedEventArgs e)
* view Contacts
*/
public void createUserControlContact()
{
int i = 0;
UserControlExpanderContact[] uc = new UserControlExpanderContact[200];
SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString());
new_con.Open();
SQLiteCommand get = new SQLiteCommand("SELECT * FROM contact_detail ORDER BY firstname ASC LIMIT 0 , 30", new_con);
SQLiteDataReader reader;
reader = get.ExecuteReader();
String header;
while (reader.Read())
{
header = reader[1].ToString() + "\t\t\t" + reader[2].ToString();
uc[i] = new UserControlExpanderContact();
uc[i].setContent(Convert.ToInt32(reader[0].ToString()), reader[2].ToString(), reader[3].ToString(), reader[5].ToString(), reader[4].ToString(), header);
WrapPanel1.Children.Add(uc[i]);
i++;
}
new_con.Close();
}
