public static FormationTree GetAtomObjectFromTreeByName(string Name)
{
string sql = "select * from TreeObject where Identification='" + Name + "'";
FormationTree atom = GetAtomObjectFromTreeBySql(sql);
return(atom);
}
private async void cmdExit_Click(object sender, RoutedEventArgs e)
{
bool isCheckOk = await CheckOk();
if (isCheckOk == false)
{
return;
}
if (isNew)
{
refAtomDTO = new FormationTree();
refAtomDTO.Identification = txtName.Text;
refAtomDTO.PlatformCategoryId = enumPlatformId.GeneralHumans;
refAtomDTO.PlatformType = string.Empty;
AtomObjectsEditEventArgs args = new AtomObjectsEditEventArgs();
args.isNew = isNew;
args.atomDTO = refAtomDTO;
if (EndAtomObjectsEditEvent != null)
{
EndAtomObjectsEditEvent(this, args);
}
}
Close();
}
protected async override void OnDrop(System.Windows.DragEventArgs e)
{
double currMapX = 0;
double currMapY = 0;
System.Windows.DataObject d = (System.Windows.DataObject)e.Data;
string[] dataFormats = d.GetFormats();
string dataText = d.GetText();
Point position = e.GetPosition(this);
GMap.NET.PointLatLng curPosition = FromLocalToLatLng((int)position.X, (int)position.Y);
currMapX = curPosition.Lng;
currMapY = curPosition.Lat;
for (int i = 0; i < dataFormats.Length; i++)
{
string dragFormat = dataFormats[i];
if (dragFormat.Contains("FormationTree") && dataText == "Actor")
{
object dragObject = d.GetData(dragFormat);
FormationTree formation = dragObject as FormationTree;
if (formation == null)
{
continue;
}
enOSMhighwayFilter highwayFilter = enOSMhighwayFilter.Undefined;
SetHighwayFilter(highwayFilter);
shPointId PointId = await clsRoadRoutingWebApi.GetNearestPointIdOnRoad("0", highwayFilter, currMapX, currMapY);
if (PointId != null)
{
shPoint pnt = PointId.point;
DeployedFormation deployFormation = new DeployedFormation();
deployFormation.x = pnt.x;
deployFormation.y = pnt.y;
deployFormation.formation = formation;
AtomData atom = await TDSClient.SAGInterface.SAGSignalR.DeployFormationFromTree(VMMainViewModel.Instance.SimulationHubProxy, deployFormation);
if (atom != null)
{
AtomDeployedEventArgs args = new AtomDeployedEventArgs();
args.atom = atom;
if (AtomDeployedEvent != null)
{
AtomDeployedEvent(this, args);
}
}
}
return;
}
}
}
public frmActorEdit(FormationTree atomDTO)
{
InitializeComponent();
this.Background = new LinearGradientBrush(Colors.AliceBlue, Colors.LightGray, 90);
refAtomDTO = atomDTO;
if (refAtomDTO == null)
{
isNew = true;
}
}
public async void frm_EndAtomObjectsEditEvent(object sender, AtomObjectsEditEventArgs args)
{
FormationTree atomDTO = await SAGSignalR.SaveTreeObject(VMMainViewModel.Instance.SimulationHubProxy, args.atomDTO);
if (args.isNew)
{
AtomDTOData Rdata = new AtomDTOData();
Rdata.atom = atomDTO;
((List <AtomDTOData>)(dtGridActors.ItemsSource)).Add(Rdata);
dtGridActors.Items.Refresh();
dtGridActors.SelectedItem = Rdata;
dtGridActors.CurrentItem = Rdata;
DataGridWPFUtility.DataGridGotoLast(dtGridActors);
}
}
private static FormationTree GetAtomObjectFromTreeBySql(string sql)
{
try
{
FormationTree atom = new FormationTree();
using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection))
using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, connection))
{
DataSet dsPol = new DataSet();
DataTable dtPol = new DataTable();
dsPol.Reset();
da.Fill(dsPol);
dtPol = dsPol.Tables[0];
if (dtPol == null || dtPol.Rows == null || dtPol.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in dtPol.Rows)
{
atom.Identification = row["Identification"].ToString();
atom.GUID = row["GUID"].ToString();
atom.ParentGUID = row["ParentGUID"].ToString();
atom.PlatformCategoryId = (enumPlatformId)System.Convert.ToInt32(row["PlatformCategoryId"]);
atom.PlatformType = row["PlatformType"].ToString();
}
}
return(atom);
}
catch (Exception ex)
{
}
return(null);
}
public static IEnumerable <FormationTree> GetAllAtomsFromTree()
{
try
{
List <FormationTree> atoms = new List <FormationTree>();
string sql = "select * from TreeObject order by Identification";
using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection))
using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, connection))
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds.Reset();
da.Fill(ds);
dt = ds.Tables[0];
if (dt == null || dt.Rows == null || dt.Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
FormationTree atom = new FormationTree();
atom.Identification = row["Identification"].ToString();
atom.GUID = row["GUID"].ToString();
atom.ParentGUID = row["ParentGUID"].ToString();
atom.PlatformCategoryId = (enumPlatformId)System.Convert.ToInt32(row["PlatformCategoryId"]);
atom.PlatformType = row["PlatformType"].ToString();
atoms.Add(atom);
}
}
return(atoms);
}
catch (Exception ex)
{
}
return(null);
}
public static FormationTree SaveTreeObject(FormationTree atomDTO)
{
try
{
//int Actid = ActivityDTO.ActivityId;
//object ob = null;
string sql;
using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection))
{
connection.Open();
NpgsqlTransaction sqlTran = connection.BeginTransaction();
try
{
// ****** Atom *******
if (string.IsNullOrEmpty(atomDTO.GUID)) //new Atom
{
atomDTO.GUID = Util.CretaeGuid().ToString();
sql = "insert into TreeObject (Identification,GUID,ParentGUID,PlatformCategoryId,PlatformType)" +
"values ('" + atomDTO.Identification + "','" +
atomDTO.GUID + "','" +
atomDTO.ParentGUID + "'," +
(int)atomDTO.PlatformCategoryId + ",'" +
atomDTO.PlatformType + "'" +
" ) ";
using (NpgsqlCommand command = new NpgsqlCommand(sql, connection))
{
command.Transaction = sqlTran;
command.ExecuteNonQuery();
}
}
else
{
sql = "update TreeObject set Identification='" + atomDTO.Identification + "'" +
" ,GUID='" + atomDTO.GUID + "'" +
" ,ParentGUID='" + atomDTO.GUID + "'" +
" ,PlatformCategoryId=" + (int)atomDTO.PlatformCategoryId +
" ,PlatformType='" + atomDTO.PlatformType + "'" +
" where GUID='" + atomDTO.GUID + "'";
using (NpgsqlCommand command = new NpgsqlCommand(sql, connection))
{
command.Transaction = sqlTran;
command.ExecuteNonQuery();
}
}
sqlTran.Commit();
return(atomDTO);
}
catch (Exception ex)
{
try
{
sqlTran.Rollback();
}
catch (Exception exRollback)
{
}
}
}
}
catch (Exception ex)
{
}
return(null);
}
