///<Summary> ///Select Latest 10 Mentions ///This method returns all data rows in the table TweetMentions ///</Summary> ///<returns> ///IList-DAOTweetMentions. ///</returns> ///<parameters> /// ///</parameters> public static IList <DAOTweetMentions> SelectDistinctTopics(string userId) { SqlCommand command = new SqlCommand(); command.CommandText = InlineProcs.ctprTweetMentions_SelectDistinctTopics; command.CommandType = CommandType.Text; SqlConnection staticConnection = StaticSqlConnection; command.Connection = staticConnection; DataTable dt = new DataTable("TweetMentions"); SqlDataAdapter sqlAdapter = new SqlDataAdapter(command); try { command.Parameters.Add(new SqlParameter("@ErrorCode", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, null)); command.Parameters.Add(new SqlParameter("@UserId", SqlDbType.NVarChar, 4000, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Proposed, (object)userId ?? (object)DBNull.Value)); staticConnection.Open(); sqlAdapter.Fill(dt); int errorCode = (Int32)command.Parameters["@ErrorCode"].Value; if (errorCode > 1) { throw new Exception("procedure ctprTweetMentions_SelectAll returned error code: " + errorCode); } List <DAOTweetMentions> objList = new List <DAOTweetMentions>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { DAOTweetMentions retObj = new DAOTweetMentions(); //retObj._id = Convert.IsDBNull(row["Id"]) ? (Int64?)null : (Int64?)row["Id"]; //retObj._time = Convert.IsDBNull(row["time"]) ? DateTime.MinValue : (DateTime)row["time"]; retObj._topic = Convert.IsDBNull(row["topic"]) ? null : (string)row["topic"]; //retObj._count = Convert.IsDBNull(row["count"]) ? (Int64?)null : (Int64?)row["count"]; //retObj._avg = Convert.IsDBNull(row["avg"]) ? (double?)null : Math.Round((double)row["avg"], 2); //retObj._min = Convert.IsDBNull(row["min"]) ? (double?)null : (double?)row["min"]; //retObj._max = Convert.IsDBNull(row["max"]) ? (double?)null : (double?)row["max"]; //retObj._stdev = Convert.IsDBNull(row["stdev"]) ? (double?)null : (double?)row["stdev"]; objList.Add(retObj); } } return(objList); } catch { throw; } finally { staticConnection.Close(); command.Dispose(); } }
///<Summary> ///Select one row by primary key(s) ///This method returns one row from the table TweetMentions based on the primary key(s) ///</Summary> ///<returns> ///DAOTweetMentions ///</returns> ///<parameters> ///Int64? id ///</parameters> public static DAOTweetMentions SelectOne(Int64?id) { SqlCommand command = new SqlCommand(); command.CommandText = InlineProcs.ctprTweetMentions_SelectOne; command.CommandType = CommandType.Text; SqlConnection staticConnection = StaticSqlConnection; command.Connection = staticConnection; DataTable dt = new DataTable("TweetMentions"); SqlDataAdapter sqlAdapter = new SqlDataAdapter(command); try { command.Parameters.Add(new SqlParameter("@Id", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 19, 0, "", DataRowVersion.Proposed, (object)id ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@ErrorCode", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, null)); staticConnection.Open(); sqlAdapter.Fill(dt); int errorCode = (Int32)command.Parameters["@ErrorCode"].Value; if (errorCode > 1) { throw new Exception("procedure ctprTweetMentions_SelectOne returned error code: " + errorCode); } DAOTweetMentions retObj = null; if (dt.Rows.Count > 0) { retObj = new DAOTweetMentions(); retObj._id = Convert.IsDBNull(dt.Rows[0]["Id"]) ? (Int64?)null : (Int64?)dt.Rows[0]["Id"]; retObj._time = Convert.IsDBNull(dt.Rows[0]["time"]) ? DateTime.MinValue : (DateTime)dt.Rows[0]["time"]; retObj._topic = Convert.IsDBNull(dt.Rows[0]["topic"]) ? null : (string)dt.Rows[0]["topic"]; retObj._count = Convert.IsDBNull(dt.Rows[0]["count"]) ? (Int64?)null : (Int64?)dt.Rows[0]["count"]; retObj._avg = Convert.IsDBNull(dt.Rows[0]["avg"]) ? (double?)null : (double?)dt.Rows[0]["avg"]; retObj._min = Convert.IsDBNull(dt.Rows[0]["min"]) ? (double?)null : (double?)dt.Rows[0]["min"]; retObj._max = Convert.IsDBNull(dt.Rows[0]["max"]) ? (double?)null : (double?)dt.Rows[0]["max"]; retObj._stdev = Convert.IsDBNull(dt.Rows[0]["stdev"]) ? (double?)null : (double?)dt.Rows[0]["stdev"]; } return(retObj); } catch { throw; } finally { staticConnection.Close(); command.Dispose(); } }
///<Summary> ///</Summary> ///<returns> ///Int32 ///</returns> ///<parameters> ///DAOTweetMentions daoTweetMentions ///</parameters> public static Int32 SelectAllBySearchFieldsCount(DAOTweetMentions daoTweetMentions) { SqlCommand command = new SqlCommand(); command.CommandText = InlineProcs.ctprTweetMentions_SelectAllBySearchFieldsCount; command.CommandType = CommandType.Text; SqlConnection staticConnection = StaticSqlConnection; command.Connection = staticConnection; try { command.Parameters.Add(new SqlParameter("@Id", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 19, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Id ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@time", SqlDbType.DateTime, 8, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Time ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@topic", SqlDbType.NVarChar, 4000, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Topic ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@count", SqlDbType.BigInt, 8, ParameterDirection.Input, true, 19, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Count ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@avg", SqlDbType.Float, 8, ParameterDirection.Input, true, 53, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Avg ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@min", SqlDbType.Float, 8, ParameterDirection.Input, true, 53, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Min ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@max", SqlDbType.Float, 8, ParameterDirection.Input, true, 53, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Max ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@stdev", SqlDbType.Float, 8, ParameterDirection.Input, true, 53, 0, "", DataRowVersion.Proposed, (object)daoTweetMentions.Stdev ?? (object)DBNull.Value)); command.Parameters.Add(new SqlParameter("@ErrorCode", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, null)); staticConnection.Open(); Int32 retCount = (Int32)command.ExecuteScalar(); int errorCode = (Int32)command.Parameters["@ErrorCode"].Value; if (errorCode > 1) { throw new Exception("procedure ctprTweetMentions_SelectAllBySearchFieldsCount returned error code: " + errorCode); } return(retCount); } catch { throw; } finally { staticConnection.Close(); command.Dispose(); } }