private void btn_EtudeCreate(object sender, RoutedEventArgs e)
{
DOEtude newEtude = new DOEtude(-1, this.text_NewEtudeTitre.Text, this.text_NewEtudeDateStart.Text, "nill");
newEtude.Insert();
_etudes.Add(newEtude);
dgEtudes.ItemsSource = _etudes;
dgEtudes.Items.Refresh();
}
public ViewModelEditEtude(int id)
{
InitializeComponent();
_daEtude = new DAEtude();
_curEtude = new DOEtude();
_daEtude.SelectEtudeById(id, _curEtude);
etudeId.Text = _curEtude.idEtude.ToString();
etudeTitre.Text = _curEtude.titre;
etudeId.Text = _curEtude.dateStart;
}
private void btn_EtudeDel(object sender, RoutedEventArgs e)
{
DOEtude selected = (DOEtude)dgEtudes.SelectedItem;
if (selected != null)
{
_daEtude.DeleteEtude(selected.idEtude);
dgEtudes.Items.Refresh();
}
else
{
MessageBox.Show("Pas d'étude sélectionnée");
}
}
private void btn_GoToEdit(object sender, RoutedEventArgs e)
{
DOEtude selected = (DOEtude)dgEtudes.SelectedItem;
if (selected != null)
{
Window page = Window.GetWindow(this);
page.Content = new ViewModelEditEtude(selected.idEtude);
}
else
{
MessageBox.Show("Pas d'étude sélectionnée");
}
}
public void UpdateEtude(DOEtude obj)
{
if (obj != null)
{
string query = "UPDATE " + _table + "(titre, dateStart, dateEnd) "
+ "VALUES('" + obj.titre + "', '" + obj.dateStart + "', 'nill')";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
// check ... ?
}
this.CloseConnection();
}
}
public void InsertEtude(DOEtude obj)
{
if (obj != null)
{
string query = "INSERT INTO " + _table + "(titre, dateStart, dateEnd) "
+ "VALUES('" + obj.titre + "', '" + obj.dateStart + "', 'nill')";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
// check rows pour vérifier qu'il y a bien eu insertion ?
// get de l'id de la dernière row insérée
}
this.CloseConnection();
}
}
public void SelectEtudeById(int id, DOEtude obj)
{
//DOEtude selected = new DOEtude();
string query = "SELECT * FROM " + _table + " WHERE idEtude = '" + id + "';";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
obj.idEtude = reader.GetInt32(0);
obj.titre = reader.GetString(1);
obj.dateStart = reader.GetString(2);
obj.dateEnd = reader.GetString(3);
}
reader.Close();
}
this.CloseConnection();
}
public List <DOEtude> SelectEtudes()
{
//ObservableCollection<DOEtude> col = new ObservableCollection<DOEtude>();
List <DOEtude> col = new List <DOEtude>();
string query = "SELECT * FROM " + _table + ";";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DOEtude obj = new DOEtude(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
col.Add(obj);
}
reader.Close();
}
this.CloseConnection();
return(col);
}
