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); }
/* ------------------------------ 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()); }