Esempio n. 1
0
            private static List <viewPageViewCount> SelectRows(string SQLString, Dictionary <Columns.ColumnNames, Object> ParameterDictionary)
            {
                List <viewPageViewCount> returnValue = new List <viewPageViewCount>();

                using (SqlConnection connection = new SqlConnection(DBL.Lookups.GetConnString()))
                {
                    using (SqlCommand Command = new SqlCommand(SQLString, connection))
                    {
                        Command.CommandType = CommandType.Text;
                        if (ParameterDictionary != null)
                        {
                            int i = 1;
                            foreach (Columns.ColumnNames key in ParameterDictionary.Keys)
                            {
                                if (ParameterDictionary[key].GetType() == typeof(string)) //TODO: TEST THIS?
                                {
                                    Command.Parameters.Add(new SqlParameter("@SearchValue" + i.ToString(), ParameterDictionary[key].ToString().Replace("*", "%")));
                                }
                                else
                                {
                                    Command.Parameters.Add(new SqlParameter("@SearchValue" + i.ToString(), ParameterDictionary[key]));
                                }
                                i += 1;
                            }
                        }
                        connection.Open();

                        try
                        {
                            IDataReader dR = Command.ExecuteReader();
                            do
                            {
                                viewPageViewCount MyviewPageViewCount = new viewPageViewCount(0);
                                if (dR[Columns.PageID] == DBNull.Value)
                                {
                                    MyviewPageViewCount.PageID = (System.Int32)dR[Columns.PageID];
                                }
                                if (dR[Columns.SumOfViewCount] == DBNull.Value)
                                {
                                    MyviewPageViewCount.SumOfViewCount = (System.Int32)dR[Columns.SumOfViewCount];
                                }
                            } while (dR.Read());
                            dR.Close();
                            dR = null;
                        }
                        catch (Exception ex)
                        {
                            System.Diagnostics.StackTrace ST = new System.Diagnostics.StackTrace();
                            System.Diagnostics.StackFrame SF = ST.GetFrame(0); // Current Method
                            DBL.Errors.LogError(SF.GetMethod().ReflectedType.Name + ":" + SF.GetMethod().Name, ex.Message);
                        }
                        finally
                        {
                            connection.Close();
                        }
                    }
                }
                return(returnValue);
            }
Esempio n. 2
0
            public static List <viewPageViewCount> SelectDynamicList(string WhereClause, string SortOrder, int NumRows)
            {
                List <viewPageViewCount> RetVal = new List <viewPageViewCount>();

                using (SqlConnection connection = new SqlConnection(DBL.Lookups.GetConnString()))
                {
                    string strSQL = "SELECT * " + NumRows + " FROM [viewPageViewCount]";
                    if (!WhereClause.Equals(null))
                    {
                        strSQL += " WHERE " + WhereClause;
                    }
                    if (!SortOrder.Equals(null))
                    {
                        strSQL += " ORDER BY " + SortOrder;
                    }
                    using (SqlCommand Command = new SqlCommand(strSQL, connection))
                    {
                        Command.CommandType = CommandType.Text;
                        connection.Open();
                        try
                        {
                            IDataReader dR = Command.ExecuteReader();
                            do
                            {
                                viewPageViewCount newRow = new viewPageViewCount(0);
                                if (dR[Columns.PageID] != DBNull.Value)
                                {
                                    newRow.PageID = (System.Int32)dR[Columns.PageID];
                                }
                                if (dR[Columns.SumOfViewCount] != DBNull.Value)
                                {
                                    newRow.SumOfViewCount = (System.Int32)dR[Columns.SumOfViewCount];
                                }
                                RetVal.Add(newRow);
                            } while (dR.Read());
                            dR.Close();
                            dR = null;
                        }
                        catch (Exception ex)
                        {
                            System.Diagnostics.StackTrace ST = new System.Diagnostics.StackTrace();
                            System.Diagnostics.StackFrame SF = ST.GetFrame(0); // Current Method
                            DBL.Errors.LogError(SF.GetMethod().ReflectedType.Name + ":" + SF.GetMethod().Name, ex.Message);
                        }
                        finally
                        {
                            connection.Close();
                        }
                    }
                }
                return(RetVal);
            }
Esempio n. 3
0
            public static List <viewPageViewCount> Search(IDictionary <string, Object> SearchValues)
            {
                List <viewPageViewCount> returnValue = new List <viewPageViewCount>();

                using (SqlConnection connection = new SqlConnection(DBL.Lookups.GetConnString()))
                {
                    string strSQL = "SELECT [PageID], [SumOfViewCount] FROM viewPageViewCount";
                    if (SearchValues.Count > 0)
                    {
                        strSQL += " WHERE ";
                        int i = 1;
                        foreach (string key in SearchValues.Keys)
                        {
                            if (SearchValues[key].GetType() == typeof(string))
                            {
                                strSQL += key + " LIKE @" + key;
                            }
                            else
                            {
                                strSQL += key + " = @" + key;
                            }
                            if (i < SearchValues.Count)
                            {
                                strSQL += " AND ";
                            }
                            i += 1;
                        }
                    }

                    using (SqlCommand Command = new SqlCommand(strSQL, connection))
                    {
                        Command.CommandType = CommandType.Text;
                        int i = 1;
                        foreach (string key in SearchValues.Keys)
                        {
                            if (SearchValues[key].GetType() == typeof(string))
                            {
                                Command.Parameters.Add(new SqlParameter("@SearchValue" + i.ToString(), SearchValues[key].ToString().Replace("*", "%")));
                            }
                            else
                            {
                                Command.Parameters.Add(new SqlParameter("@SearchValue" + i.ToString(), SearchValues[key]));
                            }
                            i += 1;
                        }
                        connection.Open();
                        try
                        {
                            IDataReader dR = Command.ExecuteReader();
                            do
                            {
                                viewPageViewCount MyviewPageViewCount = new viewPageViewCount(0);
                                if (dR[Columns.PageID] == DBNull.Value)
                                {
                                    MyviewPageViewCount.PageID = (System.Int32)dR[Columns.PageID];
                                }
                                if (dR[Columns.SumOfViewCount] == DBNull.Value)
                                {
                                    MyviewPageViewCount.SumOfViewCount = (System.Int32)dR[Columns.SumOfViewCount];
                                }
                                returnValue.Add(MyviewPageViewCount);
                            } while (dR.Read());
                            dR.Close();
                            dR = null;
                        }
                        catch (Exception ex)
                        {
                            System.Diagnostics.StackTrace ST = new System.Diagnostics.StackTrace();
                            System.Diagnostics.StackFrame SF = ST.GetFrame(0); // Current Method
                            DBL.Errors.LogError(SF.GetMethod().ReflectedType.Name + ":" + SF.GetMethod().Name, ex.Message);
                        }
                        finally
                        {
                            connection.Close();
                        }
                    }
                }
                return(returnValue);
            }