private void GetUserFromDb() { Userlist.Clear(); int i = 0; var items = Userlist.Items; try { using (var con = new MySqlConnection(cs)) { con.Open(); var query = "SELECT systemName FROM users"; using (var cmd = new MySqlCommand(query, con)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { items.Add(reader.GetString("SystemName")); Userlist.Items[i].ImageIndex = 0; i++; } } } } i++; } catch (MySqlException) { } }
public User ContainsJSONUsername(string username) { User tempUser = new User(); //List<User> listOfUsers = new List<User if (!File.Exists(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Config", "usernames.json"))) { tempUser.Name = username; tempUser.Nick = username; //tempUser.Voice = defaultvoice; return(tempUser); } String JSONtxt = File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Config", "usernames.json")); userlist = JsonConvert.DeserializeObject <Userlist>(JSONtxt); tempUser = userlist.Users.FirstOrDefault(User => User.Name == username); if (tempUser != null) { return(tempUser); } tempUser = tempuserlist.Users.FirstOrDefault(User => User.Name == username); if (tempUser != null) { return(tempUser); } if (tempUser?.Name == null) { tempUser = createTempUser(username, defaultVoice); tempuserlist.Users.Add(tempUser); return(tempUser); } return(tempUser); }
private void bindUserList() { try { Userlist.Items.Clear(); Reply objRes = new Reply(); using (WebClient client = new WebClient()) { if (Session["Role"].ToString() == "admin") { parameter = "all"; } else { parameter = "user"; } client.Headers[HttpRequestHeader.ContentType] = "text/json"; ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; string JsonString = JsonConvert.SerializeObject(parameter); EncRequest objEncRequest = new EncRequest(); objEncRequest.RequestData = AesGcm256.Encrypt(JsonString); string dataEncrypted = JsonConvert.SerializeObject(objEncRequest); string result = client.UploadString(URL + "/GetUserList", "POST", dataEncrypted); EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result); objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData); //objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData); //DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply)); //MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData)); //objRes = (Reply)objDCS.ReadObject(objMS); Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer(); json.NullValueHandling = NullValueHandling.Ignore; StringReader sr = new StringReader(objResponse.ResponseData); Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr); objRes = json.Deserialize <Reply>(reader); if (objRes.res == true) { Userlist.DataSource = objRes.DS; Userlist.DataTextField = "username"; Userlist.DataBind(); Userlist.Items.Insert(0, new ListItem("New User", "NA")); } else { Userlist.Items.Insert(0, new ListItem("New User", "NA")); } } } catch (Exception ex) { Userlist.Items.Insert(0, new ListItem("New User", "NA")); } }
public IActionResult Login(Userlist us) { TokenModel user = _repository.Authenticate(us.Username, us.Password); if (user == null) { return(BadRequest(new { message = "Username or Password Incorrect" })); } return(Ok(user)); }
public IActionResult Get(int id) { Userlist user = _repository.Get(id); if (user != null) { return(Ok(user)); } return(BadRequest("Something went wrong!")); }
private void RemoveUser_Click(object sender, EventArgs e) { try { MySqlConnection con = new MySqlConnection(cs); MySqlCommand cmd = con.CreateCommand(); cmd.CommandText = "DELETE FROM users where SystemName='" + Userlist.SelectedItems[0].Text + "' "; con.Open(); cmd.ExecuteNonQuery(); con.Close(); Userlist.Clear(); GetUserFromDb(); } catch (MySqlException) { } catch (Exception) { } }
private async Task RetrieveUsers() { //to do add uuid like this: Users/Uuid/username var firebase = Connectors.Client.DatabaseClient; var users = await firebase .Child("Users") .OrderByKey() .OnceAsync <UserModel>(); foreach (var user in users) { if (user.Object.UserUUID != Helper.RetainedData.UserUuid) { Userlist.Add(user.Object); } } }
public bool RemoveMember(User user) { Boolean success = false; int i = 0; //index variable for loops int leaderindex = -1; //index variable to see where leader is int removeindex = -2; //index variable to see where removed user is //search for leader and check to see if user is in the team //roles and userlist should have the same number of elements //so this means I can use this loop to access both lists for (i = 0; i < this.Roles.Count(); i++) { //find the roles index of the leader if (Roles[i] == true) { leaderindex = i; } //determine if person we are trying to remove exists in team if (Userlist[i].username.Equals(user.username)) { success = true; removeindex = i; } } //now, we can actually try to move the member if (success == true) { //we remove the person from the team Roles.RemoveAt(removeindex); Userlist.RemoveAt(removeindex); //now we have extra logic for if the leader was removed //we basically set the first element on the team to leader //unsure if i should do some kind of prompt to notify a leader change if (removeindex == leaderindex) { Roles[0] = true; } } return(success); }
private void button2_Click(object sender, EventArgs e) { try { using (programacionEntities db = new programacionEntities()) { int Eliminar = Convert.ToInt32(txtId.Text); Userlist userlistdddd = db.Userlist.Where(x => x.Id == Eliminar).Select(x => x).FirstOrDefault(); //userlist = db.Userlist.Find(Eliminar); db.Userlist.Remove(userlistdddd); db.SaveChanges(); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } Carga(); clear(); }
private void button1_Click(object sender, EventArgs e) { try { using (programacionEntities db = new programacionEntities()) { Userlist userlist = new Userlist(); userlist.NombreUsuario = txtNombre.Text; userlist.Apellido = txtApellido.Text; userlist.Edad = Convert.ToInt32(txtEdad.Text); userlist.Pass = txtPass.Text; db.Userlist.Add(userlist); db.SaveChanges(); MessageBox.Show("save"); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } Carga(); clear(); }
private void button3_Click(object sender, EventArgs e) { try { using (programacionEntities db = new programacionEntities()) { int Update = Convert.ToInt32(txtId.Text); Userlist user = db.Userlist.Where(x => x.Id == 3).Select(x => x).FirstOrDefault(); //Userlist userlistdddd = new Userlist(); //userlistdddd = db.Userlist.Find(7); string text = txtNombre.Text; user.NombreUsuario = text; user.Apellido = txtApellido.Text; user.Edad = Convert.ToInt32(txtEdad.Text); user.Pass = txtPass.Text; db.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } Carga(); clear(); }
public Userlist Get(int id) { Userlist user = users.FirstOrDefault(u => u.UserId == id); return(user); }