//***********************************************************************************************************************************
//***********************************************************************************************************************************
//***********************************************************************************************************************************
//***********************************************************************************************************************************
internal static void GravaDestalhesRegras(string nomeTabela, List <string> lsRegras)
{
XMLModel.ListaDescricoesModel lsDescricoes = DAO.DescricaoXMLDAO.Ler();
XMLModel.DescricaoTabelaModel descricaoTabela = (from ds in lsDescricoes.listaDescricaoTabelas where String.Equals(ds.NomeTabela, nomeTabela, StringComparison.OrdinalIgnoreCase) select ds).DefaultIfEmpty().First();
if (descricaoTabela != null)
{
descricaoTabela.Regras = lsRegras;
}
else
{
descricaoTabela = new XMLModel.DescricaoTabelaModel();
descricaoTabela.NomeTabela = nomeTabela;
descricaoTabela.Regras = lsRegras;
lsDescricoes.listaDescricaoTabelas.Add(descricaoTabela);
}
DAO.DescricaoXMLDAO.PersistirAtributos(lsDescricoes);
}
internal static void DetalhaTabela(TableInfoModel tableInfo, string nomeTabela)
{
tableInfo.nomeTabela = nomeTabela;
tableInfo.dtDetalheColunas = ListaDestalhesTabelas(tableInfo.nomeTabela);
tableInfo.dtReferenciasFK = DAO.TabelasInfoSQLDao.DependenciasFK(tableInfo.nomeTabela);
tableInfo.schema = DAO.TabelasInfoSQLDao.SchemaTabela(tableInfo.nomeTabela);
tableInfo.dtPermissoes = DAO.TabelasInfoSQLDao.Permissoes(tableInfo.nomeTabela);
//Chaves Primarias
DataTable chavesPrimarias = DAO.TabelasInfoSQLDao.ChavesPrimarias(tableInfo.nomeTabela);
for (int row = 0; row < chavesPrimarias.Rows.Count; row++)
{
tableInfo.chavesPrimarias += chavesPrimarias.Rows[row][0].ToString();
if (row != chavesPrimarias.Rows.Count - 1)
{
tableInfo.chavesPrimarias += ", ";
}
}
XMLModel.ListaDescricoesModel lsDescricoes = DAO.DescricaoXMLDAO.Ler();
XMLModel.DescricaoTabelaModel tableDescription = (from ts in lsDescricoes.listaDescricaoTabelas
where String.Equals(ts.NomeTabela, nomeTabela, StringComparison.OrdinalIgnoreCase)
select ts).DefaultIfEmpty().First();
if (tableDescription != null)
{
tableInfo.descricaoTabela = tableDescription.Descricao;
tableInfo.dtRegras = tableDescription.Regras;
}
else
{
tableInfo.descricaoTabela = "";
}
}