/// <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 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;
}
/** public void createUc() - create user controls (display reminders) *
*/
public void createUc()
{
int i = 0;
UserControl1[] uc = new UserControl1[200];
SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString());
new_con.Open();
SQLiteCommand get = new SQLiteCommand("SELECT * FROM reminder LIMIT 0 , 30", new_con);
String header;
SQLiteDataReader reader;
reader = get.ExecuteReader();
while (reader.Read())
{
//data[i,0] = new ArrayList();
string[] str = new string[3];
str[0]=reader[0].ToString();
str[1]=DateTime.Parse(reader[1].ToString()).ToShortDateString();
str[2]=DateTime.Parse(reader[5].ToString()).ToShortTimeString();
reminderList.Add(str);
header = String.Format("{1,-20} {0,5}", reader[2].ToString(), DateTime.Parse(reader[1].ToString()).ToShortDateString());
uc[i] = new UserControl1();
uc[i].setContent(Convert.ToInt16(reader[0].ToString()), reader[3].ToString(), reader[4].ToString(), DateTime.Parse(reader[5].ToString()).ToShortTimeString() , header);
WrapPanel1.Children.Add(uc[i]);
i++;
}
reminderlistarray = reminderList.ToArray();
}
// 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 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();
}
public SQLiteCommand(String pCmdText, SQLiteConnection pConn)
{
if (pConn == null)
throw new ArgumentNullException();
CommandText = pCmdText;
Connection = pConn;
}
private void btnSubmit_Click(object sender, EventArgs e)
{
// Let the SQLiteCommand object know our SQL-Query:
sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;Compress=True;");
sqlite_conn.Open();
//UPDATE People set stxtFname=@stxtFname,stxtLname = @stxtLName,
SQLiteCommand sqlite_cmd = new SQLiteCommand(@"Update ProgramConfig Set sPassword = @password, sEmail = @email, sSchoolName = @name,
sAddress = @address, sCity = @city, sState = @state, sZip = @zip, sLatitude = @latitude,
sLongitude = @longitude, sImageFile = @ImageFile Where id = 1", sqlite_conn);
sqlite_cmd.Parameters.Add("@password", SqlDbType.Text).Value = parentForm.school.password;
sqlite_cmd.Parameters.Add("@email", SqlDbType.Text).Value = parentForm.school.email;
sqlite_cmd.Parameters.Add("@name", SqlDbType.Text).Value = parentForm.school.name;
sqlite_cmd.Parameters.Add("@address", SqlDbType.Text).Value = parentForm.school.address;
sqlite_cmd.Parameters.Add("@city", SqlDbType.Text).Value = parentForm.school.city;
sqlite_cmd.Parameters.Add("@state", SqlDbType.Text).Value = parentForm.school.state;
sqlite_cmd.Parameters.Add("@zip", SqlDbType.Text).Value = parentForm.school.zip;
sqlite_cmd.Parameters.Add("@latitude", SqlDbType.Text).Value = parentForm.school.latitude;
sqlite_cmd.Parameters.Add("@longitude", SqlDbType.Text).Value = parentForm.school.longitude;
sqlite_cmd.Parameters.Add("@ImageFile", SqlDbType.Text).Value = parentForm.school.ImageFile;
sqlite_cmd.CommandType = CommandType.Text;
try
{
int i = sqlite_cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
parentForm.RefreshLogo(parentForm.school.ImageFile);
this.Close();
}
public SearchForUser(int iRequestType, PeopleManagement parent, SQLiteConnection sql_conn)
{
InitializeComponent();
sqlite_conn = sql_conn;
LoadUserSelect();
frmParent = parent;
}
internal SQLiteTransaction(SQLiteConnection pConn)
{
mpConn = pConn;
if (pConn == null)
throw new ArgumentNullException();
mpConn.sqlite.exec("begin transaction");
}
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;
}
/// <summary>
/// metodo cria ou acessa banco de dados sqlite carregar configs
/// </summary>
public void CreateOrAccessDataBase()
{
try
{
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (!ExistDataBase())
{
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3;New=True;Compress=True");
Connection.Open();
string[] config = new string[] {string.Empty, string.Empty, string.Empty};
// create table(s)
// config => contais configurations
config[0] = @"create table config (port interger(4)" +
@",server varchar(30) primary key" +
@",language varchar(20))";
// channels => contais channels
config[1] = @"create table channels (channel varchar(30) primary key)";
// user(s) => my login accont user(s) used login auth SSL
config[2] = @"create table users (nick varchar(20) primary key" +
@",password varchar(50))";
foreach (string i in config)
{
SQLiteCommand c = new SQLiteCommand(i, Connection);
c.ExecuteNonQuery();
}
IsDatabase = true;
}
else
{
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
Connection.Open();
IsDatabase = true;
// select database to list all channels and servers
C = Connection.CreateCommand();
C.CommandText = @"SELECT channel FROM channels";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
MainWindow.Configuration.Channels.Add(new TemplateChannels
{
Channels = DataReader["channel"].ToString()
});
}
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.ToString());
IsDatabase = false;
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
}
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();
}
public override IDbConnection CreateConn(string connString)
{
SQLiteConnection conn= new SQLiteConnection(connString);
// SQLiteConnection conn = new SQLiteConnection();
// SQLiteConnectionStringBuilder connsb = new SQLiteConnectionStringBuilder();
// connsb.DataSource = dbName;
// connsb.Password = "";
// conn.ConnectionString = connsb.ToString();
return conn;
}
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);
}
}
}
public CppSqlGenerationVisitor(Settings sett, Graph rooms)
{
m_settings = sett;
m_graph = rooms;
//System.Diagnostics.Process proc = new System.Diagnostics.Process();
//proc.StartInfo.FileName = "sqlite.exe";
m_conn = new SQLiteConnection("Data Source=adventure.hac;Version=3;New=True;Compress=True");
m_conn.Open();
m_cmd = m_conn.CreateCommand();
m_propid = -1;
m_statpropid = -1;
m_respid = 0;
}
private static void InitConnection()
{
Console.WriteLine(Application.UserAppDataPath);
string dataPath = Application.UserAppDataPath + "\\" + "data";
if (Directory.Exists(dataPath) && File.Exists(dataPath + "\\database.db"))
{
sqlConnection =
new SQLiteConnection(
"Data Source=" + dataPath + "\\database.db" +
";Version=3;New=False;Compress=True;UTF8Encoding=True;");
sqlConnection.Open();
sqlCommand = sqlConnection.CreateCommand();
}
else
{
if (!Directory.Exists(dataPath))
{
Directory.CreateDirectory(dataPath);
ClearFileUnderPath(dataPath);
}
sqlConnection =
new SQLiteConnection(
"Data Source=" + dataPath + "\\database.db" +
";Version=3;New=True;Compress=True;UTF8Encoding=True;");
sqlConnection.Open();
ClearFileUnderPath(dataPath);
sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandText = "create table movie(fileLocation nvarchar primary key)";
sqlCommand.ExecuteNonQuery();
sqlCommand.CommandText = "create table music(fileLocation nvarchar primary key)";
sqlCommand.ExecuteNonQuery();
sqlCommand.CommandText = "create table file(fileLocation nvarchar primary key)";
sqlCommand.ExecuteNonQuery();
}
//string sql = "select count(*) as c from sqlite_master where type ='table' and name ='movie'";
//sqlCommand.CommandText =
// "create table movie(fileLocation nvarchar primary key)";
//sqlCommand.ExecuteNonQuery();
//sqlCommand.CommandText = "create table music(fileLocation nvarchar primary key)";
//sqlCommand.ExecuteNonQuery();
//sqlCommand.CommandText = "create table file(fileLocation nvarchar primary key)";
//sqlCommand.ExecuteNonQuery();
}
public Setup1(frmMain Main)
{
parentForm = Main;
this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath);
InitializeComponent();
sqlite_conn = sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;Compress=True;");
txtPassword.Text = parentForm.school.password;
txtPassConfirm.Text = parentForm.school.password;
txtAdminEmail.Text= parentForm.school.email;
txtSchoolName.Text= parentForm.school.name;
txtAddress.Text= parentForm.school.address;
txtCity.Text= parentForm.school.city;
txtState.Text= parentForm.school.state;
txtZip.Text= parentForm.school.zip;
}
/// <summary>
/// Simplify the creation of a SQLite command object by allowing
/// a CommandType and Command Text to be provided
/// </summary>
/// <remarks>
/// e.g.:
/// SQLiteCommand command = CreateCommand(conn, CommandType.Text, "Select * from Customers");
/// </remarks>
/// <param name="connection">A valid SQLiteConnection object</param>
/// <param name="commandType">CommandType (TableDirect, Text)</param>
/// <param name="commandText">CommandText</param>
/// <returns>A valid SQLiteCommand object</returns>
public static SQLiteCommand CreateCommand(SQLiteConnection connection, CommandType commandType, string commandText )
{
if( connection == null ) throw new ArgumentNullException( "connection" );
if( commandType == CommandType.StoredProcedure ) throw new ArgumentException("Stored Procedures are not supported.");
// If we receive parameter values, we need to figure out where they go
if ((commandText == null) && (commandText.Length<= 0)) throw new ArgumentNullException( "Command Text" );
// Create a SQLiteCommand
SQLiteCommand cmd = new SQLiteCommand(commandText, connection );
cmd.CommandType = CommandType.Text ;
return cmd;
}
/// <summary>Uses an existing connection to a SQLite database created as a catalog store.
/// Assumes the schema has already been populated.</summary>
///
/// <param name="conn"></param>
internal SqliteCatalogStore(SqliteCatalogStoreManager mgr, SQLiteConnection conn, String uri)
{
if (conn == null) {
throw new ArgumentNullException("conn");
}
_mgr = mgr;
//Use this connection for the constructing thread
//It's reasonable to assume this thread will be doing most
//of the work w/ the store
_conn = conn;
_uri = uri;
_connStr = conn.ConnectionString;
_itemCache = new Hashtable();
}
public void OpenDb()
{
try
{
// create a new database connection:
sqlite_conn = new SQLiteConnection("Data Source="
+ Environment.CurrentDirectory +
"\\data\\droplist.db;Version=3;New=False;Compress=False;");
// open the connection:
sqlite_conn.Open();
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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("操作成功！");
}
}
public Reports(frmMain Main)
{
parentForm = Main;
sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;Compress=True;");
aTimer = new System.Timers.Timer(60000);
aTimer.Start();
aTimer.Elapsed += OnTimedEvent;
try
{
// open the connection:
sqlite_conn.Open();
}
catch
{
Console.WriteLine("Database is unavailable for reports");
bEnabled = false;
}
}
/** 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();
}
// Functie pentru a adauga o animatie noua in baza de date
public static void animatie_noua(string decizie, string subc_title, string guid_nou)
{
string database_title = get_databaseName_tableName.get_databaseName(decizie, "subcapitole");
string table_title = get_databaseName_tableName.get_tableName(decizie, "subcapitole");
/* if (decizie == "info") { database_title = "Subcapitole.db"; table_title = "subcapitole"; }
if (decizie == "mate") { database_title = "Subcapitole_mate.db"; table_title = "subcapitole_mate"; }
if (decizie == "bio") { database_title = "Subcapitole_bio.db"; table_title = "subcapitole_bio"; }*/
try
{
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
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 = ("update "+ table_title +" set id_animatie ='" + guid_nou + "' where nume_subcapitol ='" + subc_title + "'");
sqlite_cmd.ExecuteNonQuery();
MessageBox.Show("Animatia a fost adaugata cu succes.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
static FmMain()
{
connection = new SQLiteConnection();
command = new SQLiteCommand();
String cs = "";
cs = cs + String.Format("Data Source={0};", IDE.LibPath + "ASEExpertVS2005.CodeKeeper.db");
cs = cs + String.Format("Version=3;");
bool isNew = !File.Exists(IDE.LibPath + "ASEExpertVS2005.CodeKeeper.db");
if (isNew)
cs = cs + String.Format("New=True;");
cs = cs + String.Format("UTF8Encoding=True;");
cs = cs + String.Format(";");
connection.ConnectionString = cs;
try
{
connection.Open();
command.Connection = connection;
if (isNew)
{
ExecuteNonQuery("CREATE TABLE groups (parentid INTEGER, name TEXT)");
ExecuteNonQuery("CREATE TABLE code (groupid INTEGER, name TEXT, code TEXT, langid INTEGER)");
ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'General')");
ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'Forms')");
ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'IO')");
ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'NET')");
}
}
catch (Exception exc)
{
IDE.Debug("", exc);
}
}
public SecteurDTO(SQLiteConnection sql_con)
{
this.sql_con = sql_con;
DS = new DataSet();
DT = new DataTable();
}
private static void DisposeConnection()
{
sqlConnection.Close();
sqlConnection = null;
}
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;
}
