public static void ReadCallback(IAsyncResult ar) { String content = String.Empty; // Retrieve the state object and the handler socket // from the asynchronous state object. StateObject state = (StateObject)ar.AsyncState; Socket handler = state.workSocket; // Read data from the client socket. int bytesRead = handler.EndReceive(ar); if (bytesRead > 0) { // There might be more data, so store the data received so far. state.sb.Append(Encoding.ASCII.GetString( state.buffer, 0, bytesRead)); content = state.sb.ToString(); JsonTextReader reader = new JsonTextReader(new System.IO.StringReader(content)); int count = 0; reader.Read(); reader.Read(); if (reader.Value.ToString().Equals("updateMotoristas")) { Console.WriteLine("Adicionando usuário.."); user.Clear(); do { if (reader.Value != null) { if (count != 0 && count % 2 == 0) { user.Add(reader.Value.ToString()); Console.WriteLine(reader.Value.ToString() + " - " + user.Count.ToString()); } count++; } }while (reader.Read()); bool isUpdated = adicionarMotorista(); Send(handler, isUpdated.ToString()); } else if (reader.Value.ToString().Equals("updateDistribuidor")) { Console.WriteLine("Adicionando usuário.."); user.Clear(); do { if (reader.Value != null) { if (count != 0 && count % 2 == 0) { user.Add(reader.Value.ToString()); Console.WriteLine(reader.Value.ToString() + " - " + user.Count.ToString()); } count++; } }while (reader.Read()); bool isUpdated = adicionarDistribuidor(); Send(handler, isUpdated.ToString()); } else if (reader.Value.ToString().Equals("loginInfoMotorista")) { List <String> list = new List <String>(); Console.WriteLine("Checando motorista.."); do { if (reader.Value != null) { if (count != 0 && count % 2 == 0) { list.Add(reader.Value.ToString()); Console.WriteLine(reader.Value.ToString() + " - " + list.Count.ToString()); //user.Add(reader.Value.ToString()); } count++; } }while (reader.Read()); user isLogged = checkMotorista(list[0], list[1]); if (isLogged != null) { string jsonUserData = JsonConvert.SerializeObject(isLogged); Console.WriteLine(jsonUserData); //if (isLogged) Console.WriteLine("Usuário encontrado !"); //else Console.WriteLine("Usuário não encontrado"); Send(handler, jsonUserData); } else { Send(handler, "null"); } } else if (reader.Value.ToString().Equals("loginInfoDistribuidor")) { List <String> list = new List <String>(); Console.WriteLine("Checando distribuidor.."); do { if (reader.Value != null) { if (count != 0 && count % 2 == 0) { list.Add(reader.Value.ToString()); Console.WriteLine(reader.Value.ToString() + " - " + list.Count.ToString()); //user.Add(reader.Value.ToString()); } count++; } }while (reader.Read()); distribuidor isLogged = checkDistribuidor(list[0], list[1]); if (isLogged != null) { string jsonUserData = JsonConvert.SerializeObject(isLogged); Console.WriteLine(jsonUserData); //if (isLogged) Console.WriteLine("Usuário encontrado !"); //else Console.WriteLine("Usuário não encontrado"); Send(handler, jsonUserData); } else { Send(handler, "null"); } } else if (reader.Value.ToString().Equals("updateAutos")) { List <String> list = new List <String>(); Console.WriteLine("Adicionando automovel.."); autoInfo.Clear(); do { if (reader.Value != null) { if (count != 0 && count % 2 == 0) { autoInfo.Add(reader.Value.ToString()); Console.WriteLine(reader.Value.ToString()); //user.Add(reader.Value.ToString()); } count++; } }while (reader.Read()); bool isUpdated = updateDBAutomoveis(); Send(handler, isUpdated.ToString()); } else if (reader.Value.ToString().Equals("autoList")) { List <String> list = new List <String>(); Console.WriteLine("Buscando lista de automoveis.."); autoInfo.Clear(); do { if (reader.Value != null) { if (count != 0 && count % 2 == 0) { autoInfo.Add(reader.Value.ToString()); Console.WriteLine(reader.Value.ToString()); //user.Add(reader.Value.ToString()); } count++; } }while (reader.Read()); List <automovel> automoveis = checkAutomoveis(autoInfo[0]); string jsonUserData = JsonConvert.SerializeObject(automoveis); Console.WriteLine(jsonUserData); //if (isLogged) Console.WriteLine("Usuário encontrado !"); //else Console.WriteLine("Usuário não encontrado"); Send(handler, jsonUserData); } // } //else //{ // // Not all data received. Get more. // handler.BeginReceive(state.buffer, 0, StateObject.BufferSize, 0, // new AsyncCallback(ReadCallback), state); //} } }
public static distribuidor checkDistribuidor(String email, String pass) { bool userFound = false; bool passFound = false; distribuidor dist = new distribuidor(); String connectionString = Properties.Settings.Default.Fretinga; SqlConnection sql = new SqlConnection(connectionString); sql.Open(); //String[] info = new String[8]; using (SqlCommand readCmd = new SqlCommand("SELECT * FROM table_distribuidor WHERE email = @email", sql)) { //readCmd.Parameters.Add("@user", System.Data.SqlDbType.VarChar).Value = user; readCmd.Parameters.AddWithValue("@email", email); SqlDataReader reader = readCmd.ExecuteReader(); try { while (reader.Read()) { dist.razao_social = reader["razao_social"].ToString(); dist.nome_fantasia = reader["nome_fantasia"].ToString(); dist.cnpj = reader["cnpj"].ToString(); dist.inscricao_estadual = reader["inscricao_estadual"].ToString(); dist.pais = reader["pais"].ToString(); dist.estado = reader["estado"].ToString(); dist.cidade = reader["cidade"].ToString(); dist.endereco = reader["endereco"].ToString(); dist.bairro = reader["bairro"].ToString(); dist.cep = reader["cep"].ToString(); dist.complemento = reader["complemento"].ToString(); dist.email = reader["email"].ToString(); dist.senha = reader["senha"].ToString(); dist.telefone = reader["telefone"].ToString(); dist.celular = reader["celular"].ToString(); dist.site = reader["site"].ToString(); dist.nome_contato = reader["nome_contato"].ToString(); if (dist.email.Equals(email)) { userFound = true; } if (dist.senha.Equals(pass)) { passFound = true; } Console.WriteLine(String.Format("Formato: {0}, {1}", reader["email"], reader["senha"]));// etc } } catch (Exception e) { Console.WriteLine(e.ToString()); } //while (reader.Read()) //{ //Console.WriteLine("Usuário: {0}", reader.GetInt32(0).ToString()); //} reader.Close(); //userFound = true; } //user usuario = new user(); sql.Close(); if (passFound && userFound) { Console.WriteLine("Distribuidor encontrado e autenticado !"); return(dist); } else { return(null); } }