コード例 #1
0
ファイル: Functions.cs プロジェクト: CarverLab/Oyster
        internal Recordings GetRecordingsBySessionId(int SessionId)
        {
            try
            {
                Recordings X = new Recordings();
                string sSQL = "Select * FROM tblRecording WHERE SessionId = " + SessionId;

                DataSet DS = RF.GetDataSet(sSQL);

                foreach(DataRow R in DS.Tables[0].Rows)
                {
                    Recording Rec = null;
                    Rec = FillRecording(R);
                    if(Rec != null)
                        X.Add(Rec);
                }
                return X;
            }
            catch(Exception Err)
            {
                throw new ApplicationException(Err.Message);
            }
        }
コード例 #2
0
ファイル: Functions.cs プロジェクト: CarverLab/Oyster
        internal Recordings GetAllRecordingsMarkedForDeletion()
        {
            try
            {
                Recordings X = new Recordings();
                string sSQL = "Select * FROM tblRecording WHERE IsMarkedForDeletion <> 0";
                DataSet DS = RF.GetDataSet(sSQL);

                foreach(DataRow r in DS.Tables[0].Rows)
                {
                    //int RecordingId = Convert.ToInt32(r[0]);
                    Recording Rec = FillRecording(r);
                    X.Add(Rec);
                }

                if(X.Count == 0)
                    X = null;

                return X;
            }
            catch(Exception Err)
            {
                throw new ApplicationException(Err.Message);
            }
        }