public List <string[][]> getMovies()
{
connection.Open();
List <string[][]> movies = new List <string[][]>();
string[][] movie = new string[2][];
using (SQLiteCommand command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM Movie";
using (SQLiteDataReader reader = command.ExecuteReader())
{
int count = 0;
while (reader.Read())
{
movie[0][count] = reader.GetInt32(0).ToString();
movie[1][count] = reader.GetString(1);
movies.Add(movie);
count++;
}
}
}
connection.Close();
return(movies);
}
public static UserAccess AuthenticateUser(string username, string password)
{
UserAccess access = UserAccess.ANYONE;
try
{
SQLiteDataReader reader = ExecuteQuery("SELECT * FROM users WHERE username='******'");
if (reader.HasRows)
{
if (reader.Read())
{
if (reader.GetString(1).Equals(password))
{
return(UserAccessAttr.GetByAccess(reader.GetInt32(2)));
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(access);
}
public ObservableCollection <SGClassWrapper> GetAllStaticGestureClasses()
{
var gestures = new ObservableCollection <SGClassWrapper>();
string sql = "SELECT id, name, gesture_json, sample_instance_json FROM StaticGestureClasses";
using (var connection = new SQLiteConnection(_connString))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
//gestures.Add(new StaticGestureClassWrapper()
//{
// Id = reader.GetInt32(0),
// Name = reader.GetString(1),
// Gesture = JsonConvert.DeserializeObject<StaticGestureClass>(reader.GetString(2)),
// SampleInstance = JsonConvert.DeserializeObject<StaticGestureInstance>(reader.GetString(3))
//});
var currGest = new SGClassWrapper()
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Gesture = JsonConvert.DeserializeObject <SGClass>(reader.GetString(2)),
SampleInstance = JsonConvert.DeserializeObject <SGInstance>(reader.GetString(3))
};
gestures.Add(currGest);
}
}
}
}
return(gestures);
}
public static List <BonusMove> getAllBonusMoves()
{
List <BonusMove> bonusMoves = new List <BonusMove>();
String text = $"SELECT {BONUS_MOVE_TABLE_NAME}.id, {BONUS_MOVE_TABLE_NAME}.sum, {BONUS_MOVE_TABLE_NAME}.bonusType, {BONUS_MOVE_TABLE_NAME}.date, " +
$"{USERS_TABLE_NAME}.firstName, {USERS_TABLE_NAME}.secondName, " +
$"{USERS_TABLE_NAME}.phone, {BONUS_MOVE_TABLE_NAME}.moveType from {BONUS_MOVE_TABLE_NAME} LEFT JOIN {USERS_TABLE_NAME} " +
$"ON {BONUS_MOVE_TABLE_NAME}.user_id={USERS_TABLE_NAME}.id;";
using (SQLiteConnection conn = getConnection())
{
conn.Open();
SQLiteCommand cmd = createComand(text, conn);
try
{
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
String firstName = reader.IsDBNull(4) ? null : reader.GetString(4);
String lastName = reader.IsDBNull(5) ? null : reader.GetString(5);
String phone = reader.IsDBNull(6) ? null : reader.GetString(6);
BonusMove bonusMove = new BonusMove(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), firstName, lastName, phone, reader.GetDateTime(3), reader.GetInt32(7));
bonusMoves.Add(bonusMove);
}
}
}
}
catch (SQLiteException ex)
{
Console.WriteLine(ex.Message);
}
}
return(bonusMoves);
}
// The user profile page
public ActionResult Index()
{
if (Session["LoggedUserID"] == null)
{
Logging.Log("User profile page", Logging.AccessType.Anonymous);
return(RedirectToAction("Index", "Login"));
}
User user = null;
var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SQLiteConnection"].ConnectionString;
using (var m_dbConnection = new SQLiteConnection(connectionString))
{
m_dbConnection.Open();
SQLiteCommand command = new SQLiteCommand("SELECT * FROM tblusers WHERE id = @userid", m_dbConnection);
command.Parameters.AddWithValue("@userid", int.Parse(Session["LoggedUserID"].ToString()));
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
// adding messages to the list
user = new User();
user.ID = int.Parse(AntiXssEncoder.HtmlEncode(reader.GetInt32(0).ToString(), true));
user.Username = AntiXssEncoder.HtmlEncode(reader.GetString(1).Trim(), true);
user.FirstName = AntiXssEncoder.HtmlEncode(reader.GetString(3).Trim(), true);
user.LastName = AntiXssEncoder.HtmlEncode(reader.GetString(4).Trim(), true);
user.Email = AntiXssEncoder.HtmlEncode(reader.GetString(5).Trim(), true);
user.Phone = (!reader.IsDBNull(6)) ? AntiXssEncoder.HtmlEncode(reader.GetString(6).Trim(), true) : string.Empty;
}
}
}
}
Logging.Log("User profile page", Logging.AccessType.Valid);
return(View(user));
}
public static Candle GetLast(string instrumentID)
{
var command = new SQLiteCommand("SELECT * FROM candle WHERE instrumentid=@InstrumentID order by candletime desc limit 1", DALUtil.Connection);
command.Parameters.AddWithValue("@InstrumentID", instrumentID);
SQLiteDataReader reader = command.ExecuteReader();
if (!reader.Read())
{
return(null);
}
var candle = new Candle();
candle.InstrumentID = reader.GetString(0);
candle.TradingDay = reader.GetDateTime(1);
candle.CandleTime = reader.GetDateTime(2);
candle.Open = DALUtil.GetDouble(reader[3]);
candle.Close = DALUtil.GetDouble(reader[4]);
candle.High = DALUtil.GetDouble(reader[5]);
candle.Low = DALUtil.GetDouble(reader[6]);
candle.Volume = reader.GetInt32(7);
candle.OpenInterest = DALUtil.GetDouble(reader[8]);
return(candle);
}
private void LoadChannels()
{
using (SQLiteConnection connection = new SQLiteConnection(this.database))
{
connection.Open();
string strainStatement = "select SensorId,ChannelNo,Length,Mass from Channels where GroupNo ='" + this.deviceId + "'";
SQLiteCommand command = new SQLiteCommand(strainStatement, connection);
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
//string groupId = reader.GetString(0);
string sensorId = reader.GetString(0);
int channelNo = reader.GetInt32(1);
double length = reader.GetDouble(2);
double mass = reader.GetDouble(3);
VibrateChannel vc = new VibrateChannel(sensorId, channelNo, length, mass);
vibrateChannels.Add(channelNo, vc);
}
}
}
}
/// <summary>
/// gets a list of the average ability scores
/// </summary>
public List <string> getAverageAbilityScores()
{
List <string> averageScores = new List <string>();
using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))
using (SQLiteCommand command = new SQLiteCommand(connection))
{
connection.Open();
command.CommandText = "SELECT * FROM averageAbilityScores";
using (SQLiteDataReader dbReader = command.ExecuteReader())
{
while (dbReader.Read())
{
if (!dbReader.IsDBNull(0))
{
averageScores.Add(dbReader.GetInt32(0).ToString());
}
}
}
}
return(averageScores);
}
//read the data from the database,return the array of string
public String[] getReaderString(String sql, String[] type, int number)
{
SQLiteConnection cnn = new SQLiteConnection(dbConnection);
cnn.Open();
SQLiteCommand mycommand = new SQLiteCommand(sql, cnn);
SQLiteDataReader reader = mycommand.ExecuteReader();
reader.Read();
String[] stringArray = new String[10];
for (int i = 0; i != number; ++i)
{
if (type[i].Equals("int"))
{
stringArray[i] = reader.GetInt32(i).ToString();
}
else if (type[i].Equals("string"))
{
stringArray[i] = reader.GetValue(i).ToString();
}
}
reader.Close();
return(stringArray);
}
public static List <StudentInfo> AllFromClassroomId(int classroomId)
{
List <StudentInfo> studentList = new List <StudentInfo>();
using SQLiteCommand cmd = GlobalFunction.OpenDbConnection();
cmd.CommandText = "SELECT * FROM linkStudentToClassroom WHERE classroomId = @classroomId";
cmd.Parameters.AddWithValue("classroomId", classroomId);
cmd.Prepare();
using SQLiteDataReader rdr = cmd.ExecuteReader();
List <int> studentIdList = new List <int>();
while (rdr.Read())
{
studentIdList.Add(rdr.GetInt32(1));
}
foreach (int studentId in studentIdList)
{
StudentInfo student = FromId(studentId);
studentList.Add(student);
}
return(studentList);
}
private void ReadLevels()
{
//Application.OpenForms.OfType<EnterForm>().Single().SQLConnect.Open();
SQLiteCommand SQLCommand = new SQLiteCommand();
SQLCommand = Application.OpenForms.OfType <EnterForm>().Single().SQLConnect.CreateCommand();
SQLCommand.CommandText = "SELECT * FROM LEVELS ORDER BY LevelID;";
SQLiteDataReader Reader = SQLCommand.ExecuteReader();
while (Reader.Read())
{
try
{
levels.Add(new Level(Reader.GetInt32(0), Reader.GetString(1)));
}
catch
{
return;
}
}
Reader.Close();
SQLCommand.Dispose();
}
//Отправка сообщения всем пользователям
public void SendMessagesToAll(string pathToDB)
{
try
{
using (SQLiteConnection connection = new SQLiteConnection($"Data Source={pathToDB}"))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand("SELECT * FROM ChatIDTable", connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
SendMessgeToUser(reader.GetInt32(1));
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Message);
}
}
/// <summary>
/// 指定された授業IDでこれまでに記録された質問数を返す。
/// </summary>
public int GetNumberOfClassRecords(int classId)
{
int nrecords = -1;
using (SQLiteCommand cmd = new SQLiteCommand(this.connection)) {
try {
cmd.CommandText = (
"SELECT count(questionId) FROM Question, Student " +
"WHERE Student.studentId = Question.studentId " +
"AND classId=@classId;");
cmd.Prepare();
cmd.Parameters.AddWithValue("@classId", classId);
using (SQLiteDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
nrecords = reader.GetInt32(0);
}
}
} catch (SQLiteException e) {
Console.WriteLine("Database.GetNumberOfClassRecords: " + e);
}
}
return(nrecords);
}
public static TextureInformation[] GetTextureInformationsById(string id)
{
List <TextureInformation> result = new List <TextureInformation>();
SQLiteConnection con = GetConnection();
con.Open();
SQLiteDataReader reader = getAllWhere("res", "rtype = 'A654495C' and lower(name) = '" + id.ToLower() + "'", con);
int count = 0;
while (reader.Read())
{
if (count++ % 1000 == 0)
{
Application.DoEvents();
}
TextureInformation ti = new TextureInformation();
ti.name = reader.GetString(0);
ti.sha1 = Helpers.HexStringToByteArray(reader.GetString(1));
ti.bundleIndex = reader.GetInt32(3);
result.Add(ti);
}
con.Close();
return(result.ToArray());
}
private User FillUserData(SQLiteDataReader reader)
{
try
{
User aranan = new User();
aranan.ID = reader.GetInt32(0);
aranan.Name = (reader["Name"] != null) ? reader["Name"].ToString() : "Default name";
aranan.Surname = (reader["Surname"] != null) ? reader["Surname"].ToString() : "Default surname";
aranan.Username = (reader["Username"] != null) ? reader["Username"].ToString() : "Default username";
aranan.Password = (reader["Password"] != null) ? reader["Password"].ToString() : "Default password";
aranan.Telephone = (reader["Telephone"] != null) ? reader["Telephone"].ToString() : "Default telephone";
aranan.Mail = (reader["Mail"] != null) ? reader["Mail"].ToString() : "Default mail";
aranan.StartDateofEmployment = (reader["StartDateofEmployment"] != null) ? reader["StartDateofEmployment"].ToString() : "Default Start date of employment ";
aranan.Birthdate = (reader["Birthdate"] != null) ? reader["Birthdate"].ToString() : "Default birthdate";
aranan.Address = (reader["Address"] != null) ? reader["Address"].ToString() : "Default address";
aranan.UserRole = (reader["UserRole"] != null) ? (UserRoles)Enum.Parse(typeof(UserRoles), reader["UserRole"].ToString()) : UserRoles.None;
return aranan;
}
catch
{
}
return null;
}
/// Renvoie le nombre d'articles présents dans la bdd
/// </summary>
/// <returns></returns>
public int CountAllArticles()
{
int Total = 0;
//ouverture de la connexion avec la bdd & creation de la requete
SQLiteConnection M_dbConnection = new SQLiteConnection("Data Source=" + DatabasePath);
M_dbConnection.Open();
String Sql = "select COUNT(*) from Articles";
using (SQLiteCommand Command = new SQLiteCommand(Sql, M_dbConnection))
{
using (SQLiteDataReader Reader = Command.ExecuteReader())
{
Reader.Read();
Total = Reader.GetInt32(0);
}
}
M_dbConnection.Close();
return(Total);
}
public void GetSQL(String ConnectionString)
{
SQLiteConnection Connection = new SQLiteConnection(ConnectionString);
Connection.Open();
TextList = new List <PakTextEntry>();
using (SQLiteTransaction Transaction = Connection.BeginTransaction())
using (SQLiteCommand Command = new SQLiteCommand(Connection)) {
Command.CommandText = "SELECT english, PointerRef FROM Text ORDER BY PointerRef";
SQLiteDataReader r = Command.ExecuteReader();
while (r.Read())
{
String SQLText;
try {
SQLText = r.GetString(0).Replace("''", "'");
} catch (System.InvalidCastException) {
SQLText = "";
}
int PointerRef = r.GetInt32(1);
PakTextEntry d = new PakTextEntry();
d.OffsetLocation = PointerRef;
d.Text = SQLText;
d.Offset = -1;
TextList.Add(d);
}
Transaction.Rollback();
}
return;
}
public IList <ProblemStation> getProblemStations(IList <long> edsmIds, int distanceToBeAProblem)
{
IList <ProblemStation> result = new List <ProblemStation>();
try
{
using (var con = SimpleDbConnection())
{
con.Open();
var ids = string.Join(",", edsmIds.ToArray());
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = string.Format(FIND_PROBLEM_STATIONS_SQL, ids);
cmd.Prepare();
cmd.Parameters.AddWithValue("@distance", distanceToBeAProblem);
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
string stationName = rdr.GetString(0);
int distance = rdr.GetInt32(1);
string systemName = rdr.GetString(2);
result.Add(new ProblemStation(stationName, systemName, distance));
}
}
}
con.Close();
}
}
catch (Exception ex)
{
Logging.Warn("Problem obtaining data: " + ex);
}
return(result);
}
public void LoadData()
{
string pathToFile = AppDomain.CurrentDomain.BaseDirectory;
string newPath = Path.GetFullPath(Path.Combine(pathToFile, @"..\..\"));
string cs = @"Data Source=" + newPath + "Coordinates.db" + ";Pooling=true;FailIfMissing=false;Version=3";
SQLiteConnection con = new SQLiteConnection(cs);
con.Open();
string stm = "SELECT Id,Name,Job,Description,Cord FROM Cord";
SQLiteCommand cmd = new SQLiteCommand(stm, con);
SQLiteDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
databaseGritBindingSource.Add(new DatabaseGrit()
{
Id = rdr.GetInt32(0), Name = rdr.GetString(1), Title = rdr.GetString(2), Description = "Danni", Text = rdr.GetString(3)
});
}
}
public List <Cliente> ListAll()
{
//cria e retorna uma lista com todos os clientes
List <Cliente> lista = new List <Cliente>();
Cliente cliente = null;
SQLiteConnection conexao = Database.GetInstance().GetConnection();
string qry = "SELECT Cpf, Nome, Telefone, Frequencia FROM Cliente";
if (conexao.State != System.Data.ConnectionState.Open)
{
conexao.Open();
}
SQLiteCommand comm = new SQLiteCommand(qry, conexao);
SQLiteDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
// Cria um objeto Cliente para transferir os dados
// do banco para a aplicação (DTO)
cliente = new Cliente();
cliente.Cpf = dr.GetString(0);
cliente.Nome = dr.GetString(1);
cliente.Telefone = dr.GetString(2);
cliente.Frequencia = dr.GetInt32(3);
lista.Add(cliente); // Adiciona o objeto na lista de resultados
}
dr.Close(); // para nao dar erro de database locked
conexao.Close(); // Não esqueça de fechar a conexão
return(lista);
}
public List <String[]> getAllArticles()
{
String request = "SELECT AR_Ref,AR_Design,AR_Coli FROM colisageArticle";
List <String[]> result = null;
using (SQLiteCommand cmd = new SQLiteCommand(request, this.conn))
{
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
result = new List <string[]>();
String[] temp;
while (dr.Read())
{
temp = new String[3];
temp[0] = dr.GetString(0);
temp[1] = dr.GetString(1);
temp[2] = dr.GetInt32(2).ToString(CultureInfo.InvariantCulture);
result.Add(temp);
}
}
}
return(result);
}
public DBOutbox GetDataId(int id)
{
DBOutbox data = null;
SQLiteConnection con = DBConnection.ConnectDatabase();
try
{
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM " + tablename + " WHERE id=" + id, con);
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
data = new DBOutbox();
data.ID = reader.GetInt32(0);
data.Date = reader.GetDateTime(1);
data.Recipient = reader.GetString(2);
data.Message = reader.GetString(3);
data.Sent = reader.GetString(4);
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(data);
}
private static bool IsInDataBaseInternal <T>(T e) where T : class
{
bool returnValue = false;
using (_connection = OpenConection())
{
using (SQLiteCommand command = new SQLiteCommand($"SELECT * FROM COMPANY WHERE ID = {(int)e.GetType().GetProperty("ID").GetValue(e)}", _connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
int readerValue = reader.GetInt32(0);
returnValue = (int)e.GetType().GetProperty("ID").GetValue(e) == readerValue;
if (!reader.HasRows)
{
break;
}
}
}
}
}
return(returnValue);
}
public static DBOutboxLog GetDataMessage(string message)
{
DBOutboxLog data = null;
SQLiteConnection con = DBConnection.ConnectDatabase();
try
{
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM " + tablename + " WHERE message LIKE '%" + message + "%'", con);
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
data = new DBOutboxLog();
data.ID = reader.GetInt32(0);
data.Date = DateTime.Parse(reader.GetDateTime(1).ToString());
data.Recipient = reader.GetString(2);
data.Message = reader.GetString(3);
data.Sent = reader.GetString(4);
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(data);
}
/// <summary>
/// gets the base Weight in metric or imperial for the chosen race
/// </summary>
/// <param name="metric">true for metric, false for imperial</param>
/// <param name="subrace">chosen subrace</param>
public int getBaseWeight(bool metric, string subrace)
{
int baseWeight = 0;
using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))
using (SQLiteCommand command = new SQLiteCommand(connection))
{
connection.Open();
if (metric)
{
command.CommandText = "SELECT baseWeightKg FROM size " +
"INNER JOIN races ON size.raceId=races.raceid " +
"WHERE races.subrace=@Subrace";
}
else
{
command.CommandText = "SELECT baseWeightLb FROM size " +
"INNER JOIN races ON size.raceId=races.raceid " +
"WHERE races.subrace=@Subrace";
}
command.Parameters.AddWithValue("@Subrace", subrace);
using (SQLiteDataReader dbReader = command.ExecuteReader())
{
if (dbReader.Read())
{
if (!dbReader.IsDBNull(0))
{
baseWeight = dbReader.GetInt32(0);
}
}
}
}
return(baseWeight);
}
private void AddGamesToComboBox()
{
using (SQLiteConnection conn = new SQLiteConnection(@"Data Source=.\" + databaseName + ";"))
{
conn.Open();
SQLiteCommand command = new SQLiteCommand("select id_section, name from section;", conn);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
sections.Add(new GameBasic()
{
ID = reader.GetInt32(0), Name = reader.GetString(1)
});
}
reader.Close();
}
GamesComboBox.Items.Clear();
GamesComboBox.Items.Add("Všechny hry");
for (int i = 0; i < sections.Count; i++)
{
GamesComboBox.Items.Add(sections.ElementAt(i).Name);
}
GamesComboBox.SelectedIndex = 0;
}
public static string[] GetUseCameraDB()
{
if (cn.State != System.Data.ConnectionState.Open)
{
cn.Open();
}
SQLiteCommand cmd = new SQLiteCommand();
cmd.Connection = cn;
string cmd_text = String.Format("SELECT * FROM CAMERA WHERE USETAG = 1");
cmd.CommandText = cmd_text;
string[] camera = new string[4];
try
{
SQLiteDataReader sr = cmd.ExecuteReader();
sr.Read();
camera[0] = sr.GetInt32(0).ToString();
camera[1] = sr.GetString(2);
camera[2] = sr.GetString(3);
camera[3] = sr.GetString(4);
}catch (Exception ex) { System.Console.WriteLine(ex); return(null); }
return(camera);
}
public object getObject(string dataSourceId, string objectHashString)
{
SQLiteCommand cmd = new SQLiteCommand("SELECT ASSEMBLY_NAME, DOMAIN_OBJECT_SIZE, DOMAIN_OBJECT, QUERY_STRING FROM " + TABLE_NAME_PREFIX + dataSourceId +
" WHERE QUERY_STRING_HASH = '" + objectHashString + "';", _cxn);
try
{
openConnection();
SQLiteDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
string assemblyName = rdr.GetString(0); // probably don't need this since we know how to cast the object type already
Int32 domainObjectSize = rdr.GetInt32(1);
byte[] domainObject = new byte[domainObjectSize];
rdr.GetBytes(2, 0, domainObject, 0, domainObjectSize);
string dbQueryString = rdr.GetString(3);
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter bf = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
return(bf.Deserialize(new MemoryStream(domainObject)));
}
else
{
throw new exceptions.MdoException("No record found for that hashcode");
}
}
catch (Exception)
{
throw;
}
finally
{
closeConnection();
}
}
public List <Event> GetEvents()
{
mutex.WaitOne();
List <Event> events = new List <Event>();
string query1 = "SELECT scheduleId, time, amount FROM event";
SQLiteCommand myCommand = new SQLiteCommand(query1, myConnection);
OpenConnection();
myCommand.ExecuteNonQuery();
SQLiteDataAdapter adapter = new SQLiteDataAdapter(myCommand);
DataTable dt = new DataTable("events");
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
var cells = row.ItemArray;
Event @event = new Event(Convert.ToInt32(cells.GetValue(0)), Convert.ToInt32(cells.GetValue(1)), Convert.ToInt32(cells.GetValue(2)));
events.Add(@event);
}
CloseConnection();
for (int i = 0; i < events.Count(); i++)
{
string query = "SELECT feederId FROM schedule WHERE SheduleId = @scheduleId";
SQLiteCommand myCommand1 = new SQLiteCommand(query, myConnection);
myCommand1.Parameters.AddWithValue("@scheduleId", events[i].ScheduleId);
OpenConnection();
SQLiteDataReader reader1 = myCommand1.ExecuteReader();
while (reader1.Read())
{
events[i].FeederId = reader1.GetInt32(0);
}
CloseConnection();
}
mutex.ReleaseMutex();
return(events);
}
public List <string[][]> getActors()
{
connection.Open();
List <string[][]> actors = new List <string[][]>();
string[][] actor = new string[2][];
using (SQLiteCommand command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM Actor";
using (SQLiteDataReader reader = command.ExecuteReader())
{
int count = 0;
while (reader.Read())
{
actor[0][count] = reader.GetInt32(0).ToString();
actor[1][count] = reader.GetString(1);
actors.Add(actor);
count++;
}
}
}
connection.Close();
return(actors);
}
