private void btnPlanoDeMarketing_Click(object sender, EventArgs e) { PlanoDeMarketing PMarketing = new PlanoDeMarketing(); PMarketing.IdPlano = PlanoSelecionado.GetId(); if (PMarketingDal.VerificarPlanoDeMarketingExistente(PMarketing)) { PMarketing.Id = PMarketingDal.BuscarIdPlanoDeMarketing(PlanoSelecionado.GetId()); if (!PSCDAL.VerificarProdutoServicoComercializacao(PMarketing.Id)) { PSCDAL.CadastrarPSC(PMarketing.Id); } if (!LNegocioDAL.VerificarLocalizacaoDoNegocio(PMarketing.Id)) { LNegocioDAL.CadastrarLocalizacaoDoNegocio(PMarketing.Id); } FrmPlanoDeMarketing FormPlanoDeMarketing = new FrmPlanoDeMarketing(PMarketing); FormPlanoDeMarketing.ShowDialog(); } else { PMarketingDal.CadastrarPlanoDeMarketing(PMarketing.IdPlano); } }
//funcionando public bool VerificarPlanoDeMarketingExistente(PlanoDeMarketing Plano) { try { Dal.ConectarBanco(); //SELECT SELECT * FROM planodemarketing where id_Plano=8; string QueryPesquisar = "select * from planodemarketing where id_Plano=@IdPlano;"; ComandoPesquisarPlanoDeMarketing = new MySqlCommand(QueryPesquisar); ComandoPesquisarPlanoDeMarketing.Connection = Dal.Conn; ComandoPesquisarPlanoDeMarketing.Parameters.AddWithValue("@IdPlano", Plano.IdPlano); ReaderPesquisarPlanoDeMarketing = ComandoPesquisarPlanoDeMarketing.ExecuteReader(); if (ReaderPesquisarPlanoDeMarketing.HasRows) { return true; } else { return false; } } catch { return false; } finally { Dal.FecharConexao(); ReaderPesquisarPlanoDeMarketing.Close(); } }
public FrmPlanoDeMarketing(PlanoDeMarketing planomarketing) { InitializeComponent(); this.PMarketing = planomarketing; }