public Invitation GetServicedObjectWhere(string condition)
{
string query = string.Format("select * from Invitations where {0}", condition);
DataTable result = database.ExecuteQuery(query);
return(new Invitation()
{
Id = Convert.ToInt32(result.Rows[0]["id"]),
UserId = Convert.ToInt32(result.Rows[0]["user_id"]),
EventId = Convert.ToInt32(result.Rows[0]["event_id"])
});
}
public Game GetServicedObjectWhere(string condition)
{
string query = string.Format("select * from Games where {0}", condition);
DataTable result = database.ExecuteQuery(query);
return(new Game()
{
Id = Convert.ToInt32(result.Rows[0]["id"]),
Title = result.Rows[0]["title"].ToString(),
Description = result.Rows[0]["description"].ToString(),
Category = Convert.ToInt32(result.Rows[0]["category"]),
UserId = Convert.ToInt32(result.Rows[0]["user_id"])
});
}
public Event GetServicedObjectWhere(string condition)
{
string query = string.Format("select * from Events where {0}", condition);
DataTable result = database.ExecuteQuery(query);
return(new Event()
{
Id = Convert.ToInt32(result.Rows[0]["id"]),
Title = result.Rows[0]["title"].ToString(),
Description = result.Rows[0]["description"].ToString(),
Date = Convert.ToDateTime(result.Rows[0]["date"]),
UserId = Convert.ToInt32(result.Rows[0]["user_id"]),
GameId = Convert.ToInt32(result.Rows[0]["game_id"])
});
}
public User GetServicedObjectWhere(string condition)
{
string query = string.Format("select * from Users where {0}", condition);
DataTable result = database.ExecuteQuery(query);
if (result == null || result.Rows.Count == 0)
{
return(null);
}
return(new User()
{
Id = Convert.ToInt32(result.Rows[0]["id"]),
Name = result.Rows[0]["name"].ToString(),
LastName = result.Rows[0]["last_name"].ToString(),
Email = result.Rows[0]["email"].ToString(),
Password = result.Rows[0]["password"].ToString()
});
}