public static int Delete(Ofe_Oferece ofe) { int retorno = 0; try { IDbConnection objConnection; IDbCommand objCommand; string sql = "DELETE FROM OFE_OFERECE WHERE PEJ_CODIGO = ?pej_codigo AND ESP_CODIGO = ?esp_codigo ;"; objConnection = Mapped.Connection(); objCommand = Mapped.Command(sql, objConnection); objCommand.Parameters.Add(Mapped.Parameter("?pej_codigo", ofe.Pej_codigo.Pej_codigo)); objCommand.Parameters.Add(Mapped.Parameter("?esp_codigo", ofe.Esp_codigo.Esp_codigo)); objCommand.ExecuteNonQuery(); objConnection.Close(); objConnection.Dispose(); objCommand.Dispose(); } catch (Exception ex) { retorno = -2; } return(retorno); }
public static int Insert(Ofe_Oferece ofe) { int retorno = 0; try { IDbConnection objConnection; IDbCommand objCommand; string sql = "INSERT INTO OFE_OFERECE (PEJ_CODIGO, ESP_CODIGO, OFE_ATIVO) VALUES ( ?pej_codigo, ?esp_codigo, true);"; objConnection = Mapped.Connection(); objCommand = Mapped.Command(sql, objConnection); objCommand.Parameters.Add(Mapped.Parameter("?pej_codigo", ofe.Pej_codigo.Pej_codigo)); objCommand.Parameters.Add(Mapped.Parameter("?esp_codigo", ofe.Esp_codigo.Esp_codigo)); objCommand.ExecuteNonQuery(); objConnection.Close(); objConnection.Dispose(); objCommand.Dispose(); } catch (Exception ex) { retorno = -2; } return(retorno); }
public static DataSet SelectNaoOferecidos(Ofe_Oferece ofe) { DataSet ds = new DataSet(); IDbConnection objConnection; IDbCommand objCommand; IDataAdapter objDataDadapter; objConnection = Mapped.Connection(); string sql = "select esp_nome, esp_codigo from esp_esportes where esp_codigo"; sql += " not in (select esp_codigo from ofe_oferece where pej_codigo = ?pej_codigo );"; objCommand = Mapped.Command(sql, objConnection); objCommand.Parameters.Add(Mapped.Parameter("?pej_codigo", ofe.Pej_codigo.Pej_codigo)); objDataDadapter = Mapped.Adapter(objCommand); objDataDadapter.Fill(ds); objConnection.Close(); objCommand.Dispose(); objConnection.Dispose(); return(ds); }
protected void Page_Load(object sender, EventArgs e) { if (Session["usuario"] == null) { Response.Redirect("../Erro.aspx"); } Pej_Pessoa_Juridica pej = (Pej_Pessoa_Juridica)Session["usuario"]; Ofe_Oferece ofe = new Ofe_Oferece(); if (!IsPostBack) { ofe.Pej_codigo = pej; DataSet ds = Ofe_OfereceBD.SelectNaoOferecidos(ofe); int qtd = ds.Tables[0].Rows.Count; if (qtd > 0) { cardVazio.Visible = false; rptCard.DataSource = ds; rptCard.DataBind(); } else { cardVazio.Visible = true; cardCheio.Visible = false; } DataSet ds2 = Ofe_OfereceBD.SelectOferecidos(ofe); int qtd2 = ds2.Tables[0].Rows.Count; if (qtd2 > 0) { PesquisaVazia.Visible = false; rptCard2.DataSource = ds2; rptCard2.DataBind(); } else { PesquisaVazia.Visible = true; PesquisaCheia.Visible = false; } } }
protected void BtnAdicionar_Click(object sender, EventArgs e) { Button btn = (sender as Button); Pej_Pessoa_Juridica pej = (Pej_Pessoa_Juridica)Session["usuario"]; Esp_Esportes esp = new Esp_Esportes(); Ofe_Oferece ofe = new Ofe_Oferece(); ofe.Pej_codigo = pej; esp.Esp_codigo = Convert.ToInt32(btn.CommandArgument.ToString()); ofe.Esp_codigo = esp; switch (Ofe_OfereceBD.Insert(ofe)) { case 0: Page.Response.Redirect(Page.Request.Url.ToString(), true); break; case -2: break; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["usuario"] == null) { Response.Redirect("../Erro.aspx"); } Pej_Pessoa_Juridica pej = (Pej_Pessoa_Juridica)Session["usuario"]; //EVENTOS DO LOCAL try { DataSet ds = Eve_EventosBD.SelectEventosLocal(pej); int qtd = ds.Tables[0].Rows.Count; int eve_codigo = Convert.ToInt32(ds.Tables[0].Rows[0]["eve_codigo"]); if (qtd > 0 && eve_codigo != 0) { cardVazio.Visible = false; rptCard.DataSource = ds; rptCard.DataBind(); } } catch (Exception ex) { } //HISTÓRICO DE EVENTOS try { DataSet ds2 = Eve_EventosBD.SelectHistoricoEventos(pej); int qtd2 = ds2.Tables[0].Rows.Count; int eve_codigo2 = Convert.ToInt32(ds2.Tables[0].Rows[0]["eve_codigo"]); if (qtd2 > 0 && eve_codigo2 != 0) { historicoVazio.Visible = false; RptHistorico.DataSource = ds2; RptHistorico.DataBind(); } } catch (Exception ex) { } if (!IsPostBack) { CarregarDDL(); } DataSet dsEnd = Pej_Pessoa_JuridicaBD.GetEndereco(pej.End_cep.End_cep); string cidade = Convert.ToString(dsEnd.Tables[0].Rows[0]["end_cidade"]); string uf = Convert.ToString(dsEnd.Tables[0].Rows[0]["end_uf"]); ltlEnd.Text = "<h5>" + cidade + " - " + uf + "</h5>"; ltlNome.Text = "<h3 class='nomePerfil'>" + pej.Pej_nome_ficticio + "</h3>"; DataSet ds3 = Pej_Pessoa_JuridicaBD.Select(pej); int qtd3 = ds3.Tables[0].Rows.Count; if (qtd3 > 0) { RptImage.DataSource = ds3; RptImage.DataBind(); } else { } //ESPORTES ADICIONADOS Ofe_Oferece ofe = new Ofe_Oferece(); ofe.Pej_codigo = pej; DataSet ds4 = Ofe_OfereceBD.SelectOferecidos(ofe); int qtd4 = ds4.Tables[0].Rows.Count; if (qtd4 > 0) { espVazio.Visible = false; RptEsporte.DataSource = ds4; RptEsporte.DataBind(); } else { espVazio.Visible = true; } //MODAL DE ATUALIZAÇÃO DA FOTO DE PERFIL DataSet ds5 = Pej_Pessoa_JuridicaBD.Select(pej); int qtd5 = ds5.Tables[0].Rows.Count; if (qtd5 > 0) { RptImageEdit.DataSource = ds5; RptImageEdit.DataBind(); } else { } }