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