protected int SetVariable(string name, string value) { if (elements[name].Write == false) { throw new Exception(Translations.Score_SetValue_Requested_variable_is_read_only); } List <TblVarsScore> list = ServerModel.DB.Query <TblVarsScore>( new AndCondition( new CompareCondition <int>( DataObject.Schema.LearnerSessionRef, new ValueCondition <int>(LearnerSessionId), COMPARE_KIND.EQUAL), new CompareCondition <string>( DataObject.Schema.Name, new ValueCondition <string>(name), COMPARE_KIND.EQUAL))); if (list.Count > 0) { list[0].Value = value; ServerModel.DB.Update <TblVarsScore>(list[0]); return(list[0].ID); } else { TblVarsScore lsv = new TblVarsScore { LearnerSessionRef = LearnerSessionId, Name = name, Value = value }; return(ServerModel.DB.Insert <TblVarsScore>(lsv)); } }
protected int SetVariable(string name, string value) { if (elements[name].Write == false) { throw new Exception(Translations.Score_SetValue_Requested_variable_is_read_only); } List<TblVarsScore> list = ServerModel.DB.Query<TblVarsScore>( new AndCondition( new CompareCondition<int>( DataObject.Schema.LearnerSessionRef, new ValueCondition<int>(LearnerSessionId), COMPARE_KIND.EQUAL), new CompareCondition<string>( DataObject.Schema.Name, new ValueCondition<string>(name), COMPARE_KIND.EQUAL))); if (list.Count > 0) { list[0].Value = value; ServerModel.DB.Update<TblVarsScore>(list[0]); return list[0].ID; } else { TblVarsScore lsv = new TblVarsScore { LearnerSessionRef = LearnerSessionId, Name = name, Value = value }; return ServerModel.DB.Insert<TblVarsScore>(lsv); } }