public static void Update(UserPostingQuestionResponse entry, LcDatabase sharedDb = null) { using (var db = new LcDatabase(sharedDb)) { db.Execute(sqlUpdate, entry.userPostingID, entry.questionID, Newtonsoft.Json.JsonConvert.SerializeObject(entry.responses)); } }
public static void Insert(UserPostingQuestionResponse entry, LcDatabase sharedDb = null) { using (var db = new LcDatabase(sharedDb)) { db.Execute(sqlInsert, entry.userPostingID, entry.questionID, entry.questionTypeID, entry.question, entry.label, entry.helpBlock, entry.legend, Newtonsoft.Json.JsonConvert.SerializeObject(entry.options), Newtonsoft.Json.JsonConvert.SerializeObject(entry.responses), Newtonsoft.Json.JsonConvert.SerializeObject(entry.branchLogic)); } }
public static int Set(UserPosting entry, Locale locale, LcDatabase sharedDb = null) { using (var db = new LcDatabase(sharedDb)) { var neededSpecializationsText = string.Join(",", entry.neededSpecializationIDs); var desiredSpecializationsText = string.Join(",", entry.desiredSpecializationIDs); db.Execute("BEGIN TRANSACTION"); var id = 0; if (entry.userPostingID > 0) { db.QueryValue(sqlUpdate, entry.userID, entry.userPostingID, entry.title, neededSpecializationsText, desiredSpecializationsText ); id = entry.userPostingID; foreach (var qr in entry.questionsResponses) { qr.userPostingID = id; UserPostingQuestionResponse.Update(qr, db); } } else { id = (int)db.QueryValue(sqlInsert, entry.userID, entry.solutionID, entry.postingTemplateID, entry.statusID, entry.title, neededSpecializationsText, desiredSpecializationsText, locale.languageID, locale.countryID, entry.userID ); foreach (var qr in entry.questionsResponses) { qr.userPostingID = id; UserPostingQuestionResponse.Insert(qr, db); } } db.Execute("COMMIT TRANSACTION"); return(id); } }
public void FillQuestionsResponses() { questionsResponses = UserPostingQuestionResponse.List(userPostingID); }