private void LV_History_Loaded(object sender, RoutedEventArgs e)
{
String query = "select * from project order by id_project desc;";
DataTable dt = db.GetDataTable(query);
// Create a collection for your types
ProjectList.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
Project p = new Project();
p.mis = dt.Rows[i]["pr_mis"].ToString();
p.title = dt.Rows[i]["pr_title"].ToString();
p.Settings = dt.Rows[i]["pr_settings"].ToString();
p.SetPrefix(dt.Rows[i]["pr_table_prefix"].ToString());
ProjectList.Add(p);
}
LV_History.ItemsSource = ProjectList;
}
public Project GetProject()
{
Project p = new Project();
try
{
SQLiteConnection cnn = new SQLiteConnection(dbConnection);
// cnn.SetPassword(Password);
cnn.Open();
// cnn.ChangePassword("");
SQLiteCommand mycommand = new SQLiteCommand(cnn);
mycommand.CommandText = "Select pr_table_prefix from project order by id_project asc limit 1";
SQLiteDataReader reader = mycommand.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
p.SetPrefix(reader.GetString(0));
}
}
else
{
p = null;
}
reader.Close();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return p;
}