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;
}
