public List <ProfileQuestion> GetList(List <Dictionary <string, object> > dictList) { data.Clear(); foreach (Dictionary <string, object> dict in dictList) { foreach (KeyValuePair <string, object> obj in dict) { ProfileQuestion objectValue = (ProfileQuestion)obj.Value; objectValue.FillFromDictionary(dict); data.Add(objectValue); } } return(data); }
public virtual bool SetProfileQuestionByUuid(ProfileQuestion obj) { return act.SetProfileQuestionByUuid(DEFAULT_SET_TYPE, obj); }
public virtual bool SetProfileQuestionByUuid(SetType set_type, ProfileQuestion obj) { return act.SetProfileQuestionByUuid(ConvertSetTypeToString(set_type), obj); }
//------------------------------------------------------------------------------ public virtual bool SetProfileQuestionByUuid(string set_type, ProfileQuestion obj) { return act.SetProfileQuestionByUuid(set_type, obj); }
public virtual bool SetProfileQuestionByChannelIdByQuestionIdByProfileId(ProfileQuestion obj) { return act.SetProfileQuestionByChannelIdByQuestionIdByProfileId(DEFAULT_SET_TYPE, obj); }
public virtual bool SetProfileQuestionByChannelIdByQuestionIdByProfileId(SetType set_type, ProfileQuestion obj) { return act.SetProfileQuestionByChannelIdByQuestionIdByProfileId(ConvertSetTypeToString(set_type), obj); }
//------------------------------------------------------------------------------ public virtual bool SetProfileQuestionByChannelIdByQuestionIdByProfileId(string set_type, ProfileQuestion obj) { return act.SetProfileQuestionByChannelIdByQuestionIdByProfileId(set_type, obj); }
//------------------------------------------------------------------------------ public virtual bool SetProfileQuestionByUuid(string set_type, ProfileQuestion obj) { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@set_type", set_type)); parameters.Add(new SqlParameter("@status", obj.status)); parameters.Add(new SqlParameter("@profile_id", obj.profile_id)); parameters.Add(new SqlParameter("@active", obj.active)); parameters.Add(new SqlParameter("@data", obj.data)); parameters.Add(new SqlParameter("@uuid", obj.uuid)); parameters.Add(new SqlParameter("@date_modified", obj.date_modified)); parameters.Add(new SqlParameter("@org_id", obj.org_id)); parameters.Add(new SqlParameter("@channel_id", obj.channel_id)); parameters.Add(new SqlParameter("@answer", obj.answer)); parameters.Add(new SqlParameter("@date_created", obj.date_created)); parameters.Add(new SqlParameter("@type", obj.type)); parameters.Add(new SqlParameter("@question_id", obj.question_id)); try { return (bool)data.ExecuteScalar( BasePlatformData.connectionString , CommandType.StoredProcedure , "usp_profile_question_set_by_uuid" , parameters ); } catch (Exception e){ log.Error(e); return false; } }
//------------------------------------------------------------------------------ public virtual void SetProfileQuestionByUuid() { ResponseProfileQuestionBool wrapper = new ResponseProfileQuestionBool(); wrapper.message = "Success"; wrapper.code = 0; wrapper.action = "profile-question/set/by-uuid"; ProfileQuestion obj = new ProfileQuestion(); string _status = util.GetParamValue(_context, "status"); if(!String.IsNullOrEmpty(_status)) obj.status = (string)_status; string _profile_id = util.GetParamValue(_context, "profile_id"); if(!String.IsNullOrEmpty(_profile_id)) obj.profile_id = (string)_profile_id; string _active = util.GetParamValue(_context, "active"); if(!String.IsNullOrEmpty(_active)) obj.active = Convert.ToBoolean(_active); string _data = util.GetParamValue(_context, "data"); if(!String.IsNullOrEmpty(_data)) obj.data = (string)_data; string _uuid = util.GetParamValue(_context, "uuid"); if(!String.IsNullOrEmpty(_uuid)) obj.uuid = (string)_uuid; string _date_modified = util.GetParamValue(_context, "date_modified"); if(!String.IsNullOrEmpty(_date_modified)) obj.date_modified = Convert.ToDateTime(_date_modified); else obj.date_modified = DateTime.Now; string _org_id = util.GetParamValue(_context, "org_id"); if(!String.IsNullOrEmpty(_org_id)) obj.org_id = (string)_org_id; string _channel_id = util.GetParamValue(_context, "channel_id"); if(!String.IsNullOrEmpty(_channel_id)) obj.channel_id = (string)_channel_id; string _answer = util.GetParamValue(_context, "answer"); if(!String.IsNullOrEmpty(_answer)) obj.answer = (string)_answer; string _date_created = util.GetParamValue(_context, "date_created"); if(!String.IsNullOrEmpty(_date_created)) obj.date_created = Convert.ToDateTime(_date_created); else obj.date_created = DateTime.Now; string _type = util.GetParamValue(_context, "type"); if(!String.IsNullOrEmpty(_type)) obj.type = (string)_type; string _question_id = util.GetParamValue(_context, "question_id"); if(!String.IsNullOrEmpty(_question_id)) obj.question_id = (string)_question_id; // get data wrapper.data = api.SetProfileQuestionByUuid(obj); util.SerializeTypeJSONToResponse(_context, wrapper); }
//------------------------------------------------------------------------------ public virtual bool SetProfileQuestionByQuestionIdByProfileId(string set_type, ProfileQuestion obj) { List<NpgsqlParameter> parameters = new List<NpgsqlParameter>(); parameters.Add(new NpgsqlParameter("in_set_type", set_type)); parameters.Add(new NpgsqlParameter("in_status", obj.status)); parameters.Add(new NpgsqlParameter("in_profile_id", obj.profile_id)); parameters.Add(new NpgsqlParameter("in_active", obj.active)); parameters.Add(new NpgsqlParameter("in_data", obj.data)); parameters.Add(new NpgsqlParameter("in_uuid", obj.uuid)); parameters.Add(new NpgsqlParameter("in_date_modified", obj.date_modified)); parameters.Add(new NpgsqlParameter("in_org_id", obj.org_id)); parameters.Add(new NpgsqlParameter("in_channel_id", obj.channel_id)); parameters.Add(new NpgsqlParameter("in_answer", obj.answer)); parameters.Add(new NpgsqlParameter("in_date_created", obj.date_created)); parameters.Add(new NpgsqlParameter("in_type", obj.type)); parameters.Add(new NpgsqlParameter("in_question_id", obj.question_id)); try { return Convert.ToBoolean(data.ExecuteScalar( BasePlatformData.connectionString , CommandType.StoredProcedure , "usp_profile_question_set_question_id_profile_id" , parameters )); } catch (Exception e){ log.Error(e); return false; } }
public virtual ProfileQuestion FillProfileQuestion(DataRow dr) { ProfileQuestion obj = new ProfileQuestion(); if (dr["status"] != null) obj.status = dataType.FillDataString(dr, "status"); if (dr["profile_id"] != null) obj.profile_id = dataType.FillDataString(dr, "profile_id"); if (dr["active"] != null) obj.active = dataType.FillDataBool(dr, "active"); if (dr["data"] != null) obj.data = dataType.FillDataString(dr, "data"); if (dr["uuid"] != null) obj.uuid = dataType.FillDataString(dr, "uuid"); if (dr["date_modified"] != null) obj.date_modified = dataType.FillDataDateTime(dr, "date_modified"); if (dr["org_id"] != null) obj.org_id = dataType.FillDataString(dr, "org_id"); if (dr["channel_id"] != null) obj.channel_id = dataType.FillDataString(dr, "channel_id"); if (dr["answer"] != null) obj.answer = dataType.FillDataString(dr, "answer"); if (dr["date_created"] != null) obj.date_created = dataType.FillDataDateTime(dr, "date_created"); if (dr["type"] != null) obj.type = dataType.FillDataString(dr, "type"); if (dr["question_id"] != null) obj.question_id = dataType.FillDataString(dr, "question_id"); return obj; }