public Account GetAccountData(string username) { var query = "SELECT AccountID, Password, UserGroup, ServiceID FROM AccountData WHERE Username=@Username"; var sqlCommand = factory.GetCommand(sqlConnection); sqlCommand.AddParameter("@Username", username); sqlCommand.SetCommand(query); var sqlReader = sqlCommand.ExecuteReader(); var pData = new Account(); if (sqlReader.Read()) { pData.AccountID = (int)sqlReader.GetData("AccountID"); pData.Password = (string)sqlReader.GetData("Password"); pData.UserGroup = (int)sqlReader.GetData("UserGroup"); pData.ServiceID = Convert.ToByte(sqlReader.GetData("ServiceID")); pData.AccountName = username; } sqlReader.Close(); return(pData); }