public static void GravaDestalhesProcedures(DataTable procedureAlterados)
{
try
{
XMLModel.ListaDescricoesModel lsDescricoes = DAO.DescricaoXMLDAO.Ler();
foreach (DataRow registro in procedureAlterados.Rows)
{
XMLModel.DescricaoProcedureModel descricaoProcedureNova = (from ds in lsDescricoes.listaDescricaoProcedure
where String.Equals(ds.NomeProcedure, registro["PROCEDURE_NAME"].ToString(), StringComparison.OrdinalIgnoreCase)
select ds).DefaultIfEmpty().First();
if (descricaoProcedureNova != null)
{
descricaoProcedureNova.Descricao = registro["PROCEDURE_DESCRIPTION"].ToString();
}
else
{
descricaoProcedureNova = new XMLModel.DescricaoProcedureModel();
descricaoProcedureNova.NomeProcedure = registro["PROCEDURE_NAME"].ToString();
descricaoProcedureNova.Descricao = registro["PROCEDURE_DESCRIPTION"].ToString();
lsDescricoes.listaDescricaoProcedure.Add(descricaoProcedureNova);
}
}
DAO.DescricaoXMLDAO.PersistirAtributos(lsDescricoes);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw ex;
}
}
public static void GravaDestalhesProcedure(string nomeProcedure, string descricao)
{
XMLModel.ListaDescricoesModel lsDescricoes = DAO.DescricaoXMLDAO.Ler();
XMLModel.DescricaoProcedureModel descricaoProcedure = (from ds in lsDescricoes.listaDescricaoProcedure
where String.Equals(ds.NomeProcedure, nomeProcedure, StringComparison.OrdinalIgnoreCase)
select ds).DefaultIfEmpty().First();
if (descricaoProcedure != null)
{
descricaoProcedure.Descricao = descricao;
}
else
{
descricaoProcedure = new XMLModel.DescricaoProcedureModel();
descricaoProcedure.NomeProcedure = nomeProcedure;
descricaoProcedure.Descricao = descricao;
lsDescricoes.listaDescricaoProcedure.Add(descricaoProcedure);
}
DAO.DescricaoXMLDAO.PersistirAtributos(lsDescricoes);
}
internal static void DetalhaProcedure(ProcedureInfoModel procInfo, string nomeProcedure)
{
procInfo.nomeProcedure = nomeProcedure;
XMLModel.ListaDescricoesModel lsDescricoes = DAO.DescricaoXMLDAO.Ler();
XMLModel.DescricaoProcedureModel procedureDescription = (from ts in lsDescricoes.listaDescricaoProcedure
where String.Equals(ts.NomeProcedure, nomeProcedure, StringComparison.OrdinalIgnoreCase)
select ts).DefaultIfEmpty().First();
if (procedureDescription != null)
{
procInfo.descricaoProcedure = procedureDescription.Descricao;
}
else
{
procInfo.descricaoProcedure = "";
}
procInfo.dtPermissoes = DAO.ProceduresInfoSQLDao.ListaGrantProcedures(procInfo.nomeProcedure);
procInfo.dtParam = DAO.ProceduresInfoSQLDao.ListaDestalhesProcedures(procInfo.nomeProcedure);
}
