// // DotNetNuke - http://www.dotnetnuke.com // Copyright (c) 2002-2005 // by Perpetual Motion Interactive Systems Inc. ( http://www.perpetualmotion.ca ) // // Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated // documentation files (the "Software"), to deal in the Software without restriction, including without limitation // the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and // to permit persons to whom the Software is furnished to do so, subject to the following conditions: // // The above copyright notice and this permission notice shall be included in all copies or substantial portions // of the Software. // // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED // TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL // THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF // CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER // DEALINGS IN THE SOFTWARE. // using System; using System.Collections.Generic; using System.Data; using DotNetNuke; namespace DotNetNuke.Modules.Survey { public class SurveyOptionController { static public List GetSurveyOptions(int SurveyId) { List SurveyOptionInfolist = new List(); using (IDataReader dr = DataProvider.Instance().GetSurveyOptions(SurveyId)) { while (dr.Read()) { SurveyOptionInfo colSurveyOptionInfo = new SurveyOptionInfo(); colSurveyOptionInfo.SurveyOptionId = Convert.ToInt32(dr["SurveyOptionID"]); colSurveyOptionInfo.OptionName = Convert.ToString(dr["OptionName"]); colSurveyOptionInfo.IsCorrect = Convert.ToBoolean(dr["IsCorrect"]); colSurveyOptionInfo.Votes = Convert.ToInt32(SurveyController.ConvertNullInteger(dr["Votes"])); colSurveyOptionInfo.ViewOrder = Convert.ToInt32(SurveyController.ConvertNullInteger(dr["ViewOrder"])); SurveyOptionInfolist.Add(colSurveyOptionInfo); } } return SurveyOptionInfolist; } public static void DeleteSurveyOption(SurveyOptionInfo objSurveyOption) { DataProvider.Instance().DeleteSurveyOption(objSurveyOption.SurveyOptionId); } public static int AddSurveyOption(SurveyOptionInfo objSurveyOption) { return ((int)(DataProvider.Instance().AddSurveyOption(objSurveyOption.SurveyId, objSurveyOption.OptionName, objSurveyOption.ViewOrder, objSurveyOption.IsCorrect))); } public static void UpdateSurveyOption(SurveyOptionInfo objSurveyOption) { DataProvider.Instance().UpdateSurveyOption(objSurveyOption.SurveyOptionId, objSurveyOption.OptionName, objSurveyOption.ViewOrder, objSurveyOption.IsCorrect); } public static void AddSurveyResult(SurveyOptionInfo objSurveyOption, int UserID) { DataProvider.Instance().AddSurveyResult(objSurveyOption.SurveyOptionId, UserID); } } }