public int DeleteQuestionaire(SQLiteQuestionaire sQLiteQuestionaire)
{
if (sQLiteQuestionaire != null)
{
return(dbConnection.Delete(sQLiteQuestionaire));
}
return(0);
}
public int UpdateReport(Questionaire questionaire)
{
try
{
SQLiteQuestionaire sQLiteQuestionaire = this.GetSQLiteQuestionaires().Find(x => JsonConvert.DeserializeObject <Questionaire>(x.sqliteQuestionaire).Key == questionaire.Key);
if (sQLiteQuestionaire != null)
{
return(dbConnection.Execute($"UPDATE SQLiteQuestionaire SET sqliteQuestionaire = ? WHERE ID = ?", JsonConvert.SerializeObject(questionaire), sQLiteQuestionaire.ID));
}
}
catch (Exception ex)
{
}
return(0);
}
public int SaveSQLiteQuestionaire(SQLiteQuestionaire sQLiteQuestionaire)
{
QSections._questionaireStatus = QuestionaireStatus.Modify;
return(dbConnection.Insert(sQLiteQuestionaire));
}