private static void SetParameters(Business.DataObjectPollQuestion item, SqlParameterCollection parameters) { parameters.AddWithValue("@PollType", (int)item.PollType); parameters.AddWithValue("@AnonymousAllowed", item.AnonymousAllowed); parameters.AddWithValue("@ShowAnswerCount", item.ShowAnswerCount); parameters.AddWithValue("@ShowResult", item.ShowResult); parameters.AddWithValue("@PollLayout", (int)item.PollLayout); parameters.AddWithValue("@Answers", item.answerXml.OuterXml); if (!string.IsNullOrEmpty(item.TextRight)) { parameters.AddWithValue("@TextRight", item.TextRight); } else { parameters.AddWithValue("@TextRight", DBNull.Value); } if (!string.IsNullOrEmpty(item.TextFalse)) { parameters.AddWithValue("@TextFalse", item.TextFalse); } else { parameters.AddWithValue("@TextFalse", DBNull.Value); } if (!string.IsNullOrEmpty(item.TextPartially)) { parameters.AddWithValue("@TextPartially", item.TextPartially); } else { parameters.AddWithValue("@TextPartially", DBNull.Value); } }
public static void FillObject(Business.DataObjectPollQuestion item, SqlDataReader sqlReader) { item.PollType = (Business.DataObjectPollQuestion.QuestionPollType)(int)(sqlReader["PollType"]); item.AnonymousAllowed = bool.Parse(sqlReader["AnonymousAllowed"].ToString()); item.ShowResult = (Business.DataObjectPollQuestion.QuestionShowResult)(int)(sqlReader["ShowResult"]); item.ShowAnswerCount = (Business.DataObjectPollQuestion.QuestionShowAnswerCount)(int)(sqlReader["ShowAnswerCount"]); item.PollLayout = (Business.DataObjectPollQuestion.QuestionPollLayout)(int)(sqlReader["PollLayout"]); if (sqlReader["Answers"] != DBNull.Value) { item.answerXml.LoadXml(sqlReader["Answers"].ToString()); } item.TextRight = sqlReader["TextRight"].ToString(); item.TextFalse = sqlReader["TextFalse"].ToString(); item.TextPartially = sqlReader["TextPartially"].ToString(); }
public static string GetUpdateSQL(Business.DataObjectPollQuestion item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("UPDATE hiobj_PollQuestion SET [PollType]=@PollType,[AnonymousAllowed]=@AnonymousAllowed,[ShowAnswerCount]=@ShowAnswerCount,[ShowResult]=@ShowResult,[PollLayout]=@PollLayout,[Answers]=@Answers,[TextRight]=@TextRight,[TextFalse]=@TextFalse,[TextPartially]=@TextPartially"); }
public static string GetInsertSQL(Business.DataObjectPollQuestion item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("INSERT INTO hiobj_PollQuestion ([OBJ_ID],[PollType],[AnonymousAllowed],[ShowAnswerCount],[ShowResult],[PollLayout],[Answers],[TextRight],[TextFalse],[TextPartially]) VALUES (@OBJ_ID,@PollType,@AnonymousAllowed,@ShowAnswerCount,@ShowResult,@PollLayout,@Answers,@TextRight,@TextFalse,@TextPartially)"); }