private void editButton_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(itemName.Text) || string.IsNullOrEmpty(itemSurname.Text) || string.IsNullOrEmpty(itemID.Text))
{
//Dialog
MessageBox.Show("Name or Surname must be entered.", "Error", MessageBoxButton.OK);
}
else
{
long?deg = null;
if (!string.IsNullOrEmpty(itemDegree.Text))
{
deg = System.Convert.ToInt64(itemDegree.Text);
}
using (var db = new lppDB())
{
db.students.Update((x => x.id == selectedID), (x) => new student()
{
name = itemName.Text,
surname = itemSurname.Text,
govern_identifier = itemID.Text,
degree_id = deg
});
dataGrid.ItemsSource = getStudents();
db.Close();
}
}
}
public MainWindow()
{
InitializeComponent();
this.dg_students.AllowDrop = false;
using (var db = new lppDB())
{
students = (from s in db.students
from d in db.degrees.Where(d => d.id == s.degree_id).DefaultIfEmpty()
select new Student_item(s, d)).ToList <Student_item>();
List <degree> degrees = (from d in db.degrees select d).ToList();
degrees.Add(new degree());//allow to select an empty degree
this.fil_degree.ItemsSource = degrees;
this.dg_students.ItemsSource = students;
this.cb_ns_deg.ItemsSource = degrees;
this.columnDegree.ItemsSource = degrees;
db.Close();
}
dg_students.AllowDrop = false;
dg_students.CanUserReorderColumns = false;
dg_students.CellEditEnding += Dg_students_CellEditEnding;
}
private void insertButton_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(newName.Text) || string.IsNullOrEmpty(newSurname.Text) || string.IsNullOrEmpty(newID.Text))
{
//Dialog
MessageBox.Show("Name, Surname and Identifier must be entered.", "Error", MessageBoxButton.OK);
}
else
{
long?deg = null;
if (!string.IsNullOrEmpty(newDegree.Text))
{
deg = System.Convert.ToInt64(newDegree.Text);
}
using (var db = new lppDB())
{
db.students.Insert(() => new student
{
name = newName.Text,
surname = newSurname.Text,
govern_identifier = newID.Text,
degree_id = deg
});
dataGrid.ItemsSource = getStudents();
db.Close();
}
}
}
private IQueryable <student> getStudents()
{
var db = new lppDB();
if (string.IsNullOrEmpty(degreeFilter.Text))
{
return(from s in db.students where s.name.Contains(nameFilter.Text) && s.surname.Contains(surnameFilter.Text) && s.govern_identifier.Contains(idFilter.Text) select s);
}
return(from s in db.students where s.name.Contains(nameFilter.Text) && s.surname.Contains(surnameFilter.Text) && s.govern_identifier.Contains(idFilter.Text) && s.degree_id.Equals(degreeFilter.Text) select s);
}
public MainWindow()
{
InitializeComponent();
using (var db = new lppDB())
{
InitializeComponent();
dataGrid.ItemsSource = from c in db.students select c;
}
}
/// <summary>
/// Insert a new student in the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_submitInsert_Click(object sender, RoutedEventArgs e)
{
string name, surname, govern_identifier;
degree deg;
name = this.tb_name.Text;
surname = this.tb_surname.Text;
govern_identifier = this.tb_gov_id.Text;
deg = (degree)this.cb_ns_deg.SelectedItem;
student std = new student();
std.name = name;
std.surname = surname;
std.govern_identifier = govern_identifier;
if (deg != null)
{
if (!deg.isEmpty())//esrit aixi per seguritat
{
std.degree_id = deg.id;
}
}
//insert the new student in the database
using (var db = new lppDB())
{
db.Insert(std);
students = (from s in db.students
from d in db.degrees.Where(d => d.id == s.degree_id).DefaultIfEmpty()
select new Student_item(s, d)).ToList <Student_item>();
db.Close();
}
//update all the windows items
this.dg_students.ItemsSource = null;
this.dg_students.ItemsSource = students;
//crear the form
this.tb_name.Text = "";
this.tb_surname.Text = "";
this.tb_gov_id.Text = "";
this.cb_ns_deg.SelectedIndex = -1;
MessageBox.Show("Item insert success!");
}
//update the degree in the database
private bool updateDegree(student std, degree new_degree)
{
long?id_new_deg;
if (new_degree.isEmpty())
{
id_new_deg = null;
}
else
{
id_new_deg = new_degree.id;
}
using (var db = new lppDB())
{
db.students.Where(st => st.id == std.id).Set(p => p.degree_id, id_new_deg).Update();
db.Close();
}
return(true);
}
/// <summary>
/// Function called when you finish to edit a datagrid cell
/// Is the function that update the database with the new value
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Dg_students_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
TextBox t = e.EditingElement as TextBox; // Assumes columns are all TextBoxes
Student_item st_edit = (Student_item)dg_students.SelectedValue;
switch (e.Column.DisplayIndex)
{
case COL_ID:
MessageBox.Show("Are not allowed to change the id!");
break;
case COL_NAME:
if (t.Text.Equals(st_edit.St.name))
{
MessageBox.Show("No changes");
return;
}
using (var db = new lppDB())
{
db.students.Where(st => st.id == st_edit.St.id).Set(p => p.name, t.Text).Update();
db.Close();
}
MessageBox.Show("The name has been changed from " +
st_edit.St.name + " to " + t.Text);
break;
case COL_SURNAME:
if (t.Text.Equals(st_edit.St.surname))
{
MessageBox.Show("No changes");
return;
}
using (var db = new lppDB())
{
db.students.Where(st => st.id == st_edit.St.id).Set(p => p.surname, t.Text).Update();
db.Close();
}
MessageBox.Show("The surname has been changed from " +
st_edit.St.surname + " to " + t.Text);
break;
case COL_DEGREE:
ComboBox cb_deg = e.EditingElement as ComboBox;
degree d_selected = (degree)cb_deg.SelectedItem;
if (cb_deg.SelectedIndex == -1 || d_selected.Equals(st_edit.St.degree))
{
MessageBox.Show("No changes");
return;
}
this.updateDegree(st_edit.St, d_selected);
MessageBox.Show("The degree has been changed from " +
st_edit.St.degree + " to " + cb_deg.SelectedItem);
break;
case COL_GID:
if (t.Text.Equals(st_edit.St.govern_identifier))
{
MessageBox.Show("No changes");
return;
}
using (var db = new lppDB())
{
db.students.Where(st => st.id == st_edit.St.id).Set(p => p.govern_identifier, t.Text).Update();
db.Close();
}
MessageBox.Show("The govern id has been changed from " +
st_edit.St.govern_identifier + " to " + t.Text);
break;
default:
MessageBox.Show("Wrong action");
break;
}
}
