private void GetTasks(MySqlConnection conn) { if (executors.Count != 0) { MySqlDataAdapter adapter = null; tasksList = new ObservableCollection <TaskTable>(); dt = new DataTable("tasks"); dbHandler db = new dbHandler(); foreach (KeyValuePair <int, string> keyValue in executors) { MySqlCommand command = new MySqlCommand("SELECT id, Performer, Name, Status FROM `tasks` WHERE Performer = '" + keyValue.Key + "' AND Deleted = 0", conn); command.ExecuteNonQuery(); adapter = new MySqlDataAdapter(command); adapter.Fill(dt); } foreach (DataRow row in dt.Rows) { var name = Convert.ToString(row[2]); var status = Convert.ToString(row[3]); var executor = db.GetUser(Convert.ToInt32(row[1])); tasksList.Add(new TaskTable(name, status, executor)); } TasksDG.ItemsSource = tasksList; adapter.Update(dt); } }
private void GetTasks(MySqlConnection conn) { MySqlCommand command = new MySqlCommand("SELECT id, Performer, Name, Status, NeedTime, EndTime FROM `tasks` WHERE Performer = '" + id + "'", conn); command.ExecuteNonQuery(); MySqlDataAdapter adapter = new MySqlDataAdapter(command); tasksList = new ObservableCollection <TaskTable>(); dt = new DataTable("tasks"); dbHandler db = new dbHandler(); adapter.Fill(dt); foreach (DataRow row in dt.Rows) { var name = Convert.ToString(row[2]); var status = Convert.ToString(row[3]); var managerId = db.GetManager(Convert.ToInt32(row[1])); var manager = db.GetUser(managerId); tasksList.Add(new TaskTable(name, status, manager)); } TasksDG.ItemsSource = tasksList; adapter.Update(dt); }
private void GetExList(MySqlConnection conn) { DataTable dt = new DataTable("ex"); dbHandler db = new dbHandler(); MySqlCommand command = new MySqlCommand("SELECT id, FullName, Grade FROM `users` WHERE TypeUser = '******'", conn); command.ExecuteNonQuery(); MySqlDataAdapter adapter = new MySqlDataAdapter(command); adapter.Fill(dt); foreach (DataRow row in dt.Rows) { var fullName = Convert.ToString(row[1]); var grade = Convert.ToString(row[2]); var managerId = db.GetManager(Convert.ToInt32(row[0])); var manager = db.GetUser(managerId); exList.Add(new ExecutorTable(fullName, grade, manager)); } }