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);
}
