public JsonResult validaUsuario(string email, string senha)
{
Cliente cliente = new Cliente();
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.CommandText = "SELECT idCliente FROM CLIENTE WHERE EMAIL = @EMAIL AND SENHA = @SENHA";
conexao.command.Parameters.Clear();
conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = email;
conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(senha);
var result = conexao.command.ExecuteScalar();
int id;
Console.WriteLine(result);
if (result != null && Int32.TryParse(result.ToString(), out id))
{
cliente.GetClientById(id);
return(Json(cliente));
}
else
{
return(Json("false"));
}
}
public JsonResult cadastraUsuario(string email, string nome, string sobrenome, string senha, string cpf, string sexo, string dataNascimento)
{
Cliente cliente = new Cliente();
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.CommandText = "INSERT INTO CLIENTE OUTPUT INSERTED.IDCLIENTE VALUES(@EMAIL, @SENHA, @NOME, @SOBRENOME, @SEXO, @CPF, @DATANASC, GETDATE(), null)"; conexao.command.Parameters.Clear();
conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = email;
conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = StatueStoreEncrypt.Encrypt(senha);
conexao.command.Parameters.Add("@NOME", SqlDbType.VarChar).Value = nome;
conexao.command.Parameters.Add("@SOBRENOME", SqlDbType.VarChar).Value = sobrenome;
conexao.command.Parameters.Add("@SEXO", SqlDbType.VarChar).Value = sexo;
conexao.command.Parameters.Add("@CPF", SqlDbType.VarChar).Value = cpf;
conexao.command.Parameters.Add("@DATANASC", SqlDbType.VarChar).Value = dataNascimento.Replace("/", "-");
try
{
var id = conexao.command.ExecuteScalar();
Console.WriteLine(id);
conexao.connection.Close();
if (id == null)
{
return(Json(null));
}
else
{
cliente.GetClientById(Convert.ToInt32(id));
return(Json(cliente));
}
}
catch (Exception e)
{
Console.WriteLine(e.GetHashCode());
return(Json(null));
}
}