public virtual bool Fill(RebuilderData dataClass) { try { this.ScriptFileName = dataClass.ScriptFileName; this.ScriptId = dataClass.ScriptId; this.Sequence = dataClass.Sequence; this.ScriptText = dataClass.ScriptText; this.Database = dataClass.Database; this.Tag = dataClass.Tag; return(true); } catch (System.Exception ex) { throw new System.ApplicationException("Error in the Auto-Generated: RebuilderData.Fill(RebuilderData) Method", ex); } }
private List <RebuilderData> RetreiveBuildData() { string startinDb = connData.DatabaseName; string sql = @"SELECT ScriptFileName, ScriptId, Sequence,ScriptText, '' as [database], Tag FROM SqlBuild_Logging WHERE BuildFileName = @BuildFileName AND CommitDate = @CommitDate ORDER BY Sequence "; List <RebuilderData> data = new List <RebuilderData>(); string[] dbs = this.commitData.Database.Split(';'); for (int i = 0; i < dbs.Length; i++) { this.connData.DatabaseName = dbs[i]; SqlConnection conn = SqlSync.Connection.ConnectionHelper.GetConnection(this.connData); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@BuildFileName", this.commitData.BuildFileName); cmd.Parameters.AddWithValue("@CommitDate", this.commitData.CommitDate); conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { bool filled; while (!reader.IsClosed) { RebuilderData dat = new RebuilderData(); filled = dat.Fill(reader, false); if (filled) { dat.Database = dbs[i]; data.Add(dat); } } conn.Close(); } } this.connData.DatabaseName = startinDb; return(data); }
internal static List <RebuilderData> RetreiveBuildData(ConnectionData dbConnData, string buildFileHash, DateTime commitDate) { ; string sql = @"SELECT ScriptFileName, ScriptId, Sequence,ScriptText, '' as [database], Tag FROM SqlBuild_Logging WHERE BuildProjectHash = @BuildFileHash AND CommitDate = @CommitDate ORDER BY Sequence "; List <RebuilderData> data = new List <RebuilderData>(); SqlConnection conn = SqlSync.Connection.ConnectionHelper.GetConnection(dbConnData); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@BuildFileHash", buildFileHash); cmd.Parameters.AddWithValue("@CommitDate", commitDate.ToString("yyyy-MM-dd HH:mm:ss.FFF")); conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { bool filled; while (!reader.IsClosed) { RebuilderData dat = new RebuilderData(); filled = dat.Fill(reader, false); if (filled) { dat.Database = dbConnData.DatabaseName; data.Add(dat); } } conn.Close(); } return(data); }