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