public int ImpServicos(ServicosModel pServicos, TextBox pTela)
{
int Result = 0;
string msgRetorno = "";
string IdServico = new ServicosController().CadServicosBase.GetidServico(pServicos.nm_servico).ToString();
int Operacao = Global.GetOperacao(IdServico);
if (Operacao == 2)
{
pServicos.id_servico = Global.StrToInt(IdServico);
}
try
{
msgRetorno = new ServicosController().CadServicosBase.PersisteNoBanco(pServicos, Operacao);
Global.EnviarParaLog(msgRetorno, pTela, "ImpServicos");
if (Operacao == 1)
{
IdServico = new ServicosController().CadServicosBase.GetLastReg(pServicos).ToString();
}
}
catch (Exception ex)
{
Global.EnviarParaLog($"{msgRetorno} Motivo:{ex.Message}", pTela, "ImpServicos");
}
//}
Result = Global.StrToInt(IdServico);
return(Result);
}
public int GetidServico(string pnmServico)
{
ServicosModel servicosModel = new ServicosModel();
string script = "Select * from tb_Servicos where nm_Servico=@nm_Servico";
conexao.LimparParametros();
conexao.Parametros.Add(new SqlParameter()
{
ParameterName = "nm_Servico", Value = pnmServico
});
servicosModel.SetDados(conexao.ExecutarSelect(script));
return(servicosModel.id_servico);
}
public string GetNomeServico(int pIdServico)
{
ServicosModel servicosModel = new ServicosModel();
string script = "Select * from tb_Servicos where Id_Servico=@Id_Servico and lower(status)='ativo'";
conexao.LimparParametros();
conexao.Parametros.Add(new SqlParameter()
{
ParameterName = "Id_Servico", Value = pIdServico
});
servicosModel.SetDados(conexao.ExecutarSelect(script));
if (servicosModel.nm_servico == null)
{
return("");
}
else
{
return(servicosModel.nm_servico);
}
}
//
public frmCadastroBase()
{
InitializeComponent();
perfisModel = new PerfisModel();
usuariosModel = new UsuariosModel();
gruposModel = new GruposModel();
categoriasModel = new CategoriasModel();
PacotesModel = new PacotesModel();
ServicosModel = new ServicosModel();
arquivosModel = new ArquivosModel();
monitoramentosModel = new MonitoramentosModel();
mapeamentosModel = new MapeamentosModel();
permissoesModel = new PermissoesModel();
objetosModel = new ObjetosModel();
ParametrosModel = new ParametrosModel();
//
//
btnOk.Enabled = false;
operacao = Operacao.oNenhum;
ControlaBotoes();
}
