//populate tester dashboard public void populatetesterdashboard(String username) { try { String sql = "select bug_id as id, summary as Summary,submittedby from tbl_bug where submittedby=@username"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; MySqlDataAdapter MyAdapter = new MySqlDataAdapter(); cmd.Parameters.AddWithValue("@username", username); MyAdapter.SelectCommand = cmd; DataTable dTable = new DataTable(); MyAdapter.Fill(dTable); TesterDashboard tdash = new TesterDashboard(); tdash.dataTable = dTable; tdash.Show(); tdash.sessionusername = username; Debug.WriteLine("Logged in"); } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } }
//User Login public bool LoginUser(String username, String password) { bool flag = false; try { //query to check if username and password exists String sql = "select * from tbl_user where username=@username and password=@password"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; // Add and set value for parameter. cmd.Parameters.AddWithValue("@username", username); cmd.Parameters.AddWithValue("@password", password); MySqlDataReader login = cmd.ExecuteReader(); if (login.Read()) { sessionusername = username; int location = login.GetOrdinal("pplocation"); int role = login.GetOrdinal("role"); //Open Project Manager Dashboard if (login.GetString(role) == "projectmanager") { populatePMDashboard(); flag = true; } else if (login.GetString(role) == "developer") { flag = true; populateDeveloperDashboard(username); } else if (login.GetString(role) == "tester") { flag = true; populatetesterdashboard(username); } } else { // home.setPasswordMessage("Username or password do not match"); // home.Refresh(); Debug.WriteLine("Username and password do not match"); flag = false; } } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } return(flag); }