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());
}
/* ------------------------------ Add Relation ------------------------------ */
public void AddRelation(string Alias, int PersonID, int ContactID, int RemainingTime)
{
/// <summary> Adds an relation between two people
/// <para> Doing this by adding the connection to Person_Person table
string executeString = string.Format("INSERT INTO Student29.dbo.Person_Person (Alias, PersonID, ContactID, RemainingTime) VALUES ('{0}', {1}, {2}, {3})", Alias, PersonID, ContactID, RemainingTime);
Person_PersonTable.SendQuery(executeString);
Debug.WriteLine("Successfully sent: " + executeString);
}
public void UpdateDatetime(Person_PersonTable person_PersonTable)
{
/// <summary> Adds an relation between two people
/// <para> Doing this by adding the connection to Person_Person table
string executeString = string.Format("UPDATE Student29.dbo.Person_Person SET lastCommunication ='{0}' where ContactID='{1}'", person_PersonTable.lastCommunication, person_PersonTable.ContactID);
Person_PersonTable.SendQuery(executeString);
Debug.WriteLine("Successfully sent: " + executeString);
}
/* ------------------------ Change Remaining Time ------------------------ */
public void ChangeRemainingTime(int PersonID)
{
string executeString = string.Format("UPDATE Student29.dbo.Person_Person SET RemainingTime =- 1", PersonID);
Person_PersonTable.SendQuery(executeString);
}
