BLL.Dao.TimelapseDao.GetListByServerIP C# (CSharp) Метод

        public static List<Timelapse> GetListByServerIP(string serverIp, TimelapsePrivacy? privacy, TimelapseStatus? status)
        {
            try
            {
                string s = (status.HasValue ? " AND Status = " + ((int)status.Value) : "");
                string p = (privacy.HasValue ? " AND Privacy = " + ((int)privacy.Value) : "");
                string sql = "Select * FROM Timelapses WHERE ServerIP=@ServerIP AND IsDeleted=0 " + s + p + " ORDER BY CreatedDT DESC";
                var p1 = new SqlParameter("@ServerIP", serverIp);
                var cmd = new SqlCommand { CommandText = sql, CommandType = CommandType.Text };
                cmd.Parameters.Add(p1);
                cmd.Connection = Connection.DbConnection;
                Connection.OpenConnection();
                var dr = GetListFromDataReader(cmd.ExecuteReader());
                Connection.CloseConnection();
                return dr;
            }
            catch (Exception ex)
            {
                if (Connection.DbConnection.State == ConnectionState.Closed)
                    Utils.FileLog("TimelapseDao GetListByServerIP(string serverIp) " + ex.Message);
                else
                    Utils.FileLog(string.Format("TimelapseDao GetListByServerIP(string serverIp) serverIp={0}<br />{1}", serverIp, ex.Message));
                return new List<Timelapse>();
            }
            finally
            {
                Connection.CloseConnection();
            }
        }