From fee2c690e1ff0b8be3a3f10e30184c76efa4c0c2 Mon Sep 17 00:00:00 2001 From: Roy Ben-Shabat Date: Tue, 19 Dec 2017 14:53:03 +0200 Subject: Modified several table names. --- .../Visual_Studio/Tango.DAL.Local/DB/ACTION.cs | 25 ----- .../Tango.DAL.Local/DB/ACTION_TYPES.cs | 25 +++++ Software/Visual_Studio/Tango.DAL.Local/DB/EVENT.cs | 24 ----- .../Tango.DAL.Local/DB/EVENTS_ACTIONS.cs | 24 ----- .../Tango.DAL.Local/DB/EVENT_TYPES.cs | 24 +++++ .../Tango.DAL.Local/DB/EVENT_TYPES_ACTIONS.cs | 24 +++++ .../Visual_Studio/Tango.DAL.Local/DB/IDS_PACKS.cs | 2 +- .../Visual_Studio/Tango.DAL.Local/DB/LIQUID.cs | 25 ----- .../Tango.DAL.Local/DB/LIQUIDS_RMLS.cs | 24 ----- .../Tango.DAL.Local/DB/LIQUID_TYPES.cs | 25 +++++ .../Tango.DAL.Local/DB/LIQUID_TYPES_RMLS.cs | 24 +++++ .../Tango.DAL.Local/DB/LocalADO.Context.cs | 10 +- .../Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx | 103 +++++++++++---------- .../Tango.DAL.Local/DB/LocalADO.edmx.diagram | 10 +- .../Visual_Studio/Tango.DAL.Local/DB/MACHINE.cs | 1 + .../Tango.DAL.Local/DB/MACHINES_EVENTS.cs | 2 +- 16 files changed, 188 insertions(+), 184 deletions(-) delete mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/ACTION.cs create mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/ACTION_TYPES.cs delete mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/EVENT.cs delete mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/EVENTS_ACTIONS.cs create mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES.cs create mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES_ACTIONS.cs delete mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID.cs delete mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/LIQUIDS_RMLS.cs create mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES.cs create mode 100644 Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES_RMLS.cs (limited to 'Software/Visual_Studio/Tango.DAL.Local/DB') diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/ACTION.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/ACTION.cs deleted file mode 100644 index 6bc2a9274..000000000 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/ACTION.cs +++ /dev/null @@ -1,25 +0,0 @@ -//------------------------------------------------------------------------------ -// -// This code was generated from a template. -// -// Manual changes to this file may cause unexpected behavior in your application. -// Manual changes to this file will be overwritten if the code is regenerated. -// -//------------------------------------------------------------------------------ - -namespace Tango.DAL.Local.DB -{ - using System; - using System.Collections.Generic; - - public partial class ACTION - { - public long ID { get; set; } - public string GUID { get; set; } - public System.DateTime LAST_UPDATED { get; set; } - public bool DELETED { get; set; } - public long CODE { get; set; } - public string NAME { get; set; } - public string DESCRIPTION { get; set; } - } -} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/ACTION_TYPES.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/ACTION_TYPES.cs new file mode 100644 index 000000000..a0297f529 --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/ACTION_TYPES.cs @@ -0,0 +1,25 @@ +//------------------------------------------------------------------------------ +// +// This code was generated from a template. +// +// Manual changes to this file may cause unexpected behavior in your application. +// Manual changes to this file will be overwritten if the code is regenerated. +// +//------------------------------------------------------------------------------ + +namespace Tango.DAL.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class ACTION_TYPES + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public bool DELETED { get; set; } + public long CODE { get; set; } + public string NAME { get; set; } + public string DESCRIPTION { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT.cs deleted file mode 100644 index 636c9d31a..000000000 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT.cs +++ /dev/null @@ -1,24 +0,0 @@ -//------------------------------------------------------------------------------ -// -// This code was generated from a template. -// -// Manual changes to this file may cause unexpected behavior in your application. -// Manual changes to this file will be overwritten if the code is regenerated. -// -//------------------------------------------------------------------------------ - -namespace Tango.DAL.Local.DB -{ - using System; - using System.Collections.Generic; - - public partial class EVENT - { - public long ID { get; set; } - public string GUID { get; set; } - public System.DateTime LAST_UPDATED { get; set; } - public bool DELETED { get; set; } - public string NAME { get; set; } - public string DESCRIPTION { get; set; } - } -} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/EVENTS_ACTIONS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/EVENTS_ACTIONS.cs deleted file mode 100644 index 3c1c30eec..000000000 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/EVENTS_ACTIONS.cs +++ /dev/null @@ -1,24 +0,0 @@ -//------------------------------------------------------------------------------ -// -// This code was generated from a template. -// -// Manual changes to this file may cause unexpected behavior in your application. -// Manual changes to this file will be overwritten if the code is regenerated. -// -//------------------------------------------------------------------------------ - -namespace Tango.DAL.Local.DB -{ - using System; - using System.Collections.Generic; - - public partial class EVENTS_ACTIONS - { - public long ID { get; set; } - public string GUID { get; set; } - public System.DateTime LAST_UPDATED { get; set; } - public bool DELETED { get; set; } - public string EVENT_GUID { get; set; } - public string ACTION_GUID { get; set; } - } -} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES.cs new file mode 100644 index 000000000..3ec964cb8 --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES.cs @@ -0,0 +1,24 @@ +//------------------------------------------------------------------------------ +// +// This code was generated from a template. +// +// Manual changes to this file may cause unexpected behavior in your application. +// Manual changes to this file will be overwritten if the code is regenerated. +// +//------------------------------------------------------------------------------ + +namespace Tango.DAL.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class EVENT_TYPES + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public bool DELETED { get; set; } + public string NAME { get; set; } + public string DESCRIPTION { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES_ACTIONS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES_ACTIONS.cs new file mode 100644 index 000000000..0e7ba0913 --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/EVENT_TYPES_ACTIONS.cs @@ -0,0 +1,24 @@ +//------------------------------------------------------------------------------ +// +// This code was generated from a template. +// +// Manual changes to this file may cause unexpected behavior in your application. +// Manual changes to this file will be overwritten if the code is regenerated. +// +//------------------------------------------------------------------------------ + +namespace Tango.DAL.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class EVENT_TYPES_ACTIONS + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public bool DELETED { get; set; } + public string EVENT_TYPE_GUID { get; set; } + public string ACTION_TYPE_GUID { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/IDS_PACKS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/IDS_PACKS.cs index f97fed77c..cb94d5f67 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/IDS_PACKS.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/IDS_PACKS.cs @@ -20,7 +20,7 @@ namespace Tango.DAL.Local.DB public bool DELETED { get; set; } public string CONFIGURATION_GUID { get; set; } public string DISPENSER_GUID { get; set; } - public string LIQUID_GUID { get; set; } + public string LIQUID_TYPE_GUID { get; set; } public string CARTRIDGE_GUID { get; set; } } } diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID.cs deleted file mode 100644 index 9c70544ca..000000000 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID.cs +++ /dev/null @@ -1,25 +0,0 @@ -//------------------------------------------------------------------------------ -// -// This code was generated from a template. -// -// Manual changes to this file may cause unexpected behavior in your application. -// Manual changes to this file will be overwritten if the code is regenerated. -// -//------------------------------------------------------------------------------ - -namespace Tango.DAL.Local.DB -{ - using System; - using System.Collections.Generic; - - public partial class LIQUID - { - public long ID { get; set; } - public string GUID { get; set; } - public System.DateTime LAST_UPDATED { get; set; } - public bool DELETED { get; set; } - public long CODE { get; set; } - public string NAME { get; set; } - public double VERSION { get; set; } - } -} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUIDS_RMLS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUIDS_RMLS.cs deleted file mode 100644 index 9d613062c..000000000 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUIDS_RMLS.cs +++ /dev/null @@ -1,24 +0,0 @@ -//------------------------------------------------------------------------------ -// -// This code was generated from a template. -// -// Manual changes to this file may cause unexpected behavior in your application. -// Manual changes to this file will be overwritten if the code is regenerated. -// -//------------------------------------------------------------------------------ - -namespace Tango.DAL.Local.DB -{ - using System; - using System.Collections.Generic; - - public partial class LIQUIDS_RMLS - { - public long ID { get; set; } - public string GUID { get; set; } - public System.DateTime LAST_UPDATED { get; set; } - public bool DELETED { get; set; } - public string LIQUID_GUID { get; set; } - public string RML_GUID { get; set; } - } -} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES.cs new file mode 100644 index 000000000..652d219ba --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES.cs @@ -0,0 +1,25 @@ +//------------------------------------------------------------------------------ +// +// This code was generated from a template. +// +// Manual changes to this file may cause unexpected behavior in your application. +// Manual changes to this file will be overwritten if the code is regenerated. +// +//------------------------------------------------------------------------------ + +namespace Tango.DAL.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class LIQUID_TYPES + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public bool DELETED { get; set; } + public long CODE { get; set; } + public string NAME { get; set; } + public double VERSION { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES_RMLS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES_RMLS.cs new file mode 100644 index 000000000..cd8865526 --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LIQUID_TYPES_RMLS.cs @@ -0,0 +1,24 @@ +//------------------------------------------------------------------------------ +// +// This code was generated from a template. +// +// Manual changes to this file may cause unexpected behavior in your application. +// Manual changes to this file will be overwritten if the code is regenerated. +// +//------------------------------------------------------------------------------ + +namespace Tango.DAL.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class LIQUID_TYPES_RMLS + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public bool DELETED { get; set; } + public string LIQUID_TYPE_GUID { get; set; } + public string RML_GUID { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs index 38ae0a849..10f77068c 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs @@ -25,7 +25,7 @@ namespace Tango.DAL.Local.DB throw new UnintentionalCodeFirstException(); } - public virtual DbSet ACTIONS { get; set; } + public virtual DbSet ACTION_TYPES { get; set; } public virtual DbSet
ADDRESSES { get; set; } public virtual DbSet APPLICATION_DISPLAY_PANEL_VERSIONS { get; set; } public virtual DbSet APPLICATION_FIRMWARE_VERSIONS { get; set; } @@ -39,15 +39,15 @@ namespace Tango.DAL.Local.DB public virtual DbSet DISPENSERS { get; set; } public virtual DbSet EMBEDDED_FIRMWARE_VERSIONS { get; set; } public virtual DbSet EMBEDDED_SOFTWARE_VERSIONS { get; set; } - public virtual DbSet EVENTS { get; set; } - public virtual DbSet EVENTS_ACTIONS { get; set; } + public virtual DbSet EVENT_TYPES { get; set; } + public virtual DbSet EVENT_TYPES_ACTIONS { get; set; } public virtual DbSet FIBER_SHAPES { get; set; } public virtual DbSet FIBER_SYNTHESISES { get; set; } public virtual DbSet HARDWARE_VERSIONS { get; set; } public virtual DbSet IDS_PACKS { get; set; } public virtual DbSet LINEAR_MASS_DENSITY_UNITS { get; set; } - public virtual DbSet LIQUIDS { get; set; } - public virtual DbSet LIQUIDS_RMLS { get; set; } + public virtual DbSet LIQUID_TYPES { get; set; } + public virtual DbSet LIQUID_TYPES_RMLS { get; set; } public virtual DbSet MACHINE_VERSIONS { get; set; } public virtual DbSet MACHINES { get; set; } public virtual DbSet MACHINES_CONFIGURATIONS { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx index bd71d7457..261cec120 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx @@ -5,7 +5,7 @@ - + @@ -158,7 +158,7 @@ - + @@ -169,7 +169,7 @@ - + @@ -177,8 +177,8 @@ - - + + @@ -217,7 +217,7 @@ - + @@ -229,7 +229,7 @@ - + @@ -241,7 +241,7 @@ - + @@ -249,7 +249,7 @@ - + @@ -275,6 +275,7 @@ + @@ -296,7 +297,7 @@ - + @@ -446,7 +447,7 @@ - + @@ -460,15 +461,15 @@ - - + + - - + + @@ -491,7 +492,7 @@ - + @@ -505,15 +506,15 @@ - - + + - - + + @@ -531,7 +532,7 @@ - + @@ -684,7 +685,7 @@ - + @@ -695,7 +696,7 @@ - + @@ -703,8 +704,8 @@ - - + + @@ -743,7 +744,7 @@ - + @@ -755,7 +756,7 @@ - + @@ -767,7 +768,7 @@ - + @@ -775,7 +776,7 @@ - + @@ -801,6 +802,7 @@ + @@ -822,7 +824,7 @@ - + @@ -977,9 +979,9 @@ - - - + + + @@ -1144,9 +1146,9 @@ - - - + + + @@ -1156,11 +1158,11 @@ - - - - - + + + + + @@ -1202,7 +1204,7 @@ - + @@ -1222,9 +1224,9 @@ - - - + + + @@ -1235,11 +1237,11 @@ - - - + + + - + @@ -1261,6 +1263,7 @@ + @@ -1291,7 +1294,7 @@ - + diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram index 350983c76..5bbf17d24 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram @@ -5,7 +5,7 @@ - + @@ -19,15 +19,15 @@ - - + + - - + + diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE.cs index b01607300..7bf83f80c 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE.cs @@ -23,5 +23,6 @@ namespace Tango.DAL.Local.DB public System.DateTime PRODUCTION_DATE { get; set; } public string ORGANIZATION_GUID { get; set; } public string MACHINE_VERSION_GUID { get; set; } + public string CONFIGURATION_GUID { get; set; } } } diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINES_EVENTS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINES_EVENTS.cs index 599ab3332..2b916274a 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINES_EVENTS.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINES_EVENTS.cs @@ -19,7 +19,7 @@ namespace Tango.DAL.Local.DB public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string MACHINE_GUID { get; set; } - public string EVENT_GUID { get; set; } + public string EVENT_TYPE_GUID { get; set; } public string USER_GUID { get; set; } public System.DateTime DATE_TIME { get; set; } public string DESCRIPTION { get; set; } -- cgit v1.3.1