public List <TrailModel> GetTrailsByParkId(int id)
{
List <TrailModel> trails = new List <TrailModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM trails WHERE trails.park_id = @parkId", conn);
cmd.Parameters.AddWithValue("@parkId", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TrailModel trail = MapRowToTrail(reader);
trails.Add(trail);
}
}
}
catch (SqlException)
{
throw;
}
return(trails);
}
public override void SyncFrom(BasePieceModel otherModel)
{
base.SyncFrom(otherModel);
var otherCs = (CustomSaberModel)otherModel;
TrailModel = otherCs.TrailModel;
}
public TrailModel GetTrailByTrailName(string name)
{
TrailModel trail = new TrailModel();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM trails WHERE trails.trail_name = @name;", conn);
cmd.Parameters.AddWithValue("@name", name);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
trail = MapRowToTrail(reader);
}
else
{
trail = null;
}
}
}
catch (SqlException)
{
throw;
}
return(trail);
}
public List <TrailModel> GetTrailsByParkName(string name)
{
List <TrailModel> trails = new List <TrailModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT trails.* FROM trails INNER JOIN parks ON trails.park_id = parks.park_id WHERE parks.park_name = @parkName", conn);
cmd.Parameters.AddWithValue("@parkName", name);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TrailModel trail = MapRowToTrail(reader);
trails.Add(trail);
}
}
}
catch (SqlException)
{
throw;
}
return(trails);
}
/// <summary>
/// Creates an <see cref="InstanceTrailData" /> object
/// with the correct trail transforms
/// </summary>
/// <param name="saberObject">The saber gameobject that the <see cref="CustomTrail" /> component is on</param>
/// <param name="trailModel">The <see cref="TrailModel" /> to use</param>
public void InitializeTrailData(GameObject saberObject, TrailModel trailModel)
{
if (saberObject is null || trailModel is null)
{
return;
}
var trails = SaberHelpers.GetTrails(saberObject).ToArray();
// Add new CustomTrail component with given data (creating position transforms for given position)
CustomTrail SetupTrail(int length, float startPos, float endPos, Material material)
{
var newTrail = saberObject.AddComponent <CustomTrail>();
newTrail.Length = length;
newTrail.PointStart = saberObject.CreateGameObject("PointStart").transform;
newTrail.PointEnd = saberObject.CreateGameObject("PointEnd").transform;
newTrail.PointEnd.localPosition = new Vector3(0, 0, endPos);
newTrail.PointStart.localPosition = new Vector3(0, 0, startPos);
newTrail.TrailMaterial = material;
return(newTrail);
}
// if saber has no trial set up a generic one
if (trails is null || trails.Length < 1)
{
trails = new[] { SetupTrail(12, 0, 1, null) };
}
var saberTrail = trails[0];
List <CustomTrail> secondaryTrails = null;
// set up secondary trails from other saber
if (trailModel.TrailOriginTrails is { } && trailModel.TrailOriginTrails.Count > 1)
public static int InsertFakeTrail(TrailModel trail, int parkId)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO trails " +
" (park_id, trail_name, trail_description) " +
"VALUES " +
" (@parkId, @name, @description)", conn);
cmd.Parameters.AddWithValue("@parkId", parkId);
cmd.Parameters.AddWithValue("@name", trail.Name);
cmd.Parameters.AddWithValue("@description", trail.Description);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("SELECT trail_id FROM trails " +
"WHERE trails.trail_name = @name " +
"AND trails.trail_description = @description", conn);
cmd.Parameters.AddWithValue("@name", trail.Name);
cmd.Parameters.AddWithValue("@description", trail.Description);
int result = Convert.ToInt32(cmd.ExecuteScalar());
return(result);
}
}
private async Task LoadSaberModel(SaberModel saberModel, SerializableSaber serializableSaber)
{
saberModel.SaberWidth = serializableSaber.SaberWidth;
if (_mainAssetStore.IsLoading)
{
await _mainAssetStore.CurrentTask;
}
foreach (var piece in serializableSaber.Pieces)
{
var comp = await _mainAssetStore[piece.Path];
saberModel.PieceCollection.AddPiece(comp.AssetTypeDefinition, comp.GetPiece(saberModel.SaberSlot));
}
var trail = serializableSaber.Trail;
if (trail != null)
{
var trailModel = new TrailModel(Vector3.zero, trail.Width, trail.Length, null, trail.Whitestep, trail.TrailOrigin);
if (!string.IsNullOrEmpty(trail.TrailOrigin))
{
await LoadFromTrailOrigin(trailModel, trail.TrailOrigin);
}
if (saberModel.GetCustomSaber(out var customsaber))
{
customsaber.TrailModel = trailModel;
}
else
{
saberModel.TrailModel = trailModel;
}
}
}
public InstanceTrailData(TrailModel trailModel, Transform pointStart, Transform pointEnd)
{
TrailModel = trailModel;
PointStart = pointStart;
PointEnd = pointEnd;
Init(trailModel);
}
private void SetTrailModel(TrailModel trailModel)
{
if (_editorInstanceManager.CurrentPiece is CustomSaberInstance customsaber)
{
var model = (CustomSaberModel)customsaber.Model;
model.TrailModel = trailModel;
}
}
public void Add(TrailModel item)
{
using (IDbConnection dbConnection = Connection) {
string query = "INSERT INTO trails (name, description, length, elevationChange, longitude, latitude) VALUES (@Name, @Description, @Length, @ElevationChange, @Longitude, @Latitude)";
dbConnection.Open();
dbConnection.Execute(query, item);
}
}
private async void SaberSelected(ICustomListItem item)
{
if (item is PreloadMetaData metaData)
{
_selectedTrailModel = await GetTrail(metaData);
_onSelectionChanged?.Invoke(_selectedTrailModel);
}
}
public List <TrailModel> GetFollowTrail(string FileName)
{
List <TrailModel> objTrailModelList = new List <TrailModel>();
string[] GetText = new string[3];
StreamReader reader = new StreamReader(@"\\192.168.10.5\\Log\\" + FileName + ""); //pick appropriate Encoding
reader.BaseStream.Seek(0, SeekOrigin.End);
int count = 0;
while ((count < 23) && (reader.BaseStream.Position > 0))
{
reader.BaseStream.Position--;
int c = reader.BaseStream.ReadByte();
if (reader.BaseStream.Position > 0)
{
reader.BaseStream.Position--;
}
if (c == Convert.ToInt32('\n'))
{
++count;
}
}
string str = reader.ReadToEnd();
string[] arr = str.Replace("\r", "").Split('\n');
reader.Close();
List <string> listahb = new List <string>();
TrailModel objTrailModel;
for (int i = 0; i < 21; i++)
{
if (arr[i].Length > 20)
{
objTrailModel = new TrailModel();
GetText = TextSplit(arr[i]);
objTrailModel.Time = GetText[0];
objTrailModel.MSISDN = GetText[1];
objTrailModel.SMS = GetText[2];
if (i <= 5)
{
objTrailModelList.Add(objTrailModel);
}
listahb.Add(GetText[0]);
}
}
//GlobalVariables.listahb = listahb;
TPS(listahb);
return(objTrailModelList);
}
private async Task LoadSaberModel(SaberModel saberModel, SerializableSaber serializableSaber)
{
saberModel.SaberWidth = serializableSaber.SaberWidth;
if (_mainAssetStore.IsLoading)
{
await _mainAssetStore.CurrentTask;
}
foreach (var piece in serializableSaber.Pieces)
{
var comp = await _mainAssetStore[piece.Path];
if (comp != null)
{
saberModel.PieceCollection.AddPiece(comp.AssetTypeDefinition, comp.GetPiece(saberModel.SaberSlot));
}
}
TrailModel trailModel = null;
if (saberModel.GetCustomSaber(out var customsaber))
{
trailModel = customsaber.TrailModel;
}
else
{
trailModel = new TrailModel();
}
var trail = serializableSaber.Trail;
if (trail != null)
{
trailModel.TrailPosOffset = Vector3.zero;
trailModel.Width = trail.Width;
trailModel.Length = trail.Length;
trailModel.Whitestep = trail.Whitestep;
trailModel.ClampTexture = trail.ClampTexture;
// if trail comes from another saber
if (!string.IsNullOrEmpty(trail.TrailOrigin))
{
await LoadFromTrailOrigin(trailModel, trail.TrailOrigin);
}
// assign trailmodel to custom saber or saber factory saber
// depending on which trail type is being used
if (customsaber is null)
{
saberModel.TrailModel = trailModel;
}
trail.Material?.ApplyToMaterial(trailModel.Material?.Material, ResolveTexture);
}
}
public void GetTrailByTrailName()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
int newTrailId = TrailSqlDALTests.InsertFakeTrail(trail, newParkId);
TrailSqlDAL testClass = new TrailSqlDAL(connectionString);
TrailModel newTrail = testClass.GetTrailByTrailName(trail.Name);
Assert.AreEqual(newTrail.TrailId, newTrailId);
}
}
/// <summary>
/// Load trail from another saber
/// </summary>
/// <param name="trailModel">TrailModel to load the other saber's data into</param>
/// <param name="trailOrigin">Path of the other saber</param>
/// <returns></returns>
private async Task LoadFromTrailOrigin(TrailModel trailModel, string trailOrigin)
{
var comp = await _mainAssetStore[trailOrigin];
var originTrailModel = (comp?.GetLeft() as CustomSaberModel)?.GrabTrail(true);
if (originTrailModel == null)
{
return;
}
trailModel.Material.Material = originTrailModel.Material.Material;
}
public IActionResult Create(TrailModel submission)
{
if (ModelState.IsValid)
{
trailFactory.Add(submission);
return(RedirectToAction("Index"));
}
else
{
return(View("NewTrail"));
}
}
/// <summary>
/// Creates an <see cref="InstanceTrailData"/> object
/// with the correct trail transforms
/// </summary>
/// <param name="saberObject">The saber gameobject that the <see cref="CustomTrail"/> component is on</param>
/// <param name="trailModel">The <see cref="TrailModel"/> to use</param>
public void InitializeTrailData(GameObject saberObject, TrailModel trailModel)
{
if (trailModel is null)
{
return;
}
var trails = saberObject?.GetComponentsInChildren <CustomTrail>();
if (trails is null || trails.Length < 1)
{
return;
}
var saberTrail = trails[0];
if (trails.Length > 1)
{
SecondaryTrails = new List <CustomTrail>();
for (int i = 1; i < trails.Length; i++)
{
SecondaryTrails.Add(trails[i]);
}
}
// if trail comes from the preset save system
// the model comes without the material assigned
// so we assign
if (trailModel.Material is null)
{
trailModel.Material = new MaterialDescriptor(saberTrail.TrailMaterial);
// set texture wrap mode
if (trailModel.Material.Material.TryGetMainTexture(out var tex))
{
trailModel.OriginalTextureWrapMode = tex.wrapMode;
}
}
Transform pointStart = saberTrail.PointStart;
Transform pointEnd = saberTrail.PointEnd;
// Correction for sabers that have the transforms set up the other way around
bool isTrailReversed = pointStart.localPosition.z > pointEnd.localPosition.z;
if (isTrailReversed)
{
pointStart = saberTrail.PointEnd;
pointEnd = saberTrail.PointStart;
}
InstanceTrailData = new InstanceTrailData(trailModel, pointStart, pointEnd, isTrailReversed);
}
public TrailModel InitializeTrailData(GameObject saberObject, TrailModel trailModel)
{
var(data, model) = InstanceTrailData.FromCustomSaber(saberObject, trailModel);
if (data == null || model == null)
{
return(null);
}
InstanceTrailData = data;
return(model);
}
public IHttpActionResult GetTrailByTrailName(string trailName)
{
TrailModel trail = trailDAL.GetTrailByTrailName(trailName);
trail.PanoramicsInTrail = panoramicDAL.GetPanoramicsByTrailName(trailName);
trail.PanoramicsInTrail.ForEach(panoramic => panoramic.Connections = panoramicDAL.GetConnectionsByPanoramicId(panoramic.PanoramicId));
trail.PanoramicsInTrail.ForEach(panoramic => panoramic.LastSeenImages = lastSeenImagesDAL.GetLastSeenImagesByPanoramicId(panoramic.PanoramicId));
trail.PanoramicsInTrail.ForEach(panoramic => panoramic.LastSeenVideos = lastSeenVideosDAL.GetLastSeenVideosByPanoramicId(panoramic.PanoramicId));
trail.PanoramicsInTrail.ForEach(panoramic => panoramic.BackgroundSoundClips = panoramicDAL.GetAllBackgroundSoundClips());
trail.TrailHead = panoramicDAL.GetTrailHeadByTrailId(trail.TrailId);
trail.TrailHead = trail.PanoramicsInTrail.First(panoramic => panoramic.PanoramicId == trail.TrailHead.PanoramicId);
return(Ok(trail));
}
public List <TrailModel> GetAllTrails()
{
List <TrailModel> trails = new List <TrailModel>();
{
using (SqlConnection conn = new SqlConnection(connectionString))
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM trails;", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TrailModel trail = MapRowToTrail(reader);
trails.Add(trail);
}
return(trails);
}
catch (SqlException)
{
throw;
}
}
}
public void Initialize()
{
park = new ParkModel()
{
Name = "testPark",
Description = "testDescription",
Latitude = 41,
Longitude = 100,
Zoom = 200
};
trail = new TrailModel()
{
Name = "testTrail",
Description = "testTrailDescription"
};
trailImage = new TrailImagesModel()
{
Bit = true,
ImageAddress = "address"
};
}
public void Initialize()
{
park = new ParkModel()
{
Name = "testPark",
Description = "testDescription",
Latitude = 41,
Longitude = 100,
Zoom = 200
};
trail = new TrailModel()
{
Name = "testTrail",
Description = "testTrailDescription"
};
panoramicImage = new PanoramicModel()
{
ImageAddress = "address",
Latitude = 100,
Longitude = 42,
};
}
public void Init(TrailModel trailModel)
{
SetWidth(trailModel.Width);
}
public static (InstanceTrailData, TrailModel) FromCustomSaber(GameObject saberObject, TrailModel trailModel)
{
var saberTrail = saberObject.GetComponent <CustomTrail>();
if (!saberTrail)
{
return(default);