From 050919591a635d15cb672b94511451f5a2d263ff Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bellai=20=C3=81d=C3=A1m?= Date: Tue, 3 Oct 2017 09:32:42 +0000 Subject: [PATCH] git-tfs-id: [http://tfs.userrendszerhaz.hu:8080/tfs/DefaultCollection]$/MediaCube;C30510 --- client/IntegrationTests/PlanAIRTests.cs | 19 +- client/Maestro/MaestroForm.Target.cs | 3 +- client/Maestro/MaestroForm.cs | 2 +- client/PlanAIRClient/Reader.cs | 49 +++- client/PlanAIRClient/TrafficAPI.cs | 142 ++++++++- .../PlanAIRClient/TrafficClasses.designer.cs | 8 +- client/PlanAIRClient/TrafficClient.csproj | 2 + client/PlanAIRClient/TrafficIDSelector.cs | 11 +- .../clIFsp_EC_MAMAdvertismentsResult.cs | 195 +++++++++++++ .../clIFsp_EC_MAMPromotionalResult.cs | 273 ++++++++++++++++++ 10 files changed, 674 insertions(+), 30 deletions(-) create mode 100644 client/PlanAIRClient/clIFsp_EC_MAMAdvertismentsResult.cs create mode 100644 client/PlanAIRClient/clIFsp_EC_MAMPromotionalResult.cs diff --git a/client/IntegrationTests/PlanAIRTests.cs b/client/IntegrationTests/PlanAIRTests.cs index a4e26b69..fd3382c9 100644 --- a/client/IntegrationTests/PlanAIRTests.cs +++ b/client/IntegrationTests/PlanAIRTests.cs @@ -46,6 +46,7 @@ namespace IntegrationTests { [TestMethod] public void DeleteSegmentTest() { + //Fixture const int segmentID = 82454; //Exercise @@ -53,11 +54,21 @@ namespace IntegrationTests { } [TestMethod] - public void TestGetList() { - //TrafficAPI sut = new TrafficAPI(); - //var result = sut.GetList(); - //Assert.IsNotNull(result); + public void SearchPromotionalsTest() { + //Fixture + const string STR_PARAM = ""; + + //Exercise + List actual = sut.SearchPromotional(STR_PARAM); } + [TestMethod] + public void SearchAdvertisementTest() { + //Fixture + const string STR_PARAM = ""; + + //Exercise + List actual = sut.SearchAdvertisement(STR_PARAM); + } } } diff --git a/client/Maestro/MaestroForm.Target.cs b/client/Maestro/MaestroForm.Target.cs index 8eb4f33c..5eff6f4a 100644 --- a/client/Maestro/MaestroForm.Target.cs +++ b/client/Maestro/MaestroForm.Target.cs @@ -70,7 +70,7 @@ namespace Maestro { } private void OnInfoTextChanged(object sender, EventArgs e) { - //ApplyProcessorButtonsLogic(); + ApplyProcessorButtonsLogic(); ApplyMetaDataButtonLogic(); } @@ -106,6 +106,7 @@ namespace Maestro { if (Configuration.Player != null) ctxiDefineSegments.Enabled = SelectedSource?.FileInfo != null && Configuration.Player.SegmentEditor && MetadataType.Traffic.Equals(SelectedMetadata?.Kind); + //todo IsSelectedFileAnID(); EnableArchiveMetadataButtonAndCreateMetadataModel(); } diff --git a/client/Maestro/MaestroForm.cs b/client/Maestro/MaestroForm.cs index 704c1e0f..7886e035 100644 --- a/client/Maestro/MaestroForm.cs +++ b/client/Maestro/MaestroForm.cs @@ -231,7 +231,7 @@ namespace Maestro { private void SetTrafficIDToMetadataText() { TrafficAPI api = trafficIDSelector.trafficAPI; Cursor.Current = Cursors.WaitCursor; - List result = api.Search(startingName, null, null, true); + List result = api.SearchBroadcast(startingName, null, null, true); ProcessMamResults(result); } diff --git a/client/PlanAIRClient/Reader.cs b/client/PlanAIRClient/Reader.cs index 64bb0b8b..b7d25a31 100644 --- a/client/PlanAIRClient/Reader.cs +++ b/client/PlanAIRClient/Reader.cs @@ -43,10 +43,9 @@ namespace TrafficClient { return result; } - public clIFsp_EC_MAMResult ToclIFsp_MAMResult(SqlDataReader reader) { - clIFsp_EC_MAMResult item = new clIFsp_EC_MAMResult(); + public clIFsp_EC_MAMBradocastResult ToclIFsp_MAMBroadcastResult(SqlDataReader reader) { + clIFsp_EC_MAMBradocastResult item = new clIFsp_EC_MAMBradocastResult(); int f = 0; - //TODO check item.v_ProgrammeID = (int)ReadInt(reader, ref f); item.v_Live = (bool)ReadBool(reader, ref f); item.v_EpisodeID = ReadString(reader, ref f); @@ -69,6 +68,50 @@ namespace TrafficClient { return item; } + public clIFsp_EC_MAMPromotionalResult ToclIFsp_MAMPromotionalResult(SqlDataReader reader) { + clIFsp_EC_MAMPromotionalResult item = new clIFsp_EC_MAMPromotionalResult(); + int f = 0; + item.t_SpotID = (int)ReadInt(reader, ref f); + item.t_MediaID = ReadString(reader, ref f); + item.v_Title = ReadString(reader, ref f); + item.v_PromoType = ReadString(reader, ref f); + item.v_ProgTitle = ReadString(reader, ref f); + item.v_Episode = ReadShort(reader, ref f); + item.t_PSStart = ReadDateTime(reader, ref f); + item.t_PSEnd = ReadDateTime(reader, ref f); + item.v_EstimatedDuration = ReadInt(reader, ref f); + item.t_TcIn = ReadInt(reader, ref f); + item.t_TcOut = ReadInt(reader, ref f); + item.t_Duration = ReadInt(reader, ref f); + item.v_TcIn = ReadString(reader, ref f); + item.v_TcOut = ReadString(reader, ref f); + item.v_Duration = ReadString(reader, ref f); + item.v_Stations = ReadString(reader, ref f); + item.t_OkForAir = ReadBool(reader, ref f); + item.v_OkForAirs = ReadBool(reader, ref f); + item.v_IsInactive = ReadBool(reader, ref f); + return item; + } + + public clIFsp_EC_MAMAdvertismentResult ToclIFsp_MAMAdvertisementResult(SqlDataReader reader) { + clIFsp_EC_MAMAdvertismentResult item = new clIFsp_EC_MAMAdvertismentResult(); + int f = 0; + item.t_SpotID = (int)ReadInt(reader, ref f); + item.t_MediaID = ReadString(reader, ref f); + item.v_Title = ReadString(reader, ref f); + item.t_Advertiser = ReadString(reader, ref f); + item.v_EstimatedDuration = ReadInt(reader, ref f); + item.t_TcIn = ReadInt(reader, ref f); + item.t_TcOut = ReadInt(reader, ref f); + item.t_Duration = ReadInt(reader, ref f); + item.v_TcIn = ReadString(reader, ref f); + item.v_TcOut = ReadString(reader, ref f); + item.v_Duration = ReadString(reader, ref f); + item.t_OkForAir = ReadBool(reader, ref f); + item.v_OkForAirs = ReadBool(reader, ref f); + return item; + } + public clIFsp_EC_SegmentResult ToclIFsp_SegmentResult(SqlDataReader reader) { clIFsp_EC_SegmentResult item = new clIFsp_EC_SegmentResult(); int f = 0; diff --git a/client/PlanAIRClient/TrafficAPI.cs b/client/PlanAIRClient/TrafficAPI.cs index 038f2b62..63940e5a 100644 --- a/client/PlanAIRClient/TrafficAPI.cs +++ b/client/PlanAIRClient/TrafficAPI.cs @@ -18,8 +18,8 @@ namespace TrafficClient { cliFSPReader = new CliFSPReader(); } - public List Search(string strParam, DateTime? from, DateTime? to, bool missingCopia) { - List sqlResult = null; + public List SearchBroadcast(string strParam, DateTime? from, DateTime? to, bool missingCopia) { + List sqlResult = null; List result = null; try { TryConnect(); @@ -40,8 +40,8 @@ namespace TrafficClient { cmd.Parameters.AddWithValue("@@DateParam2", to.Value.Date); } } - sqlResult = ExecuteAndRead(cmd); - result = ProcessMamResult(sqlResult); + sqlResult = ExecuteAndReadBradcast(cmd); + result = ProcessMamBroadcastResult(sqlResult); } } catch (Exception e) { @@ -61,11 +61,11 @@ namespace TrafficClient { } } - private List ProcessMamResult(List sqlResult) { + private List ProcessMamBroadcastResult(List sqlResult) { if (sqlResult == null) return null; List result = new List(); - foreach (clIFsp_EC_MAMResult actual in sqlResult) { + foreach (clIFsp_EC_MAMBradocastResult actual in sqlResult) { MamResultWrapper actualObject = new MamResultWrapper() { MediaID = actual.v_MediaID, EpisodeTitle = actual.v_EpTitle, @@ -211,13 +211,13 @@ namespace TrafficClient { return result; } - private List ExecuteAndRead(SqlCommand cmd) { - List result = null; + private List ExecuteAndReadBradcast(SqlCommand cmd) { + List result = null; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (result == null) - result = new List(); - clIFsp_EC_MAMResult item = cliFSPReader.ToclIFsp_MAMResult(reader); + result = new List(); + clIFsp_EC_MAMBradocastResult item = cliFSPReader.ToclIFsp_MAMBroadcastResult(reader); result.Add(item); } } @@ -225,7 +225,7 @@ namespace TrafficClient { } public List SearchArchiveMetadata(string strParam) { - List sqlResult = null; + List sqlResult = null; List result = null; try { TryConnect(); @@ -235,7 +235,7 @@ namespace TrafficClient { cmd.Parameters.AddWithValue("@@@Options", 40); cmd.Parameters.AddWithValue("@@ItemID", DBNull.Value); cmd.Parameters.AddWithValue("@@StrParam1", strParam); - sqlResult = ExecuteAndRead(cmd); + sqlResult = ExecuteAndReadBradcast(cmd); result = ProcessArchiveResult(sqlResult); } } @@ -249,11 +249,11 @@ namespace TrafficClient { return result; } - private List ProcessArchiveResult(List sqlResult) { + private List ProcessArchiveResult(List sqlResult) { if (sqlResult == null) return null; List result = new List(); - foreach (clIFsp_EC_MAMResult actual in sqlResult) { + foreach (clIFsp_EC_MAMBradocastResult actual in sqlResult) { ArchiveMatadataWrapper actualObject = new ArchiveMatadataWrapper() { EpisodeID = actual.v_EpisodeID, EpisodeTitle = actual.v_EpTitle, @@ -264,5 +264,119 @@ namespace TrafficClient { } return result; } + + public List SearchPromotional(string strParam) { + List sqlResult = null; + List result = null; + try { + TryConnect(); + using (SqlCommand cmd = new SqlCommand("dbo.clIFsp_EC_MAM", connection)) { + cmd.CommandType = CommandType.StoredProcedure; + cmd.Parameters.AddWithValue("@Operation", 2001); + cmd.Parameters.AddWithValue("@@@Options", 40); + cmd.Parameters.AddWithValue("@@ItemID", DBNull.Value); + cmd.Parameters.AddWithValue("@@StrParam1", strParam); + sqlResult = ExecuteAndReadPromotionals(cmd); + result = ProcessMamPromotionalResult(sqlResult); + } + } + catch (Exception e) { + logger.Error(e.Message); + throw e; + } + finally { + connection.Close(); + } + return result; + } + + private List ExecuteAndReadPromotionals(SqlCommand cmd) { + List result = null; + using (SqlDataReader reader = cmd.ExecuteReader()) { + while (reader.Read()) { + if (result == null) + result = new List(); + clIFsp_EC_MAMPromotionalResult item = cliFSPReader.ToclIFsp_MAMPromotionalResult(reader); + result.Add(item); + } + } + return result; + } + + private List ProcessMamPromotionalResult(List sqlResult) { + if (sqlResult == null) + return null; + List result = new List(); + foreach (clIFsp_EC_MAMPromotionalResult actual in sqlResult) { + //MamResultWrapper actualObject = new MamResultWrapper() { + // MediaID = actual.v_MediaID, + // EpisodeTitle = actual.v_EpTitle, + // Title = actual.v_ProgTitle, + // EpisodeNumber = actual.v_EpisodeID, + // VariantID = actual.v_VariantID.HasValue ? actual.v_VariantID.Value : -1, + // Episode = actual.v_Episode.HasValue ? actual.v_Episode.Value : (short)-1, + // NextBroadcastDate = actual.v_NextBroadcastDate + //}; + //result.Add(actualObject); + } + return result; + } + + public List SearchAdvertisement(string strParam) { + List sqlResult = null; + List result = null; + try { + TryConnect(); + using (SqlCommand cmd = new SqlCommand("dbo.clIFsp_EC_MAM", connection)) { + cmd.CommandType = CommandType.StoredProcedure; + cmd.Parameters.AddWithValue("@Operation", 3001); + cmd.Parameters.AddWithValue("@@@Options", 40); + cmd.Parameters.AddWithValue("@@ItemID", DBNull.Value); + cmd.Parameters.AddWithValue("@@StrParam1", strParam); + sqlResult = ExecuteAndReadAdvertisement(cmd); + result = ProcessMamAdvertismentResult(sqlResult); + } + } + catch (Exception e) { + logger.Error(e.Message); + throw e; + } + finally { + connection.Close(); + } + return result; + } + + private List ExecuteAndReadAdvertisement(SqlCommand cmd) { + List result = null; + using (SqlDataReader reader = cmd.ExecuteReader()) { + while (reader.Read()) { + if (result == null) + result = new List(); + clIFsp_EC_MAMAdvertismentResult item = cliFSPReader.ToclIFsp_MAMAdvertisementResult(reader); + result.Add(item); + } + } + return result; + } + + private List ProcessMamAdvertismentResult(List sqlResult) { + if (sqlResult == null) + return null; + List result = new List(); + foreach (clIFsp_EC_MAMAdvertismentResult actual in sqlResult) { + //MamResultWrapper actualObject = new MamResultWrapper() { + // MediaID = actual.v_MediaID, + // EpisodeTitle = actual.v_EpTitle, + // Title = actual.v_ProgTitle, + // EpisodeNumber = actual.v_EpisodeID, + // VariantID = actual.v_VariantID.HasValue ? actual.v_VariantID.Value : -1, + // Episode = actual.v_Episode.HasValue ? actual.v_Episode.Value : (short)-1, + // NextBroadcastDate = actual.v_NextBroadcastDate + //}; + //result.Add(actualObject); + } + return result; + } } } diff --git a/client/PlanAIRClient/TrafficClasses.designer.cs b/client/PlanAIRClient/TrafficClasses.designer.cs index a7b3581f..390d87a9 100644 --- a/client/PlanAIRClient/TrafficClasses.designer.cs +++ b/client/PlanAIRClient/TrafficClasses.designer.cs @@ -63,14 +63,14 @@ namespace TrafficClient } [global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.clIFsp_EC_MAM")] - public ISingleResult clIFsp_EC_MAM([global::System.Data.Linq.Mapping.ParameterAttribute(Name="Operation", DbType="Int")] System.Nullable operation, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@@Options", DbType="Int")] System.Nullable @__Options, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@ItemID", DbType="Int")] System.Nullable _ItemID, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@IntParam1", DbType="Int")] System.Nullable _IntParam1, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@IntParam2", DbType="Int")] System.Nullable _IntParam2, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@IntParam3", DbType="Int")] System.Nullable _IntParam3, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@StrParam1", DbType="VarChar(200)")] string _StrParam1, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@StrParam2", DbType="VarChar(MAX)")] string _StrParam2, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@DateParam1", DbType="DateTime")] System.Nullable _DateParam1, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@DateParam2", DbType="DateTime")] System.Nullable _DateParam2) + public ISingleResult clIFsp_EC_MAM([global::System.Data.Linq.Mapping.ParameterAttribute(Name="Operation", DbType="Int")] System.Nullable operation, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@@Options", DbType="Int")] System.Nullable @__Options, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@ItemID", DbType="Int")] System.Nullable _ItemID, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@IntParam1", DbType="Int")] System.Nullable _IntParam1, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@IntParam2", DbType="Int")] System.Nullable _IntParam2, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@IntParam3", DbType="Int")] System.Nullable _IntParam3, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@StrParam1", DbType="VarChar(200)")] string _StrParam1, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@StrParam2", DbType="VarChar(MAX)")] string _StrParam2, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@DateParam1", DbType="DateTime")] System.Nullable _DateParam1, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="@DateParam2", DbType="DateTime")] System.Nullable _DateParam2) { IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), operation, @__Options, _ItemID, _IntParam1, _IntParam2, _IntParam3, _StrParam1, _StrParam2, _DateParam1, _DateParam2); - return ((ISingleResult)(result.ReturnValue)); + return ((ISingleResult)(result.ReturnValue)); } } - public partial class clIFsp_EC_MAMResult + public partial class clIFsp_EC_MAMBradocastResult { private int _v_ProgrammeID; @@ -109,7 +109,7 @@ namespace TrafficClient private string _v_MediaID; - public clIFsp_EC_MAMResult() + public clIFsp_EC_MAMBradocastResult() { } diff --git a/client/PlanAIRClient/TrafficClient.csproj b/client/PlanAIRClient/TrafficClient.csproj index 50e66513..f152a4c0 100644 --- a/client/PlanAIRClient/TrafficClient.csproj +++ b/client/PlanAIRClient/TrafficClient.csproj @@ -50,6 +50,8 @@ + + Component diff --git a/client/PlanAIRClient/TrafficIDSelector.cs b/client/PlanAIRClient/TrafficIDSelector.cs index acc44da0..4d293798 100644 --- a/client/PlanAIRClient/TrafficIDSelector.cs +++ b/client/PlanAIRClient/TrafficIDSelector.cs @@ -41,7 +41,7 @@ namespace TrafficClient { AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells, DataPropertyName = "MediaID", HeaderText = Resources.TRAFFIC_ID, - + }, new DataGridViewTextBoxColumn() { AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells, @@ -85,8 +85,13 @@ namespace TrafficClient { from = scheduledDate.Value; to = scheduledDate.Value.AddDays(1); } - var result = trafficAPI.Search(searchText, from, to, copiaCheckBox.Checked)?.ToArray(); - + MamResultWrapper[] result = null; + if (radioButtonBroadCast.Checked) + result = trafficAPI.SearchBroadcast(searchText, from, to, copiaCheckBox.Checked)?.ToArray(); + else if(radioButtonAD.Checked) + result = trafficAPI.SearchAdvertisement(searchText)?.ToArray(); + else if(radioButtonPromo.Checked) + result = trafficAPI.SearchPromotional(searchText)?.ToArray(); if (result == null) { dataGridView1.DataSource = null; return; diff --git a/client/PlanAIRClient/clIFsp_EC_MAMAdvertismentsResult.cs b/client/PlanAIRClient/clIFsp_EC_MAMAdvertismentsResult.cs new file mode 100644 index 00000000..00cee67e --- /dev/null +++ b/client/PlanAIRClient/clIFsp_EC_MAMAdvertismentsResult.cs @@ -0,0 +1,195 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace TrafficClient { + public partial class clIFsp_EC_MAMAdvertismentResult { + + private int _t_SpotID; + + private string _t_MediaID; + + private string _v_Title; + + private string _t_Advertiser; + + private System.Nullable _v_EstimatedDuration; + + private System.Nullable _t_TcIn; + + private System.Nullable _t_TcOut; + + private System.Nullable _t_Duration; + + private string _v_TcIn; + + private string _v_TcOut; + + private string _v_Duration; + + private System.Nullable _t_OkForAir; + + private System.Nullable _v_OkForAirs; + + public clIFsp_EC_MAMAdvertismentResult() { + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_SpotID", DbType = "Int NOT NULL")] + public int t_SpotID { + get { + return this._t_SpotID; + } + set { + if ((this._t_SpotID != value)) { + this._t_SpotID = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_MediaID", DbType = "VarChar(8) NOT NULL")] + public string t_MediaID { + get { + return this._t_MediaID; + } + set { + if ((this._t_MediaID != value)) { + this._t_MediaID = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_Title", DbType = "NVarChar(60)", CanBeNull = false)] + public string v_Title { + get { + return this._v_Title; + } + set { + if ((this._v_Title != value)) { + this._v_Title = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_Advertiser", DbType = "NvarChar(60)")] + public string t_Advertiser { + get { + return this._t_Advertiser; + } + set { + if ((this._t_Advertiser != value)) { + this._t_Advertiser = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_EstimatedDuration", DbType = "Int")] + public System.Nullable v_EstimatedDuration { + get { + return this._v_EstimatedDuration; + } + set { + if ((this._v_EstimatedDuration != value)) { + this._v_EstimatedDuration = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_TcIn", DbType = "Int")] + public System.Nullable t_TcIn { + get { + return this._t_TcIn; + } + set { + if ((this._t_TcIn != value)) { + this._t_TcIn = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_TcOut", DbType = "Int")] + public System.Nullable t_TcOut { + get { + return this._t_TcOut; + } + set { + if ((this._t_TcOut != value)) { + this._t_TcOut = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_Duration", DbType = "Int")] + public System.Nullable t_Duration { + get { + return this._t_Duration; + } + set { + if ((this._t_Duration != value)) { + this._t_Duration = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_TcIn", DbType = "Varchar(40)")] + public string v_TcIn { + get { + return this._v_TcIn; + } + set { + if ((this._v_TcIn != value)) { + this._v_TcIn = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_TcOut", DbType = "Varchar(40)")] + public string v_TcOut { + get { + return this._v_TcOut; + } + set { + if ((this._v_TcOut != value)) { + this._v_TcOut = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_Duration", DbType = "Varchar(40)")] + public string v_Duration { + get { + return this._v_Duration; + } + set { + if ((this._v_Duration != value)) { + this._v_Duration = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_OkForAir", DbType = "Bit")] + public System.Nullable t_OkForAir { + get { + return this._t_OkForAir; + } + set { + if ((this._t_OkForAir != value)) { + this._t_OkForAir = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_OkForAirs", DbType = "Bit")] + public System.Nullable v_OkForAirs { + get { + return this._v_OkForAirs; + } + set { + if ((this._v_OkForAirs != value)) { + this._v_OkForAirs = value; + } + } + } + } +} diff --git a/client/PlanAIRClient/clIFsp_EC_MAMPromotionalResult.cs b/client/PlanAIRClient/clIFsp_EC_MAMPromotionalResult.cs new file mode 100644 index 00000000..2a94fe37 --- /dev/null +++ b/client/PlanAIRClient/clIFsp_EC_MAMPromotionalResult.cs @@ -0,0 +1,273 @@ +namespace TrafficClient { + public partial class clIFsp_EC_MAMPromotionalResult { + + private int _t_SpotID; + + private string _t_MediaID; + + private string _v_Title; + + private string _v_PromoType; + + private string _v_ProgTitle; + + private System.Nullable _v_Episode; + + private System.Nullable _t_PSStart; + + private System.Nullable _t_PSEnd; + + private System.Nullable _v_EstimatedDuration; + + private System.Nullable _t_TcIn; + + private System.Nullable _t_TcOut; + + private System.Nullable _t_Duration; + + private string _v_TcIn; + + private string _v_TcOut; + + private string _v_Duration; + + private string _v_Stations; + + private System.Nullable _t_OkForAir; + + private System.Nullable _v_OkForAirs; + + private System.Nullable _v_IsInactive; + + public clIFsp_EC_MAMPromotionalResult() { + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_SpotID", DbType = "Int NOT NULL")] + public int t_SpotID { + get { + return this._t_SpotID; + } + set { + if ((this._t_SpotID != value)) { + this._t_SpotID = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_MediaID", DbType = "VarChar(8) NOT NULL")] + public string t_MediaID { + get { + return this._t_MediaID; + } + set { + if ((this._t_MediaID != value)) { + this._t_MediaID = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_Title", DbType = "NVarChar(60)", CanBeNull = false)] + public string v_Title { + get { + return this._v_Title; + } + set { + if ((this._v_Title != value)) { + this._v_Title = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_PromoType", DbType = "NvarChar(60)")] + public string v_PromoType { + get { + return this._v_PromoType; + } + set { + if ((this._v_PromoType != value)) { + this._v_PromoType = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_ProgTitle", DbType = "NVarChar(60)")] + public string v_ProgTitle { + get { + return this._v_ProgTitle; + } + set { + if ((this._v_ProgTitle != value)) { + this._v_ProgTitle = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_Episode", DbType = "SmallInt")] + public System.Nullable v_Episode { + get { + return this._v_Episode; + } + set { + if ((this._v_Episode != value)) { + this._v_Episode = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_PSStart", DbType = "DateTime")] + public System.Nullable t_PSStart { + get { + return this._t_PSStart; + } + set { + if ((this._t_PSStart != value)) { + this._t_PSStart = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_PSEnd", DbType = "DateTime")] + public System.Nullable t_PSEnd { + get { + return this._t_PSEnd; + } + set { + if ((this._t_PSEnd != value)) { + this._t_PSEnd = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_EstimatedDuration", DbType = "Int")] + public System.Nullable v_EstimatedDuration { + get { + return this._v_EstimatedDuration; + } + set { + if ((this._v_EstimatedDuration != value)) { + this._v_EstimatedDuration = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_TcIn", DbType = "Int")] + public System.Nullable t_TcIn { + get { + return this._t_TcIn; + } + set { + if ((this._t_TcIn != value)) { + this._t_TcIn = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_TcOut", DbType = "Int")] + public System.Nullable t_TcOut { + get { + return this._t_TcOut; + } + set { + if ((this._t_TcOut != value)) { + this._t_TcOut = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_Duration", DbType = "Int")] + public System.Nullable t_Duration { + get { + return this._t_Duration; + } + set { + if ((this._t_Duration != value)) { + this._t_Duration = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_TcIn", DbType = "Varchar(40)")] + public string v_TcIn { + get { + return this._v_TcIn; + } + set { + if ((this._v_TcIn != value)) { + this._v_TcIn = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_TcOut", DbType = "Varchar(40)")] + public string v_TcOut { + get { + return this._v_TcOut; + } + set { + if ((this._v_TcOut != value)) { + this._v_TcOut = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_Duration", DbType = "Varchar(40)")] + public string v_Duration { + get { + return this._v_Duration; + } + set { + if ((this._v_Duration != value)) { + this._v_Duration = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_Stations", DbType = "VarChar(100)")] + public string v_Stations { + get { + return this._v_Stations; + } + set { + if ((this._v_Stations != value)) { + this._v_Stations = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_t_OkForAir", DbType = "Bit")] + public System.Nullable t_OkForAir { + get { + return this._t_OkForAir; + } + set { + if ((this._t_OkForAir != value)) { + this._t_OkForAir = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_OkForAirs", DbType = "Bit")] + public System.Nullable v_OkForAirs { + get { + return this._v_OkForAirs; + } + set { + if ((this._v_OkForAirs != value)) { + this._v_OkForAirs = value; + } + } + } + + [global::System.Data.Linq.Mapping.ColumnAttribute(Storage = "_v_IsInactive", DbType = "Bit")] + public System.Nullable v_IsInactive { + get { + return this._v_IsInactive; + } + set { + if ((this._v_IsInactive != value)) { + this._v_IsInactive = value; + } + } + } + } +} -- 2.54.0