public void TagScriptsToReleaseVehicle()
        {
            try
            {
                DataTable tagScripts = new DataTable();
                tagScripts.Columns.Add("NoSoonerThan", typeof(DateTime));
                tagScripts.Columns.Add("NoLaterThan", typeof(DateTime));
                tagScripts.Columns.Add("ReleaseID", typeof(int));
                tagScripts.Columns.Add("ReleaseName", typeof(string));
                tagScripts.Columns.Add("ReleaseStartDate", typeof(DateTime));
                tagScripts.Columns.Add("ReleaseEndDate", typeof(DateTime));
                tagScripts.Columns.Add("TechnicalSignoffID", typeof(int));
                tagScripts.Columns.Add("TechnicalSignoffstartdate", typeof(DateTime));
                tagScripts.Columns.Add("TechnicalSignoffEnddate", typeof(DateTime));
                tagScripts.Columns.Add("ReleaseType", typeof(string));


                DataSet      dataSet   = new DataSet();
                SqlUtilities sqlHelper = new SqlUtilities(new SqlConnection(ConfigurationManager.AppSettings["DSConnectionString"]));
                dataSet = sqlHelper.GetDataSet("TaggingService_GetNotTaggedScripts");

                if (dataSet.Tables[0] != null && dataSet.Tables[0].Rows.Count > 0)
                {
                    SqlUtilities DOMOSQLHelper = new SqlUtilities(new SqlConnection(ConfigurationManager.AppSettings["DOMOAutomationConnectionString"]));
                    foreach (DataRow row in dataSet.Tables[0].Rows)
                    {
                        DataSet dsReleaseCalendarDetails = DOMOSQLHelper.GetDataSet("GetReleaseCalendarEventDates",
                                                                                    new List <CommandParameter> {
                            new CommandParameter {
                                Name = "NoSoonerDate", Type = SqlDbType.DateTime, Value = row["NoSoonerThan"].ToString()
                            },
                            new CommandParameter {
                                Name = "NoLongerDate", Type = SqlDbType.DateTime, Value = row["NoLaterThan"].ToString()
                            }
                        });
                        if (dsReleaseCalendarDetails != null && dsReleaseCalendarDetails.Tables[0] != null && dsReleaseCalendarDetails.Tables[0].Rows.Count > 0 && dsReleaseCalendarDetails.Tables[0].Rows[0]["ReleaseType"].ToString() != "101")
                        {
                            tagScripts.Rows.Add(row["NoSoonerThan"].ToString(),
                                                row["NoLaterThan"].ToString(),
                                                Convert.ToInt32(dsReleaseCalendarDetails.Tables[0].Rows[0]["ReleaseID"]),
                                                dsReleaseCalendarDetails.Tables[0].Rows[0]["ReleaseName"].ToString(),
                                                Convert.ToDateTime(dsReleaseCalendarDetails.Tables[0].Rows[0]["ReleaseStartDate"]),
                                                Convert.ToDateTime(dsReleaseCalendarDetails.Tables[0].Rows[0]["ReleaseEndDate"]),
                                                Convert.ToInt32(dsReleaseCalendarDetails.Tables[0].Rows[0]["TechnicalSignoffID"]),
                                                Convert.ToDateTime(dsReleaseCalendarDetails.Tables[0].Rows[0]["TechnicalSignoffstartdate"]),
                                                Convert.ToDateTime(dsReleaseCalendarDetails.Tables[0].Rows[0]["TechnicalSignoffEnddate"]),
                                                dsReleaseCalendarDetails.Tables[0].Rows[0]["ReleaseType"].ToString());
                        }
                        else
                        {
                            tagScripts.Rows.Add(row["NoSoonerThan"].ToString(),
                                                row["NoLaterThan"].ToString(),
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                dsReleaseCalendarDetails != null && dsReleaseCalendarDetails.Tables[0] != null && dsReleaseCalendarDetails.Tables[0].Rows.Count > 0
                                                        ? dsReleaseCalendarDetails.Tables[0].Rows[0]["ReleaseType"].ToString() : null);
                        }
                    }

                    if (tagScripts.Rows.Count > 0)
                    {
                        sqlHelper.ExecuteNonQuery("TaggingService_TagScriptsToReleaseVehicle",
                                                  new List <CommandParameter> {
                            new CommandParameter {
                                Name = "ReleaseCalendarDetails", Type = SqlDbType.Structured, Value = tagScripts
                            }
                        });
                    }
                }
            }
            catch (Exception ex)
            {
                LogException(ex);
            }
        }