private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnChange":
string new_value = "name = '" + name.Text.Trim() + "', " +
"address = '" + address.Text.Trim() + "', " +
"employeer = '" + employeer.Text.Trim() + "', " +
"phone = '" + phone.Text.Trim() + "', " +
"date_end = '" + date_end.Text.Trim() + "'";
SQLiteAdapter.ChangeValueById("practise_base", practise.id, new_value);
Helper.RefreshOCollection();
this.Close();
break;
default:
break;
}
}
public static void EditDataGrid <T>(DataGridCellEditEndingEventArgs e, string table_name, DataGrid dataGrid) // Editing DataGrid Row
{
dynamic selected_items = (T)dataGrid.SelectedItem; // Getting DataGrid selected items(can get Student class properties)
string column_name = e.Column.SortMemberPath; // Getting edited/changed column name
string new_value = ((TextBox)e.EditingElement).Text.Trim(); // Getting entered value
Type propertyInfo = typeof(T);
string old_value = propertyInfo.GetProperty(column_name).GetValue(selected_items, null).ToString(); // Get previous value in edited cells
if (e.EditAction == DataGridEditAction.Commit && !new_value.Equals("") && !new_value.Equals(old_value)) // Checking entered value for empty
{
MessageBoxResult msgBox = MessageBox.Show("Вы действительно хотите изменить текушие данные?", "Изменение данных", MessageBoxButton.YesNo);
if (msgBox == MessageBoxResult.Yes) // If answer YES
{
SQLiteAdapter.ChangeValueById(table_name, selected_items.id, column_name + " = '" + new_value + "'");
// TODO: Добавить проверку выполненности изменения данных в БД, если FALSE, то откат изменений в DataGrid
}
else
{ // If answer No
dataGrid.CancelEdit(); //DataGridEditingUnit.Row
}
}
else if (e.EditAction == DataGridEditAction.Cancel)
{
return;
}
else
{
dataGrid.CancelEdit();
} // Cancel editing row
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "AddStudent":
string sel_group = group.SelectedItem.ToString().Trim();
string group_id = SQLiteAdapter.GetValue($"groups WHERE groupe = '{sel_group}'", "id")[0][0];
SQLiteAdapter.SetValue("students",
surname.Text.Trim(),
name.Text.Trim(),
patronymic.Text.Trim(),
group_id.Trim(),
formStudy.SelectedItem.ToString().Trim(),
email.Text.Trim(),
phone.Text.Trim()
);
Helper.RefreshOCollection();
this.Close();
break;
default:
break;
}
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnChange":
Helper.Level level = (Helper.Level)Enum.Parse(typeof(Helper.Level), lvl.SelectedItem.ToString().Trim()); // Convert string (Selected Level) to enum
string new_value = "surname = '" + surname.Text.Trim() + "', " +
"name = '" + name.Text.Trim() + "', " +
"patronymic = '" + patronymic.Text.Trim() + "', " +
"phone = '" + phone.Text.Trim() + "', " +
"email = '" + email.Text.Trim() + "', " +
"account = '" + login.Text.Trim() + "', " +
"lvl = '" + level.GetHashCode().ToString() + "'";
SQLiteAdapter.ChangeValueById("employees", employee.id, new_value);
Helper.RefreshOCollection();
this.Close();
break;
default:
break;
}
}
/*private void dataGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e) // Editing DataGrid Row
* {
* dataGridHelper.EditDataGrid<Group>(e, table_name, dataGrid);
* load_data_grid();
* }*/
#endregion
#region DataGrid: Deleting
/*private void dataGrid_PreviewKeyDown(object sender, KeyEventArgs e) // Deleting DataGrid Row
* {
* if (e.Key == Key.Delete)
* {
* e.Handled = DataGridHelper.DeleteDataGrid<Group>(dataGrid);
* }
* }*/
#endregion
#region DataGrid: Filtering
/*public void FilterValue(object sender, EventArgs e)
* {
* dataGridHelper.FilterDataGrid<Group>(sender, e, dataGrid);
* }*/
#endregion
#endregion
private void Group_Hotkey(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "Group_add":
new Groups_Add().ShowDialog();
break;
case "Group_edit":
if (dataGrid.SelectedIndex != -1)
{
new Groups_Edit(dataGrid.SelectedItem as Group).ShowDialog();
}
break;
case "Group_del":
if (dataGrid.SelectedIndex != -1)
{
if (DataGridHelper.DeleteDataGrid <Group>(dataGrid) == false)
{
string group_id = ((Group)dataGrid.SelectedItem).id;
Helper.OGroups.Remove(Helper.OGroups.Where(i => i.Equals(dataGrid.SelectedItem)).Single()); // Deleting row from OCathedras(ObservableCollection)
SQLiteAdapter.DeleteRowById("pract_types", $"[id_groupe]='{group_id}'");
}
}
break;
default: break;
}
}
public Student_Add()
{
InitializeComponent();
controls = new List <Control>()
{
surname, name, patronymic, group, formStudy, email, phone
};
formStudy.ItemsSource = new List <string>()
{
"Бюджет", "Внебюджет"
};
foreach (List <string> groups in SQLiteAdapter.GetValue("groups", "groupe"))
{
if (!group.Items.Contains(groups[0]))
{
group.Items.Add(groups[0]);
}
}
// EventHandler's
surname.TextChanged += Controls_Listener;
name.TextChanged += Controls_Listener;
patronymic.TextChanged += Controls_Listener;
group.SelectionChanged += Controls_Listener;
formStudy.SelectionChanged += Controls_Listener;
email.TextChanged += Controls_Listener;
phone.TextChanged += Controls_Listener;
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnChange":
string sel_group = group.SelectedItem.ToString().Trim();
string group_id = SQLiteAdapter.GetValue($"groups WHERE groupe = '{sel_group}'", "id")[0][0];
string new_value = "surname = '" + surname.Text.Trim() + "', " +
"name = '" + name.Text.Trim() + "', " +
"patronymic = '" + patronymic.Text.Trim() + "', " +
"groupe = '" + group_id.Trim() + "', " +
"free_study = '" + formStudy.SelectedItem.ToString().Trim() + "', " +
"email = '" + email.Text.Trim() + "', " +
"phone = '" + phone.Text.Trim() + "'";
SQLiteAdapter.ChangeValueById("students", student.id, new_value);
Helper.RefreshOCollection();
this.Close();
break;
default:
break;
}
}
public Cathedras_Edit(Cathedra cathedra)
{
InitializeComponent();
this.cathedra = cathedra;
controls = new List <Control>()
{
number, name, phone, decan
};
foreach (List <string> value in SQLiteAdapter.GetValue("employees WHERE employees.id NOT IN(SELECT cathedras.id_decan FROM cathedras)", "employees.surname, employees.name, employees.patronymic"))
{
string decan_name = value[0].Trim() + " " + value[1].Trim() + " " + value[2].Trim();
if (!decan.Items.Contains(decan_name))
{
decan.Items.Add(decan_name);
}
}
decan.Items.Add(cathedra.surname.Trim() + " " + cathedra.name.Trim() + " " + cathedra.patronymic.Trim());
number.Text = cathedra.number;
name.Text = cathedra.cathedra;
phone.Text = cathedra.phone;
decan.SelectedItem = cathedra.surname.Trim() + " " + cathedra.name.Trim() + " " + cathedra.patronymic.Trim();
// EventHandler's
number.TextChanged += Controls_Listener;
name.TextChanged += Controls_Listener;
phone.TextChanged += Controls_Listener;
decan.SelectionChanged += Controls_Listener;
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnChange":
// Get id decan name from Employees table for adding to Cathedras table
string cathedra_id_tmp = id_cathedra.SelectedItem.ToString().Trim();
string cathedra_id = SQLiteAdapter.GetValue($"cathedras WHERE cathedra = '{cathedra_id_tmp}'", "id")[0][0];
string new_value = "code = '" + code.Text.Trim() + "', " +
"name = '" + name.Text.Trim() + "', " +
"id_cathedra = '" + cathedra_id.Trim() + "'";
SQLiteAdapter.ChangeValueById("directions", direction.id, new_value);
Helper.RefreshOCollection();
this.Close();
break;
default:
break;
}
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnAdd":
SQLiteAdapter.SetValue("practise_base",
name.Text.Trim(),
address.Text.Trim(),
employeer.Text.Trim(),
phone.Text.Trim(),
date_end.Text.Trim()
);
// Refresh ObservableCollection for update dataGrids
Helper.RefreshOCollection();
this.Close();
break;
default:
break;
}
}
public Direction_Edit(Direction direction)
{
InitializeComponent();
this.direction = direction;
controls = new List <Control>()
{
name, code, id_cathedra
};
foreach (List <string> value in SQLiteAdapter.GetValue("cathedras WHERE cathedras.id NOT IN(SELECT directions.id_cathedra FROM directions)", "cathedra"))
{
if (!id_cathedra.Items.Contains(value[0]))
{
id_cathedra.Items.Add(value[0]);
}
}
id_cathedra.Items.Add(direction.id_cathedra);
code.Text = direction.code;
name.Text = direction.name;
id_cathedra.SelectedItem = direction.id_cathedra;
// EventHandler's
name.TextChanged += Controls_Listener;
code.TextChanged += Controls_Listener;
id_cathedra.SelectionChanged += Controls_Listener;
}
public static List <T> GetTableByClass <T>(string table_name = null, string select = "*") where T : new()
{
if (table_name == null)
{
table_name = GetTNameByClass <T>(); // Get table name in database by class
}
Type properties = typeof(T);
PropertyInfo property;
List <T> values = new List <T>();
List <List <string> > tmp = SQLiteAdapter.GetValue(table_name, select);
foreach (List <string> column in tmp)
{
T ClassName = new T();
for (int i = 0; i < properties.GetProperties().Count(); i++)
{
property = properties.GetProperties().ElementAt(i);
if (column.Count > i)
{
property.SetValue(ClassName, column[i]);
}
else
{
break;
}
}
values.Add(ClassName);
}
return(values);
}
private List <string> Selected_Groups(List <string> selected_dir, List <List <string> > selected_course)
{
List <string> groups = new List <string>();
for (int i = 0; i < selected_course.Count; i++)
{
for (int j = 0; j < selected_course[i].Count; j++)
{
//Конвертируем курс в группу
int course = Convert.ToInt32(selected_course[i].ElementAt(j).Split()[0]);
int month = DateTime.Today.Month - 9; // Текущий месяц - месяц поступления
if (month >= 0)
{
course--;
}
int enroll = DateTime.Today.Year - course; // Год поступления
List <List <string> > groups_arr = SQLiteAdapter.GetValue($"groups INNER JOIN directions ON directions.id=groups.direction WHERE code ='{selected_dir[i]}' AND enroll_year='{enroll}'", "groups.groupe");
foreach (List <string> group_tmp in groups_arr)
{
groups.Add(group_tmp[0]);
}
}
}
return(groups);
}
public Groups_Add()
{
InitializeComponent();
controls = new List <Control>()
{
groupe, direction, form_study, enroll, end
};
form_study.ItemsSource = new List <string>()
{
"Очная", "Заочная"
};
foreach (List <string> groups in SQLiteAdapter.GetValue("directions", "name"))
{
if (!direction.Items.Contains(groups[0]))
{
direction.Items.Add(groups[0]);
}
}
typePract.ItemsSource = practise_Types;
// EventHandler's
groupe.TextChanged += Controls_Listener;
direction.SelectionChanged += Controls_Listener;
form_study.SelectionChanged += Controls_Listener;
enroll.TextChanged += Controls_Listener;
end.TextChanged += Controls_Listener;
}
private void Form_pract_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
combobox_type.IsEnabled = true;
combobox_type.Items.Clear();
List <List <string> > type_practs = SQLiteAdapter.GetValue($"pract_types INNER JOIN groups ON groups.id=pract_types.id_groupe WHERE groups.groupe='{combobox_groupe.SelectedItem}'", "pract_types.type_name");
foreach (List <string> tmp in type_practs)
{
combobox_type.Items.Add(tmp[0]);
}
}
public void ReadPGN(string dir)
{
string qry = "";
using (SQLiteConnection cxn = new SQLiteConnection(_connectionString))
{
cxn.Open();
SQLiteCommand cmd = new SQLiteCommand(qry, cxn);
cmd.CommandType = CommandType.Text;
SQLiteAdapter ad = new SQLiteAdapter(cmd);
}
}
public Groups_Edit(Group group)
{
InitializeComponent();
this.group = group;
controls = new List <Control>()
{
groupe, direction, form_study, enroll, end
};
form_study.ItemsSource = new List <string>()
{
"Очная", "Заочная"
};
foreach (List <string> groups in SQLiteAdapter.GetValue("directions", "name"))
{
if (!direction.Items.Contains(groups[0]))
{
direction.Items.Add(groups[0]);
}
}
groupe.Text = group.groupe;
direction.SelectedItem = group.direction;
form_study.SelectedItem = group.form_study;
enroll.Text = group.enroll_year;
end.Text = group.end_year;
List <List <string> > LGroups = SQLiteAdapter.GetValue($"pract_types INNER JOIN groups ON groups.id=pract_types.id_groupe WHERE groupe='{group.groupe}'", "pract_types.type_name");
if (LGroups.Count > 0)
{
foreach (List <string> tmp in LGroups)
{
practise_Types.Add(new Practise_Type {
type_name = tmp[0]
});
//if(!typePract.Items.Contains(tmp[0])) typePract.Items.Add(tmp[0]);
}
}
typePract.ItemsSource = practise_Types;
// EventHandler's
groupe.TextChanged += Controls_Listener;
direction.SelectionChanged += Controls_Listener;
form_study.SelectionChanged += Controls_Listener;
enroll.TextChanged += Controls_Listener;
end.TextChanged += Controls_Listener;
}
IDataClient GetDataClient(string ClientType)
{
if (ClientType == "SQL")
{
if (sqlClient != null)
{
return(sqlClient);
}
sqlClient = new SqlAdapter();
return(sqlClient);
}
else if (ClientType == "ORACLE")
{
if (oraClient != null)
{
return(oraClient);
}
oraClient = new OracleAdapter();
return(oraClient);
}
else if (ClientType == "SQLite")
{
if (sqliteClient != null)
{
return(sqliteClient);
}
sqliteClient = new SQLiteAdapter();
return(sqliteClient);
}
else if (ClientType == "OleDb")
{
if (oleDbClient != null)
{
return(oleDbClient);
}
oleDbClient = new OleDbAdapter();
return(oleDbClient);
}
else if (ClientType == "Postgre")
{
if (postgreClient != null)
{
return(postgreClient);
}
postgreClient = new PostgreAdapter();
return(postgreClient);
}
return(null);
}
public static bool DeleteDataGrid <T>(DataGrid dataGrid) // Deleting DataGrid Row
{
string table_name = Helper.GetTNameByClass <T>(); // Get table name in database by class
MessageBoxResult msgBox = MessageBox.Show("Вы действительно хотите данное значение?", "Удаление значения", MessageBoxButton.YesNo);
if (msgBox == MessageBoxResult.Yes)
{
dynamic selected_items = (T)dataGrid.SelectedItem; // Getting DataGrid selected items(can get Student class properties)
return(SQLiteAdapter.DeleteRowById(table_name, $"[id] = '{selected_items.id}'"));
}
else
{
return(true);
} // Cancel delete row
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnAdd":
Helper.Level level = (Helper.Level)Enum.Parse(typeof(Helper.Level), lvl.SelectedItem.ToString().Trim()); // Convert string (Selected Level) to enum
SQLiteAdapter.SetValue("employees",
surname.Text.Trim(),
name.Text.Trim(),
patronymic.Text.Trim(),
phone.Text.Trim(),
email.Text.Trim(),
login.Text.Trim(),
level.GetHashCode().ToString()
);
// Refresh ObservableCollection for update dataGrids
Helper.RefreshOCollection();
/*Helper.OEmployees.Add(new Employee
* {
* id = (Helper.OEmployees.Count() + 1).ToString(),
* surname = surname.Text.Trim(),
* name = name.Text.Trim(),
* patronymic = patronymic.Text.Trim(),
* phone = phone.Text.Trim(),
* email = email.Text.Trim(),
* login = login.Text.Trim(),
* lvl = level.GetHashCode().ToString()
* });*/
this.Close();
break;
default:
break;
}
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnAdd":
string sel_direction = direction.SelectedItem.ToString().Trim();
string direction_id = SQLiteAdapter.GetValue($"directions WHERE name = '{sel_direction}'", "id")[0][0];
SQLiteAdapter.SetValue("groups",
groupe.Text.Trim(),
direction_id.Trim(),
form_study.SelectedItem.ToString().Trim(),
enroll.Text.Trim(),
end.Text.Trim()
);
Helper.RefreshOCollection();
string group_id = SQLiteAdapter.GetValue($"groups WHERE groupe='{groupe.Text.Trim()}' " +
$"AND direction='{direction_id.Trim()}' " +
$"AND form_study='{form_study.SelectedItem.ToString().Trim()}' " +
$"AND enroll_year='{enroll.Text.Trim()}'" +
$"AND end_year='{end.Text.Trim()}'", "id")[0][0];
for (int i = 0; i < practise_Types.Count; i++)
{
if (practise_Types[i].type_name.ToString().Trim().Length > 0)
{
SQLiteAdapter.SetValue("pract_types", group_id, practise_Types[i].type_name.ToString().Trim());
}
}
this.Close();
break;
default:
break;
}
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnChange":
string[] decan_name = decan.SelectedItem.ToString().Trim().Split();
string decan_id = SQLiteAdapter.GetValue($"employees WHERE surname = '{decan_name[0]}' AND name = '{decan_name[1]}' AND patronymic = '{decan_name[2]}'", "id")[0][0];
string new_value = "number = '" + number.Text.Trim() + "', " +
"cathedra = '" + name.Text.Trim() + "', " +
"phone = '" + phone.Text.Trim() + "', " +
"id_decan = '" + decan_id + "'";
SQLiteAdapter.ChangeValueById("cathedras", cathedra.id, new_value);
Helper.RefreshOCollection();
/*Helper.OCathedras[Helper.OCathedras.IndexOf(cathedra)] = new Cathedra
* {
* id = cathedra.id,
* number = number.Text.Trim(),
* name = name.Text.Trim(),
* phone = phone.Text.Trim(),
* id_decan = decan.SelectedItem.ToString().Trim()
* }; */// Replace OCathedras with new values
this.Close();
break;
default:
break;
}
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnChange":
string sel_direction = direction.SelectedItem.ToString().Trim();
string direction_id = SQLiteAdapter.GetValue($"directions WHERE name = '{sel_direction}'", "id")[0][0];
string new_value = "groupe = '" + groupe.Text.Trim() + "', " +
"direction = '" + direction_id.Trim() + "', " +
"form_study = '" + form_study.SelectedItem.ToString().Trim() + "', " +
"enroll_year = '" + enroll.Text.Trim() + "', " +
"end_year = '" + end.Text.Trim() + "'";
SQLiteAdapter.ChangeValueById("groups", group.id, new_value);
Helper.RefreshOCollection();
SQLiteAdapter.DeleteRowById("pract_types", $"[id_groupe]='{group.id}'");
for (int i = 0; i < practise_Types.Count; i++)
{
if (practise_Types[i].type_name.ToString().Trim().Length > 0)
{
SQLiteAdapter.SetValue("pract_types", group.id, practise_Types[i].type_name.ToString().Trim());
}
}
this.Close();
break;
default:
break;
}
}
private void Controls_Buttons(object sender, RoutedEventArgs e)
{
if (contracts_list.SelectedIndex == -1)
{
return;
}
Button button = (Button)sender;
switch (button.Name)
{
case "Contract_open":
try { Process.Start(path_contracts + "Договор №" + Helper.OContracts.Where(i => i.Equals(contracts_list.SelectedItem)).Single().id); }
catch { MessageBox.Show($"Ошибка открытия папки! Возможно сперва необходимо сформировать договор.", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error); }
break;
case "Contract_edit":
new Contracts_Edit(contracts_list.SelectedItem as Classes.Contracts).ShowDialog();
Helper.RefreshOCollection();
break;
case "Contract_del":
if (DataGridHelper.DeleteDataGrid <Classes.Contracts>(contracts_list) == false)
{
string id = ((Classes.Contracts)contracts_list.SelectedItem).id;
if (SQLiteAdapter.DeleteRowById("attach", $"[id_contract]='{id}'") == false)
{
Helper.OContracts.Remove(Helper.OContracts.Where(i => i.Equals(contracts_list.SelectedItem)).Single()); // Удаляем элемент из коллекции
if (Directory.Exists(path_contracts + $"Договор №{id}"))
{
Directory.Delete(path_contracts + $"Договор №{id}", true); // Удаляем папку договора
}
}
}
break;
default: break;
}
}
private void Button_Listener(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
switch (button.Name)
{
case "FormClose":
this.Close();
break;
case "btnAdd":
// Get id decan name from Employees table for adding to Cathedras table
string[] decan_name = decan.SelectedItem.ToString().Trim().Split();
string decan_id = SQLiteAdapter.GetValue($"employees WHERE surname = '{decan_name[0]}' AND name = '{decan_name[1]}' AND patronymic = '{decan_name[2]}'", "id")[0][0];
SQLiteAdapter.SetValue("cathedras",
number.Text.Trim(),
name.Text.Trim(),
phone.Text.Trim(),
decan_id
);
// TODO: добавить проверку на добавление в БД
Helper.RefreshOCollection();
/*Helper.OCathedras.Add(new Cathedra {
* id = (Helper.OCathedras.Count()+1).ToString(),
* number = number.Text.Trim(),
* name = name.Text.Trim(),
* phone = phone.Text.Trim(),
* id_decan = decan_id });*/
this.Close();
break;
default:
break;
}
}
protected override void onCreate(global::android.os.Bundle savedInstanceState)
{
base.onCreate(savedInstanceState);
setContentView(R.layout.main);
TextView listContent = (TextView)findViewById(R.id.contentlist);
/*
* Create/Open a SQLite database
* and fill with dummy content
* and close it
*/
mySQLiteAdapter = new SQLiteAdapter(this);
mySQLiteAdapter.openToWrite();
mySQLiteAdapter.deleteAll();
mySQLiteAdapter.insert("ABCDE");
mySQLiteAdapter.insert("FGHIJK");
mySQLiteAdapter.insert("1234567");
mySQLiteAdapter.insert("890");
mySQLiteAdapter.insert("Testing");
mySQLiteAdapter.close();
/*
* Open the same SQLite database
* and read all it's content.
*/
mySQLiteAdapter = new SQLiteAdapter(this);
mySQLiteAdapter.openToRead();
var contentRead = mySQLiteAdapter.queueAll();
mySQLiteAdapter.close();
listContent.setText(contentRead);
this.ShowToast("http://jsc-solutions.net");
}
protected override void onCreate(global::android.os.Bundle savedInstanceState)
{
base.onCreate(savedInstanceState);
setContentView(R.layout.main);
TextView listContent = (TextView)findViewById(R.id.contentlist);
/*
* Create/Open a SQLite database
* and fill with dummy content
* and close it
*/
mySQLiteAdapter = new SQLiteAdapter(this);
mySQLiteAdapter.openToWrite();
mySQLiteAdapter.deleteAll();
mySQLiteAdapter.insert("ABCDE");
mySQLiteAdapter.insert("FGHIJK");
mySQLiteAdapter.insert("1234567");
mySQLiteAdapter.insert("890");
mySQLiteAdapter.insert("Testing");
mySQLiteAdapter.close();
/*
* Open the same SQLite database
* and read all it's content.
*/
mySQLiteAdapter = new SQLiteAdapter(this);
mySQLiteAdapter.openToRead();
var contentRead = mySQLiteAdapter.queueAll();
mySQLiteAdapter.close();
listContent.setText(contentRead);
this.ShowToast("http://jsc-solutions.net");
}
public DocumentController()
{
SQLiteAdapter = new SQLiteAdapter();
}
public SQLiteAdapterProperty()
{
pms["DbAdapter"] = new SQLiteAdapter();
}
public ModelBase()
{
connection = SQLiteAdapter.NewInstance();
}
public LoggerController(SQLiteAdapter dbAdapter)
{
this.dbAdapter = dbAdapter ?? throw new ArgumentNullException(nameof(dbAdapter));
}
