Exemple #1
0
        public int GetRemainingTime(int PersonID, int ContactID)
        {
            string executeString = string.Format("SELECT RemainingTime FROM Student29.dbo.Person_Person WHERE PersonID = {0} AND ContactID = {1}", PersonID, ContactID);
            var    query         = Person_PersonTable.SendAndGetQuery(executeString);

            return(query.AsList()[0].RemainingTime);
        }
Exemple #2
0
        /* ------------------------------ List Relation ----------------------------- */
        public List <Person_PersonTable> ListRelation(int id)
        {
            /// <summary> Outputs an list where the query is returned
            string executeString = string.Format("EXEC SelectAllPersonRelation @Id = {0}", id);
            var    query         = Person_PersonTable.SendAndGetQuery(executeString);

            return(query.ToList());
        }