void view2(List <object[]> hash, out List <Dictionary <string, object> > list, string tablename)
{
sqlconnect.sqlconnect conn;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
list = conn.view2(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
}
internal void deletefromdb(Hashtable hash, string tablename)
{
sqlconnect.sqlconnect conn;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
conn.delete(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
}
internal void deletefromdb(Hashtable hash, string tablename)
{
sqlconnect.sqlconnect conn;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
conn.delete(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
}
internal int GetCountdb(Hashtable hash, string tablename)
{
sqlconnect.sqlconnect conn;
int count = 0;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
count = conn.Count(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
return count;
}
internal int GetCountdb(Hashtable hash, string tablename)
{
sqlconnect.sqlconnect conn;
int count = 0;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
count = conn.Count(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
return(count);
}
internal void insertbulk(Hashtable[] hash, string tablename)
{
if (this.InvokeRequired)
{
deg_insertbulk bulk = new deg_insertbulk(insertbulk);
this.Invoke(bulk, new object[] { hash, tablename });
}
else
{
sqlconnect.sqlconnect conn;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
conn.insertBulk(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
}
}
internal void insertbulk(Hashtable[] hash, string tablename)
{
if (this.InvokeRequired)
{
deg_insertbulk bulk = new deg_insertbulk(insertbulk);
this.Invoke(bulk,new object[]{hash,tablename});
}
else
{
sqlconnect.sqlconnect conn;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
conn.insertBulk(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
}
}
void view2(List<object[]> hash, out List<Dictionary<string, object>> list, string tablename)
{
sqlconnect.sqlconnect conn;
using (TransactionScope ts = new TransactionScope())
{
conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed");
list = conn.view2(tablename, hash);
conn.close_dbConnection();
ts.Complete();
}
}
