private void Validation(object sender, RoutedEventArgs e)
{
Jour j = new Jour();
//DateTime UpdatedTime = laDate.SelectedDate ?? j.date;
//this.date = DateTime.Parse(this.date.ToString("YYYY/MM/DD"));
//var uneDate = laDate.SelectedDate.ToString();
//DateTime convertDate = Convert.ToDateTime(uneDate);
if (unIntitule.Text == "" || laDate.Text == "" || nbFragments.Text == "0" || unIntitule.Text == "Intitulé")
{
PhraseValidation.Visibility = Visibility.Visible;
}
else
{
PhraseValidation.Visibility = Visibility.Hidden;
InitBDD bdd = new InitBDD();
var con = bdd.ConnectionBDD();
j.Date = laDate.SelectedDate.ToString(); //convertDate
j.Intitule = unIntitule.Text;
j.Fragment = Int32.Parse(nbFragments.Text);
j.Insert();
RemplissageFragments rf = new RemplissageFragments(j);
this.NavigationService.Navigate(rf);
}
}
public void Insert()
{
InitBDD bdd = new InitBDD();
var con = bdd.ConnectionBDD();
con.Open();
var cmd = new SQLiteCommand(con);
//this.MotClef = "'" + this.MotClef + "'";
//var test = "\'" + this.MotClef + "\'";
cmd.CommandText = "INSERT INTO pomodoro(motClef, heure, idJour) VALUES(\'" + this.MotClef + "\',\'" + this.Heure + "\'," + IdJour + ")";
cmd.ExecuteNonQuery();
con.Close();
}
public Accueil()
{
InitializeComponent();
InitBDD bdd = new InitBDD();
var con = bdd.ConnectionBDD();
con.Open();
var cmd = new SQLiteCommand(con);
cmd.CommandText = "SELECT * FROM jour";
cmd.ExecuteNonQuery();
SQLiteDataReader reader = cmd.ExecuteReader();
List <Jour> listJ = new List <Jour>();
/*Button b = new Button();
* DataGridTextColumn col = new DataGridTextColumn();
* col.Header = "Voir";
* DataGrid.Columns.Add(col);*/
while (reader.Read())
{
//DataGrid.Items.Add();
listJ.Add(new Jour()
{
Id = reader.GetInt32(0), Date = reader.GetString(1), Intitule = reader.GetString(2), Fragment = reader.GetInt32(3)
});
DataGrid.ItemsSource = listJ;
/*var idThis = reader.GetInt32(0);
* var dateThis = reader.GetString(1);
* var intituleThis = reader.GetString(1);*/
//Jour j = new Jour();
//top = top + 10;
/*left = left + 10;
* j.id = reader.GetInt32(0);
* j.date = reader.GetString(1);
* j.intitule = reader.GetString(2);
* TextBlock tb = new TextBlock();
* Thickness marginThickness = tb.Margin;
* marginThickness.Left = left;
* tb.Height = 20;
* tb.Width = 50;
* tb.Text = j.intitule.ToString();
* RootGrid.Children.Add(tb);*/
}
}
public void Insert()
{
InitBDD bdd = new InitBDD();
var con = bdd.ConnectionBDD();
con.Open();
var cmd = new SQLiteCommand(con);
this.Intitule = "'" + this.Intitule + "'";
cmd.CommandText = "INSERT INTO jour(dateJour, intitule, fragment) VALUES(\'" + this.Date + "\'," + this.Intitule + "," + Fragment + ");";
cmd.ExecuteNonQuery();
long oui = con.LastInsertRowId;
Id = Convert.ToInt32(oui);
con.Close();
}
