public static string gravaAcessoRapidoUsuario(cadModulo cadmodulo)
{
String vret = "";
try
{
String vsql = " insert into usuarioprogmenu(cd_usuario, cd_modulo, cd_programa, dt_registro) " +
" values (@cdusuario, @cdmodulo, @cdprograma, current_timestamp);";
Conexao.getInstance().startTransaction();
List <ParametroPGSQL> plist = new List <ParametroPGSQL>();
plist.Add(new ParametroPGSQL("cdusuario", cadmodulo.cd_usuario, DbType.String));
plist.Add(new ParametroPGSQL("cdmodulo", cadmodulo.cd_modulo, DbType.String));
plist.Add(new ParametroPGSQL("cdprograma", cadmodulo.cd_programa, DbType.Int32));
vret = Conexao.getInstance().gravar(vsql, plist);
if (vret.Equals(string.Empty))
{
Conexao.getInstance().commit();
Alert.informacao("Registro Salvo com Sucesso!");
}
else
{
Conexao.getInstance().rollback();
Alert.erro("Erro ao Gravar Registro! \n" + vret);
}
}
catch (Exception erro)
{
Alert.erro(String.Format("Erro ao inserir o registro {0}", erro.Message));
}
return(vret);
}
public static string gravaPrograma(cadModulo cadmodulo)
{
String vret = "", vsql = "";
try
{
vsql = "insert into public.programa(cd_modulo, cd_programa, cd_submenu, ds_programa, dt_registro) " +
" values (@cdmodulo, @cdprograma, @cdsubmenu, @dsprograma, current_timestamp);";
if (cadProgramaDAO.existePrograma(cadmodulo.cd_modulo, cadmodulo.cd_programa))
{
vsql = "update public.programa " +
" set cd_submenu = @cdsubmenu, ds_programa = @dsprograma " +
" where cd_modulo = @cdmodulo and cd_programa = @cdprograma ";
}
Conexao.getInstance().startTransaction();
List <ParametroPGSQL> plist = new List <ParametroPGSQL>();
plist.Add(new ParametroPGSQL("cdmodulo", cadmodulo.cd_modulo, DbType.String));
plist.Add(new ParametroPGSQL("cdprograma", cadmodulo.cd_programa, DbType.Int32));
plist.Add(new ParametroPGSQL("cdsubmenu", cadmodulo.cd_submenu, DbType.Int32));
plist.Add(new ParametroPGSQL("dsprograma", cadmodulo.ds_programa, DbType.String));
vret = Conexao.getInstance().gravar(vsql, plist);
if (vret.Equals(string.Empty))
{
Conexao.getInstance().commit();
Alert.informacao("Registro Salvo com Sucesso!");
}
else
{
Conexao.getInstance().rollback();
Alert.erro("Erro ao Gravar Registro! \n" + vret);
}
}
catch (Exception erro)
{
Alert.erro(String.Format("Erro ao inserir o registro {0}", erro.Message));
}
return(vret);
}