New Extra Inks DB, PMR, BL.

1 files changed, 117 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
index 4b7448f98..8ed5c4fed 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
@@ -832,6 +832,43 @@
           <Property Name="LIGHT_RUBINE_QUANTITY" Type="bigint" Nullable="false" />
           <Property Name="NAVY_QUANTITY" Type="bigint" Nullable="false" />
           <Property Name="VIOLET_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_TRANSPARENT_INK_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="C1_TI_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_CYAN_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_LIGHT_CYAN_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_MAGENTA_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_LIGHT_MAGENTA_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_YELLOW_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_LIGHT_YELLOW_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="C1_YELLOW_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="C1_LIGHT_YELLOW_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_BLACK_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_VIOLET_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="TW_LIGHT_VIOLET_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="CT_BLUE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="CT_LIGHT_BLUE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="CT_RUBINE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="CT_LIGHT_RUBINE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="CT_ORANGE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="CT_LIGHT_ORANGE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="CT_NAVY_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_BLUE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_LIGHT_BLUE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_RUBINE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_LIGHT_RUBINE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_ORANGE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_LIGHT_ORANGE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_NAVY_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="HD_LIGHT_NAVY_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_BLUE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_LIGHT_BLUE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_RED_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_LIGHT_RED_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_ORANGE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_LIGHT_ORANGE_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_YELLOW_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_LIGHT_YELLOW_QUANTITY" Type="bigint" Nullable="false" />
+          <Property Name="AM_BLACK_QUANTITY" Type="bigint" Nullable="false" />
         </EntityType>
         <EntityType Name="JOBS">
           <Key>
@@ -906,6 +943,7 @@
           <Property Name="IS_EXTRA_INK" Type="bit" Nullable="false" />
           <Property Name="IS_LIGHT_INK" Type="bit" Nullable="false" />
           <Property Name="DARK_INK_CODE" Type="int" Nullable="false" />
+          <Property Name="DISPLAY_NAME" Type="nvarchar" MaxLength="50" />
         </EntityType>
         <EntityType Name="LIQUID_TYPES_RMLS">
           <Key>
@@ -1420,6 +1458,7 @@
           <Property Name="BTSR_APPLICATION_TYPE_GUID" Type="varchar" MaxLength="36" />
           <Property Name="BTSR_YARN_TYPE_GUID" Type="varchar" MaxLength="36" />
           <Property Name="BTSR_TENSION_ERROR" Type="float" Nullable="false" />
+          <Property Name="DEFAULT_LIQUID_FACTOR" Type="float" Nullable="false" />
         </EntityType>
         <EntityType Name="RMLS_EXTENSIONS">
           <Key>
@@ -6529,6 +6568,43 @@
           <Property Name="LIGHT_RUBINE_QUANTITY" Type="Int64" Nullable="false" />
           <Property Name="NAVY_QUANTITY" Type="Int64" Nullable="false" />
           <Property Name="VIOLET_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_TRANSPARENT_INK_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="C1_TI_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_CYAN_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_LIGHT_CYAN_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_MAGENTA_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_LIGHT_MAGENTA_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_YELLOW_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_LIGHT_YELLOW_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="C1_YELLOW_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="C1_LIGHT_YELLOW_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_BLACK_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_VIOLET_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="TW_LIGHT_VIOLET_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="CT_BLUE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="CT_LIGHT_BLUE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="CT_RUBINE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="CT_LIGHT_RUBINE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="CT_ORANGE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="CT_LIGHT_ORANGE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="CT_NAVY_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_BLUE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_LIGHT_BLUE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_RUBINE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_LIGHT_RUBINE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_ORANGE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_LIGHT_ORANGE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_NAVY_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="HD_LIGHT_NAVY_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_BLUE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_LIGHT_BLUE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_RED_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_LIGHT_RED_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_ORANGE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_LIGHT_ORANGE_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_YELLOW_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_LIGHT_YELLOW_QUANTITY" Type="Int64" Nullable="false" />
+          <Property Name="AM_BLACK_QUANTITY" Type="Int64" Nullable="false" />
         </EntityType>
         <EntityType Name="JOB">
           <Key>
@@ -6614,6 +6690,7 @@
           <Property Name="IS_EXTRA_INK" Type="Boolean" Nullable="false" />
           <Property Name="IS_LIGHT_INK" Type="Boolean" Nullable="false" />
           <Property Name="DARK_INK_CODE" Type="Int32" Nullable="false" />
+          <Property Name="DISPLAY_NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
           <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_LIQUID_TYPES1" FromRole="LIQUID_TYPES" ToRole="CAT" />
           <NavigationProperty Name="IDS_PACKS" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="LIQUID_TYPES" ToRole="IDS_PACKS" />
           <NavigationProperty Name="LIQUID_TYPES_RMLS" Relationship="RemoteModel.FK_LIQUID_TYPES_RMLS_LIQUID_TYPES" FromRole="LIQUID_TYPES" ToRole="LIQUID_TYPES_RMLS" />
@@ -7031,6 +7108,7 @@
           <Property Name="BTSR_APPLICATION_TYPE_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
           <Property Name="BTSR_YARN_TYPE_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
           <Property Name="BTSR_TENSION_ERROR" Type="Double" Nullable="false" />
+          <Property Name="DEFAULT_LIQUID_FACTOR" Type="Double" Nullable="false" />
           <NavigationProperty Name="BTSR_APPLICATION_TYPES" Relationship="RemoteModel.FK_RMLS_BTSR_APPLICATION_TYPES" FromRole="RML" ToRole="BTSR_APPLICATION_TYPES" />
           <NavigationProperty Name="BTSR_YARN_TYPES" Relationship="RemoteModel.FK_RMLS_BTSR_YARN_TYPES" FromRole="RML" ToRole="BTSR_YARN_TYPES" />
           <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_RMLS" FromRole="RML" ToRole="CAT" />
@@ -10009,6 +10087,43 @@
           <EntitySetMapping Name="JOB_RUNS">
             <EntityTypeMapping TypeName="RemoteModel.JOB_RUNS">
               <MappingFragment StoreEntitySet="JOB_RUNS">
+                <ScalarProperty Name="AM_BLACK_QUANTITY" ColumnName="AM_BLACK_QUANTITY" />
+                <ScalarProperty Name="AM_LIGHT_YELLOW_QUANTITY" ColumnName="AM_LIGHT_YELLOW_QUANTITY" />
+                <ScalarProperty Name="AM_YELLOW_QUANTITY" ColumnName="AM_YELLOW_QUANTITY" />
+                <ScalarProperty Name="AM_LIGHT_ORANGE_QUANTITY" ColumnName="AM_LIGHT_ORANGE_QUANTITY" />
+                <ScalarProperty Name="AM_ORANGE_QUANTITY" ColumnName="AM_ORANGE_QUANTITY" />
+                <ScalarProperty Name="AM_LIGHT_RED_QUANTITY" ColumnName="AM_LIGHT_RED_QUANTITY" />
+                <ScalarProperty Name="AM_RED_QUANTITY" ColumnName="AM_RED_QUANTITY" />
+                <ScalarProperty Name="AM_LIGHT_BLUE_QUANTITY" ColumnName="AM_LIGHT_BLUE_QUANTITY" />
+                <ScalarProperty Name="AM_BLUE_QUANTITY" ColumnName="AM_BLUE_QUANTITY" />
+                <ScalarProperty Name="HD_LIGHT_NAVY_QUANTITY" ColumnName="HD_LIGHT_NAVY_QUANTITY" />
+                <ScalarProperty Name="HD_NAVY_QUANTITY" ColumnName="HD_NAVY_QUANTITY" />
+                <ScalarProperty Name="HD_LIGHT_ORANGE_QUANTITY" ColumnName="HD_LIGHT_ORANGE_QUANTITY" />
+                <ScalarProperty Name="HD_ORANGE_QUANTITY" ColumnName="HD_ORANGE_QUANTITY" />
+                <ScalarProperty Name="HD_LIGHT_RUBINE_QUANTITY" ColumnName="HD_LIGHT_RUBINE_QUANTITY" />
+                <ScalarProperty Name="HD_RUBINE_QUANTITY" ColumnName="HD_RUBINE_QUANTITY" />
+                <ScalarProperty Name="HD_LIGHT_BLUE_QUANTITY" ColumnName="HD_LIGHT_BLUE_QUANTITY" />
+                <ScalarProperty Name="HD_BLUE_QUANTITY" ColumnName="HD_BLUE_QUANTITY" />
+                <ScalarProperty Name="CT_NAVY_QUANTITY" ColumnName="CT_NAVY_QUANTITY" />
+                <ScalarProperty Name="CT_LIGHT_ORANGE_QUANTITY" ColumnName="CT_LIGHT_ORANGE_QUANTITY" />
+                <ScalarProperty Name="CT_ORANGE_QUANTITY" ColumnName="CT_ORANGE_QUANTITY" />
+                <ScalarProperty Name="CT_LIGHT_RUBINE_QUANTITY" ColumnName="CT_LIGHT_RUBINE_QUANTITY" />
+                <ScalarProperty Name="CT_RUBINE_QUANTITY" ColumnName="CT_RUBINE_QUANTITY" />
+                <ScalarProperty Name="CT_LIGHT_BLUE_QUANTITY" ColumnName="CT_LIGHT_BLUE_QUANTITY" />
+                <ScalarProperty Name="CT_BLUE_QUANTITY" ColumnName="CT_BLUE_QUANTITY" />
+                <ScalarProperty Name="TW_LIGHT_VIOLET_QUANTITY" ColumnName="TW_LIGHT_VIOLET_QUANTITY" />
+                <ScalarProperty Name="TW_VIOLET_QUANTITY" ColumnName="TW_VIOLET_QUANTITY" />
+                <ScalarProperty Name="TW_BLACK_QUANTITY" ColumnName="TW_BLACK_QUANTITY" />
+                <ScalarProperty Name="C1_LIGHT_YELLOW_QUANTITY" ColumnName="C1_LIGHT_YELLOW_QUANTITY" />
+                <ScalarProperty Name="C1_YELLOW_QUANTITY" ColumnName="C1_YELLOW_QUANTITY" />
+                <ScalarProperty Name="TW_LIGHT_YELLOW_QUANTITY" ColumnName="TW_LIGHT_YELLOW_QUANTITY" />
+                <ScalarProperty Name="TW_YELLOW_QUANTITY" ColumnName="TW_YELLOW_QUANTITY" />
+                <ScalarProperty Name="TW_LIGHT_MAGENTA_QUANTITY" ColumnName="TW_LIGHT_MAGENTA_QUANTITY" />
+                <ScalarProperty Name="TW_MAGENTA_QUANTITY" ColumnName="TW_MAGENTA_QUANTITY" />
+                <ScalarProperty Name="TW_LIGHT_CYAN_QUANTITY" ColumnName="TW_LIGHT_CYAN_QUANTITY" />
+                <ScalarProperty Name="TW_CYAN_QUANTITY" ColumnName="TW_CYAN_QUANTITY" />
+                <ScalarProperty Name="C1_TI_QUANTITY" ColumnName="C1_TI_QUANTITY" />
+                <ScalarProperty Name="TW_TRANSPARENT_INK_QUANTITY" ColumnName="TW_TRANSPARENT_INK_QUANTITY" />
                 <ScalarProperty Name="VIOLET_QUANTITY" ColumnName="VIOLET_QUANTITY" />
                 <ScalarProperty Name="NAVY_QUANTITY" ColumnName="NAVY_QUANTITY" />
                 <ScalarProperty Name="LIGHT_RUBINE_QUANTITY" ColumnName="LIGHT_RUBINE_QUANTITY" />
@@ -10125,6 +10240,7 @@
           <EntitySetMapping Name="LIQUID_TYPES">
             <EntityTypeMapping TypeName="RemoteModel.LIQUID_TYPES">
               <MappingFragment StoreEntitySet="LIQUID_TYPES">
+                <ScalarProperty Name="DISPLAY_NAME" ColumnName="DISPLAY_NAME" />
                 <ScalarProperty Name="DARK_INK_CODE" ColumnName="DARK_INK_CODE" />
                 <ScalarProperty Name="IS_LIGHT_INK" ColumnName="IS_LIGHT_INK" />
                 <ScalarProperty Name="IS_EXTRA_INK" ColumnName="IS_EXTRA_INK" />
@@ -10477,6 +10593,7 @@
           <EntitySetMapping Name="RMLS">
             <EntityTypeMapping TypeName="RemoteModel.RML">
               <MappingFragment StoreEntitySet="RMLS">
+                <ScalarProperty Name="DEFAULT_LIQUID_FACTOR" ColumnName="DEFAULT_LIQUID_FACTOR" />
                 <ScalarProperty Name="BTSR_TENSION_ERROR" ColumnName="BTSR_TENSION_ERROR" />
                 <ScalarProperty Name="BTSR_YARN_TYPE_GUID" ColumnName="BTSR_YARN_TYPE_GUID" />
                 <ScalarProperty Name="BTSR_APPLICATION_TYPE_GUID" ColumnName="BTSR_APPLICATION_TYPE_GUID" />