public List <EnvironmentalData> Get()
{
List <EnvironmentalData> envDataList = new List <EnvironmentalData> {
};
var result = _context.Facts.GroupBy(x => x.RoomId)
.Select(x => x.OrderByDescending(y => y.DateId)
.OrderByDescending(z => z.TimeId).First());
//pull data out of every dim table to create a EnvironmentalData object
foreach (var x in result)
{
string roomName = _context.RoomDim.Find(x.RoomId).Name;
string timeString = _context.TimeDim.Find(x.TimeId).Time.ToString();
string dateString = _context.DateDim.Find(x.DateId).Date.ToShortDateString();
EnvironmentalData envDataObject = new EnvironmentalData
{
location = roomName,
temperature = x.TempC.ToString(),
time = timeString,
date = dateString,
co2 = x.Co2.ToString()
};
envDataList.Add(envDataObject);
}
return(envDataList);
}
public List <EnvironmentalData> getAllEnvironmentalData()
{
List <EnvironmentalData> list = new List <EnvironmentalData>();
EnvironmentalData aTestEnvironmentalData1 = new EnvironmentalData("D304", 767, 24, "2012");
EnvironmentalData aTestEnvironmentalData2 = new EnvironmentalData("C201", 891, 22, "2013");
list.Add(aTestEnvironmentalData1);
list.Add(aTestEnvironmentalData2);
return(list);
}
public EnvironmentalData Get(int id)
{
var result = _context.Facts.Where(x => x.RoomId == id)
.OrderByDescending(x => x.DateId)
.OrderByDescending(x => x.TimeId).First();
string roomName = _context.RoomDim.Find(id).Name;
string timeString = _context.TimeDim.Find(result.TimeId).Time.ToString();
string dateString = _context.DateDim.Find(result.DateId).Date.ToShortDateString();
EnvironmentalData data = new EnvironmentalData {
location = roomName,
temperature = result.TempC.ToString(),
time = timeString,
date = dateString,
co2 = result.Co2.ToString()
};
return(data);
}
public override void UpdateState(Player player)
{
if (InputManager.ButtonJump)
{
player.currentState = PlayerStateKeeper.stateJump;
}
else if (InputManager.AxisUpDown > 0 && player.InteractionObject is Rope)
{
player.currentState = PlayerStateKeeper.stateMoveToObjectAction;
player.currentState.nextState = PlayerStateKeeper.stateClimb;
player.PlayerRigidbody2D.bodyType = RigidbodyType2D.Kinematic;
player.PlayerRigidbody2D.velocity = Vector2.zero;
}
if (InputManager.AxisUpDown < 0 && player.InteractionObject is RopeTop)
{
player.currentState = PlayerStateKeeper.stateMoveToObjectAction;
player.currentState.nextState = PlayerStateKeeper.stateClimbedToBotton;
player.PlayerRigidbody2D.bodyType = RigidbodyType2D.Kinematic;
player.PlayerRigidbody2D.velocity = Vector2.zero;
}
else if (InputManager.ButtonSomersault)
{
player.currentState = PlayerStateKeeper.stateSamersault;
}
else if (!EnvironmentalData.IsOnGround(player.DataTransform.PointDown))
{
player.currentState = PlayerStateKeeper.stateFall;
}
else if (InputManager.ButtonHealing && player.Health.IsHealingAllowed())
{
player.currentState = PlayerStateKeeper.stateHealing;
}
else if (InputManager.ButtonUse &&
InteractionObject.TryGetObject <UsedObject>(player.InteractionObject, out UsedObject usedObject) && usedObject.IsCanUse())
{
player.currentState = PlayerStateKeeper.stateMoveToObjectAction;
player.currentState.nextState = PlayerStateKeeper.stateUseObject;
player.PlayerRigidbody2D.bodyType = RigidbodyType2D.Kinematic;
player.PlayerRigidbody2D.velocity = Vector2.zero;
}
}
