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