public virtual bool Fill(CodeTableAudit dataClass)
{
try {
this.TableName = dataClass.TableName;
this.UpdateIdColumn = dataClass.UpdateIdColumn;
this.UpdateDateColumn = dataClass.UpdateDateColumn;
this.CreateDateColumn = dataClass.CreateDateColumn;
this.CreateIdColumn = dataClass.CreateIdColumn;
this.RowCount = dataClass.RowCount;
this.HasUpdateTrigger = dataClass.HasUpdateTrigger;
this.LookUpTableRow = dataClass.LookUpTableRow;
return(true);
}
catch (System.Exception ex) {
throw new System.ApplicationException("Error in the Auto-Generated: CodeTableAudit.Fill(CodeTableAudit) Method", ex);
}
}
public static System.Collections.Generic.SortedDictionary <string, CodeTableAudit> GetTablesWithAuditColumns(ConnectionData connData)
{
System.Collections.Generic.SortedDictionary <string, CodeTableAudit> tableDefs = new SortedDictionary <string, CodeTableAudit>();
//if(UpdateDateFields.Length == 0 || UpdateIdFields.Length == 0)
if (!codeTableAuditCols.IsValid)
{
SetUpdateColumnNames();
}
string updateId = GetDelimitedListForSql(codeTableAuditCols.UpdateIdColumns);
string updateDate = GetDelimitedListForSql(codeTableAuditCols.UpdateDateColumns);
string createId = GetDelimitedListForSql(codeTableAuditCols.CreateIdColumns);
string createDate = GetDelimitedListForSql(codeTableAuditCols.CreateDateColumns);
string sql = "select TABLE_NAME, COLUMN_NAME, TABLE_SCHEMA from INFORMATION_SCHEMA.COLUMNS where column_name IN ({0}) ORDER BY table_name";
SqlConnection conn = SqlSync.Connection.ConnectionHelper.GetConnection(connData.DatabaseName, connData.SQLServerName, connData.UserId, connData.Password, connData.AuthenticationType, connData.ScriptTimeout);
conn.Open();
//Tables with Update ID columns
SqlCommand cmd = new SqlCommand(String.Format(sql, updateId), conn);
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
CodeTableAudit tbl = new CodeTableAudit();
tbl.TableName = reader[2].ToString() + "." + reader[0].ToString();
tbl.UpdateIdColumn = reader[1].ToString();
tableDefs.Add(tbl.TableName, tbl);
}
reader.Close();
}
//Tables with Update date columns
cmd = new SqlCommand(String.Format(sql, updateDate), conn);
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
string tableName = reader[2].ToString() + "." + reader[0].ToString();
if (!tableDefs.ContainsKey(tableName))
{
CodeTableAudit tbl = new CodeTableAudit();
tbl.TableName = tableName;
tbl.UpdateDateColumn = reader[1].ToString();
tableDefs.Add(tbl.TableName, tbl);
}
else
{
CodeTableAudit tbl;
if (tableDefs.TryGetValue(tableName, out tbl))
{
tbl.UpdateDateColumn = reader[1].ToString();
}
}
}
reader.Close();
}
//Tables with Create id columns
cmd = new SqlCommand(String.Format(sql, createId), conn);
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
string tableName = reader[2].ToString() + "." + reader[0].ToString();
if (!tableDefs.ContainsKey(tableName))
{
CodeTableAudit tbl = new CodeTableAudit();
tbl.TableName = tableName;
tbl.CreateIdColumn = reader[1].ToString();
tableDefs.Add(tbl.TableName, tbl);
}
else
{
CodeTableAudit tbl;
if (tableDefs.TryGetValue(tableName, out tbl))
{
tbl.CreateIdColumn = reader[1].ToString();
}
}
}
reader.Close();
}
//Tables with Create date columns
cmd = new SqlCommand(String.Format(sql, createDate), conn);
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
string tableName = reader[2].ToString() + "." + reader[0].ToString();
if (!tableDefs.ContainsKey(tableName))
{
CodeTableAudit tbl = new CodeTableAudit();
tbl.TableName = tableName;
tbl.CreateDateColumn = reader[1].ToString();
tableDefs.Add(tbl.TableName, tbl);
}
else
{
CodeTableAudit tbl;
if (tableDefs.TryGetValue(tableName, out tbl))
{
tbl.CreateDateColumn = reader[1].ToString();
}
}
}
reader.Close();
}
return(tableDefs);
}
