public List <JobRoleViewModel> GetAllJobRoles() { string connectionString = "server=localhost;uid=root;password=Reset1234;database=OnlineTestManagement;"; List <JobRoleViewModel> model = new List <JobRoleViewModel>(); string queryString = "SELECT * FROM OnlineTestManagement.JobRole;"; using (MySqlConnection connection = new MySqlConnection(connectionString)) { MySqlCommand command = new MySqlCommand(queryString, connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); // Call Read before accessing data. while (reader.Read()) { JobRoleViewModel obj = new JobRoleViewModel(); obj.Id = (int)reader[0]; obj.Value = reader[1].ToString(); obj.Description = reader[2].ToString(); model.Add(obj); } // Call Close when done reading. connection.Close(); } return(model); }
public JobRoleView(JobRoleViewModel viewModel) { InitializeComponent(); DataContext = viewModel; }