public frmRouteActivityRouting(GeneralActivityDTO pActivityDTO) { InitializeComponent(); this.Background = new LinearGradientBrush(Colors.AliceBlue, Colors.LightGray, 90); refActivityDTO = pActivityDTO; SetGridRoutes(); dtGridRoute.ItemsSource = new List <OsmRouteData>(); }
public frmActivityEdit(structTransportCommonProperty CommonProperty, GeneralActivityDTO ActivityDTO) { InitializeComponent(); this.Background = new LinearGradientBrush(Colors.AliceBlue, Colors.LightGray, 90); txPlatformName.IsReadOnly = true; AtomCommonProperty = CommonProperty; refActivityDTO = ActivityDTO; if (AtomCommonProperty != null) { txPlatformName.Text = AtomCommonProperty.AtomName; } }
public static IEnumerable <GeneralActivityDTO> GetAllActivites() { try { List <GeneralActivityDTO> Activites = new List <GeneralActivityDTO>(); string sql = "select * from Activites order by ActivityId,Activity_SeqNumber"; 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) { GeneralActivityDTO activity = new GeneralActivityDTO(); activity.ActivityType = (enumActivity)Convert.ToInt32(row["ActivityType"]); // enumActivity.MovementActivity; activity.ActivityId = System.Convert.ToInt32(row["ActivityId"]); activity.Activity_SeqNumber = System.Convert.ToInt32(row["Activity_SeqNumber"]); activity.StartActivityOffset = TimeSpan.Parse(row["StartActivityOffset"].ToString()); activity.DurationActivity = TimeSpan.Parse(row["DurationActivity"].ToString()); activity.Speed = System.Convert.ToInt32(row["Speed"]); activity.ReferencePoint = new DPoint(); activity.ReferencePoint.x = System.Convert.ToDouble(row["ReferencePointX"]); activity.ReferencePoint.y = System.Convert.ToDouble(row["ReferencePointY"]); string RouteGuid = row["route_guid"].ToString(); activity.RouteActivity = TDS.DAL.RoutesDB.GetRouteByGuid(RouteGuid); Activites.Add(activity); } } return(Activites); } catch (Exception ex) { } return(null); }
async void frm_ActivityDTOEditEvent(object sender, ActivityDTOEditEventArgs args) { if (args.isNew) { int n = ((List <ActivityDTONotify>)(dtGridActivities.ItemsSource)).Count + 1; args.ActivityDTO.Activity_SeqNumber = n; GeneralActivityDTO activity = await SAGSignalR.SaveActivity(VMMainViewModel.Instance.SimulationHubProxy, args.ActivityDTO); ActivityDTONotify Rdata = new ActivityDTONotify(); Rdata.ActivityDTO = activity; ((List <ActivityDTONotify>)(dtGridActivities.ItemsSource)).Add(Rdata); dtGridActivities.Items.Refresh(); dtGridActivities.SelectedItem = Rdata; dtGridActivities.CurrentItem = Rdata; DataGridWPFUtility.DataGridGotoLast(dtGridActivities); } else { GeneralActivityDTO activity = await SAGSignalR.SaveActivity(VMMainViewModel.Instance.SimulationHubProxy, args.ActivityDTO); if (dtGridActivities.ItemsSource == null) { return; } List <ActivityDTONotify> listData = (List <ActivityDTONotify>)(dtGridActivities.ItemsSource); // RouteData currRouteData = null; for (int j = 0; j < listData.Count; j++) { if (listData[j].ActivityId == activity.ActivityId) { // currRouteData = listData[j]; listData[j].ActivityDTO = activity; dtGridActivities.Items.Refresh(); break; } } } }
private async void cmdExit_Click(object sender, RoutedEventArgs e) { bool isCheckOk = await CheckOk(); if (isCheckOk == false) { return; } DrawPolygonEventArgs arg = new DrawPolygonEventArgs(); arg.isCancel = false; arg.isNew = true; arg.PolygonName = txtRouteName.Text.Trim(); arg.PolygonPnts = m_PolygonPnts.ToArray <DPoint>(); // isOK = true; if (EndDrawPolygonEvent != null) { EndDrawPolygonEvent(this, arg); } GeneralActivityDTO ActivityDTO = new GeneralActivityDTO(); ActivityDTO.ActivityType = enumActivity.MovementActivity; AtomData atomdata = new AtomData(); atomdata.UnitName = txPlatformName.Text; atomdata.Location = m_PolygonPnts[0]; ActivityDTO.StartActivityOffset = (TimeSpan)startActivity.Value; ActivityDTO.DurationActivity = (TimeSpan)durationActivity.Value; ActivityDTO.Speed = (int)speedUpDown.Value; Route route = new Route(); route.RouteName = txtRouteName.Text; route.Points = m_PolygonPnts; ActivityDTO.RouteActivity = route; if (refActivityDTO != null) { atomdata.UnitGuid = refActivityDTO.Atom.UnitGuid; ActivityDTO.ActivityId = refActivityDTO.ActivityId; if (ActivityDTO.RouteActivity != null) { ActivityDTO.RouteActivity.RouteGuid = refActivityDTO.RouteActivity.RouteGuid; } } ActivityDTO.Atom = atomdata; await SAGSignalR.SaveActivity(VMMainViewModel.Instance.SimulationHubProxy, ActivityDTO); this.Close(); }
private void btnOK_Click(object sender, RoutedEventArgs e) { // bool isCheckOk = await CheckOk(); bool isCheckOk = CheckOk(); if (isCheckOk == false) { return; } GeneralActivityDTO ActivityDTO = new GeneralActivityDTO(); ActivityDTO.Atom = new AtomData(); ActivityDTO.Atom.UnitName = AtomCommonProperty.AtomName; ActivityDTO.ActivityType = enumActivity.MovementActivity; ActivityDTO.StartActivityOffset = (TimeSpan)startActivity.Value; ActivityDTO.Speed = (int)speedUpDown.Value; double X = 0; double Y = 0; if (txtReferenceX.Tag != null) { double.TryParse(txtReferenceX.Tag.ToString(), out X); double.TryParse(txtReferenceY.Tag.ToString(), out Y); ActivityDTO.ReferencePoint = new DPoint(X, Y); } // Route route = new Route(); // route.RouteName = txtRoute.Text; ActivityDTO.RouteActivity = ActivityRoute; // route; ActivityDTOEditEventArgs args = new ActivityDTOEditEventArgs(); args.isNew = false; if (refActivityDTO == null) { args.isNew = true; } else { ActivityDTO.ActivityId = refActivityDTO.ActivityId; ActivityDTO.Activity_SeqNumber = refActivityDTO.Activity_SeqNumber; } args.ActivityDTO = ActivityDTO; if (ActivityDTOEditEvent != null) { ActivityDTOEditEvent(this, args); } Close(); }
public static void SaveActivityOLD(GeneralActivityDTO ActivityDTO) { 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(ActivityDTO.Atom.UnitGuid)) //new Atom { ActivityDTO.Atom.UnitGuid = Util.CretaeGuid().ToString(); sql = "insert into AtomObjects (atom_guid,atom_name,CountryId,pointX,pointY)" + "values ('" + ActivityDTO.Atom.UnitGuid + "','" + ActivityDTO.Atom.UnitName + "'," + 0 + "," + ActivityDTO.Atom.Location.x + "," + ActivityDTO.Atom.Location.y + " ) "; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } else { sql = "update AtomObjects set atom_guid='" + ActivityDTO.Atom.UnitGuid + "'" + " ,atom_name='" + ActivityDTO.Atom.UnitName + "'" + " ,CountryId=" + 0 + " ,pointX=" + ActivityDTO.Atom.Location.x + " ,pointY=" + ActivityDTO.Atom.Location.y + " where atom_guid='" + ActivityDTO.Atom.UnitGuid + "'"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } // ****** Route ****** if (string.IsNullOrEmpty(ActivityDTO.RouteActivity.RouteGuid)) { ActivityDTO.RouteActivity.RouteGuid = Util.CretaeGuid().ToString(); } RoutesDB.SaveRoute(ActivityDTO.RouteActivity, connection, sqlTran); // ****** Activity ******* if (ActivityDTO.ActivityId == 0) //new Activity { sql = "insert into ActivityMovement (atom_guid,StartActivityOffset,DurationActivity,Speed,route_guid)" + "values ('" + ActivityDTO.Atom.UnitGuid + "','" + ActivityDTO.StartActivityOffset.ToString() + "','" + ActivityDTO.DurationActivity.ToString() + "'," + ActivityDTO.Speed + ",'" + ActivityDTO.RouteActivity.RouteGuid + "'" + " ) RETURNING ActivityId"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; Actid = (int)command.ExecuteScalar(); ActivityDTO.ActivityId = Actid; } } else { sql = "update ActivityMovement set atom_guid='" + ActivityDTO.Atom.UnitGuid + "'" + " ,StartActivityOffset='" + ActivityDTO.StartActivityOffset.ToString() + "'" + " ,DurationActivity='" + ActivityDTO.DurationActivity.ToString() + "'" + " ,Speed=" + ActivityDTO.Speed + " ,route_guid='" + ActivityDTO.RouteActivity.RouteGuid + "'" + " where ActivityId=" + ActivityDTO.ActivityId; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } //********************************************************** sqlTran.Commit(); } catch (Exception ex) { try { sqlTran.Rollback(); } catch (Exception exRollback) { } } } } catch (Exception ex) { } }
public static GeneralActivityDTO SaveActivity(GeneralActivityDTO ActivityDTO) { try { int Actid = ActivityDTO.ActivityId; object ob = null; string sql; using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection)) { connection.Open(); NpgsqlTransaction sqlTran = connection.BeginTransaction(); try { AtomData atomdata = DAL.AtomsDB.GetAtomByName(ActivityDTO.Atom.UnitName); ActivityDTO.Atom.UnitGuid = atomdata.UnitGuid; // ****** Activity ******* if (ActivityDTO.ActivityId == 0) //new Activity { sql = "insert into Activites ( atom_guid,StartActivityOffset,DurationActivity,ActivityType,Speed,route_guid,ReferencePointX,ReferencePointY,Activity_SeqNumber)" + "values ('" + atomdata.UnitGuid + "','" + ActivityDTO.StartActivityOffset.ToString() + "','" + ActivityDTO.DurationActivity.ToString() + "'," + (int)ActivityDTO.ActivityType + "," + ActivityDTO.Speed + ",'" + ActivityDTO.RouteActivity.RouteGuid + "'," + ActivityDTO.ReferencePoint.x + "," + ActivityDTO.ReferencePoint.y + "," + ActivityDTO.Activity_SeqNumber + " ) RETURNING ActivityId"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; Actid = (int)command.ExecuteScalar(); ActivityDTO.ActivityId = Actid; } } else { sql = "update Activites set atom_guid='" + atomdata.UnitGuid + "'" + " ,StartActivityOffset='" + ActivityDTO.StartActivityOffset.ToString() + "'" + " ,DurationActivity='" + ActivityDTO.DurationActivity.ToString() + "'" + " ,ActivityType=" + (int)ActivityDTO.ActivityType + " ,Speed=" + ActivityDTO.Speed + " ,route_guid='" + ActivityDTO.RouteActivity.RouteGuid + "'" + " ,ReferencePointX=" + ActivityDTO.ReferencePoint.x + " ,ReferencePointY=" + ActivityDTO.ReferencePoint.y + " ,Activity_SeqNumber=" + ActivityDTO.Activity_SeqNumber + " where ActivityId=" + ActivityDTO.ActivityId; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } //********************************************************** sqlTran.Commit(); return(ActivityDTO); } catch (Exception ex) { try { sqlTran.Rollback(); } catch (Exception exRollback) { } } } } catch (Exception ex) { } return(null); }
public static IEnumerable<GeneralActivityDTO> GetAllActivites() { try { List<GeneralActivityDTO> Activites = new List<GeneralActivityDTO>(); string sql = "select * from Activites order by ActivityId,Activity_SeqNumber"; 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) { GeneralActivityDTO activity = new GeneralActivityDTO(); activity.ActivityType = (enumActivity)Convert.ToInt32(row["ActivityType"]); // enumActivity.MovementActivity; activity.ActivityId = System.Convert.ToInt32(row["ActivityId"]); activity.Activity_SeqNumber = System.Convert.ToInt32(row["Activity_SeqNumber"]); activity.StartActivityOffset = TimeSpan.Parse(row["StartActivityOffset"].ToString()); activity.DurationActivity = TimeSpan.Parse(row["DurationActivity"].ToString()); activity.Speed = System.Convert.ToInt32(row["Speed"]); activity.ReferencePoint = new DPoint(); activity.ReferencePoint.x = System.Convert.ToDouble(row["ReferencePointX"]); activity.ReferencePoint.y = System.Convert.ToDouble(row["ReferencePointY"]); string RouteGuid = row["route_guid"].ToString(); activity.RouteActivity = TDS.DAL.RoutesDB.GetRouteByGuid(RouteGuid); Activites.Add(activity); } } return Activites; } catch (Exception ex) { } return null; }
public static void SaveActivityOLD(GeneralActivityDTO ActivityDTO) { 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(ActivityDTO.Atom.UnitGuid)) //new Atom { ActivityDTO.Atom.UnitGuid = Util.CretaeGuid().ToString(); sql = "insert into AtomObjects (atom_guid,atom_name,CountryId,pointX,pointY)" + "values ('" + ActivityDTO.Atom.UnitGuid + "','" + ActivityDTO.Atom.UnitName + "'," + 0 + "," + ActivityDTO.Atom.Location.x + "," + ActivityDTO.Atom.Location.y + " ) "; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } else { sql = "update AtomObjects set atom_guid='" + ActivityDTO.Atom.UnitGuid + "'" + " ,atom_name='" + ActivityDTO.Atom.UnitName + "'" + " ,CountryId=" + 0 + " ,pointX=" + ActivityDTO.Atom.Location.x + " ,pointY=" + ActivityDTO.Atom.Location.y + " where atom_guid='" + ActivityDTO.Atom.UnitGuid + "'"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } // ****** Route ****** if (string.IsNullOrEmpty(ActivityDTO.RouteActivity.RouteGuid)) { ActivityDTO.RouteActivity.RouteGuid = Util.CretaeGuid().ToString(); } RoutesDB.SaveRoute(ActivityDTO.RouteActivity, connection, sqlTran); // ****** Activity ******* if (ActivityDTO.ActivityId == 0) //new Activity { sql = "insert into ActivityMovement (atom_guid,StartActivityOffset,DurationActivity,Speed,route_guid)" + "values ('" + ActivityDTO.Atom.UnitGuid + "','" + ActivityDTO.StartActivityOffset.ToString() + "','" + ActivityDTO.DurationActivity.ToString() + "'," + ActivityDTO.Speed + ",'" + ActivityDTO.RouteActivity.RouteGuid + "'" + " ) RETURNING ActivityId"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; Actid = (int)command.ExecuteScalar(); ActivityDTO.ActivityId = Actid; } } else { sql = "update ActivityMovement set atom_guid='" + ActivityDTO.Atom.UnitGuid + "'" + " ,StartActivityOffset='" + ActivityDTO.StartActivityOffset.ToString() + "'" + " ,DurationActivity='" + ActivityDTO.DurationActivity.ToString() + "'" + " ,Speed=" + ActivityDTO.Speed + " ,route_guid='" + ActivityDTO.RouteActivity.RouteGuid + "'" + " where ActivityId=" + ActivityDTO.ActivityId; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } //********************************************************** sqlTran.Commit(); } catch (Exception ex) { try { sqlTran.Rollback(); } catch (Exception exRollback) { } } } } catch (Exception ex) { } }
public static GeneralActivityDTO SaveActivity(GeneralActivityDTO ActivityDTO) { try { int Actid = ActivityDTO.ActivityId; object ob = null; string sql; using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection)) { connection.Open(); NpgsqlTransaction sqlTran = connection.BeginTransaction(); try { AtomData atomdata=DAL.AtomsDB.GetAtomByName(ActivityDTO.Atom.UnitName); ActivityDTO.Atom.UnitGuid = atomdata.UnitGuid; // ****** Activity ******* if (ActivityDTO.ActivityId == 0) //new Activity { sql = "insert into Activites ( atom_guid,StartActivityOffset,DurationActivity,ActivityType,Speed,route_guid,ReferencePointX,ReferencePointY,Activity_SeqNumber)" + "values ('" + atomdata.UnitGuid + "','" + ActivityDTO.StartActivityOffset.ToString() + "','" + ActivityDTO.DurationActivity.ToString() + "'," + (int)ActivityDTO.ActivityType+ ","+ ActivityDTO.Speed + ",'" + ActivityDTO.RouteActivity.RouteGuid + "'," + ActivityDTO.ReferencePoint.x+"," + ActivityDTO.ReferencePoint.y+ ","+ ActivityDTO.Activity_SeqNumber+ " ) RETURNING ActivityId"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; Actid = (int)command.ExecuteScalar(); ActivityDTO.ActivityId = Actid; } } else { sql = "update Activites set atom_guid='" + atomdata.UnitGuid + "'" + " ,StartActivityOffset='" + ActivityDTO.StartActivityOffset.ToString() + "'" + " ,DurationActivity='" + ActivityDTO.DurationActivity.ToString() + "'" + " ,ActivityType=" + (int)ActivityDTO.ActivityType + " ,Speed=" + ActivityDTO.Speed + " ,route_guid='" + ActivityDTO.RouteActivity.RouteGuid + "'" + " ,ReferencePointX=" + ActivityDTO.ReferencePoint.x + " ,ReferencePointY=" + ActivityDTO.ReferencePoint.y + " ,Activity_SeqNumber=" + ActivityDTO.Activity_SeqNumber + " where ActivityId=" + ActivityDTO.ActivityId; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } //********************************************************** sqlTran.Commit(); return ActivityDTO; } catch (Exception ex) { try { sqlTran.Rollback(); } catch (Exception exRollback) { } } } } catch (Exception ex) { } return null; }