public static void UpdateAll(HabitModel habit)
{
string textCommand = "update Habit set progress='" + habit.progress + "', _minus0='" + habit._minus0 + "', _minus1='" + habit._minus1 +
"', _minus2='" + habit._minus2 + "', _minus3='" + habit._minus3 + "', _minus4='" + habit._minus4 + "', _minus0Date='" + habit._minus0Date +
"', _minus1Date='" + habit._minus1Date + "', _minus2Date='" + habit._minus2Date + "', _minus3Date='" + habit._minus3Date +
"', _minus4Date='" + habit._minus4Date + "' where habitName='" + habit.habitName + "'";
ExecuteQuery(textCommand);
}
public static void SaveHabit(HabitModel habit)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionStr()))
{
cnn.Execute($"insert into Habit (habitName, startDate, progress, _minus0, _minus1, _minus2, _minus3, _minus4, _minus0Date, _minus1Date, _minus2Date, _minus3Date, _minus4Date)" +
$" values (@habitName, '{habit.startDate}', '{habit.progress}'," +
$" '{habit._minus0}', '{habit._minus1}', '{habit._minus2}', '{habit._minus3}', '{habit._minus4}'," +
$" '{habit._minus0Date}', '{habit._minus1Date}', '{habit._minus2Date}', '{habit._minus3Date}', '{habit._minus4Date}')", param: habit);
}
}
private void AddBtn_Click(object sender, RoutedEventArgs e)
{
string name = nameTxtBox.Text;
if ((name == "TextBox") || (name == "") || (name == " "))
{
return;
}
try
{
HabitModel habit = new HabitModel(name);
SqliteDataAccess.SaveHabit(habit);
UpdateSource();
ListofHabits.ItemsSource = listOfHabitModels;
}
catch
{
ResetTxtBox(nameTxtBox);
}
finally
{
ResetTxtBox(nameTxtBox);
}
}