protected void BtnEntrar_Click(object sender, EventArgs e) { try { Types.AssociacaoType assoc = new Types.AssociacaoType(); assoc.Nome = txtNome.Text; assoc.Url = txtUrl.Text; assoc.Usuario = txtUsuario.Text; assoc.Senha = txtSenha.Text; BLL.AssociacaoBLL assocBLL = new BLL.AssociacaoBLL(); int id = assocBLL.insert(assoc); if (id > 0) { Session["AssociacaoID"] = id; Session["FlashMsg"] = "Seja bem-vindo"; Session["FlashMsgType"] = "info"; Response.Redirect("~/Default.aspx"); } else { throw new Exception("Ocorreu um erro"); } } catch (Exception ex) { //Session["FlashMsg"] = ex.Message; Response.Write("<script>Javascript:alert('Ocorreu um erro ao tentar cadastrar a associação');</script>"); } finally { } }
protected void Page_Load(object sender, EventArgs e) { string mes = "11"; string ano = "2013"; if (IsPostBack) { mes = cmb_mes.Text; ano = cmb_ano.Text; } else { cmb_mes.Text = mes.ToString(); cmb_ano.Text = ano.ToString(); } Types.AssociacaoType assoc = Master.getAssociacaoSession(); BLL.FinanceiroBLL BLL = new BLL.FinanceiroBLL(); _DadosFinanceiros = BLL.selectByAssociacao(assoc, ano, mes); saldoAnterior = BLL.selectSaldoAnterior(assoc, ano, mes); this.DataBind(); }
protected void BtnEntrar_Click(object sender, EventArgs e) { try { Types.AssociacaoType assoc = new Types.AssociacaoType(); assoc.Nome = txtNome.Text; assoc.Url = txtUrl.Text; assoc.Usuario = txtUsuario.Text; assoc.Senha = txtSenha.Text; BLL.AssociacaoBLL assocBLL = new BLL.AssociacaoBLL(); int id = assocBLL.insert(assoc); if (id > 0) { Session["AssociacaoID"] = id; Session["FlashMsg"] = "Seja bem-vindo"; Session["FlashMsgType"] = "info"; Response.Redirect("~/Default.aspx"); } else { throw new Exception("Ocorreu um erro"); } } catch (Exception ex) { //Session["FlashMsg"] = ex.Message; Response.Write("<script>Javascript:alert('Ocorreu um erro ao tentar cadastrar a associação');</script>"); } finally { } }
public Types.AssociacaoType getAssociacaoSession() { if (Assoc == null) { VerificaSession(); BLL.AssociacaoBLL AssocBLL = new BLL.AssociacaoBLL(); Assoc = AssocBLL.selectRecord(SessionAssociacaoId); } return Assoc; }
public Types.AssociacaoType getAssociacaoSession() { if (Assoc == null) { VerificaSession(); BLL.AssociacaoBLL AssocBLL = new BLL.AssociacaoBLL(); Assoc = AssocBLL.selectRecord(SessionAssociacaoId); } return(Assoc); }
public Types.AssociacaoType execReader(MySqlDataReader dr) { Types.AssociacaoType type = new Types.AssociacaoType(); type.IdAssociacao = Convert.ToInt32(dr["ID_ASSOCIACAO"].ToString()); type.Nome = dr["NOME"].ToString(); type.Url = dr["URL"].ToString(); type.Logo = dr["LOGO"].ToString(); type.Usuario = dr["USUARIO"].ToString(); type.Senha = dr["SENHA"].ToString(); return type; }
public Types.AssociacaoType execReader(MySqlDataReader dr) { Types.AssociacaoType type = new Types.AssociacaoType(); type.IdAssociacao = Convert.ToInt32(dr["ID_ASSOCIACAO"].ToString()); type.Nome = dr["NOME"].ToString(); type.Url = dr["URL"].ToString(); type.Logo = dr["LOGO"].ToString(); type.Usuario = dr["USUARIO"].ToString(); type.Senha = dr["SENHA"].ToString(); return(type); }
public Types.AssociacaoType login(Types.AssociacaoType assoc) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM associacao A " + "WHERE USUARIO = @usuario AND SENHA = @senha"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@usuario", assoc.Usuario); cmd.Parameters.AddWithValue("@senha", assoc.Senha); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Types.AssociacaoType type = new Types.AssociacaoType(); if (dr.Read()) { type = execReader(dr); } return type; }
public Types.AssociacaoType selectRecord(int id) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM associacao " + "WHERE id_associacao = @id"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id", id); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Types.AssociacaoType type = new Types.AssociacaoType(); if (dr.Read()) { type = execReader(dr); } return(type); }
protected void BtnEntrar_Click(object sender, EventArgs e) { Types.AssociacaoType assoc = new Types.AssociacaoType(); assoc.Usuario = txtUsuario.Text; assoc.Senha = txtSenha.Text; BLL.AssociacaoBLL assocBLL = new BLL.AssociacaoBLL(); assoc = assocBLL.login(assoc); if (assoc.IdAssociacao > 0) { Session["AssociacaoID"] = assoc.IdAssociacao; Response.Redirect("~/Default.aspx"); } else { Response.Write("<script>Javascript:alert('Acesso negado');</script>"); } }
protected void BtnEntrar_Click(object sender, EventArgs e) { Types.AssociacaoType assoc = new Types.AssociacaoType(); assoc.Usuario = txtUsuario.Text; assoc.Senha = txtSenha.Text; BLL.AssociacaoBLL assocBLL = new BLL.AssociacaoBLL(); assoc = assocBLL.login(assoc); if (assoc.IdAssociacao > 0) { Session["AssociacaoID"] = assoc.IdAssociacao; Response.Redirect("~/Default.aspx"); } else { Response.Write("<script>Javascript:alert('Acesso negado');</script>"); } }
public Types.AssociacaoType login(Types.AssociacaoType assoc) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM associacao A " + "WHERE USUARIO = @usuario AND SENHA = @senha"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@usuario", assoc.Usuario); cmd.Parameters.AddWithValue("@senha", assoc.Senha); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Types.AssociacaoType type = new Types.AssociacaoType(); if (dr.Read()) { type = execReader(dr); } return(type); }
public int insert(Types.AssociacaoType obj) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "INSERT INTO associacao " + "( " + "nome," + "url," + "usuario," + "senha" + ") " + "VALUES" + "( " + "@nome," + "@url," + "@usuario," + "@senha" + ")"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@nome", obj.Nome); cmd.Parameters.AddWithValue("@url", obj.Url); cmd.Parameters.AddWithValue("@usuario", obj.Usuario); cmd.Parameters.AddWithValue("@senha", obj.Senha); con.Open(); int id = 0; try { cmd.ExecuteNonQuery(); cmd.CommandText = "SELECT MAX(id_associacao) " + "FROM associacao"; id = Convert.ToInt32(cmd.ExecuteScalar()); } finally { con.Close(); } return(id); }
public int insert(Types.AssociacaoType obj) { AssociacaoDAL assocDAL = new AssociacaoDAL(); return(assocDAL.insert(obj)); }
public Types.AssociacaoType login(Types.AssociacaoType assoc) { AssociacaoDAL assocDAL = new AssociacaoDAL(); return(assocDAL.login(assoc)); }
public Types.EmpresasType selectByAssociacao(Types.AssociacaoType associacao) { return(DAL.selectByAssociacao(associacao)); }
public Types.AssociacaoType selectRecord(int id) { MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM associacao " + "WHERE id_associacao = @id"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id", id); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Types.AssociacaoType type = new Types.AssociacaoType(); if (dr.Read()) { type = execReader(dr); } return type; }