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)); }