}//
/// <summary>
///
/// </summary>
/// <param name="login"></param>
/// <param name="senha"></param>
/// <param name="ativo"></param>
/// <param name="perfil"></param>
/// <param name="email"></param>
/// <param name="con"></param>
/// <returns></returns>
public static Boolean cadastraUsuario(string login, string senha, bool ativo, int perfil, string email, OleDbConnection con)
{
bool flag = false;
string sql = "Insert Into Usuarios(login,senha,ativo,perfil,email) values(?,?,?,?,?)";
try
{
OleDbCommand cmd = new OleDbCommand(sql, con);
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("login", login));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("senha", Acesso.GerarHash(senha)));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("ativo", ativo));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("perfil", perfil));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("email", email));
int rg = cmd.ExecuteNonQuery();
if (rg > 0)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}//
}//
/// <summary>
/// ///
/// </summary>
/// <param name="login"></param>
/// <param name="senha"></param>
/// <param name="con"></param>
/// <returns></returns>
public static Boolean alteraSenha(string login, string senha, OleDbConnection con)
{
bool flag = false;
string sql = "Update Usuarios set senha = ? Where login = ?";
try
{
OleDbCommand cmd = new OleDbCommand(sql, con);
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("login", login));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("senha", Acesso.GerarHash(senha)));
int rg = cmd.ExecuteNonQuery();
if (rg > 0)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}//
}//fim preencheLancamento
/// <summary>
///
/// </summary>
/// <param name="Combo"></param>
/// <param name="strSql"></param>
/// <param name="Display"></param>
/// <param name="Value"></param>
public static void preencheComboBox(ComboBox Combo, string strSql, string Display, string Value)
{
using (OleDbConnection con = Acesso.GetConnection())
{
try
{
con.Open();
string sql = strSql;
OleDbCommand cmd = new OleDbCommand(sql, con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
//coloque as definições na ordem abaixo
Combo.DisplayMember = Display;
Combo.ValueMember = Value;
Combo.DataSource = dt;
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
}//fim preencheComboBox
}//fim preencheComboBox
//----------------------------------------------------------------
/// <summary>
///
/// </summary>
/// <param name="codigo"></param>
/// <returns></returns>
public static string getData(int codigo)
{
OleDbDataReader dr = null;
string banco = "";
using (OleDbConnection con = Acesso.GetConnection())
{
try
{
con.Open();
string sql = "Select desc_conta from tblcontas where cod_conta=" + codigo;
OleDbCommand cmd = new OleDbCommand(sql, con);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
banco = dr["desc_conta"].ToString();
}
return(banco);
}
else
{
return(banco);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable preencheLancamentos(string sql)
{
using (OleDbConnection con = Acesso.GetConnection())
{
try
{
con.Open();
OleDbCommand cmd = new OleDbCommand(sql, con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
}//fim preencheLancamento