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