public static UsuarioModel ValidarUsuario(string login, string senha)
{
UsuarioModel retorno = null;
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["Default"].ConnectionString;
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
comando.CommandText = "select * from usuario where usuario_login=@login and usuario_senha=@senha";
var reader = comando.ExecuteReader();
if (reader.Read())
{
retorno = new UsuarioModel
{
Id = (int)reader[0],
Nome = (string)reader[1],
Login = (string)reader[2]
}
}
;
}
}
return(retorno);
}
//Persiste os dados do Usuario na Base de Dados
public int Salvar()
{
var ret = 0;
var model = GetFindOrDefault(this.Id);
if (model == null)
{
using (IConnection Conexion = new Connection())
{
IDAO <Usuario> dao = new DAOUsuario(Conexion);
Usuario u = new Usuario();//Objeto tipo Modulos(tabela)
u.Login = this.Login;
u.Senha = CriptoHelper.HashMD5(this.Senha);
u.Nome = this.Nome;
ret = dao.Insert(u).Id;
}
}
else
{
using (IConnection Conexion = new Connection())
{
IDAO <Usuario> dao = new DAOUsuario(Conexion);
Usuario u = new Usuario();
u.Id = this.Id;
u.Login = this.Login;
//u.Senha = CriptoHelper.HashMD5(this.Senha);
u.Nome = this.Nome;
dao.Update(u);
ret = this.Id;
}
}
return(ret);
}
public static UsuarioModel ValidarUsuario(string login, string senha)
{
UsuarioModel ret = null;
using (var conexao = new MySqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
conexao.Open();
using (var comando = new MySqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "select * from tb_usuario where usuario=@login and senha=@senha";
comando.Parameters.Add("@login", MySqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
MySqlDataReader dtreader = comando.ExecuteReader();
if (dtreader.Read())
{
ret = new UsuarioModel
{
Id = (int)dtreader["id_usuario"],
Login = (string)dtreader["usuario"],
Senha = (string)dtreader["senha"],
Nome = (string)dtreader["nome"],
Email = (string)dtreader["email"],
Ativo = (bool)dtreader["status"]
};
}
}
}
return(ret);
}
public static LoginModel ValidarUsuario(string usuario, string senha)
{
LoginModel result = null;
using (var conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["baseDados"].ConnectionString;
conn.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conn;
comando.CommandText = "SELECT * FROM usuario WHERE usuario=@usuario AND senha=@senha";
comando.Parameters.Add("@usuario", SqlDbType.VarChar).Value = usuario;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
var reader = comando.ExecuteReader();
if (reader.Read())
{
result = new LoginModel
{
Usuario = (string)reader["usuario"],
Senha = (string)reader["senha"],
Nome = (string)reader["nome"]
};
}
}
}
return(result);
}
public static UsuarioModel ValidarUsuario(string login, string senha)
{
UsuarioModel ret = null;
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = "Data Source=DESKTOP-N8I4SE5\\SQLEXPRESS;Initial Catalog=controle-estoque;Integrated Security=True";
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "select * from usuario where login=@login and senha=@senha";
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
var reader = comando.ExecuteReader();
if (reader.Read())
{
ret = new UsuarioModel
{
Id = (int)reader["id"],
Login = (string)reader["login"],
Senha = (string)reader["senha"],
Nome = (string)reader["nome"]
};
}
}
}
return(ret);
}
public static bool LogUser(string email, string senha)
{
bool ret = false;
using (var conexao = new MySqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
conexao.Open();
using (var comando = new MySqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "select count(*) from usuario where email=@email and senha=@senha;";
comando.Parameters.Add("@email", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(email);
comando.Parameters.Add("@senha", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
var teste = comando.ExecuteScalar();
ret = (Convert.ToInt32(comando.ExecuteScalar()) > 0);
}
return(ret);
}
}
public static UsuarioModel validarUsuario(string login, string senha)
{
UsuarioModel ret = null;
using (Iconnection Conexion = new Conexion())
{
IDao <Usuario> dao = new DaoUsuario(Conexion);
Usuario entity = dao.FindOrDefaultParam(login, CriptoHelper.HashMD5(senha));
if (entity != null)
{
ret = new UsuarioModel
{
Codigo = entity.codigo,
Nome = entity.nome,
Cpf = entity.cpf,
Sexo = entity.sexo,
Telefone = entity.telefone,
Data_cadastro = entity.data_cadastro,
Cidade_id = entity.cidade_id,
Email = entity.email,
Senha = entity.senha
};
}
}
return(ret);
}
static void Main(string[] args)
{
//Generate an init vector for test
string IV = RandomGenerator.GenericOnlyAlfaNumericString(16, 0, false);
string Password;
CriptoHelper cripto = new CriptoHelper(IV);
var stringToEncrypt = String.Empty;
var stringEncrypted = String.Empty;
for (int i = 0; i < 10000; i++)
{
//Generate Password
Password = RandomGenerator.GenericString(16, 0, false);
//Encrypt
stringToEncrypt = RandomGenerator.GenericString(RandomGenerator.GenericInt(300));
stringEncrypted = cripto.EncryptString(stringToEncrypt, Password);
//Decrypt
if (stringToEncrypt != cripto.DecryptString(stringEncrypted, Password))
{
throw new Exception("The strings don't match!!");
}
Console.WriteLine($"String {i.ToString()} ok!");
}
Console.ReadKey();
}
public static UsuarioModel ValidarUsuario(string login, string senha)
{
UsuarioModel ret = null;
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = @"Data Source=DESKTOP-ETQP54K\SQLEXPRESS;Initial Catalog=controle-estoque2;User Id=daniel;Password=12345";
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
// comando.CommandText = string.Format( // Permite SQL Injection, o acesso de verificar tem que mudar passando por meio de parametros
// "Select count(*) from usuario where login='******' and senha='{1}'", login, CriptoHelper.HashMD5(senha));
comando.CommandText = "Select * from usuario where login=@login and senha=@senha";
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
var reader = comando.ExecuteReader();
if (reader.Read())
{
ret = new UsuarioModel
{
Id = (int)reader["id"],
Login = (string)reader["login"],
Senha = (string)reader["senha"],
Nome = (string)reader["nome"]
};
}
}
}
return(ret);
}
public static UsuarioModel ValidarUsuario(string login, string senha)
{
UsuarioModel ret = null;
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = @"Data Source=localhost\SQLEXPRESS;Database=olx;Trusted_Connection=True;";
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "select * from usuario where login=@login and senha=@senha";
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
var reader = comando.ExecuteReader();
if (reader.Read())
{
ret = new UsuarioModel
{
Id = (int)reader["id"],
Login = (string)reader["login"],
Senha = (string)reader["senha"],
Nome = (string)reader["nome"],
IdPerfil = (int)reader["id_perfil"]
};
}
}
}
return(ret);
}
internal static object ValidarUsuario(string login, string senha)
{
var ret = new List <UsuarioModel>();
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["Con"].ConnectionString;
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
comando.CommandText = $"select * from usuario where login = @login and senha=@senha";
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
var reader = comando.ExecuteReader();
while (reader.Read())
{
ret.Add(new UsuarioModel {
Id = (int)reader["id"], Nome = reader["nome"].ToString(), Ativo = (bool)reader["ativo"]
});
}
}
}
return(true);
}
public static UserModel ValidateUser(string login, string Key)
{
UserModel ret = null;
using (var Connection = new MySqlConnection())
{
Connection.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
Connection.Open();
using (var command = new MySqlCommand())
{
command.Connection = Connection;
command.CommandText = "select * from usuario where login=@login and Key=@Key";
command.Parameters.Add("@login", MySqlDbType.VarChar).Value = login;
command.Parameters.Add("@Key", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(Key);
var reader = command.ExecuteReader();
if (reader.Read())
{
ret = new UserModel
{
Id = (int)reader["id"],
Login = (string)reader["login"],
Key = (string)reader["Key"],
Name = (string)reader["nome"],
Email = (string)reader["email"]
};
}
}
}
return(ret);
}
public bool AlterarSenha(string novaSenha)
{
var ret = false;
using (var db = new ContextoBD())
{
this.Senha = CriptoHelper.HashMD5(novaSenha);
db.Usuarios.Attach(this);
db.Entry(this).Property(x => x.Senha).IsModified = true;
db.SaveChanges();
//var sql = "UPDATE usuario set senha = @senha WHERE id = @id";
//var parametros = new { id = this.Id, senha = CriptoHelper.HashMD5(novaSenha) };
//ret = (db.Database.Connection.Execute(sql, parametros) > 0);
//using (var comando = new SqlCommand())
//{
// comando.Connection = conexao;
// comando.CommandText = "UPDATE usuario set senha = @senha WHERE id = @id";
// comando.Parameters.Add("@id", SqlDbType.Int).Value = this.Id;
// comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(novaSenha);
// ret = (comando.ExecuteNonQuery() > 0);
//}
}
return(ret);
}
public ActionResult AlterarLogin(string novoUsuario, string novaSenha, string usuario, string senha)//[Bind(Include = "Id,Nome,Data_nascimento,Celular,Telefone,Email")]
{
if (ModelState.IsValid)
{
senha = CriptoHelper.HashMD5(senha);
try
{
LoginFuncionario loginAntigo = db.LoginFuncionarios.SingleOrDefault(lf => lf.Usuario == usuario && lf.Senha == senha);
if (loginAntigo != null)
{
loginAntigo.Usuario = novoUsuario;
loginAntigo.Senha = CriptoHelper.HashMD5(novaSenha);
db.Entry(loginAntigo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("LogOff"));
}
else
{
ModelState.AddModelError("", "Usuário ou senha não existem...");
}
}
catch (Exception e) { ModelState.AddModelError("", "Algo deu errado, tente novamente"); }
}
else
{
ModelState.AddModelError("", "Login Inválido");
}
return(View());
}
public static bool ResetSenha(int id, string newSenha)
{
var retorno = false;
if (RecuperarPeloId(id) != null)
{
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "update usuario set senha = @senha where id =@id";
comando.Parameters.Add("@id", SqlDbType.Int).Value = id;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(newSenha);
retorno = (comando.ExecuteNonQuery() > 0);
}
}
}
return(retorno);
}
public static UsuarioModel ValidarUsuario(string login, string senha)
{
UsuarioModel retorno = null;
using (var conexao = new SqlConnection())
{
//@"Password=abc123;Persist Security Info=True;User ID=sa;Initial Catalog=HeroApp;Data Source=SOLARIS\SQLEXPRESS")
conexao.ConnectionString =
@"Data Source=SOLARIS\SQLEXPRESS; Initial Catalog=controle-estoque; User Id=admin; Password=123";
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "SELECT * FROM usuario WHERE login = @login AND senha = @senha";
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
SqlDataReader reader = comando.ExecuteReader();
if (reader.Read())
{
retorno = new UsuarioModel
{
Id = (int)reader["id"],
Login = (string)reader["login"],
Senha = (string)reader["senha"],
Nome = (string)reader["Nome"]
};
}
}
}
return(retorno);
}
public static bool CadUser(string CPF, string nome, string email, string senha)
{
var ret = false;
using (var conexao = new MySqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
conexao.Open();
using (var comando = new MySqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "Insert into usuario (CPF,email,nome,senha) values (@CPF, @email, @nome, @senha ); ";
comando.Parameters.Add("@CPF", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(CPF);
comando.Parameters.Add("@email", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(email);
comando.Parameters.Add("@nome", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(nome);
comando.Parameters.Add("@senha", MySqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
ret = (comando.ExecuteNonQuery() > 0);
}
return(ret);
}
}
//O método Salvar deve ser construído.
public static int Salvar(Usuario um)
{
var ret = 0;
var model = RecuperarPeloId(um.Id);
bool detachAndAtach = RealizarDetachAndAtach(um);
if (detachAndAtach)
{
if (model == null)
{
//Encriptando a senha
um.Senha = CriptoHelper.HashMD5(um.Senha);
Cadastrar(um);
}
else
{
if (!string.IsNullOrEmpty(um.Senha))
{
um.Senha = CriptoHelper.HashMD5(um.Senha);
Alterar(um);
}
else
{
Alterar(um);
}
}
}
ctx.SaveChanges();
ret = um.Id;
//}
return(ret);
}
public static UsuarioModel ValidarUsuario(string login, string senha)
{
UsuarioModel ret = null;
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
comando.CommandText = "select * from usuario where login=@login and senha=@senha";
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(senha);
var reader = comando.ExecuteReader();
if (reader.Read())
{
ret = new UsuarioModel
{
Id = (int)reader["id"],
Login = (string)reader["login"],
Senha = (string)reader["senha"],
Nome = (string)reader["nome"],
IdPerfil = (int)reader["id_perfil"]
};
}
}
}
return(ret);
}
public int Salvar()
{
var ret = 0;
var model = RecuperarPeloId(this.Id);
using (var db = new ContextoBD())
{
if (model == null)
{
db.Usuarios.Add(this);
}
else
{
db.Usuarios.Attach(this);
db.Entry(this).State = EntityState.Modified;
if (string.IsNullOrEmpty(this.Senha))
{
db.Entry(this).Property(x => x.Senha).IsModified = false;
}
else
{
this.Senha = CriptoHelper.HashMD5(this.Senha);
}
}
db.SaveChanges();
ret = this.Id;
}
return(ret);
}
/// <summary>
/// Retorna um usuário válido ou null
/// </summary>
/// <param name="login"></param>
/// <param name="senha"></param>
/// <returns></returns>
public static Usuario ValidarUsuario(string login, string senha)
{
Usuario ret = null;
senha = CriptoHelper.HashMD5(senha);
ret = ctx.Usuarios.Where(x => x.Login.Equals(login) && x.Senha.Equals(senha)).FirstOrDefault();
return(ret);
}
public static async Task <Usuario> ValidarUsuarioAPI(string login, string senha)
{
Usuario ret = null;
senha = CriptoHelper.HashMD5(senha);
ret = await ctx.Usuarios.Include("KeyC").Include("Perfil").Where(x => x.Login.Equals(login) && x.Senha.Equals(senha)).FirstOrDefaultAsync();
return(ret);
}
private string gerarSenha(Funcionario funcionario)
{
string senha = Convert.ToString(funcionario.DataNascimento.Day.ToString().PadLeft(2, '0'));
senha += Convert.ToString(funcionario.DataNascimento.Month.ToString().PadLeft(2, '0'));
senha += Convert.ToString(funcionario.DataNascimento.Year);
return(CriptoHelper.HashMD5(senha));
}
private string gerarSenha(Cliente cliente)
{
string senha = Convert.ToString(cliente.Data_nascimento.Day.ToString().PadLeft(2, '0'));
senha += Convert.ToString(cliente.Data_nascimento.Month.ToString().PadLeft(2, '0'));
senha += Convert.ToString(cliente.Data_nascimento.Year);
return(CriptoHelper.HashMD5(senha));
}
public async Task <string> LoginAsync(UserLoginData userLogin)
{
var user = await AuthenticateAsync(userLogin.Email, userLogin.Password);
var userAuthToken = CriptoHelper.encrypt($"{user.Email}:{user.Password}");
AuthTokens[userAuthToken] = user;
return(userAuthToken);
}
public ActionResult CriarConta(Cliente cliente, LoginCliente loginC, string ConfirmarSenha)
{
if (ModelState.IsValid)
{
if (loginC.Senha != ConfirmarSenha)
{
ModelState.AddModelError("", "Senhas não coincidem");
}
else
{
try
{
string VEmail = cliente.Email;
var ValidarEmail = db.Clientes.Where(a => a.Email == VEmail).SingleOrDefault();
if (ValidarEmail != null)
{
ModelState.AddModelError("", "Esse Cadastro já Existe!");
}
else
{
if (!(LoginCliente.Existe(loginC)))
{
db.Clientes.Add(cliente);
var LoginCliente1 = new LoginCliente()
{
Usuario = loginC.Usuario,
Senha = CriptoHelper.HashMD5(loginC.Senha),
ClienteId = cliente.Id
};
db.LoginClientes.Add(LoginCliente1);
db.SaveChanges();
return(RedirectToAction("Login", "ContaCliente"));
}
else
{
ModelState.AddModelError("", "Esse usuário já existe!");
}
}
}
catch (Exception e) { ModelState.AddModelError("", "Confira os dados e tente novamente"); }
}
}
HtmlHelper.ClientValidationEnabled = true;
HtmlHelper.UnobtrusiveJavaScriptEnabled = true;
ViewBag.cliente = cliente;
return(View());
}
public int Salvar()
{
var ret = 0;
var model = RecuperarPeloId(this.Id);
//criar objeto conexão
using (var conexao = new SqlConnection())
{
//dados da conexão
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
//abrir conexão
conexao.Open();
using (var comando = new SqlCommand())
{
//conectar comando com a conexao no banco
comando.Connection = conexao;
if (model == null)
{
//comando
comando.CommandText = "Insert into usuario (nome, login, senha) values (@nome, @login, @senha); select convert(int, scope_identity());";
//parametros para impedir sql injection
comando.Parameters.Add("@nome", SqlDbType.VarChar).Value = this.Nome;
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = this.Login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(this.Senha);
ret = (int)comando.ExecuteScalar();
}
else
{
comando.CommandText = "update usuario set nome=@nome, login=@login" +
(!string.IsNullOrEmpty(this.Senha)? ", senha=@senha ":"") +
" where id=@id;";
comando.Parameters.Add("@nome", SqlDbType.VarChar).Value = this.Nome;
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = this.Login;
if (!string.IsNullOrEmpty(this.Senha))
{
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(this.Senha);
}
comando.Parameters.Add("@id", SqlDbType.Int).Value = this.Id;
if (comando.ExecuteNonQuery() > 0)
{
ret = this.Id;
}
}
}
}
return(ret);
}
public int Salvar()
{
var ret = 0;
var model = RecuperarPeloId(this.Id);
using (var conexao = new SqlConnection())
{
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
conexao.Open();
using (var comando = new SqlCommand())
{
comando.Connection = conexao;
if (model == null)
{
comando.CommandText = "insert into usuario (nome, login, senha, id_perfil) values (@nome, @login, @senha, @id_perfil); select convert(int, scope_identity())";
comando.Parameters.Add("@nome", SqlDbType.VarChar).Value = this.Nome;
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = this.Login;
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(this.Senha);
comando.Parameters.Add("@id_perfil", SqlDbType.Int).Value = this.IdPerfil;
ret = (int)comando.ExecuteScalar();
}
else
{
comando.CommandText =
"update usuario set nome=@nome, login=@login, id_perfil=@id_perfil" +
(!string.IsNullOrEmpty(this.Senha) ? ", senha=@senha" : "") +
" where id = @id";
comando.Parameters.Add("@nome", SqlDbType.VarChar).Value = this.Nome;
comando.Parameters.Add("@login", SqlDbType.VarChar).Value = this.Login;
comando.Parameters.Add("@id_perfil", SqlDbType.Int).Value = this.IdPerfil;
if (!string.IsNullOrEmpty(this.Senha))
{
comando.Parameters.Add("@senha", SqlDbType.VarChar).Value = CriptoHelper.HashMD5(this.Senha);
}
comando.Parameters.Add("@id", SqlDbType.Int).Value = this.Id;
if (comando.ExecuteNonQuery() > 0)
{
ret = this.Id;
}
}
}
}
return(ret);
}
public int Salvar()
{
var ret = 0;
try
{
var model = RecuperarPeloId(this.Id);
string ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
con.Open();
using (MySqlCommand cmd = con.CreateCommand())
{
if (model == null)
{
cmd.CommandText = @"insert into usuario (nome, login, senha) values(@nome,@login,@senha);";
cmd.Parameters.Add(new MySqlParameter("nome", this.Nome));
cmd.Parameters.Add(new MySqlParameter("login", this.Login));
cmd.Parameters.Add(new MySqlParameter("senha", CriptoHelper.HashMD5(this.Senha)));
//cmd.LastInsertedId.ToString();
ret = cmd.ExecuteNonQuery();
ret = (int)cmd.LastInsertedId;
//ret = Convert.ToInt32(cmd.ExecuteScalar());
}
else
{
cmd.CommandText = @"update usuario set nome=@nome, login=@login" +
(!string.IsNullOrEmpty(this.Senha) ? ", senha=@senha" : "") +
" where id=@id;";
cmd.Parameters.Add(new MySqlParameter("id", this.Id));
cmd.Parameters.Add(new MySqlParameter("nome", this.Nome));
cmd.Parameters.Add(new MySqlParameter("login", this.Login));
if (!string.IsNullOrEmpty(this.Senha))
{
cmd.Parameters.Add(new MySqlParameter("senha", CriptoHelper.HashMD5(this.Senha)));
}
if (cmd.ExecuteNonQuery() > 0)
{
ret = this.Id;
}
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("{0}", ex);
}
return(ret);
}
public async Task SaveAsync(NewUserData newUser)
{
var url = await cloudStorageService.SaveFile(newUser.Image, CONTAINER_NAME);
await userRepository.SaveAsync(new User
{
Email = newUser.Email,
Image = new Image(url),
Name = newUser.Name,
Password = CriptoHelper.encrypt(newUser.Password),
});
}
