private VoteAnswersEntity PopulateEntity(IDataReader reader) { //Create a new VoteAnswers object VoteAnswersEntity voteAnswers = new VoteAnswersEntity(); //Fill the object with data //AnswerId if (reader["AnswerId"] != DBNull.Value) { voteAnswers.AnswerId = (int)reader["AnswerId"]; } //QuesID if (reader["QuesID"] != DBNull.Value) { voteAnswers.QuesID = (int)reader["QuesID"]; } //AnswerText if (reader["AnswerText"] != DBNull.Value) { voteAnswers.AnswerText = (string)reader["AnswerText"]; } //HitsCount if (reader["HitsCount"] != DBNull.Value) { voteAnswers.HitsCount = (int)reader["HitsCount"]; } //Return the populated object return(voteAnswers); }
//---------------------------------------------------------- #endregion #region ----------------InsertTestingDataForVoteModule--------------- //---------------------------------------------------------- //InsertTestingDataForVoteModule //---------------------------------------------------------- public void InsertTestingDataForVoteModule() { //--------------------------------------------------------------------- VoteQuestionsEntity ArVoteQuestions = new VoteQuestionsEntity(); string ArQuestionText = "سؤال تجريبي {0} ؟"; ArVoteQuestions.AnswersCount = 4; ArVoteQuestions.IsMain = true; ArVoteQuestions.LangID = Languages.Ar; //--------------------------------------------------------------------- string ArAnswer = "إجابة رقم "; VoteAnswersEntity ArVoteAnswer = new VoteAnswersEntity(); //--------------------------------------------------------------------- //--------------------------------------------------------------------- VoteQuestionsEntity EnVoteQuestions = new VoteQuestionsEntity(); string EnQuestionText = "Testing Question {0} ?"; EnVoteQuestions.AnswersCount = 4; EnVoteQuestions.IsMain = true; EnVoteQuestions.LangID = Languages.En; //--------------------------------------------------------------------- string EnAnswer = "Answer no "; VoteAnswersEntity EnVoteAnswer = new VoteAnswersEntity(); //--------------------------------------------------------------------- for (int i = 1; i <= 2; i++) { if (SiteSettings.Languages_HasArabicLanguages) { ArVoteQuestions.QuestionText = string.Format(ArQuestionText, i.ToString()); bool ArResult = VoteQuestionsFactory.Save(ArVoteQuestions, SPOperation.Insert); if (ArResult) { for (int b = 1; b <= 4; b++) { ArVoteAnswer.QuesID = ArVoteQuestions.QuesID; ArVoteAnswer.AnswerText = ArAnswer + b.ToString(); VoteAnswersFactory.Create(ArVoteAnswer); } } } if (SiteSettings.Languages_HasEnglishLanguages) { EnVoteQuestions.QuestionText = string.Format(EnQuestionText, i.ToString()); bool EnResult = VoteQuestionsFactory.Save(EnVoteQuestions, SPOperation.Insert); if (EnResult) { for (int b = 1; b <= 4; b++) { EnVoteAnswer.QuesID = EnVoteQuestions.QuesID; EnVoteAnswer.AnswerText = EnAnswer + b.ToString(); VoteAnswersFactory.Create(EnVoteAnswer); } } } } }
//------------------------------------------ #endregion #region --------------Create-------------- /// <summary> /// Converts the VoteAnswers object properties to SQL paramters and executes the create VoteAnswers procedure /// and updates the VoteAnswers object with the SQL data by reference. /// <example>[Example]bool status=VoteAnswersSqlDataPrvider.Instance.Create(voteAnswers);.</example> /// </summary> /// <param name="voteAnswers">The VoteAnswers object.</param> /// <returns>The status of create query.</returns> public bool Create(VoteAnswersEntity voteAnswers) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("VoteAnswers_Create", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@AnswerId", SqlDbType.Int, 4).Direction = ParameterDirection.Output; myCommand.Parameters.Add("@QuesID", SqlDbType.Int, 4).Value = voteAnswers.QuesID; myCommand.Parameters.Add("@AnswerText", SqlDbType.NVarChar, 128).Value = voteAnswers.AnswerText; // Execute the command bool status = false; myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { status = true; //Get ID value from database and set it in object voteAnswers.AnswerId = (int)myCommand.Parameters["@AnswerId"].Value; } myConnection.Close(); return(status); } }
public static bool Create(VoteAnswersEntity voteAnswers) { return(VoteAnswersSqlDataPrvider.Instance.Create(voteAnswers)); }