public string UpdatePreview(PreviewObj model)
{
string message = "";
#region Update Archieve Item
string question = $"EXECUTE SP_UpdateArchieveItem '{model.Question.Id}','{model.Question.ExamId}','{model.Question.Stem}'";
_db.Database.SqlQuery <string>(question).FirstOrDefault();
#endregion
#region Delete Old Archieve Answers
string remove = $"EXECUTE SP_RemoveArchieveAnswer '{model.Question.Id}','{model.Question.ExamId}'";
message = _db.Database.SqlQuery <string>(remove).FirstOrDefault();
#endregion
#region Add New Archieve Answers
foreach (var answer in model.Answers)
{
string add = $"EXECUTE SP_AddArchieveAnswer '{model.Question.Id}','{model.Question.ExamId}','{answer.Text}','{answer.Status}'";
_db.Database.SqlQuery <string>(add).FirstOrDefault();
}
#endregion
return(message);
}
private void StopBuild()
{
Destroy(preview); //get rid of the preview
preview = null; //not sure if you need this actually
previewScript = null; //
isBuilding = false;
selector.TogglePanel(); //toggle the button panel back on
}
private void StopBuild()
{
Destroy(preview); //get rid of the preview
preview = null; //not sure if you need this actually
previewScript = null; //
selector.TogglePanel();
isBuilding = false;
FurnitureSelection.SetActive(false);
building?.Invoke(false);
if (curfurnGo != null)
{
Destroy(curfurnGo);
}
}
public void NewBuild(GameObject _go) //this gets called by one of the buttons
{
preview = Instantiate(_go, Vector3.zero, Quaternion.identity); //set the preview = to something
previewScript = preview.GetComponent <PreviewObj>(); //grab the script that is sitting on the preview
if (_go.name.Contains("512") || _go.name.Contains("513") || _go.name.Contains("514"))
{
preview.transform.position = new Vector3(0, -6.2f, 0);
}
else
{
preview.transform.position = new Vector3(0, -6f, 0);
}
//isBuilding = true;//we can now build
}
public TwitchStream(JToken twitchStreamData)
{
bool isPlaylist;
long id;
int viewers, videoHeight, delay;
double averageFps;
if (bool.TryParse(twitchStreamData.SelectToken("is_playlist").ToString(), out isPlaylist) && isPlaylist) _isPlaylist = true;
if (long.TryParse(twitchStreamData.SelectToken("_id").ToString(), out id)) _id = id;
if (int.TryParse(twitchStreamData.SelectToken("viewers").ToString(), out viewers)) _viewers = viewers;
if (int.TryParse(twitchStreamData.SelectToken("video_height").ToString(), out videoHeight)) _videoHeight = videoHeight;
if (int.TryParse(twitchStreamData.SelectToken("delay").ToString(), out delay)) _delay = delay;
if (double.TryParse(twitchStreamData.SelectToken("average_fps").ToString(), out averageFps)) _averageFps = averageFps;
_game = twitchStreamData.SelectToken("game").ToString();
_createdAt = twitchStreamData.SelectToken("created_at").ToString();
_channel = new TwitchChannel((JObject) twitchStreamData.SelectToken("channel"));
_preview = new PreviewObj(twitchStreamData.SelectToken("preview"));
}
/// <summary>Stream object constructor.</summary>
public Stream(JToken twitchStreamData)
{
bool isPlaylist;
long id;
int viewers, videoHeight, delay;
double averageFps;
if (bool.TryParse(twitchStreamData.SelectToken("is_playlist").ToString(), out isPlaylist) && isPlaylist) IsPlaylist = true;
if (long.TryParse(twitchStreamData.SelectToken("_id").ToString(), out id)) Id = id;
if (int.TryParse(twitchStreamData.SelectToken("viewers").ToString(), out viewers)) Viewers = viewers;
if (int.TryParse(twitchStreamData.SelectToken("video_height").ToString(), out videoHeight)) VideoHeight = videoHeight;
if (int.TryParse(twitchStreamData.SelectToken("delay").ToString(), out delay)) Delay = delay;
if (double.TryParse(twitchStreamData.SelectToken("average_fps").ToString(), out averageFps)) AverageFps = averageFps;
Game = twitchStreamData.SelectToken("game").ToString();
CreatedAt = Common.DateTimeStringToObject(twitchStreamData.SelectToken("created_at").ToString());
TimeSinceCreated = DateTime.UtcNow - CreatedAt;
Channel = new Channel((JObject) twitchStreamData.SelectToken("channel"));
Preview = new PreviewObj(twitchStreamData.SelectToken("preview"));
}
/// <summary>Stream object constructor.</summary>
public Stream(JToken twitchStreamData)
{
bool isPlaylist;
long id;
int viewers, videoHeight, delay;
double averageFps;
if (bool.TryParse(twitchStreamData.SelectToken("is_playlist").ToString(), out isPlaylist) && isPlaylist)
{
IsPlaylist = true;
}
if (long.TryParse(twitchStreamData.SelectToken("_id").ToString(), out id))
{
Id = id;
}
if (int.TryParse(twitchStreamData.SelectToken("viewers").ToString(), out viewers))
{
Viewers = viewers;
}
if (int.TryParse(twitchStreamData.SelectToken("video_height").ToString(), out videoHeight))
{
VideoHeight = videoHeight;
}
if (int.TryParse(twitchStreamData.SelectToken("delay").ToString(), out delay))
{
Delay = delay;
}
if (double.TryParse(twitchStreamData.SelectToken("average_fps").ToString(), out averageFps))
{
AverageFps = averageFps;
}
Game = twitchStreamData.SelectToken("game").ToString();
CreatedAt = twitchStreamData.SelectToken("created_at").ToString();
Channel = new Channel((JObject)twitchStreamData.SelectToken("channel"));
Preview = new PreviewObj(twitchStreamData.SelectToken("preview"));
}
public void NewBuild(GameObject _go) //this gets called by one of the buttons
{
preview = Instantiate(_go, Vector3.zero, Quaternion.identity); //set the preview = to something
previewScript = preview.GetComponent <PreviewObj>(); //grab the script that is sitting on the preview
isBuilding = true; //we can now build
}
public IHttpActionResult UpdatePreview([FromBody] PreviewObj model)
{
var result = new ExamService().UpdatePreview(model);
return(Ok(result));
}
